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!

deadlock on RAC

647600Dec 21 2008 — edited Dec 29 2008
Dear all,

The situation is that I have a RAC structure using 2 nodes, (node1, and node2).

During the day I got some deadlock messages which cause the database to hang, the only solution is to restart the 2 instances.

And as I know that oracle 10g can handle this issue (while getting ORA-0060) by killing a session.

And what it is stranger is that after checking the traces files (alert and udump files) and found that the deadlocks happen only on the node1 and never on node2.

The SQL statements that cause the deadlock are used frequently and during some day they work without any problem.

Would you please give me your points and thank you in advance

Elie
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2009
Added on Dec 21 2008
10 comments
3,247 views