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@xxxxxxxxx> 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
