Re: Firwall keep-alive parameter?

Good point about how and when the packets are sent. For safety I used to set the timeout to slightly less than half --- but now I know why I was right !!

Hemant K Chitale

On Wed, Jan 31, 2018 at 11:51 PM, Li Li <litanli_at_gmail.com> wrote:

> 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