oracle 10g 标准版数据库日志中ORA-02097 ORA-00439问题

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:387

数据库日志发现经常报以下错误: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.

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】