Problem connecting with external oracle db

[Former Member]

Hello,

I have defined a connection in dbco with an external ora db.

The oracle connection works fine but from sap if I test the conecction with the ADBC_TEST_CONNECTION report I get the error sql error 12154.

My question is, how to write "Info con."  in dbco. I have not clear in spite of having changed this string several times.

Can anybody help me?

Thanks in advance.

Regards.

[former_member206552 · Accepted solution]

Hi David,

I had the same problem in the past but i fixed mine by supplying checking what TNSMANES.ORA user SIDADM user is using

and that you are able to do an 'tnsping SID' to the database you want to connect

let me know if you dont come right

just for info you can also test the connecting using DB02

From here you can create, modify and delete as well.

Best Regards

Marius

[Reagan]

Hello

You need to maintain the database connection entries in the tnsnames.ora file.

Check for the file tnsnames.ora present under the location TNS_ADMIN which is normally /usr/sap/SID/SYS/profile/oracle

Regards

RB

[former_member185239]

Hi David,

You need to maintain the entry of database connection string in tnsname.ora file.

on the client side(SAP System) to connect to the external database oracle.

Check the environment variable TNS_ADMIN where you will be getting tnsname.ora file.

Global_name of oracle(SID)=

(description=

   (address_list=

     (address = (protocol = TCP)(host =xx.xx.xx.xx)(port = 152X))

   )

(connect_data =

   (service_name=Connector name)

)

)

With Regards

Ashutosh Chaturvedi

[Sriram2009]

Hi David

Kindly go thru the SAP Note 443867 - ORA-12154 Collective SAP note

Thanks

Ram

[Former Member]

Hi David,

              Check the below forum it might help.

http://scn.sap.com/thread/1794452

Thanks and Regards,

Kunal Gahlot