This discussion is archived
10 Replies Latest reply: Sep 12, 2013 1:32 PM by EdStevens RSS

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

John-MK Newbie
Currently Being Moderated

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

Legend

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