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

Encountered Ora 600 error out of nowhere… DB is old and no issues for a year. but suddenly it aborted with below error.
DB : 10.2.0.3

 
Errors in file /opt/app/oracle/admin/PBTOQ/bdump/pbtoq_smon_27517.trc:
ORA-00600: internal error code, arguments: [13013], [5001], [482], [4198088], [114], [4198088], [3], []
Wed Jul  3 21:34:42 2013
Errors in file /opt/app/oracle/admin/PBTOQ/bdump/pbtoq_pmon_27505.trc:
ORA-00474: SMON process terminated with error
Wed Jul  3 21:34:42 2013
PMON: terminating instance due to error 474


1. identify the table.

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

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
---------------------------------------------------------
OWNER
--------------------------------------------------------------------------------
MON_MODS$
TABLE
SYS

2. validate table

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

Table analyzed.

SQL> analyze table SYS.MON_MODS$ validate structure cascade online;
analyze table SYS.MON_MODS$ validate structure cascade online
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file

SQL>

3. check the index involve.

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

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

SQL>

4. get DDL of the index and recreate it.

  
SQL> Set long 100000000
SQL> Select dbms_metadata.get_ddl('INDEX','I_MON_MODS$_OBJ','SYS') 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 "SYS"."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> analyze table SYS.MON_MODS$ validate structure cascade online;

Table analyzed.

SQL>

check alert log for any error.

Advertisements

13 thoughts on “ORA-00600: internal error code, arguments: [13013], [5001], [482]

  1. looks great, but in my case i works different:

    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

    analyze table SYS.SMON_SCN_TIME

    — no error
    validate structure online;

    analyze cluster SYS.SMON_SCN_TO_TIME_AUX
    validate structure;

    *
    ERROR at line 1: ORA-01499: table/index cross reference failure – see trace file

    INDEX_NAME
    ——————————
    SMON_SCN_TO_TIME_AUX_IDX

    select index_name from dba_indexes where table_name=’SMON_SCN_TO_TIME_AUX’;

    Set long 100000000
    Select dbms_metadata.get_ddl(‘INDEX’,’SMON_SCN_TO_TIME_AUX_IDX’,’SYS’) from dual;
    CREATE INDEX “SYS”.”SMON_SCN_TO_TIME_AUX_IDX” ON CLUSTER “SYS”.”SMON_SCN_TO_TIME_AUX”
    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 “SYSTEM”;

    drop index sys.SMON_SCN_TO_TIME_AUX_IDX
    *
    error in line 1:ORA-01418: Index does not exist

    CREATE INDEX “SYS”.”SMON_SCN_TO_TIME_AUX_IDX” ON CLUSTER “SYS”.”SMON_SCN_TO_TIME_AUX”
    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 “SYSTEM”;

    CREATE INDEX “SYS”.”SMON_SCN_TO_TIME_AUX_IDX” ON CLUSTER “SYS”.”SMON_SCN_TO_TIME_AUX”
    *
    error in line 1: ORA-00942: Table or view does not exist

    Any help welcome

    best Regards
    Herbert

  2. try searching in metalink for working on cluster. the issue i encountered is on none cluster table.

    what is the ora error in alert log and will try to help search related article.

  3. Thx for answering. This hopefully solved the problem:

    drop index “SYS”.”SMON_SCN_TIME_TIM_IDX”;
    drop index “SYS”.”SMON_SCN_TIME_SCN_IDX”;
    CREATE UNIQUE INDEX “SYS”.”SMON_SCN_TIME_TIM_IDX” ON “SYS”.”SMON_SCN_TIME” (“TIME_MP”) tablespace sysaux;
    CREATE UNIQUE INDEX “SYS”.”SMON_SCN_TIME_SCN_IDX” ON “SYS”.”SMON_SCN_TIME” (“SCN”) tablespace sysaux;

    analyze cluster SYS.SMON_SCN_TO_TIME_AUX validate structure;
    — no error

    Best Regards
    Herbert

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s