Oracle: How to troubleshoot Oracle database errors [ID 1031459.1]

How to troubleshoot Oracle database errors [ID 1031459.1]

Goal

How to troubleshoot Oracle database errors
How to gather additional information about Oracle database errors.

Symptoms:
Error messages returned with an "ORA" prefix.

Solution

Login as the oracle user and run the command 'oerr ora {errornumber}'. The resulting information should state the cause and action to take to correct the problem. An example of this is as follows:

> oerr ora 1653
01653, 00000, "unable to extend table %s.%s by %s in tablespace %s"
// *Cause:  Failed to allocate an extent for table segment in tablespace.
// *Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
//         files to the tablespace indicated.

Legacy ATG Properties
Category: Database, Troubleshooting Tips
Product Name: eServer: Server
Advisory: No
Localization: English (US)
Database: Oracle 8.1.6, Oracle 8.0.6, Oracle 8.1.7
Topics: Primus eServer, Knowledge Base Solutions, Product & Services
ATG Solution ID: primus3504