ORA-00482 : LMD* process terminated with error

Thursday, March 27th, 2008

Cause: A Lock Manager /A global enqueue service daemon process terminated abnormally.
Action: Restart the instance.

Popularity: 5% [?]

ORA-00481 : LMON process terminated with error

Thursday, March 27th, 2008

Cause : The Lock Manager monitor process terminated abnormally / The global enqueue service monitor process died.
Action: Restart the instance.

Popularity: 4% [?]

ORA-00480 : LCK* process terminated with error

Thursday, March 27th, 2008

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 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: 3% [?]

ORA-00477 : SNP* process terminated with error

Thursday, March 27th, 2008

Cause: A materialized view refresh process died / A snapshot refresh process terminated abnormally.
Action: PMON will restart SNP process shortly. If SNP process does not get started, contact Oracle support or Restart the instance.

Popularity: 2% [?]

ORA-00476 : RECO process terminated with error

Thursday, March 27th, 2008

Cause : The distributed transaction (two-phase commit) recovery process terminated abnormally.
Action : Restart the instance.

Popularity: 5% [?]

ORA-00475 : TRWR process terminated with error

Thursday, March 27th, 2008

Cause : The system tracing process terminated abnormally.
Action : Restart the instance.

Popularity: 2% [?]

ORA-00474 : SMON process terminated with error

Thursday, March 27th, 2008

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 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: 4% [?]

ORA-00473 : ARCH process terminated with error

Thursday, March 27th, 2008

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 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: 3% [?]

ORA-00471 : DBWR process terminated with error

Thursday, March 27th, 2008

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.

Popularity: 5% [?]

ORA-00470 : LGWR process terminated with error

Thursday, March 27th, 2008

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 messages, check the trace file for the mentioned process until the root message is found.

Popularity: 4% [?]

Close
E-mail It