Symptom
On the primary database's alert<SID>.log you will see the following messages:
Errors in file /oracle/<SID>/saptrace/background/<sid>_arcn_<pid>.trc:
ORA-12154: TNS:could not resolve the connect identifier specifiedPING[ARC7]:
Heartbeat failed to connect to standby '<STDBYSID>'. Error is 12154.
And:
Error 12154 received logging on to the standby
Read more...
Environment
- Oracle database release independent
- Data Guard
- UNIX or Linux release independent
Product
SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0
Keywords
oracle, dataguard, data guard, tns, ORA-12154, TNS-12154, standby, connectivity, connection, TNS_ADMIN, failed, resolve, tns-03505 , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.