ORA-00600: internal error code, arguments: [13013], [5001], [267], [8455677], [0], [8455677], [17],

最新推荐文章于 2024-07-31 10:17:32 发布

DV2

最新推荐文章于 2024-07-31 10:17:32 发布

阅读量2.5k

点赞数

分类专栏： Oracle 文章标签：数据库 oracle

本文链接：https://blog.csdn.net/Team77/article/details/51612997

版权

Oracle 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

数据库重启后不定期的发生ORA-00600: internal error code, arguments: [13013], [5001], [267], [8455677], [0], [8455677], [17], [], [], [], [], []错误。这里小计一下解决办法

一、查看实例日志

在alter_sid.log中找到最近一次的错误信息


Wed Jun 08 22:28:15 2016
Errors in file /home/oracle/app/diag/rdbms/bsjdb/bsjdb/trace/bsjdb_ora_25780.trc:
Wed Jun 08 22:28:18 2016
Trace dumping is performing id=[cdmp_20160608222818]
Wed Jun 08 22:28:52 2016
Errors in file /home/oracle/app/diag/rdbms/bsjdb/bsjdb/trace/bsjdb_smon_23740.trc  (incident=8567):
ORA-00600: internal error code, arguments: [13013], [5001], [267], [8455677], [0], [8455677], [17], [], [], [], [], []
Incident details in: /home/oracle/app/diag/rdbms/bsjdb/bsjdb/incident/incdir_8567/bsjdb_smon_23740_i8567.trc
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 5 out of maximum 100 non-fatal internal errors.
Wed Jun 08 22:28:53 2016
Trace dumping is performing id=[cdmp_20160608222853]
Wed Jun 08 22:28:54 2016
Sweep [inc][8567]: completed
Sweep [inc2][8567]: completed

得知，实例触发了ora-006错误，但是是非致命的（non-fatal internal errors）
根据提示继续查看.trc日志。

...
*** 2016-06-08 22:08:44.037
*** SESSION ID:(158.1) 2016-06-08 22:08:44.037
*** CLIENT ID:() 2016-06-08 22:08:44.037
*** SERVICE NAME:(SYS$BACKGROUND) 2016-06-08 22:08:44.037
*** MODULE NAME:() 2016-06-08 22:08:44.037
*** ACTION NAME:() 2016-06-08 22:08:44.037

Dump continued from file: /home/oracle/app/diag/rdbms/bsjdb/bsjdb/trace/bsjdb_smon_23740.trc
ORA-00600: internal error code, arguments: [13013], [5001], [267], [8455677], [0], [8455677], [17], [], [], [], [], []

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

*** 2016-06-08 22:08:44.038
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)
...

Google找到类似解决方案After database restore errors appear in the alert log and instance crash -> ORA-00600: [13013], [5001], [267], [8402519], [0], [8402519], [17]

二、重建索引


SQL> ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE;
ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file


SQL> ALTER INDEX SMON_SCN_TIME_TIM_IDX REBUILD ONLINE;

Index altered.

SQL>  ALTER INDEX SMON_SCN_TIME_SCN_IDX REBUILD ONLINE;

Index altered.

SQL>  ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE;

Table analyzed.

至此，已解决