20160611-ORA-00600: 内部错误代码, 参数: [13013]

说明:

本文整理自我的ITPUB博客，链接如下:

https://blog.itpub.net/29785807/viewspace-2118427/

环境说明:

数据库版本： Oracle 11.2.0.1.0
数据库服务器操作系统： Windows server 2008

错误号 (1) ：

ORA-00600: internal error code, arguments: [13013], [5001], [267] , [8460734], [2], [8460734], [17], [], [], [], []

详细报错如下 :

Mon May 30 11:40:28 2016
Errors in file e:\app\administrator\diag\rdbms\klnew\klnew\trace\klnew_smon_2184.trc  (incident=93782):
ORA-00600: internal error code, arguments: [13013], [5001], [267] , [8460734], [2], [8460734], [17], [], [], [], [], []
Incident details in: e:\app\administrator\diag\rdbms\klnew\klnew\incident\incdir_93782\klnew_smon_2184_i93782.trc
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 3 out of maximum 100 non-fatal internal errors.
Mon May 30 11:40:30 2016

问题现象 (1) ：

SMON encountered 3 out of maximum 100 non-fatal internal errors.

数据库运行一段时间，实例自动关闭；
查看： klnew_smon_2184_i93782.trc

========= Dump for incident 93782 (ORA 600 [13013]) ========

*** 2016-05-30 11:40:28.480
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=dma0vxbwh325p) -----
update smon_scn_time
   set time_mp      = :1,
       time_dp      = :2,
       scn          = :3,
       scn_wrp      = :4,
       scn_bas      = :5,
       num_mappings = :6,
       tim_scn_map  = :7
 where scn = (select min(scn) from smon_scn_time)

错误号 (2) ：

ORA-00600: internal error code, arguments: [13011], [267], [8460734] , [2], [8460734], [17], [], [], [], [], [], []

详细报错如下：

Mon May 30 11:30:24 2016

Errors in file e:\app\administrator\diag\rdbms\klnew\klnew\trace\klnew_smon_2184.trc  (incident=93780):
ORA-00600: internal error code, arguments: [13011], [267], [8460734] , [2], [8460734], [17], [], [], [], [], [], []
Incident details in: e:\app\administrator\diag\rdbms\klnew\klnew\incident\incdir_93780\klnew_smon_2184_i93780.trc
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Mon May 30 11:30:26 2016

问题现象 (2) ：

SMON encountered 3 out of maximum 100 non-fatal internal errors.

数据库运行一段时间，实例自动关闭；
查看 klnew_smon_2184_i93780.trc ：

========= Dump for incident 93780 (ORA 600 [13011]) ========
*** 2016-05-30 11:30:24.650
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=gm9t6ycmb1yu6) -----
delete from smon_scn_time where scn = (select min(scn) from smon_scn_time)

错误号 (3) ：

ORA-00600: internal error code, arguments: [13013], [5001], [456] , [4338038], [0], [4338038], [17], [], [], [], [], []

详细报错如下：

Fri May 27 17:25:50 2016
Errors in file e:\app\administrator\diag\rdbms\klnew\klnew\trace\klnew_smon_516.trc  (incident=90132):
ORA-00600: internal error code, arguments: [13013], [5001], [456] , [4338038], [0], [4338038], [17], [], [], [], [], []
Incident details in: e:\app\administrator\diag\rdbms\klnew\klnew\incident\incdir_90132\klnew_smon_516_i90132.trc
Non-fatal internal error happenned while SMON was doing flushing of monitored table stats.
SMON encountered 1 out of maximum 100 non-fatal internal errors.

问题现象 (3) ：

数据库无法通过 shutdown immediate 方式关闭，只能通过 shutdown abort 关闭
查看： klnew_smon_516_i90132.trc

========= Dump for incident 90132 (ORA 600 [13013]) ========
*** 2016-05-27 17:25:50.929
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=3c1kubcdjnppq) -----
update sys.col_usage$
   set equality_preds    = equality_preds +
                           decode(bitand(:flag, 1), 0, 0, 1),
       equijoin_preds    = equijoin_preds +
                           decode(bitand(:flag, 2), 0, 0, 1),
       nonequijoin_preds = nonequijoin_preds +
                           decode(bitand(:flag, 4), 0, 0, 1),
       range_preds       = range_preds + decode(bitand(:flag, 8), 0, 0, 1),
       like_preds        = like_preds + decode(bitand(:flag, 16), 0, 0, 1),
       null_preds        = null_preds + decode(bitand(:flag, 32), 0, 0, 1),
       timestamp         = :time
 where obj# = :objn
   and intcol# = :coln

解决方案：

ORA-00600: [13013] , [5001] , [267]
ORA-00600: [13011], [267]
select * from dba_objects where object_id= 267; 

select * from dba_ind_columns where table_name=' SMON_SCN_TIME';

ORA-00600: [13013] , [5001], [456]
select * from dba_objects where object_id= 456; 

select * from dba_ind_columns where table_name= 'COL_USAGE$';

select dbms_metadata.get_ddl(' INDEX',' I_COL_USAGE$',' SYS') from dual;

唯一索引里出现了重复数据
删除索引 I_COL_USAGE$， 重建 非唯一 索引；

 New and  Improved: ORA-600 [13013] "Unable to get a Stable set of Records" ( 文档 ID 1438920.1)

欢迎关注我的微信公众号"IT小Chen"