ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600(6002)错误

ORA-600(6002)错误

原创 Linux操作系统 作者:yangtingkun 时间:2012-04-19 23:54:53 0 删除 编辑

客户数据库出现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.511.2.0.1中被FIXED

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-721890/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10386722