An exposition of ORACLE ORA-00600 errors

oracle| Error Oracle ORA-00600 error is not your program error. Oracle internal error, in general, most ORA-00600 errors are made by Oracle


software bugs, so you need to contact Oracle Technical support engineers in time for such errors. For this type of ORA-00600 error,


a simple way to do this is to patch, upgrade the database to a stable version, and also recommend masking some Oracle features, such as MTS


(multithread Server). But there are also parts of the error that are made by


the table or index inside the database (including the applied) structure is corrupted or otherwise caused.





1:ora-600[12700] indicates that some entity (Table/index) is corrupted when executing the SQL statement, and that the


error is handled by:


? Modify the Init$oracle_sid.ora file to add the following lines:


event = "10210 Trace name Context Forever level 10"


event = "10211 Trace name Context Forever level 10"


event = "10231 Trace name forever level 10


? Execute the following statement:


analyze Table/index/cluster [name] validate structure;


? If you suspect that the data dictionary is corrupted, you cannot use the above method to analyze the table,


because performing the above on some platforms will cause system paralysis, execute the following stored procedure:


dbms_utility. Analyze_schema


Example 2: An error occurred while reading and writing to the database: ora-00600:internal error


CODE,ARGUMENTS:[4519],[6711],[2],... Represents the corresponding entity data when executing an SQL statement

The structure of the
block [6711] is caused by destruction. This error is handled by:


? Perform the following package for analysis:


svrmgrl > select Dbms_utility.data_block_address_file (6711) from dual;


svrmgrl > select Dbms_utility.data_block_address_block (6711) from dual;


to find its corresponding block_id and file_id.


? Find the corrupted entity type, owner, etc. by using the following SQL command:


svrmgrl > select Segment_name,segment_type,owner


? From Dba_extents


? where file_id=file# and block# between


? block_id and Block_id+blocks-1;


? If the corrupted object is not a system table or index, you can pass the database object \ r


the method of recreating the entity after the backup. If the error is a system table or index, you need


according to the actual situation to deal with.








in addition, using resultset to perform inserts, updates, and deletions is, in principle, feasible, but inefficient, and cannot test the success of the operation.