一套HP-UX上的9.2.0.8系统，某条查询语句执行时出现ORA-00600: internal error code, arguments: [6033], [], [], [], [], [], [], []内部错误，错误trace信息如下:
*** SESSION ID:(583.18281) 2010-12-20 22:49:01.364 *** 2010-12-20 22:49:01.364 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [6033], [], [], [], [], [], [], [] Current SQL statement for this session: SELECT INTERFACE_HEADER_ID, DOCUMENT_SUBTYPE, AGENT_ID, VENDOR_SITE_ID FROM PO_HEADERS_INTERFACE WHE RE WF_GROUP_ID = :B1 ORDER BY INTERFACE_HEADER_ID ----- PL/SQL Call Stack ----- object line object handle number name c0000001067e3328 4332 package body APPS.PO_AUTOCREATE_DOC c0000000fd267060 1 anonymous block c000000108fe4d60 1979 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1745 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1099 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 560 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1863 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1099 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 560 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1863 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1099 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 560 package body APPS.WF_ENGINE_UTIL c000000108fe4d60 1863 package body PL/SQL call stack truncated after 1024 bytes. ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp()+184 ? ksedst() C0000000CEB36420 ? 400000000147994B ?
已知的ORA-00600:[6033]错误一般和索引逻辑讹误相关,metalink上有相关的Note建议在出现该错误后运行analyze table validate structure cascade语句以验证表与索引间的数据正确性。
ORA-600 [6033] "null value retrieved from index leaf lookup" [ID 45795.1]
Modified 03-JUN-2010 Type REFERENCE Status PUBLISHED
Note: For additional ORA-600 related information please read Note:146580.1
PURPOSE:
This article represents a partially published OERI note.
It has been published because the ORA-600 error has been
reported in at least one confirmed bug.
Therefore, the SUGGESTIONS section of this article may help
in terms of identifying the cause of the error.
This specific ORA-600 error may be considered for full publication
at a later date. If/when fully published, additional information
will be available here on the nature of this error.
SUGGESTIONS:
Run the ANALYZE command on any tables and indexes in the
trace file:
Example: ANALYZE TABLE
VALIDATE STRUCTURE CASCADE;
Rebuild any corrupted indexes.
Index corruption.
Known Bugs
| NB | Bug | Fixed | Description |
| 6401576 | 9.2.0.8.P22 | OERI[ktbair1] / ORA-600 [6101] index corruption possible | |
| 5845232 | 9.2.0.8.P06 | Block corruption / errors from concurrent dequeue operations | |
| 2718937 | 9.2.0.4, 10.1.0.2 | OERI:6033 from SELECT on IOT with COMPRESSED PRIMARY KEY | |
| 1573283 | 8.1.7.2, 9.0.1.0 | OERI:6033 from ALTER INDEX .. REBUILD ONLINE PARAMETERS ('OPTIMIZE FULL') |
通过analyze table validate structure cascade命令验证索引后若存在问题则会进一步产生相关的trace文件，一般这类索引逻辑讹误的问题可以通过drop-recreate索引来解决。
