Oerr

Oerr is an Oracle utility that extracts error messages with suggested actions from the standard Oracle message files. This utility is very useful as it can extract OS-specific errors that are not in the generic Error Messages and Codes Manual.

oerr for Unix

Oerr is installed with the Oracle Database software and is located in the ORACLE_HOME/bin directory.

Example:

$ oerr ora 600
ora-00600: internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]
 *Cause:  This is the generic internal error number for Oracle program
          exceptions.  This indicates that a process has encountered an
          exceptional condition.
*Action: Report as a bug - the first argument is the internal error number

oerr for Windows

Oracle doesn't ship an "oerr" utility for Windows platforms. However, a perl script is available to simulate oerr behavior on Windows.

External links

• Oracle error search
• John Barrenechea's Windows oerr: does not require the Oracle error documentation and message files

Also see

• Category:Errors, list of common errors.