That is a network function, not SQL*Net. SQL*Net operates through
network objects called "sockets". If your socket survives, your
database connection will survive , too. Your network engineer can
usually slow the heartbeat (TCP_KEEPALIVE) to probing the other peer
every 30 minutes. If the connection is reestablished within that interval,
it will not die. Modern routers and hubs have many setup options and you
can make them rather reliable. My advice is to talk to the CISCO guys.
> -----Original Message-----
> From: Bond Mike A Contr OC-ALC/LPRC [mailto:Mike.Bond_at_tinker.af.mil]
> Sent: Tuesday, January 28, 2003 4:14 PM
> To: Multiple recipients of list ORACLE-L
> Subject: SQL Net connection.
>
>
>
> 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?
>
>
>
> Michael Bond
> OC-ALC\LPRC
> Oracle DBA
> 405 736-3840
> DSN 336-3840
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Bond Mike A Contr OC-ALC/LPRC
> INET: Mike.Bond_at_tinker.af.mil
>
> 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: Gogala, Mladen
INET: MGogala_at_oxhp.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 Tue Jan 28 2003 - 17:39:27 CST
