OraFAQ Forum: Networking and Gateways » session is getting diconnected

Home » RDBMS Server » Networking and Gateways » session is getting diconnected

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

session is getting diconnected [message #165513]

Thu, 30 March 2006 14:13

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

10g server is in Chicago.
10g unix client and 10g windows client in New York.

If session is inactive for what seems to be a little over an hour, the session is disconnected with no message to the user until another query is run or I even try to exit. On the unix SQL*Plus client, the session hangs and I get an ORA-12152 message after about 5 minutes. On Windows client, session hangs and I get an ORA-3113 error after only about 1 minute.

One the server side there is no SQLNET.EXPIRE_TIME set and the default profile has both IDLE_TIME and CONNECT_TIME set to unlimited.

Is there anything else I can tell the DBAs to look at because they tell me there is nothing else they can look for and don't know why sessions are getting disconnected.

One last piece of info is that even on a client in Chicago, the session will disconnect after said amount of time with an ORA-3113 error too.

Report message to a moderator