Sunday, January 25, 2015

ORA-00600: internal error code, arguments: [13013], [5001], [517]


Scenerio 

ORACLE RDBMS Version: 10.2.0.3.0 - x86_64 GNU/Linux

Throws error message :  ORA-00600: internal error code, arguments: [13013], [5001], [517], [4260059], [139], [4260059], [3], []  in the alert log and sometimes, the database stops working ...

Workaround 

SQL> Select object_name,object_type,owner from dba_objects where data_object_id=517;
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE         OWNER
------------------- ------------------------------
COL_USAGE$
TABLE               SYS

SQL> analyze table SYS.COL_USAGE$ validate structure online;

Table analyzed.

SQL> analyze table SYS.COL_USAGE$ validate structure cascade online;
analyze table SYS.COL_USAGE$ validate structure cascade online
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [],[]

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

INDEX_NAME
------------------------------
I_COL_USAGE$

SQL> Set long 1000000
SQL> Select dbms_metadata.get_ddl('INDEX','I_COL_USAGE$','SYS') from dual;

DBMS_METADATA.GET_DDL('INDEX',
--------------------------------------------------------------------------------

 CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" ("OBJ#", "INTCOL#")
  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 "SYS"."I_COL_USAGE$";

Index dropped.

SQL> CREATE UNIQUE INDEX "SYS"."I_COL_USAGE$" ON "SYS"."COL_USAGE$" ("OBJ#", "INTCOL#") 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";

Index created.

SQL> analyze table SYS.COL_USAGE$ validate structure cascade online;




Table analyzed. ---------------------------------------------------------------------------------------------------------------
Oracle Doc ID : 816784.1

No comments:

Post a Comment