【报错解决】RMAN-00554；RMAN-04006；ORA-12528

Inkcup

实验环境
Oracle Linux 7.9

安装软件：
Oracle database 11.2.0.4

节点设置：
主库：dbserver  192.168.133.111
备库：db_dg      192.168.133.112

                               
登录/注册后可看大图

迁移数据时，使用rman命令，无法连接，产生报错如下：

[oracle@dbserver dbs]$ rman target sys/oracle@orcl_primary auxiliary sys/oracle@orcl_standby

Recovery Manager: Release 11.2.0.4.0 - Production on Wed Apr 9 09:04:35 2025

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1725729066)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

报错解决：
检查主备库上的监听文件：
[oracle@dbserver dbs]$ vim $ORACLE_HOME/network/admin/listener.ora

file:///C:\Windows\TEMP\ksohtml15756\wps1.jpgSID_LIST_LISTENER =

   (SID_LIST =

        (SID_DESC =

          (GLOBAL_DBNAME = orcl) #相当于service_name，主备库设置要统一

          (ORACLE_HOME =  /u01/app/oracle/product/11.2.0.4/dbhome_1)

          (SID_NAME = orcl)

        )

)

#主备库都需要设置，然后重启监听
$ lsnrctl stop
$ lsnrctl start

登录/注册后可看大图