Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-3113 errors after switching W2K server to new network

RE: ORA-3113 errors after switching W2K server to new network

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Mon, 12 Jan 2004 07:19:35 -0800
Message-ID: <F001.005DC6FF.20040112071935@fatcity.com>

Greg,

short of migrating to *nix, dead connection detection does not work on win32. not in 8.1.7.4, not in 9.2.0.4.

possibly in 10g? ;)

Pd

> This causes
> oracle to send pseudo-keepalive packets
> periodically, which should keep your sessions active
> from the firewall's perspective. You enable this by
> adding
>
> sqlnet.expire_time = ??
>
> to sqlnet.ora on the DB server, where ?? is the
> frequency (in minutes) for the packets to be sent.
> It should start being used for new connections
> immediately... no DB restart required.
>
> -----Original Message-----
> Paul Vincent
> Sent: Monday, January 12, 2004 1:44 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Success! I've now learnt, from our network security
> admin guy, that the
> Firewall Manager on the new network is configured by
> default to timeout
> inactive connections after 60 minutes. Even though
> all the user clients
> are inside the firewall, the server is specially
> ringfenced because the
> third-party application suppliers have access to it
> via PC Anywhere.
> Therefore the users have to access the server via
> the firewall, and
> therein lies the problem! Apparently the old
> firewall had this feature
> either disabled or set ludicrously high, but those
> responsible for the
> new firewall are unwilling to change the 60-minute
> default. Obviously
> they're being far more cautios about accumulating
> idle connections this
> time around!
>
> So we now have our solution choices - either someone
> makes the decision
> to up the timeout period, or the application vendors
> fix the app to
> issue a dummy query every so-many minutes of
> inactivity... or the users
> get used to logging in and out of the app when they
> need it, rather than
> leaving it running idle all day... It's now a
> political decision rather
> than a technical problem.
>
> A satisfactory end to the problem, which may well
> have not been the case
> without the input from this list, for which many
> thanks, particularly to
> Tim Onions, Paul Drake and Tim's resident firewall
> guru.
>
> Paul Vincent
> DBA
> University of Central England
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Paul Vincent
> INET: Paul.Vincent_at_uce.ac.uk
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>



> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Norris, Gregory T [ITS]
> INET: gregory.t.norris_at_mail.sprint.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>


> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).


Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Drake
  INET: discgolfdba_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Jan 12 2004 - 09:19:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US