DBCO Connection not working

[Former Member]

Hi All

We are trying to connect to other oracle database from SAP.

We have maintained the DBCO connection details and also the TNSNAMES.ORA file is also properly editied

Following is the TNSNAMES.ORA details and it is edited in the following folder (oracle/ED1/102_64/network/admin)

devdb.world =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.212) (PORT = 1521:devdb)

)

)

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = devdb.world)

)

)

When we test using the program "ADBC_TEST_CONNECTION", we are getting the following error

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

Any suggestions for the same

Regards

Madhan D

[Former Member]

Madhan,

Can you try to execute a command in prompt "tnsping devdb.world"? I think your TNSNAMES.ORA isn´t properly edited, or the LISTENER.ORA isn´t properly edited too.

You can try remove from TNSNAMES.ORA (PORT = 1521:devdb) and to use (PORT = 1521) only.

I hope help.

Regards

[Former Member]

I agree with Alex. Against port only the port number for listener service needs to be given..Confirm if it is 1521 and then use that one only.