RMAN04006: error from auxiliary database

Recovery Manager: Release 11.1.0.6.0 - Production on Wed Nov 7 01:45:35 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: ORA11G (DBID=4026820313)
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

造成这个问题的原因是,实例虽然启动,但是没有注册到监听。实例是通过PMON进程注册到监听上的,而PMON进程需要在MOUNT状态下才会启动。因此造成了上面的错误。

Oracle给出了两种解决方案,一种方法是对AUXILIARY数据库直接使用/,对TARGET数据库通过网络访问。

a. rman target sys/oracle@orcl auxiliary /

b. 为AUXILIARY数据库设置静态监听

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = jssdup)
(ORACLE_HOME = /data/oracle/product/11.1)
)
)

 

原文地址:https://www.cnblogs.com/landexia/p/2613363.html