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@(protected)> 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 (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. >
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l
