Oracle Utilities - Using Hidden
Programs, Import/Export, SQL Loader, oradebug, Dbverify, Tkprof and
More
Viewing Errors with the oerr Utility
The oerr utility (Oracle Error) is provided only with Oracle databases
on UNIX platforms. oerr is not an executable, but instead, a shell
script that retrieves messages from installed message files. The utility
is not provided on Windows systems, since it uses awk commands to
retrieve the requested text from the file. However, later in this
chapter, a Windows-based implementation will be provided.
The syntax required of the oerr utility is:
oerr <facility> <error>
The facility is the prefix to the error number. These include ORA, PLS,
EXP, etc. The error is the actual error number returned by Oracle.
For example, if the database returned an ORA-12544 error, the following
oerr command would be executed to gain more information:
$ oerr ora 12544
12544, 00000, "TNS:contexts have different wait/test functions"
// *Cause: Two protocol adapters have conflicting wait/test functions.
// *Action: Not normally visible to the user. For further details, turn
// on tracing and reexecute the operation. If error persists, contact
// Oracle Customer Support.
Notice that Oracle returned the “Cause” of the error and recommended
“Action”. This is usually the case, however many error codes exist with
no cause or action text available.
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.
