Hi all,
Ora10g
Suddenly this afternoon the users complained that they cannot connect to the database, I tried to connect and was able to confirmed that connection hanged up.
I checked the alert log and I found these :
Thread 1 advanced to log sequence 11682
Current log# 3 seq# 11682 mem# 0: D:\ORACLE\ORADATA\TURBDV2\REDO03.LOG
Mon Jun 13 09:00:15 2011
WARNING: inbound connection timed out (ORA-3136)
Mon Jun 13 10:00:27 2011
Thread 1 advanced to log sequence 11683
Current log# 1 seq# 11683 mem# 0: D:\ORACLE\ORADATA\TURBDV2\REDO01.LOG
Mon Jun 13 13:15:50 2011
WARNING: inbound connection timed out (ORA-3136)
Mon Jun 13 13:51:28 2011
WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=27
System State dumped to trace file c:\oracle\admin\turbdv2\udump\turbdv2_ora_7668.trc
Mon Jun 13 14:50:44 2011
WARNING: inbound connection timed out (ORA-3136)
Mon Jun 13 15:23:10 2011
How do i resolve this error please....