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

[Jose Arriagada]

Hola amigos:

Tengo en mi servidor windows 2000, oracle 8i, y acceso la base de datos a traves de TOAD y me arroja el siguiente mensaje:

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

Y en el detalle aparece:

Details:
Building Oracle HOMES List
HOME Name OraHome81 added to list.
Found multiple homes, searching each HOMEx for valid PATH
searching in SOFTWARE\ORACLE\HOME0
Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path!
oci.dll found

QUE SERA?

[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