ORA-12535: TNS:operation timed out

[Former Member]

Hi,

I am trying to connect to a external oracle database from SAP.

I entered the TNS entry of the external DB in the TNSNAMES.ORA and configured it in the table DBCON.

But i am not able to connect to the external database. It is throwing the error

"sql error 12.535 ; occured:ORA-12535: TNS:operation timed out"

But i was able to connect the database from my system through TNSPING and also from TOAD.

Do i need to configure any parameter in LISTENER.ORA in SAP or in the external database?

Regards,

Niranjan

[Former Member]

check the GLOBAL_DBNAME & port number in listener.ora

Raj

[Former Member]

Hi,

I checked the domain name and port number in the LISTENER.ORA file of the destination server. But i got connected to the remote database thorugh the DBCON for an hour and it got disconnected again.

In the LISTENER.ORA file of the destination server, the CONNECT_PARAMETER is not set. will this is the reason for the TIMEOUT?