knudwdbs1> rman auxiliary username/password@TNSALIAS
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Dec 28 15:52:05 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
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
---------------
checking Listener Service using lsnrctl status, also shows All the service with instance with status 'BLOCKED'.
lsnrctl status
===============
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "DBSiteA.qvcuk.local" has 1 instance(s).
Instance "DBUAT1", status BLOCKED, has 1 handler(s) for this service...
Service "standby.qvcuk.local" has 1 instance(s).
Instance "DBUAT1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully
Solution
This is because instance is STARTED status, To fix the update the listener.ora file with static registration for the instance.
-------- listner.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = DBUAT_SiteA)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/dbhome_1)
(SID_NAME = DBUAT1)
)
)
lsnrctl reload
lsnrctl status
Service "DBUAT_SiteA" has 1 instance(s).
Instance "DBUAT1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Reload listener and check status, as its status registration , Service DBUAT_siteA with instance in unknown status added to listener.
Once the status is UNKNOWN for the instance you should be able to connect.
