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: SQL Net connection.

Re: SQL Net connection.

From: Lyndon Tiu <ltiu_at_alumni.sfu.ca>
Date: Tue, 28 Jan 2003 15:39:26 -0800
Message-ID: <F001.0053CACD.20030128153926@fatcity.com>


Quoting dgoulet_at_vicr.com:
> Mike,
> Sorry there is no way to keep the connection alive. It's a
> TCP/IP thing. I
> wish you could do that too.
>
> Dick Goulet.
>
> Bond Mike A Contr OC-ALC/LPRC <Mike.Bond_at_tinker.af.mil> wrote on
> 1/28/03 1:14
> pm:
>
>
> Is there any possible way to retain/reinstate/continue a SQLNet
> connection if
> there is say a 10-second network outage?
>
> For example: If a session is established and then the network cable
> is unplugged
> for 5 seconds and then replaced. Is there anyway to keep that
> connection alive?
>

With the example you gave, then yes, it is possible. It is dependent on the TCP timeout value set for your OS before disconnecting a dead session. I've done this many times on Linux using intel hardware and cheap network switches and it works. The timeout value is the key here. It's probably in the range of 30 seconds to 2 minutes depending on the OS.

--
Lyndon Tiu

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Lyndon Tiu
  INET: ltiu_at_alumni.sfu.ca

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 Tue Jan 28 2003 - 17:39:26 CST

Original text of this message

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