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博客

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

最新文章