Thursday, 18 February 2016

ORA -600 - What to do ?

ORA-600 is an internal error generated by the generic kernel code of the Oracle RDBMS software.

Step 1     
Check alert log for path to trace file.


Step 2   
Look into trace file as a record is written to the the trace file every time ORA-00600 error occurs.

Step 3.

Take the information you get from your trace file and the first argument in the square brackets (the internal message number), and head over to My Oracle Support (Metalink). There you will find a handy ORA-0600 lookup tool (Note 153788.1) that will direct you to additional information that will help you solve your problem.


Each ORA-600 error comes with a list of arguments They 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.


See example screenshot below :

Step 4
Open an Service Request with Oracle support.

No comments:

Post a Comment