关于oracle DG搭建时的 静态监听问题

Question

在搭建DG时 连接rman进行standby文件创建时输入rman target sys/123456@orcl auxiliary sys/123456@orcls，提示 error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections。查了资料好像是备库监听问题，说是要陪静态监听，但是我应该已经配置了静态监听了，配置文件如下：请问哪里配错了？
LISTENER=

(DESCRIPTION_LIST =

(DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.174.31)(PORT = 1521))

  (ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC1521))

)

)

SID_LIST_LISTENER=

(SID_LIST =

(SID_DESC =

  (GLOBAL_DBNAME = orcl)

  (ORACLE_HOME =/ora01/app/oracle/product/11.2.0/dbhome_1)

  (SID_NAME = orcls)

)

)

Answer 1

你这个不一定是静态监听的问题，还有可能有两个原因
1、密码文件
2、tnsnames
rman target sys/123456@orcl auxiliary sys/123456@orcls 这条命令的@后面内容是tnsnams上面的命名
都可以验证一下
pri =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pri)(PORT = 1530))
)
(CONNECT_DATA =
(SERVICE_NAME = pri)
)
)

pri_dg =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = std)(PORT = 1530))
)
(CONNECT_DATA =
(SERVICE_NAME = pri)
)
)
以下是我的执行命令，你可以对比一下你的命令
rman target sys/oracle@pri auxiliary sys/oracle@pri_dg
ps:sys/oracle 这个好像是密码文件的密码，你可以分别下，应该是可以的