Oracle7 Administrator's Reference for UNIX

Contents Index Home Previous Next

Using the oerr Message Help Utility

Use the oerr utility to look up the text of messages, as well as their possible causes, and the action to take. To use oerr, you must set ORACLE_HOME correctly. If you are using the Multilingual Option, set the NLS_LANGUAGE environment variable to specify the language in which to display information.

Use the following syntax to look up messages with oerr:

oerr facility errno

where:

facility specifies a facility of the Oracle product to which the messages correspond.
errno specifies the message number.
The following are some of the valid facility codes for Oracle products:

dba SQL*DBA
exp Export
iac SQL*Forms Convert
iad SQL*Forms Designer
iag SQL*Forms Generate
iap SQL*Forms Runform
ifp SQL*Forms and PL/SQL integration (supported for SQL*Forms version 3 only)
imp Import
lcd Library Command Driver SQL*Forms:
ora Oracle Server
typ Type Conversions
For example, if you enter:

$  oerr ora 7201

the following information is displayed on your screen:

07201, 00000, "slhom: oracle_home variable not set in environment."
// *cause:  $(ORACLE_HOME) environment variable not set.
// *action: Set ORACLE_HOME.

Contents Index Home Previous Next