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

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

WBOY
WBOYOriginal
2016-06-07 17:27:262662browse

shutdown immediate的时候碰到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>

linux

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn