10g client session getting disconnected 2006-04-01 - By full name
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 (See ORA-12152.ora-code.com) message after about 5 minutes. On Windows client,
session hangs and I get an ORA-3113 (See ORA-3113.ora-code.com) error after only about 1 minute.
One the server side there is no SQLNET.EXPIRE_TIME set and every user is
using the default profile. 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 (See ORA-3113.ora-code.com) error too.
<span class="MsgBodyText">10g server is in Chicago.<br>
10g unix client and 10g windows client in New York.<br>
<br>
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 (See ORA-12152.ora-code.com) message after about 5 minutes. On Windows
client, session hangs and I get an ORA-3113 (See ORA-3113.ora-code.com) error after only about 1
minute.<br>
<br>
One the server side there is no SQLNET.EXPIRE_TIME set and every user is using
the default profile. The default
profile has both IDLE_TIME and CONNECT_TIME set to unlimited.<br>
<br>
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?<br>
<br>
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 (See ORA-3113.ora-code.com) error too.<br><br><
/span>
|
|
