This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Sep 10, 2013 3:32 AM by John-MK RSS

CONNECT AUXILIARY failing (db names confusion)

John-MK Newbie
Currently Being Moderated

Hello,

 

For the purpose of creating Physical standby Database, I am having connect to AUXILIARY DB issue. I think I am confused between PRIMARY and STANDBY DB names. Please have a look at the configuration and suggest where  I am doing mistake.

 

Thanks a lot.

 

# Primary

SQL> select name,db_unique_name from v$database;

 

NAME      DB_UNIQUE_NAME

--------- ------------------------------

JOHN      JOHN

 

SQL> select * from global_name;

 

GLOBAL_NAME

--------------------------------------------------------------------------------

JOHN

 

TNSNAMES.ORA entries on both primary and standby looks like this:

JOHN=

  (DESCRIPTION = - - -

 

JOHN_DB2

(DESCRIPTION = - -

 

TNSPING JOHN

TNSPING JOHN_DB2    are working fine.   e.g. from Primary when I do this it return OK (10 msec) . . .

 

LISTENER.ORA on both have static entries: e.g. on AUXILIARY listener.ora:

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = john_db2)

      (ORACLE_HOME = /oracle/app/oracle/11g)

      (SID_NAME = john)

    )

  )

 

lsnrctl stop and start returned no errors.

 

Here is the error I am concerned:  From Standby I tried to connect:

 

RMAN> CONNECT TARGET sys/oracle@JOHN;

 

connected to target database: JOHN (DBID=1279980307)

 

RMAN> CONNECT AUXILIARY sys/oracle@JOHN_DB2;

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

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

I want to select JOHN_DB2 to for Standby database (at least to differentiate between the two), but I don't know how RMAN recognises the CONNECT IDENTIFIER of the AUXILIARY DB which is not yet replicated/created?

 

db_name,db_unique_name,instance_name on both are same, i.e. JOHN. I just queries v$parameter on Auxiliary.

 

Please suggest.

 

Best Regards

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points