Home » RDBMS Server » Networking and Gateways » Dead Connection Detection
Dead Connection Detection [message #145363] Wed, 02 November 2005 13:37 Go to next message
bnorma01
Messages: 4
Registered: November 2005
Junior Member
We have Oracle 8.1.7.4.0 on HP-UX 11.11 If I run sqlplus on pc client running xp pro and then disconnect network jack of my pc my oracle session takes 2 1/4 hours to go away on server. We do not have expire_time set in our servers sqlnet.ora file.

What is removing session ?

It always seems to be 2 1/4 hours even when it is my app on a pc server that loses its connection. I just duplicated with sqlplus removing any issues with my app or my odbc connection.
Re: Dead Connection Detection [message #145667 is a reply to message #145363] Fri, 04 November 2005 12:53 Go to previous messageGo to next message
bnorma01
Messages: 4
Registered: November 2005
Junior Member
Found the answer. HP-UX is seeing the tcp/ip socket and removing it. oracle then removes the connection. The 2 hours is the interval that UNIX checks for inactivity. In HP-UX the ndd parameter is tcp_keepalive_interval which mine is set to 7,200,000 milliseconds which is 2 hours. To view this parm I used the following command:

"ndd -get /dev/tcp tcp_keepalive_interval"
Re: Dead Connection Detection [message #145668 is a reply to message #145667] Fri, 04 November 2005 12:54 Go to previous message
bnorma01
Messages: 4
Registered: November 2005
Junior Member
Also see:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=94510
Previous Topic: ORA-12541: TNS: no listener but I can connect from the server !
Next Topic: list all available oracle server on network
Goto Forum:
  


Current Time: Thu Mar 28 10:00:42 CDT 2024