The OERR utility, which ships with Oracle software distributions for UNIX and Linux, provides quick access to ORACLE DBMS error message texts based on an error message code. The code consists of a facility name and a positive number. Furthermore, the cause and action sections retrieved by OERR along with the error message may help in solving a problem at hand. The OERR script is mentioned in Oracle10g documentation in conjunction with TNS errors (see Oracle Database Net Services Administrator’s Guide). It is undocumented that OERR supports additional categories of errors except TNS. The SQL * Plus User’s Guide and Reference Release 9.2 states that “the UNIX oerr script now recognizes SP2- error prefixes to display the Cause and Action text”, but does not explain how to use OERR. It is undocumented that most events (e.g., 10046 for extended SQL trace) known by the DBMS instance are also represented in the message files read by OERR and that a short description on each event is available.


Dition Prefix Inte Grity Veri 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Norbert Debes 2009

Authors and Affiliations

  • Norbert Debes

There are no affiliations available

Personalised recommendations