2153975 - Connection to RAC failing with ORA-12154

You have a RAC cluster, a service is configured using srvctl for instance specific connection. If you run a lsnrctl status, you will see the service listed:

Service "P8S_D01" has 1 instance(s).
  Instance "P8S1", status READY, has 1 handler(s) for this service...

When trying to connect an R3 system to a RAC database instance, the R3trans -d fails and you see the error bellow in the trans.log:

Thu Mar 19 12:08:20 2015
   OCIServerAttach(OCI_DEFAULT) failed with -1=OCI_ERROR
   OCIServerAttach(OCI_DEFAULT) failed with SQL error 12154:
   ORA-12154: TNS:could not resolve the connect identifier specified
 
OCIServerAttach failed for '<SERVICE>', free srv=200a550 (con=0, svc=2707248)
 
*** ERROR => CONNECT failed with SQL error '12154'
-->oci_get_errmsg (con=0, rc=12154)
   OCIErrorGet() -> SQL error code: 12154
ORA-12154: TNS:could not resolve the connect identifier specified
 
ocica() -> SQL error code 12154,12154
   DbSlConnect(con=0) -> orc=12154, 99=DBSL_ERR_DB
***LOG BY2=>sql error 12154  performing CON
***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified 

Read more...

• SAP systems with Oracle RAC database
• Not restricted to a product or product version
• Any Operating System

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; 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

connect, connection, resolve, sid, service_name, listener, real, application, cluster, clusters, failure, startup, error, tns , KBA , BC-DB-ORA-RAC , Real Application Clusters (RAC) , Problem