ORA-00600 [13013], [5001]故障处理

最新推荐文章于 2025-03-17 17:27:17 发布

congwei1863

最新推荐文章于 2025-03-17 17:27:17 发布

阅读量733

点赞数

文章标签：数据库

博客内容记录了Oracle数据库出现ORA-00600内部错误，具体错误码为[13013], [5001]，并伴随SMON和PMON进程的异常行为。错误导致了非致命内部错误和实例的终止，文中提到了错误详细信息的日志文件路径，并建议使用ADRCI或Support Workbench进行故障包装和解决。" 100989026,8652903,Python爬虫：一键抓取海量表情包，斗图再也不怕,"['Python', '后端开发', '编程语言', 'Python开发', '网络爬虫']

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

alert.log

Thu Jan 07 06:20:40 2016
Errors in file /oracle/app/diag/rdbms/cnpos5qa/cnpos5qa/trace/cnpos5qa_smon_8978724.trc (incident=153713):
ORA-00600: internal error code, arguments: [13013], [5001], [268], [8458146], [5], [8458146], [17], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/cnpos5qa/cnpos5qa/incident/incdir_153713/cnpos5qa_smon_8978724_i153713.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Non-fatal internal error happenned while SMON was doing logging scn->time mapping.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Thu Jan 07 06:20:45 2016
Dumping diagnostic data in directory=[cdmp_20160107062045], requested by (instance=1, osid=8978724 (SMON)), summary=[incident=153713].
Thu Jan 07 06:20:47 2016
Sweep [inc][153713]: completed
Sweep [inc2][153713]: completed
... ...
Thu Jan 07 07:36:03 2016
Errors in file /oracle/app/diag/rdbms/cnpos5qa/cnpos5qa/trace/cnpos5qa_smon_8978724.trc (incident=160007):
ORA-00600: internal error code, arguments: [13013], [5001], [268], [8458146], [5], [8458146], [17], [], [], [], [], []
Incident details in: /oracle/app/diag/rdbms/cnpos5qa/cnpos5qa/incident/incdir_160007/cnpos5qa_smon_8978724_i160007.trc
Thu Jan 07 07:36:06 2016
PMON (ospid: 15532412): terminating the instance due to error 474
Thu Jan 07 07:36:06 2016
System state dump requested by (instance=1, osid=15532412 (PMON)), summary=[abnormal instance termination].
System State dumped to trace file /oracle/app/diag/rdbms/cnpos5qa/cnpos5qa/trace/cnpos5qa_diag_11404196_20160107073606.trc
Dumping diagnostic data in directory=[cdmp_20160107073606], requested by (instance=1, osid=15532412 (PMON)), summary=[abnormal instance termination].
Instance terminated by PMON, pid = 15532412

解决方法：

ORA - 00600 : internal error code , arguments : [ 13013 ] , [ 5001 ] , [ 268 ] , [ 8458146 ] , [ 5 ] , [ 8458146 ] , [ 17 ] , [ ] , [ ] , [ ] , [ ] , [ ]

通过ORA-600报错参数收集对象信息， ORA-600 [13013]参数说明如下：
-----------------------------------------------------------------------------------------
ORA-600 [13013] [a] [b] [c] [d] [e] [f]

Arg [a] Passcount
Arg [b] Data Object number
Arg [c] Tablespace Relative DBA of block containing the row to be updated
Arg [d] Row Slot number
Arg [e] Relative DBA of block being updated (should be same as [c])
Arg [f] Code
------------------------------------------------------------------------------------------
第二个参数“b”，对应的是数据库对象ID

SQL> Select object_name,object_type,owner from dba_objects where data_object_id= 268 ;

OBJECT_NAME OBJECT_TYPE OWNER
--------------- -------------------------------------- ---------------
SMON_SCN_TIME TABLE SYS
SMON_SCN_TO_TIME_AUX CLUSTER SYS

使用validate 检验表关联对象的可用性。使用方法与说明，请参考下面lin
http://blog.itpub.net/17086096/viewspace-1973745/

ORA-01499说明 SYS.SMON_SCN_TIME 关联的索引已损坏。
SQL> Analyze table SYS.SMON_SCN_TIME validate structure cascade online ;
Analyze table SYS.SMON_SCN_TIME validate structure cascade online
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file --若报错信息未ORA-01498,说明表结果或数据损坏。请参考How to resolve ORA-00600 [13013], [5001] (文档 ID 816784.1)

使用 dbms_metadata.get_ddl函数，查看索引的创建信息
SQL> Select dbms_metadata.get_ddl('INDEX','SMON_SCN_TIME_TIM_IDX','SYS') from dual;

DBMS_METADATA.GET_DDL('INDEX','SMON_SCN_TIME_TIM_IDX','SYS')
--------------------------------------------------------------------------------
CREATE UNIQUE INDEX "SYS"."SMON_SCN_TIME_TIM_IDX" ON "SYS"."SMON_SCN_TIME" ("TIME_MP")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "SYSAUX"

重建索引
SQL> drop index "SYS"."SMON_SCN_TIME_TIM_IDX";
SQL> drop index "SYS"."SMON_SCN_TIME_SCN_IDX";
SQL> CREATE UNIQUE INDEX "SYS"."SMON_SCN_TIME_TIM_IDX" ON "SYS"."SMON_SCN_TIME" ("TIME_MP") tablespace sysaux;
SQL> CREATE UNIQUE INDEX "SYS"."SMON_SCN_TIME_SCN_IDX" ON "SYS"."SMON_SCN_TIME" ("SCN") tablespace sysaux;

再次验证，对象已恢复正常。
SQL> Analyze table SYS.SMON_SCN_TIME validate structure cascade online ;

Table analyzed.

可参考METALINK：
Instance Terminated With Error ORA-00474: SMON Process Terminated With Error (文档 ID 1361872.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=421598097050611&id=1361872.1&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=vtmrhkpov_183

How to resolve ORA-00600 [13013], [5001] (文档 ID 816784.1)
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=422436266526312&id=816784.1&displayIndex=4&_afrWindowMode=0&_adf.ctrl-state=vtmrhkpov_330#aref_section22

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

转载于:http://blog.itpub.net/26655292/viewspace-2128490/