RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

posted Mar 29, 2011, 9:45 AM by Sachchida Ojha   [ updated Mar 29, 2011, 10:36 AM ]
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


You need to have the database in the SID_LIST_LISTENER section of LISTENER.ORA and your TNSNAMES needs to read
orcl.. = (connect_data=(***SID***= ))
instead of service_name =

va-iperf01:DUPDB1:/u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1/network/admin>vi listener.ora
"listener.ora" 38 lines, 899 characters
# LISTENER.ORA Network Configuration File: /u01/ARBPRDDB/app/oracle/product/9205/network/admin/listener.ora
# Generated by Oracle configuration tools.
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = DUPDB1)
      (ORACLE_HOME = /u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = DUPDB1)
    )
   (SID_DESC =
      (GLOBAL_DBNAME = DUPAT1)
      (ORACLE_HOME = /u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = DUPAT1)
    )
   (SID_DESC =
      (GLOBAL_DBNAME = STGDB1)
      (ORACLE_HOME = /u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = STGDB1)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = STGAT1)
      (ORACLE_HOME = /u01/ARBPRDDB/app/oracle/product/11.2.0/dbhome_1)
      (SID_NAME = STGAT1)
    )

  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = dbref01)(PORT = 1521))
      )
    )
  )

DUPAT1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =  dbref01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (ORACLE_SID = DUPAT1)
    )
  )
DUPDB1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dbref01)(PORT = 1521))
    )
    (CONNECT_DATA =
      (ORACLE_SID = DUPDB1)
    )
  )

INBOUND_CONNECT_TIMEOUT_AT1 = 0
INBOUND_CONNECT_TIMEOUT_DB1 = 0
#added to remove ORA-3136 from alert.log
INBOUND_CONNECT_TIMEOUT_LISTENER = 0

DIAG_ADR_ENABLED_listener_name=OFF


Comments