*** ERROR => CONNECT failed with SQL error '12154' after Oracle Upgrade

[Former Member]

Hello Experts,

Recently I upgraded my oracle database from 11.2.0.3 to 11.2.0.4.The upgrade completed successfully but I am unable to start the instance.

R3trans -d failing with the error--

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(con=0, svc=069C1630): Error 12154 attaching new srv=069C17D0

OCIHandleFree(con=0): Server handle srv=069C17D0 freed.          

server_detach(con=0, svc=069C1630; srv=NULL, stale=2)            

OCIHandleFree(con=0): Service svc=069C1630 freed (i=1).          

*** ERROR => CONNECT failed with SQL error '12154'              

-->oci_get_errmsg (con=0, rc=12154)                              

  OCIErrorGet() -> SQL error code: 12154; buflen=66            

OCIErrorGet(): error text ->                                    

ORA-12154: TNS:could not resolve the connect identifier specified

ocica() -> SQL error code 12154,12154                          

  DbSlConnect(con=0) -> orc=12154, rc=99=DBSL_ERR_DB            

***LOG BY2=>sql error 12154  performing CON                      

***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified

I have checked listener is up and running properly.Entry is maintained in tnsnames.ora.

Also kernel is upgraded with latest path.Curent kernel version--742

Please suggest on the mentioned error.I am attaching the logs here.Thanks in advance.

Best Regards,

Debaditya

dev_w0_log.txt.zip

tns.txt.zip

trans.txt.zip

[Sriram2009 · Accepted solution]

Hi Debadiya

Kindly check this SAP Notes

1204916 - Error: "ORA-12154" when connecting to Oracle from a Windows 64-bit platform

2153975 - Database connectivity fails with ORA-12154

556232 - Environment settings for R/3/Oracle on Windows

443867 - ORA-12154 Collective SAP note

BR

SS

[Former Member · Accepted solution]

Hi SS,

Thanks for the notes.My issue is resolved using the note 556232 - Environment settings for R/3/Oracle on Windows.

In my case env variable was set for TNS_ADMIN  and as  per the the note it shouldn't be the case.I have removed the same and R3trans-d finished with 0000

SAP is up and working fine.

Thanks again.Closing the thread.

[Former Member]

Hello,

Have you performed all the post-steps according the the Oracle Upgrade Guide. If not, please perform all the below steps.

regards,

pavan

[Former Member]

Hi Pavan,

Yes all post-upgrade steps are performed as per the standard guide.

Best Regards,

Debaditya

[Former Member]

Looks like the issue is with env variables. Have you changed the ENV variables after the upgrade?