ITPub博客

首页 > 数据库 > Oracle > RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropri

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

原创 Oracle 作者:筋斗云007 时间:2019-01-12 22:17:33 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: DG 各参数解释
请登录后发表评论 登录
全部评论

注册时间:2018-10-04

  • 博文量
    21
  • 访问量
    36271