hello gurus,
we have 11g r2 oracle database standing on linux red hat 6.4(64 bit). it is production database, many applications are connected to it.
the problem is, it closes inactive sessions (in my oppinion, cause if i open sql navigator do some query and then do nothing in like 30-60 minutes and then when i try to execute query, it gives me this error: ORA-03113 or sometimes OCI_INVALID_HANDLE);
when i log off and log on again everything works fine, untill i repeat above statement;
i can log on and off anytime it is no problem, but problem is applications which are connecting to oracle. if you log on them do some work and then do nothing for a while, it loses connection and all work is lost, if you didn't saved it ofc.
i have searched for this issue but found nothing helpfull;
i tried to check SQLNET.EXPIRE_TIME parameter in sqlnet.ora file but there is nothing(i guess it is set on default which is 0) here what is looks like:
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ADR_BASE = /opt/app/oracle
also there is procedure which kills inactive sessions every 5 minutes, but it works only on username like 'BILL' so it should not close connection for app users which are connected to AK_POOL_USER;
also when i connect to my red hat linux server(on which oracle db is set) with ssh, if i do nothing it for a while, same happens, it loses connection and asks me to log in again. therefore i think that it is not an oracle problem but
a server problem. but firewall is shut down (service iptables stop) and i do not know what else could close server processes.
i even thought that this was my sql navigator and secureCRT program parameter which closed the sessions but then again if it was the case, applications shouldn't have lost connection.
i do not know where to look anymore. please help if you can.
thanks