Search This Blog

Loading...

Thursday, October 30, 2014

Restarting dead background process QMNC recorded in the alert.log file

To BottomTo Bottom

In this Document
Symptoms
Changes
Cause
Solution


APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.



SYMPTOMS

The following messages are recorded in the alert log every 5 minutes

Restarting dead background process QMNC

CHANGES


CAUSE

1. database startup :
The database has not opened for an undetermined reason, i.e there is no statement:
Completed: ALTER DATABASE OPEN
recorded in the alert.log file.
2. database shutdown :
A process may be preventing the database from shutting down
cleanly. As a consequence, this may be causing the qmnc process problems.

SOLUTION

This is expected behaviour.

The reason why the database has not opened or shutdown should be investigated.
These messages are a symptom of the problem and not the underlying cause.