ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 一个BUG导致MMON进程down掉

一个BUG导致MMON进程down掉

原创 Linux操作系统 作者:yywangsx 时间:2012-08-22 20:39:44 0 删除 编辑
今天下班前检查alert日志文件,发现在中午的时候MMON进程死了,并自动重启,错误信息如下:
KEBM: MMON action policy violation. 'Flashback Archive RAC Health Check' 
 viol=0; err=8181
 error 8181 detected in background process
 OPIRIP: Uncaught error 447. Error stack:
 ORA-00447: fatal error in background process
 ORA-08181: specified number is not a valid system change number
 ORA-12751: cpu time or run time policy violation
 
经过查询,此问题为ORACLE 一个BUG引起,BUG号为:10207092,影响的版本为:11.1.0.7(正是我们数据库的版本)和11.2.0.2
MMON进程解释:

MMON:Manageability Monitor Process

 

Performs or schedules many manageability tasks

 

MMON performs many tasks related to manageability, including taking Automatic Workload Repository snapshots and performing Automatic Database Diagnostic Monitor analysis.

 

 

 

以下是metalink上的说明:

 

Bug 10207092  MMON may repeatedly fail with ORA-447 / ORA-12751

 This note gives a brief overview of bug 10207092. 
 The content was last updated on: 14-AUG-2012
 Click here for details of each of the sections below.

Affects:

Product (Component)Oracle Server (Rdbms)
Range of versions believed to be affectedVersions >= 11 but BELOW 12.1
Versions confirmed as being affected
Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in

Symptoms:

Related To:

Description

Scheduler code in MMON suppresses an error which can result in an MMON 
dump.
eg:
 KEBM: MMON action policy violation. 'Flashback Archive RAC Health Check' 
 viol=0; err=8181
 error 8181 detected in background process
 OPIRIP: Uncaught error 447. Error stack:
 ORA-00447: fatal error in background process
 ORA-08181: specified number is not a valid system change number
 ORA-12751: cpu time or run time policy violation
 
Rediscovery Notes:
  MMON keeps failing with ORA-12751 and ORA-447 on the error stack 
 
Workaround
 None
 

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

References

Bug:10207092 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

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

上一篇: hanganalye使用示例
请登录后发表评论 登录
全部评论

注册时间:2011-08-13

  • 博文量
    6
  • 访问量
    16958