ORA-12528: TNS:listener: all appropriate instances are blocking new connections

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.