-- Oracle OLAP API失效错误，错误提示如下：

SQL> select comp_name, version, status from sys.dba_registry;

COMP_NAME VERSION   STATUS
-------------------------------------------------- -------------------- ------------------------------
OWB 11.2.0.1.0     VALID
Oracle Application Express   3.2.1.00.10   VALID
Oracle Enterprise Manager 11.2.0.3.0     VALID
OLAP Catalog     11.2.0.1.0     OPTION OFF
Spatial 11.2.0.1.0     OPTION OFF
Oracle Multimedia 11.2.0.3.0     VALID
Oracle XML Database   11.2.0.3.0     VALID
Oracle Text 11.2.0.3.0     VALID
Oracle Expression Filter   11.2.0.3.0     VALID
Oracle Rules Manager   11.2.0.3.0     VALID
Oracle Workspace Manager   11.2.0.3.0     VALID
Oracle Database Catalog Views 11.2.0.3.0     VALID
Oracle Database Packages and Types   11.2.0.3.0     VALID
JServer JAVA Virtual Machine   11.2.0.3.0     VALID
Oracle XDK   11.2.0.3.0     VALID
Oracle Database Java Packages 11.2.0.3.0     VALID
OLAP Analytic Workspace 11.2.0.1.0     OPTION OFF
Oracle OLAP API 11.2.0.1.0     OPTION OFF

解决方案：
++ 官方的一个链接反馈运用系统默认模版在标准版中会出现OLAP的升级问题
Use Of Database Templates with Standard Edition Cause Problems With OLAP (Doc ID 556194.1)

Changes

A new instance of the database is being configured using DBCA and a template other than Custom had been chosen.

Cause

All templates used by DBCA(except the Custom template) use pre-configured datafiles and are based on the Enterprise Edition feature set, which includes OLAP.

Standard Edition does not support OLAP.

When trying to configure the OLAP-related components while creating the instance, OLAP-specific configurations are performed and fail due to the OLAP option not being present.

Solution

When using DBCA with the Standard Edition of 10g or 11g of Oracle RDBMS, ensure that:

In Step 2 (Database Template) of DBCA, select Custom Database.
In Step 9 (Database Content) of DBCA, in the Database Content tab, please uncheck the OLAP component.

This will avoid executing the scripts that configure the OLAP option (which is not supported with the Standard Edition).

For Oracle 10g Enterprise Edition, you may choose to manually remove the (partially present) OLAP option by following these instructions (also outlined in Note 278111.1 How To Remove the Oracle OLAP API Objects From 9i and 10g):

SQL> conn / as sysdba
SQL> @?/olap/admin/catnoamd.sql
SQL> @?/olap/admin/olapidrp.plb
SQL> @?/olap/admin/catnoaps.sql
SQL> @?/olap/admin/catnoxoq.sql

For Standard Edition, these scripts do not exist and it is highly recommended to open a Service Request with Oracle Support to assist in the process.

不过在另外一个文档也有叙述OPTION OFF意味着我们无需理会即可。

Oracle OLAP Components listed as 'OPTION OFF' in Standard Edition Installation (Doc ID 459153.1)

Applies to:

Oracle OLAP - Version: 9.2 to 10.2
Information in this document applies to any platform.

Goal

Why are Oracle OLAP components listed in dba_registry as 'OPTION OFF'

Solution

The Oracle OLAP components are listed in a database instance as 'OPTION OFF' due to:

1- The Standard Edition of Oracle was installed.
2- The database instance was created using dbca.
3- When using dbca to create a database instance, Oracle OLAP is automatically included in all database selections, other than the 'Custom Database' selection.
4- Upon the initial creation all the OLAP Components will be listed as VALID when viewing the dba_registry. NOTE: the version information in this example is only for example purposes.

SQL> col comp_name format a30
SQL> select comp_name, status, substr(version,1,10) as version from dba_registry where comp_name like '%OLAP%';

COMP_NAME                      STATUS      VERSION
------------------------------ ----------- ----------
OLAP Analytic Workspace        VALID       10.2.0.1.0
Oracle OLAP API                VALID       10.2.0.1.0
OLAP Catalog                   VALID       10.2.0.1.0

5- Once the database is upgraded, starting with 10.2.0.2, the STATUS will be returned as:

SQL> col comp_name format a30
SQL> select comp_name, status, substr(version,1,10) as version from
dba_registry where comp_name like '%OLAP%';

COMP_NAME                      STATUS      VERSION
------------------------------ ----------- ----------
OLAP Analytic Workspace        OPTION OFF 10.2.0.3.0
Oracle OLAP API                OPTION OFF 10.2.0.3.0
OLAP Catalog                   OPTION OFF 10.2.0.3.0

6- The return from the dba_registry indicating the Oracle OLAP components as 'OPTION OFF' indicates that the Oracle OLAP software option has not been installed and therefore the Oracle OLAP scripts are not present.

7- This is normal under these conditions and does not require Oracle OLAP to be removed from the instance as it is not usable and will not be looked at upon future patches or upgrades.

这是否意味着我们忽略即可？现在数据库暂定测试没有问题，暂定这样先用吧。

ITPub博客

数据库从11.2.0.1到11.2.0.x版本注意事项

Changes

Cause

Solution

Applies to:

Goal

Solution

最新文章