Table of Contents
This user guide will help you if you notice the internal arguments of the ora-00600 13011 error code.
Approved: ASR Pro
Error in warning file:
Friday, August 09, 09:01:06 2013
c:appadministratordiagrdbmsitimdbitimdbtraceitimdb_j000_9064.trc (incident=91417):
ORA-00600: refrigerator and freezer code, error arguments: [13011], [67714], [8421315], [2], [8421317], [0], [], [], [], [], [ ] , []
Incident details: c:appadministratordiagrdbmsitimdbitimdbincidentincdir_91417itimdb_j000_9064_i91417.trc
This applies to Oracle Server 8.0.3-10.1
Arg [a] Password
Arg [b] data object number
Arg [c] Relative tablespace DBA of the block containing the row to actually update
Arg[d] line slot number
Arg [e] Relative DBA of the actual updated block (should be equal to [c])
Code Arg[f]
Check the object ID for the following error:
SQL> select object_name, object_type, owner of all of dba_objects data_object_id=67714;
Analyze the table Checking for corruption with the DBV Database Check Tool
SQL> view table sysman.mgmt_system_performance_log, check cascading structure;
The table has been parsed.
Check the data file
SQL>dbms_utility select.data_block_address_file(8421315) to double;
Rfile#
----------
2
File DDV=C:APPADMINISTRATORORADATAITIMDBSYSAUX01.DBF was not found.
Find index relative to tables:
SQL> Consider index_name for dba_indexes where table_name implies 'MGMT_SYSTEM_PERFORMANCE_LOG';
INDEX_NAME
-------------------------------
MGMT_SYSTEM_PERF_LOG_IDX_01
MGMT_SYSTEM_PERF_LOG_IDX_02
Rebuild online index change:
SQL> interactive rebuilt collection sysman.mgmt_system_perf_log_idx_01;
Index changed.
sql> change checklist sysman.mgmt_system_perf_log_idx_02 rebuild online ;
Index changed.
After rebuilding the index, the error is fixed.