ORA-600 Lookup Error Categories (part 1)

What causes this error?
ORA-600 is an internal error generated by the generic kernel code of the Oracle RDBMS software.
It is different from other Oracle errors in many ways.
The following is a list of these differences:
1. An ORA-600 error may or may not be displayed on the screen. Therefore, screen output should not be relied on for capturing information on this error. Information on ORA-600 errors are found in the database alert and trace files. We recommend that you check these files frequently for database errors. (See the Alert and Trace Files section for more information.)
2. Each ORA-600 error comes with a list of arguments.
They are usually enclosed in square brackets and follow the error on the same line.
For example:
ORA-00600 [14000][51202][1][51200][][]
Each argument has a specific meaning which can only be interpreted by an Oracle support analyst. The arguments may also change meaning from version to version therefore customers are not advised to memorize them.
3. Every occurrence of an ORA-600 should be reported to Oracle Support. Unlike other errors, you can not find help text for these errors. Only Oracle technical support should diagnose and take actions to prevent or resolve damage to the database.
4. Each ORA-600 error generates a database trace file.
Possible causes include (but are not limited to):
1. time-outs
2. file corruption
3. failed data checks in memory, hardware, memory, or I/O messages
4. incorrectly restored files
5. a SELECT FROM DUAL statement in PL/SQL within Oracle Forms (you have to use SELECT FROM SYS.DUAL instead!)

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *