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 )
    )
  )

请使用浏览器的分享功能分享到微信等