unable to connect to DB

[Former Member]

We are unable to connect to DB. Details below.

nb0xdm0x:prdadm 99% R3trans -D

This is R3trans version 6.14 (release 700 - 28.07.08 - 15:52:00).

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"

R3trans finished (0012).

nb0xdm0x:prdadm 100%

4 ETW000 [dboci.c ,00000] *** ERROR => OCI-call 'OCIServerAttach' failed with rc=12154

4 ETW000 816 0.146778

4 ETW000 [dbsloci. ,00000] *** ERROR => CONNECT failed with sql error '12154'

4 ETW000 51 0.146829

4 ETW000 [dev trc ,00000] set_ocica() -> OCI or SQL return code 12154 28 0.146857

4 ETW000 [dblink ,00431] ***LOG BY2=>sql error 12154 performing CON [dblink#5 @ 431]

4 ETW000 319 0.147176

4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified [dblink#5 @ 431]

4 ETW000 52 0.147228

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_ora_tnsname = 'PRD'"

Thanks and Regards,

Damanaidu J

[Former Member]

Hi,

Please refer below notes

[Note 443867 - ORA-12154 Collective SAP note|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=443867]

[Note 562403 - FAQ: Oracle Net|https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=562403]

Thanks

[Former Member]

Hi Damanaidu,

Check this:

- The TNSNAMES.ORA file exists and is in the proper place and accessible.

- The service name exists in one of the TNSNAMES.ORA files and add it if necessary.

- Started Oracle NET Configuration Assitant and Select TEST for the connection.

Hope this information is help to you.

Regards,

José

[markus_doehr2]

> 4 ETW000 [dblink ,00431] ***LOG BY0=>ORA-12154: TNS:could not resolve the connect identifier specified [dblink#5 @ 431]

If you enter "ORA-12154" in the search field in the right upper corner you'll get about 100 forum posts and a bunch of notes how you may resolve that issue, did you try that?

Markus