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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Norbert Debes
About this chapter
Cite this chapter
Debes, N. (2009). OERR. In: Secrets of the Oracle Database. Apress. https://doi.org/10.1007/978-1-4302-1953-8_35
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1953-8_35
Publisher Name: Apress
Print ISBN: 978-1-4302-1952-1
Online ISBN: 978-1-4302-1953-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books