Home » SQL & PL/SQL » SQL & PL/SQL » Getting ORA-0060 Dead lock error (SQL*Plus: Release 9.2.0.6.0 - Production , HP Unix B.11.00 U 9000/800)
Getting ORA-0060 Dead lock error [message #356345] Thu, 30 October 2008 07:41 Go to next message
prem.y83
Messages: 2
Registered: October 2008
Location: bangalore
Junior Member
hi ,
i am getting ORA-0060 (Dead Lock )error in my application code.
The ORA-60 (Dead lock ) condition when two instances (instance A and instance B )trying to update the same table using one common data.

i am pasting you the production scenario , i want to simulate it into test machine , so i need help ..

1) Ora file logs :-

DEADLOCK DETECTED
Current SQL statement for this session:
UPDATE tn_work SET status = :x1, prev_status = :x2 WHERE tn_work_seq = :x3
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL.

2) Other Instance using the below SQl statment :-

Current SQL Statement:
UPDATE tn_work SET status = :x1 WHERE tn_work_seq = :x2
End of information on OTHER waiting sessions.


So my question is :-
1) how can i simulate the same scenario in test machine ?
our aplication using SQL SQL*Plus: Release 9.2.0.6.0 - Production version on HP unix (HP-UX B.11.00 U 9000/800).



Here table tn_work keeps recors of the status of a particula tn (i.e currently tn is in which state) and sql statment uses "tn_work_seq " as a primary key to update the tn_work table .




Re: Getting ORA-0060 Dead lock error [message #356350 is a reply to message #356345] Thu, 30 October 2008 08:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to study the deadlock diagram that is in the trace file to know where it comes from.

Regards
Michel
Re: Getting ORA-0060 Dead lock error [message #356439 is a reply to message #356350] Thu, 30 October 2008 13:21 Go to previous messageGo to next message
prem.y83
Messages: 2
Registered: October 2008
Location: bangalore
Junior Member
okie , but i have one more doubt that in Oracle CPU Patch Oct 2006 Release fixed thid deadlock issue or not ?
Re: Getting ORA-0060 Dead lock error [message #356447 is a reply to message #356439] Thu, 30 October 2008 13:49 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CPU fix SECURITY issues only.
And deadlock is an APPLICATION bug not an Oracle one (almost all the time).

Regards
Michel

[Updated on: Thu, 30 October 2008 13:51]

Report message to a moderator

Previous Topic: fuction in my where condition
Next Topic: get ORA-04098 when inserting nextval into sequence nbr using trigger
Goto Forum:
  


Current Time: Sun Dec 11 06:21:19 CST 2016

Total time taken to generate the page: 0.17613 seconds