告警日志频繁出现Restarting dead background process QMNC信息

客户的告警日志中，频繁出现Restarting dead background process QMNC信息。

 

 

错误信息如下：

Mon Jun 27 22:35:30 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=29, OS id=25000
Mon Jun 27 22:39:40 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=29, OS id=25764
Mon Jun 27 22:44:38 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=25, OS id=27222
Mon Jun 27 22:48:51 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=25, OS id=28268
Mon Jun 27 22:53:01 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=25, OS id=29474
Mon Jun 27 22:57:11 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=19, OS id=521
Mon Jun 27 23:01:25 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=16, OS id=1547
Mon Jun 27 23:05:32 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=29, OS id=2744

错误几分钟就出现一次。

检查发现，原因客户执行过SHUTDOWN操作，但是随后取消了这个关闭数据库的操作：

Mon Jun 27 16:09:07 GMT 2011
Thread 1 advanced to log sequence 65940 (LGWR switch)
Current log# 3 seq# 65940 mem# 0: /ora1/RT/redo03a.log
Current log# 3 seq# 65940 mem# 1: /ora1/RT/redo03b.log
Mon Jun 27 20:02:59 GMT 2011
Thread 1 advanced to log sequence 65941 (LGWR switch)
Current log# 4 seq# 65941 mem# 0: /ora1/RT/redo04a.log
Current log# 4 seq# 65941 mem# 1: /ora1/RT/redo04b.log
Mon Jun 27 20:30:52 GMT 2011
Shutting down instance (immediate)
Starting background process EMN0
Mon Jun 27 20:30:52 GMT 2011
Shutting down instance: further logons disabled
EMN0 started with pid=125, OS id=21556
Mon Jun 27 20:30:54 GMT 2011
Stopping background process QMNC
Mon Jun 27 20:30:54 GMT 2011
Stopping background process CJQ0
Mon Jun 27 20:30:56 GMT 2011
Stopping background process MMNL
Mon Jun 27 20:30:57 GMT 2011
Stopping background process MMON
License high water mark = 460
Mon Jun 27 20:30:58 GMT 2011
Job queue slave processes stopped
Mon Jun 27 20:36:01 GMT 2011
Active call for process 26071 user 'nrnr' program 'oracle@ho0 (TNS V1-V3)'
Active call for process 29638 user 'nrnr' program 'oracle@ho0 (TNS V1-V3)'
System State dumped to trace file /home/oracle/admin/RT/udump/rt_ora_21554.trc
SHUTDOWN: waiting for active calls to complete.
Mon Jun 27 20:50:43 GMT 2011
MMNL absent for 1204 secs; Foregrounds taking over
Mon Jun 27 21:31:40 GMT 2011
SHUTDOWN: Active sessions prevent database close operation
Mon Jun 27 21:31:40 GMT 2011
Instance shutdown cancelled
Mon Jun 27 22:26:52 GMT 2011
Starting ORACLE instance (normal)
Mon Jun 27 22:27:20 GMT 2011
ALTER SYSTEM SET cursor_sharing='EXACT' SCOPE=MEMORY;
The value (30) of MAXTRANS parameter ignored.
Mon Jun 27 22:27:31 GMT 2011
Starting background process QMNC
QMNC started with pid=40, OS id=22820
kupprdp: master process DM00 started with pid=40, OS id=22825
to execute - SYS.KUPM$MCP.MAIN('SYS_EXPORT_FULL_23', 'OPS$NRNR', 'KUPC$C_1_20110627222731', 'KUPC$S_1_20110627222731', 0);
kupprdp: worker process DW01 started with worker id=1, pid=41, OS id=22828
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_23', 'OPS$NRNR');
kupprdp: worker process DW02 started with worker id=2, pid=42, OS id=22981
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_23', 'OPS$NRNR');
kupprdp: worker process DW03 started with worker id=3, pid=43, OS id=22983
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_23', 'OPS$NRNR');
kupprdp: worker process DW04 started with worker id=4, pid=44, OS id=22985
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_23', 'OPS$NRNR');
kupprdp: worker process DW05 started with worker id=5, pid=45, OS id=22987
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_23', 'OPS$NRNR');
Mon Jun 27 22:28:16 GMT 2011
Restarting dead background process QMNC
kupprdp: worker process DW06 started with worker id=6, pid=46, OS id=22989
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_23', 'OPS$NRNR');
QMNC started with pid=47, OS id=22991
kupprdp: worker process DW07 started with worker id=7, pid=48, OS id=22993
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_23', 'OPS$NRNR');
kupprdp: worker process DW08 started with worker id=8, pid=49, OS id=22995
to execute - SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_23', 'OPS$NRNR');
Mon Jun 27 22:29:19 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=34, OS id=23176
Mon Jun 27 22:31:26 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=34, OS id=23954
Mon Jun 27 22:35:30 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=29, OS id=25000
Mon Jun 27 22:39:40 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=29, OS id=25764
Mon Jun 27 22:44:38 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=25, OS id=27222
Mon Jun 27 22:48:51 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=25, OS id=28268
Mon Jun 27 22:53:01 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=25, OS id=29474
Mon Jun 27 22:57:11 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=19, OS id=521
Mon Jun 27 23:01:25 GMT 2011
Restarting dead background process QMNC
QMNC started with pid=16, OS id=1547

由于关闭数据库且中途中止，致使数据库的某些状态异常，导致了这个错误，metalink文档ID 395137.1描述了这个问题。

解决这个问题只需要重启数据库就可以了。

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/4227/viewspace-701022/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/4227/viewspace-701022/