Firwall keep-alive parameter?

  • From: Dennis Williams <oracledba.williams@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 31 Jan 2018 09:36:50 -0600

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

Other related posts: