ORA-00600: internal error code, arguments: [qkabix]

最新推荐文章于 2019-10-28 21:10:44 发布

cka6619

最新推荐文章于 2019-10-28 21:10:44 发布

阅读量300

点赞数

文章标签：数据库

应用的人反应说执行以下语句，报ora-600错误，

SELECT
      T3.CONFLICT_ID,
      T3.LAST_UPD,
      T3.CREATED,
      T3.LAST_UPD_BY,
      T3.CREATED_BY,
      T3.MODIFICATION_NUM,
      T3.ROW_ID,
      T3.X_CHRED_INT_ID,
      T3.ATTRIB_03,
      T3.ATTRIB_01,
      T3.ATTRIB_38,
      T3.ATTRIB_46,
      T3.ATTRIB_06,
      T3.ATTRIB_11,
      T3.ATTRIB_17,
      T3.ATTRIB_36,
      T3.ATTRIB_10,
      T3.ATTRIB_04,
      T3.ATTRIB_07,
      T3.ATTRIB_14,
      T3.ATTRIB_02,
      T3.ATTRIB_16,
      T3.ATTRIB_26,
      T3.ATTRIB_45,
      T3.ATTRIB_35,
      T3.ATTRIB_44,
      T3.ATTRIB_13,
      T3.PAR_ROW_ID,
      T2.PROCESSED_FLG,
      T3.ATTRIB_15,
      T3.ATTRIB_18,
      T3.ATTRIB_37,
      T3.ATTRIB_12,
      T3.ATTRIB_34,
      T3.ATTRIB_42,
      T3.ATTRIB_41,
      T3.ATTRIB_40,
      T3.ATTRIB_39,
      T3.ATTRIB_43
   FROM
       SIEBEL.S_ORDER_ITEM T1,
       SIEBEL.S_ORDER_ITEM T2,
       SIEBEL.S_ORDER_ITEM_XM T3
   WHERE
      T3.PAR_ROW_ID = T1.ROW_ID AND
      T3.ATTRIB_05 = T2.ROW_ID AND
      (T1.ORDER_ID = :1 AND T3.ATTRIB_03 = :2)
   ORDER BY
      T3.TYPE, T3.NAME

查看alertlog日志发现

Errors in file /app/oracle/admin/****/udump/****_ora_2913.trc:
ORA-00600: internal error code, arguments: [qkabix], [0], [], [], [], [], [], []
Sun Apr 6 17:25:51 2008

在metalink开SR发现命中bug 4564389 在修改init参数后错误解决：_B_TREE_BITMAP_PLANS=FALSE

以下为具体信息：

ORA-00600: internal error code, arguments: [qkabix]

Errors in file /app/oracle/admin/*****/udump/****_ora_2913.trc:

ORA-00600: internal error code, arguments: [qkabix], [0], [], [], [], [], [], []

Sun Apr 6 17:25:51 2008

This error is reported when Oracle fails with rowid-to-bitmap conversion.
Caused due to Bug 4564389, DEV believes this is a duplicate bug of Bug 3219917

CAUSE JUSTIFICATION
====================
Call stack and symptom matches.

.
PROPOSED SOLUTION(S)
======================
1. Workaround:

set _B_TREE_BITMAP_PLANS=FALSE in init.ora and retry the operation.

--OR--

2. Apply the latest patchset 9208 to get fix all known bugs including this one.

PROPOSED SOLUTION JUSTIFICATION(S)
====================================
This issue is described in Metalink Bug 3219917, which explain the workaround and this issue has been fixed on top of 9208.
No one-off patch is available for 9205

.
SOLUTION / ACTION PLAN
=======================
Please perform. either of the following solution:

1. Workaround:

set _B_TREE_BITMAP_PLANS=FALSE in init.ora and retry the operation.

--OR--

2. Apply the latest patchset 9208 to get fix all known bugs including this one.

If feasible ,I would also recommend you to plan to upgrade the DB latest patchset to 9208 (9i) or 10.2.0.3 (10g) w
hich fixes many of the known bugs/issues arised/encountered in previous releases
, current release and also makes you to log a new bug in case if we encounter an
y new issue in the DB.

Advantages for being on the latest patchset release:

+ latest patchset contains fix for all the known issues/Bugs raised in previous re
leases.
+ patchsets doesn't include any new functionality, it's only for bug fixing
+ new bugs can only be logged against latest patchset release of supported versions
+ backports can only be requested against latest patchset release of supported versions
+ most stable release since a lot of bugs are already be fixed in the successive patchsets