Skip to Content
avatar image
Former Member

database check finish with warnings

Dear all

Please guide how can resolve this warings

oracle 9.2.0.7 ,oprating system windos 2003 advanced server sap ECC5

ORA-000060: Deadlock detected. More info in file d:\oracle\prd\saptrace\usertrace\prd_ora_6080.trc.

BR0976W Database message alert - level: ERROR, line: 108900, time: 2007-08-29 19.57.47, message:

ORA-00600: internal error code, arguments: [kdtdelrow-2], [65], [65], [], [], [], [], []

BR0976W Database message alert - level: WARNING, line: 108901, time: 2007-08-29 19.57.47, message:

ORA-00060: deadlock detected while waiting for resource

BR0976W Database message alert - level: WARNING, line: 108904, time: 2007-08-29 19.57.51, message:

ORA-000060: Deadlock detected. More info in file d:\oracle\prd\saptrace\usertrace\prd_ora_5992.trc.

BR0976W Database message alert - level: ERROR, line: 108908, time: 2007-08-29 19.57.51, message:

ORA-00600: internal error code, arguments: [kdtdelrow-2], [61], [61], [], [], [], [], []

BR0976W Database message alert - level: WARNING, line: 108909, time: 2007-08-29 19.57.51, message:

ORA-00060: deadlock detected while waiting for resource

BR0976W Database message alert - level: WARNING, line: 109228, time: 2007-08-30 10.10.44, message:

ORA-000060: Deadlock detected. More info in file d:\oracle\prd\saptrace\usertrace\prd_ora_4212.trc.

BR0976W Database message alert - level: ERROR, line: 109232, time: 2007-08-30 10.10.44, message:

ORA-00600: internal error code, arguments: [kdtdelrow-2], [65], [65], [], [], [], [], []

tahnks in advanced

with reagrds

venkat

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 31, 2007 at 02:30 PM

    go for patchset 9.2.0.8 and the latest minipatch (currently 9.2.0.8.10).

    deadlocks are normaly application specific and not database related. the ORA-000060 only indicates that the Oracle database prevents a deadlock (two or more transactions locking each other)

    Peter

    Add comment
    10|10000 characters needed characters exceeded