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