Home > ORA-XXX, RMAN, TNS > ORA-12528: TNS:listener: all appropriate instances are blocking new connections

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

Today, I clone a 11gR2.0.3 database at the same database server. Once I start rman, I get the ORA errors message below

[oracle@ycsdb01 dbs]$ rman target / nocatalog auxiliary sys/12345@spbpro

Recovery Manager: Release 11.2.0.3.0 – Production on Wed Jun 20 17:13:06 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: CSPRO (DBID=3560463483)
using target database control file instead of recovery catalog
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
[oracle@ycsdb01 dbs]$ cd $ORACLE_HOME/network/admin

Solution

Then, I add the option “(UR=A)”  in tnsnames.ora as below. The problem is fixed.

SPBPRO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan.springboard.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = spbpro)(UR=A)
)
)

 

 

Advertisements
Categories: ORA-XXX, RMAN, TNS
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: