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

Cause : One of the background processes did not exit normally at or near the time of shutdown.
Action : Use the SHUTDOWN ABORT command. Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the messages. Then shut down and restart the instance. If the trace file mentions any other background process messages, check the trace file for the mentioned process until the root message is found.

Popularity: 8% [?]

Share This

Cause : A failure occurred during a critical portion of the log code during single process operation. This error does not occur during normal multi-process operation.
Action : SHUTDOWN ABORT and restart the database.

Popularity: 7% [?]

Share This

Cause : The log is smaller than the space allocated in it. May be the result of a SHUTDOWN ABORT while it was being written by the archiver.
Action : Get a complete version of this log and use it for recovery. There should either be an online version of it or a copy that was successfully archived.

Popularity: 12% [?]

Share This