Re: Firwall keep-alive parameter?

From: Li Li <litanli_at_gmail.com>
Date: Wed, 31 Jan 2018 09:51:46 -0600
Message-ID: <CAN-mCbOB6pqBo79ZVu4uimCDFJbtTr-voJNEWzYeShhRLK2Htg_at_mail.gmail.com>



I've dealt with this problem a while back and wrote some notes on this: http://li555li.blogspot.com/2014/09/, hope it helps...

On Wed, Jan 31, 2018 at 9:36 AM, Dennis Williams < oracledba.williams_at_gmail.com> wrote:

> List,
>
> We have a factory with a requirement to keep a client connected with no
> activity for over 2 hours. Eventually the firewall times out stale
> connections.
>
> Does anyone know of an Oracle network parameter that will send an
> occasional packet to keep the firewall from killing the connection? I've
> looked at CONNECT_TIMEOUT_LISTENER and SQLNET_EXPIRE_TIME, but if I
> understand the documentation correctly (not easy when this becomes an
> emergency at 2 am.), these actually just kill stale connections, not keep
> them open.
>
> Any suggestions appreciated.
> Dennis Williams
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 31 2018 - 16:51:46 CET

Original text of this message