Database Reference
In-Depth Information
Table 35-1.
Facility Codes
Facility
Description
NID
New Database Id (NID Utility)
OCI
Oracle Call Interface
ORA
ORACLE DBMS Server
PCP
Pro*C/C++ C/SQL/PLS/DDL Parser
PLS
PL/SQL
PLW
PL/SQL Warnings
PROT
Oracle Cluster Registry (OCR) Tools
RMAN
Recovery Manager
SP2
SQL*Plus
TNS
Oracle Net Services (Transparent Network Substrate)
UDE
Data Pump Export
UDI
Data Pump Import
UL
SQL*Loader
Retrieving Undocumented Events
In addition to the documented error messages, ORACLE error message files also contain event
numbers of undocumented events. These are handled as if they were error codes and most are
in the range between 10000 and 10999. Just like with true error codes, there's a message asso-
ciated with them. Some of the events are described further in the cause and action sections of
oerr
output.
The following shell script (file
oerr.sh
) retrieves all the events of a particular ORACLE
DBMS release:
event=10000
counter=0
while [ $event -lt 11000 ]
do
text=`oerr ora $event`
if [ "$text" != "" ]; then
counter=`expr $counter + 1`
echo "$text"
fi
event=`expr $event + 1`
done
echo "$counter events found."
