Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK!

846231Jun 13 2011 — edited Feb 29 2012
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....
This post has been answered by 912595 on Feb 29 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2012
Added on Jun 13 2011
7 comments
9,197 views