1 2 Previous Next 15 Replies Latest reply: Sep 10, 2013 5:32 AM by John-MK RSS

    CONNECT AUXILIARY failing (db names confusion)

    John-MK

      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