ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 告警日志频繁出现Restarting dead background process QMNC信息

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

原创 Linux操作系统 作者:yangtingkun 时间:2011-06-29 23:58:12 0 删除 编辑

客户的告警日志中,频繁出现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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10539152