ORA-600 (ORA-00600 Internal Error) Detection, Diagnosis & Resolution

Step by step instructions for detection, diagnosis & resolution of ORA-600 (ORA-00600 Internal error)

As a DBA it is not uncommon to find ORA-00600 errors in your alert log.

Because there is no other context to the ORA-600 it can be difficult to know if it's something you need to act on.

This post guides you through what the error means, how to use Oracle Trace File Analyzer (TFA) to detect it, how to diagnose the cause and then how to resolve.

Here's what's covered below:

• What is an ORA-600 (ORA-00600 internal error)?
• How to automatically detect and ORA-00600 and capture diagnostics before they are lost