I have a public facing application server that accesses an Oracle database that resides behind a firewall.
Some of the processes that are executed through the application server can run for over an hour. This causes the firewall to disconnect the session without any error messages being generated. This causes the process to appear hung.
I've set the KeepAliveInterval to 1 second and KeepAliveTime to two hours in the registry.
I've set the enable=broken option in my tnsnames.ora file
The listener has the sqlnet expire time set to two minutes, so it's sending keepalives from that end as well.
The problem is, it doesn't seem to be working. On a different machine, I at least got a message that the firewall had disconnected the app-server (that's when I discovered the enable=broken requirement)
How do I make sure that the keep-alives are being sent?