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
