-- 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)
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.
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):
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)
Information in this document applies to any platform.
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.
5- Once the database is upgraded, starting with 10.2.0.2, the STATUS will be returned as:
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.
这是否意味着我们忽略即可?现在数据库暂定测试没有问题,暂定这样先用吧。
![](http://img.blog.itpub.net/blog/attachment/201311/28/12974804_1385623266ke55.jpg?x-oss-process=style/bb)
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.
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
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.2Information 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
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
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/