Find Oracle Error Code Ora- and Pl/SQL Tips and Tricks

Cause : Oracle detected that the initialization parameter COMPATIBLE was not explicitly specified, and the compatibility of the database is lower than the default value of the COMPATIBLE parameter. In order to use the new compatible setting, the intialization parameter must be explicitly set by the user.
Action : Explicitly set the value of COMPATIBLE parameter either in PFILE or SPFILE, whichever is used.

Popularity: 8% [?]

Share This

Cause : Reporting name of the feature for details of another error.
Action : See associated error message.

Popularity: 2% [?]

Share This

Cause : An attempt to import a tablespace failed because the tablespace contains changes that require a newer software release or that violate the compatibility parameters.
Action : Use a version of the software that can understand the changes or relax the compatibility requirements in the initialization parameter file.

Popularity: 1% [?]

Share This

Cause : ALTER DATABASE RESET COMPATIBILITY command has been de-supported since Oracle 10i.
Action : No action required.

Popularity: 1% [?]

Share This

Cause : An attempt to rename the system tablespace failed.
Action : No action required.

Popularity: 1% [?]

Share This

Cause : An attempt to rename a tablespace failed because the new name is invalid.
Action: Choose a valid new name and retry the command.

Popularity: 1% [?]

Share This

Cause : An attempt to rename a tablespace failed because the new name is the same as the old name.
Action : No action required.

Popularity: 1% [?]

Share This

Cause : An attempt to change the block0 format of the specified file failed because the file is read-only or offline.
Action : Make the file read-write or bring the file online and set the BLK0_FMTCHG event.

Popularity: 1% [?]

Share This

Cause : A previous attempt to start an instance was terminated.
Action : Shut down the instance completely and then restart it.

Popularity: 1% [?]

Share This

Cause : Failure in processing bootstrap data. Refer to the accompanying messages for more information about the cause of the problem.
Action : Correct the problems mentioned in the other messages. If the problem persists, contact Oracle Customer Support.

Popularity: 2% [?]

Share This