Home » Server Options » Streams & AQ » QMNC problem (11.2.0.1.0, Redhat Enterprise 5)
QMNC problem [message #486561] Thu, 16 December 2010 13:01
Haraprasad Hota
Messages: 4
Registered: May 2007
Location: Bangalore, India
Junior Member

Hi,

I renamed my alertlog file as a maintenance task and then fired this query:
SQL> alter system archive log current noswitch;

Then I got an error in the alert log as follows:

Stopping background process QMNC
Tue Dec 14 07:48:47 2010
All dispatchers and shared servers shutdown
Active process 29353 user 'oracle' program 'oracle@domU-12-31-39-08-0B-05'
Active process 30007 user 'oracle' program 'oracle@domU-12-31-39-08-0B-05'
Active process 30081 user 'oracle' program 'oracle@domU-12-31-39-08-0B-05'
Active process 30079 user 'oracle' program 'oracle@domU-12-31-39-08-0B-05'
.
.
.
.

Active process 30009 user 'oracle' program 'oracle@domU-12-31-39-08-0B-05'
Active process 30003 user 'oracle' program 'oracle@domU-12-31-39-08-0B-05'
Active process 30077 user 'oracle' program 'oracle@domU-12-31-39-08-0B-05'
Active process 30005 user 'oracle' program 'oracle@domU-12-31-39-08-0B-05'
CLOSE: Active sessions prevent database close operation
CLOSE: Error 1093 during database close
SMCO started with pid=39, OS id=30217
Tue Dec 14 08:18:08 2010

And then after one day:

Starting background process QMNC
QMNC started with pid=47, OS id=5691
DM00 started with pid=48, OS id=5695, job SYSTEM.FULL_DB_EXPORT
QMNC started with pid=46, OS id=5700
DW00 started with pid=47, OS id=5708, wid=1, job SYSTEM.FULL_DB_EXPORT
QMNC started with pid=49, OS id=5723
QMNC started with pid=46, OS id=5737
QMNC started with pid=46, OS id=5785

The problem is QMNC shows as started with different pid. I can not find it in ps -ef command.
I have stream configured but is disabled for some requirement. I doubt stream will work or not if enabled. The database is running well with good performance but I think it requires a restart to get QMNC permanently running in background. But is there any alternate way ?

Thanks in advance..

Regards,
Haraprasad
Previous Topic: REPLICATION IN SAME DATABASE....
Next Topic: OLTP to OLAP data transfer - CDC or Streams?
Goto Forum:
  


Current Time: Thu Mar 28 11:39:47 CDT 2024