Skip to Content

ORA-00060 error - application deadlock issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 13, 2017 at 12:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2017 at 11:23 PM

    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?).

    Add comment
    10|10000 characters needed 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

    Add comment
    10|10000 characters needed 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