ORA-00600: internal error code, arguments: [13011], [67714], [8421315]

ORA-00600: internal error code, arguments: [13011], [67714], [8421315]

Error in Alert log file:

Fri Aug 09 09:01:06 2013
c:\app\administrator\diag\rdbms\itimdb\itimdb\trace\itimdb_j000_9064.trc  (incident=91417):
ORA-00600: internal error code, arguments: [13011], [67714], [8421315], [2], [8421317], [0], [], [], [], [], [], []
Incident details in: c:\app\administrator\diag\rdbms\itimdb\itimdb\incident\incdir_91417\itimdb_j000_9064_i91417.trc

This format relates to Oracle Server 8.0.3 to 10.1
Arg [a] Passcount
Arg [b] Data Object number
Arg [c] Tablespace Relative DBA of block containing the row to be updated
Arg [d] Row Slot number
Arg [e] Relative DBA of block being updated (should be same as [c])
Arg [f] Code

 
Check the object id with following error:

SQL> select object_name,object_type,owner from dba_objects where data_object_id=67714;

OBJECT_NAME                  OBJECT_TYPE OWNER
---------------------------  ----------- ------
MGMT_SYSTEM_PERFORMANCE_LOG  TABLE       SYSMAN


Analyse the table

SQL> analyze table sysman.mgmt_system_performance_log validate structure cascade;
Table analyzed.

Check the data file

SQL> select dbms_utility.data_block_address_file(8421315) from dual;
Rfile#
----------
2

SQL>  Select name from v$datafile where rfile#=2;
NAME
------------------------------------------------
C:\APP\ADMINISTRATOR\ORADATA\ITIMDB\SYSAUX01.DBF

Verify the corruption with database verify utility DBV

DDV file=C:\APP\ADMINISTRATOR\ORADATA\ITIMDB\SYSAUX01.DBF nothing found.

Find the index related to tables:

SQL> select index_name from dba_indexes where table_name = 'MGMT_SYSTEM_PERFORMANCE_LOG';
INDEX_NAME
------------------------------
MGMT_SYSTEM_PERF_LOG_IDX_01
MGMT_SYSTEM_PERF_LOG_IDX_02

Rebuild index online:

SQL> alter index sysman.mgmt_system_perf_log_idx_01 rebuild online;
Index altered.
SQL> alter index sysman.mgmt_system_perf_log_idx_02 rebuild online;
Index altered.

After rebuild indexes the error is finished.
 

Advertisements

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s