Re: 10g client session getting disconnected
- From: Mindaugas Navickas <mnavickas@xxxxxxxxx>
- To: full.name@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Sat, 1 Apr 2006 14:48:43 -0500 (EST)
Hi,
I would think that connections are dropped by firewalls (it must be more than
one between Chicago and New York :-) ). Having similar situation we couldn't
find another solution than enabling DCD (SQLNET.EXPIRE_TIME=20) on server site
(listener sqlnet.ora file). Note that parameter is in minutes - you have to
adjust it depending what timeout for inactive connection is set on firewall.
You should read following Metalink note 151972.1. Oracle does not recommend to
use DCD for connections to keep-alive (it's designed to clean dead
connections), but as I mentioned above, we couldn't find an alternative way to
do it. May be somebody from the list can suggest something else.
Regards
Mindaugas Navickas
Oracle OCP DBA
--- full name <full.name@xxxxxxxxx> wrote:
> 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 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 error too.
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
