Database Reference
In-Depth Information
$ oerr
Usage: oerr facility error
Facility is identified by the prefix string in the error message.
For example, if you get ORA-7300, "ora" is the facility and "7300"
is the error. So you should type "oerr ora 7300".
If you get LCD-111, type "oerr lcd 111", and so on.
OERR reads the plain text error message files shipped with UNIX distributions of the
ORACLE DBMS. Windows distributions merely contain binary error message files. Plain text
error message files have the extension
.msg
, whereas binary error message files have the extension
.msb
. Error message files are located in the directory
$ORACLE_HOME/
component
/
mesg
/
facility
us.msg
.
With the help of the file
$ORACLE_HOME/lib/facility.lis
, OERR translates the facility name
into the corresponding component name. It uses the UNIX utility
awk
to extract the requested
portions from a message file.
Many DBAs are already familiar with OERR. It is known to a lesser degree that it supports
many more facilities than just “ORA”. If, for example, you were running Oracle Clusterware to
support RAC and received the error message “CLSS-02206: local node evicted by vendor node
monitor”, then OERR would have the following advice for you:
$ oerr clss 2206
2206, 1, "local node evicted by vendor node monitor"
// *Cause: The Operating System vendor's node monitor evicted the local node.
// *Action: Examine the vendor node monitor's logs for relevant information.
Some common facility codes and component names are listed in Table 35-1. The compi-
lation in the table is by no means complete. Oracle10
g
boasts a total of 174 facilities.
Table 35-1.
Facility Codes
Facility
Description
CLSR
Message file for Oracle Real Application Clusters HA (RACHA)
CLSS
Message file for Oracle Cluster Synchronization Services
CLST
Message file for modules common to Cluster Ready Services
DBV
Database Verification Utility (DBVERIFY)
DGM
Oracle Data Guard broker command line utility DGMGRL
EXP
Export Utility
IMP
Import Utility
LDAP
OiD LDAP Server
LPX
XML parser
LRM
CORE error message file for the parameter manager
LSX
XML Schema processor
