OERR is a utility provided on the UNIX platform. It can be used to retrieve more information about an error message. This utility cannot work on Windows because it needs awk command to function; however, some workarounds are available to use this utility on Windows. It is a shell script that is saved in the $ORACLE_HOME/bin directory.
The syntax of the OERR utility is given as follows:
oerr <facility> <error> In the preceding syntax, the facility is the prefix to the error number that includes ORA, PLS, and EXP and the error is the actual error number returned by Oracle.
For example, if the database returns the ORA-12544 error, the following OERR utility would be executed to gain more information: