Blog

Oracle Database Tips by Ankush Thalavi

The oerr itulity and show how oerr is used to display Oracle error message details:

Viewing Errors with the oerr Utility is simple

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.

The syntax required of the oerr utility is:

oerr facility number

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 oerr utility (command line executable) can be used to look up Oracle error messages. Many products within Oracle contain an msg file, or message library. Available only on UNIX platforms and not on Windows, type oerr at the command prompt to receive help on how to use this tool.

%oerr

Usage: oerr facility error

Facility is identified by the three-letter prefix in the error string. For example, if the developer gets ORA-7300, "ora" is the facility and "7300" is the error. So type "oerr ora 7300". If one gets LCD-111, type "oerr lcd 111", and so on.

Thanks for reading

Follow me

Contact us for Training/ Job Support

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.