RE: SQL*Net - Connection Timeout
Date: Mon, 3 Mar 2008 11:30:22 -0000
From: Justin Cave (DDBC) [mailto:jcave_at_ddbcinc.com]
> I believe that the timeout is controlled at the TCP/IP level.
Thanks, I'll look into this. One other bit of information has come to light - it appears that the server I was connecting to was having some form of network problems. Any process on that server which needed access to the SAN attached disks was hanging. Our Unix team haven't found out why yet, but it seems likely that the dedicated server process would have been hanging when I was trying to connect. Whether that results in a different type of behaviour than a normal network issue which gives a TNS connection timeout error, I don't know. I've never had any luck finding documentation of the lower level details of how a SQL*Net connection is established.
Thanks for the help in any case,
Atos Origin and Atos Consulting are trading names used by the Atos Origin group. The following trading entities are registered in England and Wales: Atos Origin IT Services UK Limited (registered number 01245534) and Atos Consulting Limited (registered number 04312380). The registered office for each is at 4 Triton Square, Regents Place, London, NW1 3HG.
This e-mail and the documents attached are confidential and intended solely for the addressee, and may contain confidential or privileged information. If you receive this e-mail in error, you are not authorised to copy, disclose, use or retain it. Please notify the sender immediately and delete this email from your systems. As emails may be intercepted, amended or lost, they are not secure. Atos Origin therefore can accept no liability for any errors or their content. Although Atos Origin endeavours to maintain a virus-free network, we do not warrant that this transmission is virus-free and can accept no liability for any damages resulting from any virus transmitted. The risks are deemed to be accepted by everyone who communicates with Atos Origin by email.
Received on Mon Mar 03 2008 - 05:30:22 CST