搭建dg时监听问题

一、dg种静态监听

在instance没有建立的情况下，用pfile启动到nomount状态，实现数据库动态注册，虽然可以实现动态注册，在service中能看到service name，但是其状态为blocked，客户端此时无法连接。

要解决此问题： 1.改用静态注册 2.建完database后才用动态注册

alter system register;是在动态注册的时候执行的

二、问题

1.ORA-12528:

ORA-12528: TNS:listener: all appropriate instances are blocking new connections
ORA-12528:监听中的服务使用了动态服务,系统启动后,数据库没有正常的MOUNT,因此在动态模式下,就会出现这个问题，用静态的就不会有这个问题,因此上面的方法就是把监听设置为静态,或者在tnsnames.ora中追加(UR=A)。
lisnter.ora增加如下内容
 (SID_DESC =
      (GLOBAL_DBNAME = ammicly)
      (ORACLE_HOME = c:\oracle\product\10.1.0\db_1)
      (SID_NAME = ammicly)
    )
或者在tnsnames.ora增加如下内容
      (UR=A)

2.遇到

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

检查tnsnames.ora中

ORCL_PRI =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.84)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

参数SERVICE_NAME是lsnrctl status中红色部分

[oracle@single04 dbs]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 13-DEC-2021 16:23:17

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=single04)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                13-DEC-2021 15:32:59
Uptime                    0 days 0 hr. 50 min. 17 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.3.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/single04/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=single04)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "orcl_std" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

服务名“orcl_std”是tnsnames.ora中参数SERVICE_NAME的取值

更多监听内容参考：https://blog.csdn.net/weixin_43475880/article/details/121583120
来源：https://blog.51cto.com/itbull/1120381