Hi all,
11.2.0.3
Oel 6.5
I am connecting thru sqlplus client and I run sqlplus like this:
SQL> select count(*) from tab;
COUNT(*)
----------
194
Afte a minute or less, my connection seemed get killed if it not doing database activity. But if I continue doing db process, it will not be diconnected or killed.
SQL> /
select count(*) from tab
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 63519
Session ID: 432 Serial number: 29415
It happened also to my toad, and sqldev connections. Which firewall in linux is killing idle Oracle databse connection? It so weird that a firewall will intervene an idle Oracle process?
This is my first time to encounter this issue.
I checked the alert log and something like this showed:
Sat Nov 22 19:10:58 2014
Stopping background process CJQ0
Sat Nov 22 19:12:24 2014
Incremental checkpoint up to RBA [0x2a.10dbd7.0], current log tail at RBA [0x2a.10dd32.0]
Disregard this...I have proven this is not the cause.
Please help what to do.
Thanks,
mk