Connection to Auxilary using connect string failed with ORA-12528 [ID 419440.1]

最新推荐文章于 2022-04-28 15:42:09 发布

Dave

最新推荐文章于 2022-04-28 15:42:09 发布

阅读量5.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle Troubleshooting oracle常见故障解决方案文章标签： string database authentication oracle oracle10g

本文链接：https://blog.youkuaiyun.com/tianlesoftware/article/details/6230505

Oracle Troubleshooting 同时被 2 个专栏收录

194 篇文章

订阅专栏

oracle常见故障解决方案

113 篇文章

订阅专栏

Connection to Auxilary using connect string failed with ORA-12528 [ID 419440.1]

	Modified 15-FEB-2011 Type PROBLEM Status PUBLISHED

In this Document
  Symptoms
  Cause
  Solution
  References

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.6 - Release: 9.2 to 11.1
Information in this document applies to any platform.
***Checked for relevance on 15-Feb-2011***

Symptoms

During duplicate database creation, connection to the auxiliary database from target database server fails with ORA-12528: TNS:listener: all appropriate instances are blocking new connections.

E:/oracle/product/10.2.0/db_1/BIN>rman target / auxiliary sys/sys@duplicate

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Mar 16 00:11:05 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORIGINAL (DBID=1451288337)
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 appropri
ate instances are blocking new connections

When it fails , add manual entry for sid in listener.ora as per Note 301099.1

However, still you receive the same error on connect in some cases.

Cause

Its because only the Auxiliary Instance is running .The instance registers with the listener by the PMON process. TO start the PMON process the database need to be in MOUNT status. Before there is nothing to register the database to the listerner so the instance is BLOCKED.

Solution

There are 2 options to solve this problem

Option 1

Connect to the auxiliary instance using OS authentication (as /) and use password file authentication for target database and connect via Listener.For example make below connection in RMAN from auxiliary database server

E:>rman target sys/sys@original auxiliary /

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Mar 15 23:57:08 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORIGINAL (DBID=1451288337)
connected to auxiliary database: DUPLICATE (not mounted)

Option 2

Create a static entry for the auxiliary database in the listener.ora file of the auxiliary database Oracle home and restart the listener. For example

Listener.ora
-------------

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = SAIRAM)
      (ORACLE_HOME = G:/oracle/product/10.2.0/db_1)
      (SID_NAME = SAIRAM)
    )
  )

Or

Use the Oracle10G feature. Make below entry in the tnsnames.ora file of the Oracle home from when RMAN is being executed.

tnsnames.ora
------------

SAIRAM =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = apadhi-idc)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SAIRAM)(UR=A)
    )
  )