Re: SQL*Net error

From: Radojevic <gradojev_at_us.oracle.com>
Date: 1995/06/02
Message-ID: <3qlqbb$28e_at_inet-nntp-gw-1.us.oracle.com>#1/1

don,

     ORA-12535 means the client/server connection handshake timed out:

12535, 00000, "TNS:operation timed out"
// *Cause: 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.
// *Action: Either 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.

     If you're using SQL*Net v2.x TCP/IP, try using <hostip> instead of <hostname> in your tnsnames.ora servicename descriptions. You're connections will be faster, especially if you've got DNS (Domain Name Service) on your network.

     Increasing CONNECT_TIMEOUT_LISTENER in listener.ora may also help.

                        g

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

% Oracle Networking Support % guru dude, joe SQL*Net, joe SQL*Toes %

%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Received on Fri Jun 02 1995 - 00:00:00 CEST