Oerr

From Oracle FAQ
Jump to: navigation, search

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[edit]

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[edit]

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

External links[edit]

Also see[edit]