OERR

Abstract

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.