10 Replies Latest reply: Sep 12, 2013 3:32 PM by EdStevens RSS

    ORA-12514: TNS:listener while connecting from both Primary and Auxiliary

    John-MK

      Hello,

       

      Getting following teasing error. Mind frozen ....  Please suggest to solve it. Errors are same whether to connect from Primary or Aux. Some TNSNAMES or LISTENER static entry is wrong...not able to get what is wrong...

       

      RMAN> CONNECT AUXILIARY sys/oracle@dg_db2;

       

      connected to auxiliary database: DG_DB2 (not mounted)

       

      RMAN> CONNECT TARGET sys/oracle@dg_db1;

       

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

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

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

      ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

       

      tnsping dg_db1

      tnsping dg_db2     are working fine..i.e. no error

       

      # Primary:

      SQL> select name,db_unique_name from v$database;

       

      NAME      DB_UNIQUE_NAME

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

      DG           dg_db1

       

       

      SQL> sho parameter service

       

      NAME                     TYPE     VALUE

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

      service_names        string       dg

       

      # Auxiliary:

      service_names  : dg_db2

       

      # TNSNAMES.ORA on both plus LISTENER entry:

      DG_DB1 =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = db01)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = dg)

          )

        )

       

      DG_DB2 =

        (DESCRIPTION =

          (ADDRESS = (PROTOCOL = TCP)(HOST = db02)(PORT = 1521))

          (CONNECT_DATA =

            (SERVER = DEDICATED)

            (SERVICE_NAME = dg_db2)

          )

        )

       

      # LISTENER.ORA status entry on AUXILIARY + plus listeners entry:

      SID_LIST_LISTENER =

        (SID_LIST =

          (SID_DESC =

            (GLOBAL_DBNAME = dg_db2)

            (ORACLE_HOME = /oracle/11g/dbhome)

            (SID_NAME = dg)

          )

        )

      Also, do not know whether STATIC entry is required for PRIMARY DB listener.ora or not before using DUPLICATE DATABASE command to creata PYHSICAL STANDBY DB.

       

      Thanks a lot.

      Best Regards