ORA 600 kcbo_unlink_q_1

songdeyouxiang

请帮分析下，数据库在08:24突然宕机后台日志报ora 600 ，谢谢！

songdeyouxiang

谢谢，大家还有没好其他想法和思路

Ling.QIu

看了半天 没有11.1 的修复 不好意思

Ling.QIu

Bug 10214450  ORA-600 [kcbo_unlink_q_1] / ORA-600 [504] from Ctrl-C / interrupt
This note gives a brief overview of bug 10214450.
The content was last updated on: 03-FEB-2012
  Click here for details of each of the sections below.

Affects:




Product (Component)

Oracle Server (Rdbms)



Range of versions believed to be affected

Versions BELOW 12.1



Versions confirmed as being affected

•11.2.0.1
•11.1.0.7
•10.2.0.5



Platforms affected

Generic (all / most platforms affected)


It is believed to be a regression in default behaviour thus:
    Regression introduced in 10.2.0.5

Fixed:




This issue is fixed in

•11.2.0.2 (Server Patch Set)
•10.2.0.5.5 Patch Set Update
•10.2.0.5 Patch 13 on Windows Platforms





Symptoms:


Related To:



• ORA-600 [kcbo_unlink_q_1]
•ORA-600 [504]
• Stack is likely to include kgxWait

• (None Specified)


Description

  
The fix for bug 5476091 included in 10.2.0.5 , 11.1.0.7 and 11.2.0.1
can lead to internal errors if an interrupt occurs when in Mutex
handling code:
- ORA-600 [kcbo_unlink_q_1] errors
- ORA-504 with kgxWait on the stack (in 10.2.0.5)

Note:
  One off fixes for this bug also address the issue described in bug 5476091







Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.




References

Bug:10214450 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

songdeyouxiang

Mon Aug 13 08:24:32 2012
Errors in file /usr/oracle/diag/rdbms/dev/dev/trace/dev_ora_12193.trc  (incident=153392):
ORA-00600: internal error code, arguments: [kcbo_unlink_q_1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /usr/oracle/diag/rdbms/dev/dev/incident/incdir_153392/dev_ora_12193_i153392.trc
Mon Aug 13 08:24:36 2012
Trace dumping is performing id=[cdmp_20120813082436]
Errors in file /usr/oracle/diag/rdbms/dev/dev/trace/dev_ora_12193.trc  (incident=153393):
ORA-00600: internal error code, arguments: [kcbo_unlink_q_1], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbo_unlink_q_1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /usr/oracle/diag/rdbms/dev/dev/incident/incdir_153393/dev_ora_12193_i153393.trc
Mon Aug 13 08:24:36 2012
Sweep Incident[153392]: completed
Mon Aug 13 08:24:39 2012
Sweep Incident[153393]: completed
Trace dumping is performing id=[cdmp_20120813082439]
Mon Aug 13 08:24:42 2012
Errors in file /usr/oracle/diag/rdbms/dev/dev/trace/dev_pmon_7089.trc  (incident=152440):
ORA-00600: 内部错误代码, 参数: [kcbo_unlink_q_1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /usr/oracle/diag/rdbms/dev/dev/incident/incdir_152440/dev_pmon_7089_i152440.trc
Errors in file /usr/oracle/diag/rdbms/dev/dev/trace/dev_pmon_7089.trc:
ORA-00600: 内部错误代码, 参数: [kcbo_unlink_q_1], [], [], [], [], [], [], [], [], [], [], []
Mon Aug 13 08:24:49 2012
Doing block recovery for file 3 block 56936
PMON (ospid: 7089): terminating the instance due to error 472
Instance terminated by PMON, pid = 7089