Unable to restore resource manager plan to '':

今天在windows 上的oracle(10.2.0.1)  中alert文件发现每天都会提示下列错误：

Unable to restore resource manager plan to '':
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00439: feature not enabled: Database resource manager

查询后发现这个oracle 10G的一个bug ,10.2.0.3后这个bug已经解决

 

Subject:         Bug 4343398 - Alert log reports ORA-2097 / ORA-439 on 10.1.0.4 Standard Edition
          Doc ID:         Note:4343398.8         Type:         PATCH
          Last Revision Date:         17-MAY-2007         Status:         PUBLISHED
Click here for details of sections in this note.
Bug 4343398  Alert log reports ORA-2097 / ORA-439 on 10.1.0.4 Standard Edition
This note gives a brief overview of bug 4343398.
Affects:

    Product (Component)        Oracle Server (Rdbms)
    Range of versions believed to be affected        Versions >= 10.1.0.4
    Versions confirmed as being affected       

        * 10.1.0.4
        * 10.1.0.5
        * 10.2.0.2

    Platforms affected        Generic (all / most platforms affected)

     It is believed to be a regression in default behaviour thus:
       Regression introduced in 10.1.0.4

Fixed:

    This issue is fixed in       

        * 10.2.0.3 (Server Patch Set)

Symptoms:
       
Related To:

    * Error May Occur
    * ORA-2097 / ORA-439

       

    * (None Specified)

Description

    This problem is introduced in 10.1.0.4 Standard Edition
    by the fix for bug 4039780 .

    In Standard Edition 10.1.0.4 errors such as those below
    can appear in the alert log periodically:

      Unable to restore resource manager plan to '':
      ORA-02097: parameter cannot be modified because specified value is invalid
      ORA-00439: feature not enabled: Database resource manager

    These errors can be ignored as resource manager is not enabled in
    Standard Edition.

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

转载于:http://blog.itpub.net/26920263/viewspace-722338/