13.32 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.