Re: Firwall keep-alive parameter?

SQLNET.EXPIRE_TIME is designed to detect *dead* connections not just idle ones, but it works by sending probe packets and so the firewall won't kill the connection. We set our servers to 10.

On Wed, Jan 31, 2018 at 3:36 PM, 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
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l