重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛
标题: 【报错解决】RMAN-00554；RMAN-04006；ORA-12528 [打印本页]
作者: Inkcup 时间: 前天 15:54
标题: 【报错解决】RMAN-00554；RMAN-04006；ORA-12528
实验环境
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
