ORA-00600: internal error code, arguments: [13013]解决方法

shutdown immediate的时候碰到ORA-00600: internal error code, arguments: [13013]。

错误出现及解决如下：

SQL> shutdown immediate
ORA-00600: internal error code, arguments: [13013], [5001], [483], [4198090],
[64], [4198090], [17], []
SQL> select status from v$instance;

STATUS
------------
OPEN

SQL> select object_name from dba_objects where object_id=483
2 ;

OBJECT_NAME
--------------------------------------------------------------------------------
MON_MODS$
SQL> select index_name from dba_indexes where table_name="MON_MODS$";

INDEX_NAME
------------------------------
I_MON_MODS$_OBJ

SQL> alter index I_MON_MODS$_OBJ rebuild;

Index altered.

SQL> shutdown immediate
ORA-00600: internal error code, arguments: [13013], [5001], [483], [4198090],
[64], [4198090], [17], []
SQL> set pagesize 0
SQL> set long 10000
SQL> select dbms_metadata.get_ddl（"INDEX","I_MON_MODS$_OBJ"） from dual;

CREATE UNIQUE INDEX "SYS"."I_MON_MODS$_OBJ" ON "SYS"."MON_MODS$" （"OBJ#"）
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）
TABLESPACE "SYSTEM"

SQL> drop index I_MON_MODS$_OBJ;

Index dropped.

SQL> CREATE UNIQUE INDEX "SYS"."I_MON_MODS$_OBJ" ON "SYS"."MON_MODS$" （"OBJ#"）
2 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
3 STORAGE（INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
4 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT）
5 TABLESPACE "SYSTEM";

Index created.

SQL> shutdown immediate
ORA-00600: internal error code, arguments: [13013], [5001], [518], [4198419],
[162], [4198419], [17], []
SQL> select object_name from dba_objects where object_id=518;
COL_USAGE$

SQL> select index_name from dba_indexes where table_name="COL_USAGE$";
I_COL_USAGE$

SQL> select dbms_metadata.get_ddl（"INDEX","I_COL_USAGE$"） from dual;

CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" （"OBJ#", "INTCO
L#"）
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）
TABLESPACE "SYSTEM"

SQL> drop index I_COL_USAGE$;

Index dropped.

SQL> CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" （"OBJ#", "INTCO
2 L#"）
3 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
4 STORAGE（INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
5 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT）
6 TABLESPACE "SYSTEM";
CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" （"OBJ#", "INTCO
*
ERROR at line 1:
ORA-00904: "INTCO
L#": invalid identifier
SQL> CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" （"OBJ#", "INTCOL#"）
2 PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
3 STORAGE（INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
4 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT）
5 TABLESPACE "SYSTEM";

Index created.

SQL> shutdown immediate
Database closed.
Database dismounted.
Oracle instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1.0737E+10 bytes
Fixed Size 2114072 bytes
Variable Size 1056968168 bytes
Database Buffers 9646899200 bytes
Redo Buffers 31436800 bytes
Database mounted.
Database opened.
SQL>更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Oracle数据库OPEN状态下迁移数据文件的几种方法ORA-00600: internal error code, arguments: [4194]解决方法相关资讯 ORA-00600

ORA-00600（13013）错误解决方法（今 07:47）
ORA-00600: internal error code, （04月19日）
ORA-00600 错误解决一例（10/21/2015 20:56:11）

一个SQL语句引发的ORA-00600错误排（07月21日）
cursor_sharing引发的ORA-00600错（01月09日）
遭遇 ORA-00600: internal error （09/17/2015 19:21:46）

本文评论查看全部评论（0）