oracle 10g 標準版資料庫日誌中ORA-02097 ORA-00439問題

     最近在客戶那巡檢一套資料庫時，資料庫日誌發現經常報以下錯誤：

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 10.2.0.1,標準版。

透過查metalink,在oracle 10.2.0.1標準版中會出現這個問題，而且是bug,錯誤可以忽略。

如何判斷資料庫是標準版還是企業版呢？有以下兩個方法:

1.sqlplus "/as sysdba"  版本查詢

   select * from v$version

  Oracle Database 10g Enterprise Edition Release                                   10.2.0.1.0                                                                                                                                                            
   而標準版沒Enterprise Edition 字眼出現

  Oracle Database 10g  Release 10.2.0.1.0

2.查詢v$option檢視

   標準版裡面很多功能都是false 比如partition false

   而企業版本里面則為true  比如partition true

以下附件為metalink解釋：

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.