ORA-12535: TNS:operation time out
Joc
15 de Abril del 2005
Hola,
Al intentar realizar una conexión remota se genera el error ORA-12535.
Lo curioso es que TNSPING no tiene problema para ver la base de datos...
Ya modificamos la variable CONNECT_TIMEOUT , ya hemos abierto los puertos 1521 y 1526... pero sigue el problema...
Alguna idea...? Como configurar el firewall?
Gracias
Al intentar realizar una conexión remota se genera el error ORA-12535.
Lo curioso es que TNSPING no tiene problema para ver la base de datos...
Ya modificamos la variable CONNECT_TIMEOUT , ya hemos abierto los puertos 1521 y 1526... pero sigue el problema...
Alguna idea...? Como configurar el firewall?
Gracias
dio
15 de Abril del 2005
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,
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,