Oracle Utilities - Using Hidden
Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and
More
How oerr Works
To best understand exactly how oerr works, review the shell script. The
oerr.ksh script is provided by Oracle in the $ORACLE_HOME/bin directory.
The commands in the oerr.ksh shell script confirm that $ORACLE_HOME is
set, and if not, the program terminates. Next, the facility information
is read from the facility file located in $ORACLE_HOME/lib/facility.lis.
Below is a portion of the facility.lis file. The facility file contains
three mandatory data items and one optional. The mandatory data items
include the facility, component, and the name of the alias for the
component, if one exists, otherwise a “*” will be used. In the file
below, “ora” is the facility, “rdbms” is the component, and it does not
have an alias “*”. The optional data item is the description, which none
are provided in the file below.
The above is an excerpt from Oracle Utilities - Using
Hidden Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof
and More by Rampant TechPress.
For more details on Oracle
utilities, see the book "Advanced
Oracle Utilities" by Bert Scalzo, Donald K. Burleson, and Steve Callan.
You can buy it direct from the publisher
for 30% off directly from
Rampant TechPress.
