資料庫日志發現經常報以下錯誤: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.