执行SQL语句报ORA-00600 错误的解决

 

最近公司应用新开发了 几个功能(jsp+struts+ejb)，当部署成功后，执行其中的一个功能后发现异常错误，

weblogic连接池失效，同时ORACLE ALERT日志报如下错误

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

一开始是怀疑RAC有问题，重新启动数据库后，没有解决，后来怀疑是WEBLOGIC的问题，重新启动及部署应用后，依然没有解决。最后到METALINK上查找相关资料，发现BUGNO5945798 与该现象相似，解决办法是对查询中涉及的表进行统计。

我执行了一下过程

EXEC DBMS_STATS.GATHRE_SCHEMA_STATS('USER');

但是执行之后，错误仍然没有解决，没有办法，在metalink上将这个问题提交，没想到，已经夜里11点多了，还有人在回复问题（估计不是中国吧），oracle给我的回复如下

Searched: WebIV
Keywords: qkabix qkaix qkatab qkajoi qkaqkn qkadrv
Found:
23 Bug.5871502 (10) CT IS GETTING ORA-00600 [QKABIX] INTERMITTANTLY. P59. V1020:
--> working on getting a reproducible testcase
11 Bug.5945798 (31) ORA-00600 [QKABIX] WHILE RUNNING A SELECT STATEMENT P197. V1020:
--> bug closed as Could Not Reproduce after setting init.ora parameter
_B_TREE_BITMAP_PLANS to FALSE and issue was resolved

eos (end of section)

18-APR-07 18:19:35 GMT

.
UPDATE
=======
Hello Wenbo,

Can you pls try setting _B_TREE_BITMAP_PLANS to FALSE and see if it resolves the issue.

Since you are not able to reproduce the error from a sqlplus session, you will need to set this parameter in the pfile/s
pfile:

_B_TREE_BITMAP_PLANS=FALSE

Then shutdown and restart the database.

 

按照oracle的要求操作，问题解决。