客户数据库出现ORA-600(6002)错误。

在告警文件中出现大量的错误：

Sun Apr 1 16:15:41 2012
Errors in file /oracle/orcl/udump/orcl_ora_16555.trc:
ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []
Sun Apr 1 16:16:43 2012
Errors in file /oracle/orcl/udump/orcl_ora_16555.trc:
ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []
Sun Apr 1 16:17:44 2012
Errors in file /oracle/orcl/udump/orcl_ora_16961.trc:
ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []
Sun Apr 1 16:18:45 2012
Errors in file /oracle/orcl/udump/orcl_ora_16961.trc:
ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []
Sun Apr 1 16:19:47 2012
Errors in file /oracle/orcl/udump/orcl_ora_16961.trc:
ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []
Sun Apr 1 16:20:48 2012
Errors in file /oracle/orcl/udump/orcl_ora_16555.trc:
ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []
Sun Apr 1 16:21:49 2012
Errors in file /oracle/orcl/udump/orcl_ora_16961.trc:
ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []

详细错误信息为：

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [6002], [0], [0], [4], [0], [], [], []
Current SQL statement for this session:
INSERT INTO TABLE_STAT (ID ,START_TIME, END_TIME) VALUES (:1, :2, :3)        
----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
ksedst()+31          call     ksedst1()            000000000 ? 000000001 ?
                                                   7FFF7063E240 ? 7FFF7063E2A0 ?
                                                   7FFF7063E1E0 ? 000000000 ?
ksedmp()+610         call     ksedst()             000000000 ? 000000001 ?
                                                   7FFF7063E240 ? 7FFF7063E2A0 ?
                                                   7FFF7063E1E0 ? 000000000 ?
ksfdmp()+21          call     ksedmp()             000000003 ? 000000001 ?
                                                   7FFF7063E240 ? 7FFF7063E2A0 ?
                                                   7FFF7063E1E0 ? 000000000 ?
kgeriv()+176         call     ksfdmp()             000000003 ? 000000001 ?
                                                   7FFF7063E240 ? 7FFF7063E2A0 ?
                                                   7FFF7063E1E0 ? 000000000 ?
kgeasi()+263         call     kgeriv()             0068966E0 ? 2AAACED21168 ?
                                                   000000000 ? 000000000 ?
                                                   7FFF7063E1E0 ? 000000000 ?
kdiins0()+4578       call     kgeasi()             0068966E0 ? 2AAACED21168 ?
                                                   000001772 ? 000000002 ?
                                                   000000004 ? 000000000 ?
kauxsin()+4261       call     kdiins0()            11BCC8DD0 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
insidx()+2461        call     kauxsin()            11BCC8E38 ? 7FFF70651640 ?

这个错误一般都是索引块出现了逻辑损坏造成的，解决方法其实很简单，将索引删除重建一般就可以解决问题。如果想要使用REBUILD的方式重建索引，记得加上ONLINE选项，确保在索引重建的时候选择读表，而不是从本来就存在数据错误的索引来获取数据。

关于ORA-600[6002]错误的更多问题可以参考文档ID 47449.1，而对于当前版本可能的bug，则应该是Bug 6621940 - Corruption after MOVE of an empty partition with local indexes [ID 6621940.8]，这个问题在10.2.0.5和11.2.0.1中被FIXED。