How to remove OLAP组件？
本站文章除注明转载外，均为本站原创： 转载自love wife love life —Roger的Oracle/MySQL/PostgreSQL数据恢复博客
本文链接地址: How to remove OLAP组件？
|
1 2 |
今天在升级一套10204 db时，发现OLAP组件有异常，由于该组件对该系统来讲 无用，故可以remove，查询dba_registry信息如下： |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 |
SQL> Col comp_name for a35 SQL> Col status for a15 SQL> Set lines 150 SQL> Select comp_name,version,status from dba_registry; COMP_NAME VERSION STATUS ----------------------------------- ---------------- --------------- Oracle Database Catalog Views 10.2.0.4.0 VALID Oracle Database Packages and Types 10.2.0.4.0 VALID Oracle Workspace Manager 10.2.0.4.3 VALID JServer JAVA Virtual Machine 10.2.0.4.0 VALID Oracle XDK 10.2.0.4.0 VALID Oracle Database Java Packages 10.2.0.4.0 VALID Oracle Expression Filter 10.2.0.4.0 VALID Oracle Data Mining 10.2.0.4.0 VALID Oracle Text 10.2.0.4.0 VALID Oracle XML Database 10.2.0.4.0 VALID Oracle Rules Manager 10.2.0.4.0 VALID Oracle interMedia 10.2.0.4.0 VALID OLAP Analytic Workspace 10.2.0.4.0 INVALID Oracle OLAP API 10.2.0.4.0 INVALID OLAP Catalog 10.2.0.4.0 INVALID Spatial 10.2.0.4.0 VALID Oracle Enterprise Manager 10.2.0.4.0 VALID 17 rows selected. SQL> select VALUE 2 from v$OPTION 3 where PARAMETER = 'OLAP'; VALUE ------------------------------------------- FALSE SQL> select owner, aw_name from dba_aws; OWNER AW_NAME -------------------- ---------------------- SYS EXPRESS SYS AWMD SYS AWCREATE SYS AWCREATE10G SYS AWXML SYS AWREPORT 6 rows selected. |
|
1 2 |
metalink 上的一篇文档中提供了如何remove OLAP组件的方法，对于10g~11g版本， 执行如下几个sql scripts即可： |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
SQL> @?/olap/admin/catnoamd.sql SQL> @?/olap/admin/olapidrp.plb SQL> @?/olap/admin/catnoaps.sql SQL> @?/olap/admin/catnoxoq.sql SQL> @?/olap/admin/cwm2drop.sql ++++++ 执行完成以后，再次查询dba_registry，将会发现OLAP组件的状态为remove，如下：++++++ COMP_NAME VERSION STATUS ---------------------------------------- ----------------- ---------------------- Oracle Database Catalog Views 10.2.0.4.0 VALID Oracle Database Packages and Types 10.2.0.4.0 VALID Oracle Workspace Manager 10.2.0.4.3 VALID JServer JAVA Virtual Machine 10.2.0.4.0 VALID Oracle XDK 10.2.0.4.0 VALID Oracle Database Java Packages 10.2.0.4.0 VALID Oracle Expression Filter 10.2.0.4.0 VALID Oracle Data Mining 10.2.0.4.0 VALID Oracle Text 10.2.0.4.0 VALID Oracle XML Database 10.2.0.4.0 VALID Oracle Rules Manager 10.2.0.4.0 VALID Oracle interMedia 10.2.0.4.0 VALID OLAP Analytic Workspace 10.2.0.4.0 REMOVED Oracle OLAP API 10.2.0.4.0 REMOVED Spatial 10.2.0.4.0 VALID Oracle Enterprise Manager 10.2.0.4.0 VALID 16 rows selected. |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
如果是10g以前版本，可以使用如下方法： 1) drop the olapsys schema; 2) remove the olap option from a Oracle9i Database: % sqlplus / nolog SQL> conn / as sysdba SQL> @?/cwmlite/admin/onedrop.sql SQL> @?/olap/admin/olapidrp.sql 3) create the database using the Database Creation Assistant (dbca) and then remove the olap script from the list of scripts to be executed. 更为详细的信息，大家可以参考如下两篇文档： How To Find Out If OLAP Is Being Used And How To Remove OLAP [ID 739032.1] How To Remove the Oracle OLAP API Objects From 9i and 11g Databases [ID 278111.1] |
One Response to “How to remove OLAP组件？”
沙发上学习
Leave a Reply
You must be logged in to post a comment.