Hi Experts
We are facing this error 'ORA 12154 tns could not resolve the connect identifier specified' in alert log file while shipping logs to standby database. We have checked tnsping from both the servers (prim and stndby) are successful. If we are trying to connect standby database from primary database with command 'sqlplus sys/password@standby as sysdba', it is successful.
tnsping result in secondary: SOL_DR
orasol> tnsping SOL
TNS Ping Utility for Solaris: Version 12.1.0.2.0 - Production on 23-JAN-2019 14:56:44
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/oracle/SOL/121/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = ERPSOL) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SOL)))
OK (0 msec)
orasol>
tnsping result in primary: SOL
ERPSOL:orasol 1% tnsping SOL_DR
TNS Ping Utility for Solaris: Version 12.1.0.2.0 - Production on 23-JAN-2019 14:55:43
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/oracle/SOL/121/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = ERPSOL-CL) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SOL_DR)))
OK (0 msec)
ERPSOL:orasol 2%
Getting no idea then how it is showing error while log shipping