Wednesday, November 20, 2013

ORA-00600: internal error code, arguments: [6749]

When you see these errors in alert log this is block corruption on some files. Usually due to BUG 6127434 these objects are owned by SYS / SYSMAN and are residing on SYSAUX tablespace

Follow the example for the solution:

1. Error identification :

Thu Nov 14 07:01:07 GTB Standard Time 2013
Errors in file c:\oracle\product\10.2.0\admin\ergose\bdump\mysid_j000_3028.trc:
ORA-00600: internal error code, arguments: [6749], [3], [12614560], [1], [], [], [], []

From the trace file find find the FILE_ID and the BLOCK_NUMBER

Check for similar lines :

DBAs (file#, block#): (3, 30754) 

Run the foillwoing query:

SELECT tablespace_name, segment_type, owner, segment_name 
    FROM dba_extents 
    WHERE file_id = 3
    and 30754 between block_id AND block_id + blocks - 1;

SYSAUX  INDEX     SYSMAN MGMT_METRICS_RAW_PK


select owner,index_name,index_type,table_name from dba_indexes where index_name in ('MGMT_METRICS_RAW_PK','MGMT_CURRENT_METRICS_PK');

OWNER INDEX_NAME INDEX_TYPE TABLE_NAME
SYSMAN MGMT_METRICS_RAW_PK IOT - TOP MGMT_METRICS_RAW

Problem originated from MGMT_METRICS_RAW table (IOT)

With SQLPLUS As sys as sysdba:

SQL> create table SYSMAN.MGMT_METRICS_RAW_COPY 
as select * from SYSMAN.MGMT_METRICS_RAW;

SQL> insert into SYSMAN.MGMT_METRICS_RAW select * from SYSMAN.MGMT_METRICS_RAW_COPY; 
SQL> commit;

SQL> drop table SYSMAN.MGMT_METRICS_RAW_COPY; 

1 comment:

  1. Very informative feature indeed, i have come across a similar solution at an ERP Job Board

    ReplyDelete