Oracle Error Message Guidelines

The following is an example of how Oracle writes error messages.

Notice the format of the error message:

· ORA-00058 – error number for tracking

· DB_BLOCK_SIZE must be string to mount this database (not string) – description of error message

· Cause: what caused the error to occur

· Potential reasons: note the use of the word potential in the following example.

· Action: what steps need to be taken

For example:

Cause: The value of the DB_BLOCK_SIZE initialization parameter used to start this database does not match the value used when that database was created.

Potential reasons for this mismatch are:

Mounting the wrong database

Using the wrong initialization parameter file

The value of the db_block_size parameter was changed

Action: For one of the above causes, either:

Mount the correct database

Use the correct initialization parameter file

Correct the value of the DB_BLOCK_SIZE parameter