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) ) )