00470-00485: Detached Process Death Messages

ORA-00470: LGWR process terminated with error

Cause: The log writer process terminated abnormally.

Action: Check the accompanying messages, 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 errors, check the trace file for the mentioned process until the root error is found.

ORA-00471: DBWR process terminated with error

Cause: The Database Writer process terminated abnormally.

Action: Check the accompanying messages, 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.

ORA-00472: PMON process terminated with error

Cause: The Process Monitor process terminated abnormally.

Action: Check the accompanying messages, 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.

ORA-00473: ARCH process terminated with error

Cause: The Archiver process terminated abnormally.

Action: Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other 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.

ORA-00474: SMON process terminated with error

Cause: The System Monitor process terminated abnormally.

Action: Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other 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.

ORA-00475: TRWR process terminated with error.

Cause: The system tracing process died.

Action: Restart the instance.

ORA-00476: RECO process terminated with error

Cause: The distributed transaction, two-phase commit, recovery process died.

Action: Restart the instance.

ORA-00477: SNP* process terminated with an error

Cause: A snapshot refresh process died.

Action: Restart the instance.

ORA-00480: LCK* process terminated with error

Cause: One Lock process terminated abnormally.

Action: Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other 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.

ORA-00481: LMON process terminated with error

Cause: The lock manager monitor process terminated.

Action: Warm start instance.

ORA-00482: LMD* process terminated with error

Cause: A lock manager daemon process terminated.

Action: Warm start instance.

ORA-00483: during shutdown a process abnormally terminated

Cause: One of the background processes did not exit normally when the instance shut down.

Action: Use the SHUTDOWN ABORT command. Check the accompanying messages, if any, and the background process trace file. Correct the problem mentioned in the other messages. Then 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.

---