ORA-12535: TNS: operation timed out

ORA-12535: TNS: operation timed out

This message appears when i am trying to connect to a oracle server from a client machine. The database works normally when used at the server machine. I created the TNS name with the host's IP address and put the correct user and password but it doesn't connect!!!!

Somebody can help me???

Thanks,

JMarcos.

As the message says the request going to your database from the client is timing out. In other words the packets are not reaching the server or vice versa.
move the client machine near to the database server ...may be in the same room kidding....

I assume you have the oracle client installed on your client machine. try the tnsping utility from the command prompt.

tnsping <connection name>

also try and see what are resposne times when you do a normal ping.

try both pings with first with IP address and then with Hostnames. you wanna make sure your DNS is not screwing up things. sometimes by specifying the ip everything works..but with the host name it fails... thatz bcos of name resolution is not working properly.

hth,

Jiggee

The requested connection could not be completed within the timeout period specified by the CONNECT_TIMEOUT parameter in LISTENER.ORA. This error arises from the TNSLSNR.
Either reconfigure CONNECT_TIMEOUT to be 0, which means wait indefinitely, or reconfigure CONNECT_TIMEOUT to be some higher value.