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

-- 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博客 ” ，链接：http://blog.itpub.net/12974804/viewspace-1061540/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12974804/viewspace-1061540/