deadlock on RAC
647600Dec 21 2008 — edited Dec 29 2008Dear 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