Oracle: ORA-12535: TNS:timeout de la operación

[ko^ke]

ORA-12535 error is when your TNS operation timed out.

The cause is that the requested connection could not be completed within the timeout period specified by the CONNECT_TIMEOUT parameter in listener.ora. Try reconfigure CONNECT_TIMEOUT to be 0, which means wait indefinitely, or reconfigure CONNECT_TIMEOUT to be some higher value. Or, if the timeout is unacceptably long, turn on tracing for further information. Here is what you can do:

1. Find out if you are going through any Firewalls or Routers.
2. Try to "ping" the ip address or hostname from the client. Check the timing response and see if it is acceptable. If it is not, then you may need to increase the CONNECT_TIMEOUT_<listener_name> value in the listener.ora file on the Server. Doing this will correct the connectivity problem, but may be masking the real problem of the physical network.


Best regards. Your neighborhood friendly,

http://www.dbaclick.com/forums/archive/11/2665.html