Client is facing problem of connection time-out after being idle for more than 1 hr. ORA error is "Ora-03113: end-of-file on communication channel".
I have checked in the database and the default profile gives the user unlimited idle time and also OS team said that they have kept alive time as 2hrs as firewall setting for idle connection to be terminated.
Will creating sqlnet.ora and putting parameter SQLNET.EXPIRE_TIME= <# of minutes> would solve the issue ?
OS : AIX 5.3
DB : 10.2.0.4
What exactly they want is the idle time to be unlimited .Need you valuable input on the same ?
Edited by: 832812 on Aug 16, 2011 11:52 PM