OERR

Syntax

OERR [error_code|<facility name> <error number>]

Displays detailed cause and action text for Oracle errors. The OERR command accepts an error code or an error prefix (facility name) along with an error number to display error details.

Terms

error_code

Contains the error prefix, such as ORA or SP2, and the error number.

facility name

Refers to the error prefix, such as ORA, SP2, and so on.

error number

Refers to the error number.

Examples

The following examples display the usage and output of the OERR command:

Example 1

OERR ORA-1033
Message: "ORACLE initialization or shutdown in progress"
Help: https://docs.oracle.com/error-help/db/ora-01033/
Cause:  An attempt was made to log on while Oracle is being started up
        or shutdown.
Action: Wait a few minutes. Then retry the operation.

Example 2

OERR ORA 1033
Message: "ORACLE initialization or shutdown in progress"
Help: https://docs.oracle.com/error-help/db/ora-01033/
Cause:  An attempt was made to log on while Oracle is being started up
        or shutdown.
Action: Wait a few minutes. Then retry the operation.

Example 3

OERR SP2 0640
Message: "Not connected\n"
Help: https://docs.oracle.com/error-help/db/sp2-00640/
Cause:  The PASSWORD command was issued when there was no
        connection to the Oracle instance.
Action: Connect to the Oracle database before re-issuing the
        PASSWORD command.