说明:
本文整理自我的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"