SAP Knowledge Base Article - Preview

1701375 - ORA-12154 connecting to Standby database

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.