Hi,
I would like to prevent session closed in forms with error ora-03135 after inactivity.
After an hour of inactivity error ora-03135 or ora-03134 pop up and session is closed.
I already check heartbeat and FORMS_TIMEOUT and even put session-timeout with -1 into web.xml into formsapp.ear (through plan.xml).
Nothing helps.
I'm using also TOAD and when i set there DBMS Output/Interval pooling (60 sec) connection is alive forever.
I can monitor through v$session field SECONDS_IN_WAIT how every 60 sec toad session is reseted to zero. But forms session after 3600 second is closed.
I'm running out of ideas.
The last one was to use DCD (dead connection detected) mehanism, but when i put
SQLNET.EXPIRE_TIME=1 into sqlnet.ora and enable tracing in trace file i found
niotns: Not trying to enable dead connecton detection.
Is there any other parameter to enable DCD?
Any idea how to prevent closing forms session after 1hour would be appreciated.
We are using WEBLOGIC SERVER 12.2.1.2.0 (Windows 16 server)
Oracle database Enterprise 12.1.0.2.0
formsapp 12.2.1