Skip to Content
0

ORA-00060 error - application deadlock issue

Jan 12, 2017 at 11:55 AM

190

avatar image

Hi Experts,

We are facing deadlock in our system, It is application deadlock with oracle DB.

I'm attaching the alert of the deadlock, please help to troubleshot and understand the issue... Is any parameter to set avoid user/application deadlock.

Alert

-------

deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:

Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-0069000a-00021b71 661 2089 X 216 3266 X
TX-0018001c-0005df14 216 3266 X 661 2089 X

session 2089: DID 0001-0295-00000006 session 3266: DID 0001-00D8-00000004
session 3266: DID 0001-00D8-00000004 session 2089: DID 0001-0295-00000006

----------------------------------------------------------------------------------

Already i go through these SAP notes,

-----> https://launchpad.support.sap.com/#/notes/0001872040

-----> https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=414089456

I'm waiting for your valuable Replay,

Regards,

Sajmal TS

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

James Zhang
Jan 13, 2017 at 12:57 AM
1

Hi Sajmal,

This has nothing to do with database. :)

Application deadlock needs to be solved by "application", you can find the involved table in the deadlock trace, then involve the applciation team who is responsible for this table, or raise a ticket to SAP application support team.

Best regards,
James

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi James,

Thanks for your valuable replay,

I had one doubt, If any parameter to set to resolve this issue ?

Regards,

Sajmal

0

Hi Sajmal,

If it is application deadlock, then there is no way to solve it from database level.

best regards,
James

0
avatar image
Former Member Jan 13, 2017 at 06:10 PM
1

Hi Sajmal,

Take a look at below link, it has steps how to proceed with further analysis.

https://wiki.scn.sap.com/wiki/display/ORA/How+to+approach+ORA-00600+errors

Regards,

Harish Karra

Share
10 |10000 characters needed characters left characters exceeded
Reagan Benjamin
Jan 13, 2017 at 11:23 PM
1

ORA-00600 error is not something new. There is no parameter to be set to get rid of the ORA-00600 message. The database is working as designed. There are plenty of resources available online. Take time to read them. You need to analyze the deadlock trace file and see what caused it. The trace file will also show the SQL statement. You need to find out whether it was caused by some jobs (check dumps) and the reason why it happened (probably scheduling?).

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 12, 2017 at 08:01 PM
-1

Hi,

What is your DB version and patch level. Normally ORA 600 errors can be ignored (in specific versions/patch levels) until unless it is causing to any serious issue.

Regards,

Harish Karra

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Harish,

Thanks for your replay,

Our DB is Oracle - 11.2.0.4.0

When we go to oracle alert log we can see it is not an oracle deadlock, it is as application deadlock

Regards,

Sajmal

0