RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropri

rman target / auxiliary sys/oracle@ standby ；
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

备库LISTENER.ORA文件中全局服务名配错导致.

错误配置如下：

SID_LIST_LISTENER=
  (SID_LIST=
     (SID_DESC=
       (GLOBAL_DBNAME= primary .example.com)
       (ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
       (SID_NAME=JDY)
     )
    (SID_DESC=
       (GLOBAL_DBNAME= primary _DGMGRL.example.com)
       (ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
       (SID_NAME= JDY )
    )
  )

正确配置
SID_LIST_LISTENER=
  (SID_LIST=
     (SID_DESC=
       (GLOBAL_DBNAME= standby . example.com)
       (ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
       (SID_NAME= JDY )
     )
    (SID_DESC=
       (GLOBAL_DBNAME= standby _DGMGRL.example.com)
       (ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1)
       (SID_NAME= JDY )
    )
  )

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31557076/viewspace-2397693/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31557076/viewspace-2397693/