发表于:2008.10.14 10:56
分类: JOB
出处：http://kennyblues.itpub.net/post/31846/472174
---------------------------------------------------------------
在网上看到说创建olap时运行olap.sql即可，在这里做一些补充。
1.remove:
在database中的remove：
ORACLE_HOME=your_oracle_home
ORACLE_SID=your_db_sid
PATH=$ORACLE_HOME/bin:$PATH
sqlplus /nolog
SQL> conn / as sysdba
----> Remove OLAP Catalog
SQL> @?/olap/admin/catnoamd.sql
----> Remove OLAP API
SQL> @?/olap/admin/olapidrp.plb
SQL> @?/olap/admin/catnoxoq.sql
----> Deinstall APS - OLAP AW component
SQL> @?/olap/admin/catnoaps.sql
----> Recompile everything
SQL> @?/rdbms/admin/utlrp.sql
在oracle_home中的remove：
Remove completely the Oracle OLAP in the ORACLE_HOME.
1) Ensure that all processes in the ORACLE_HOME are stopped, including database, listener, http server, etc.
In Unix or Linux:
2) cd $ORACLE_HOME/rdbms/lib
3) make -f ins_rdbms.mk olap_off
4) make -f ins_rdbms.mk ioracle 5) Use the Oracle Universal Installer (OUI) to deinstall the OLAP option.
Please note that, you should perform a full backup of the ORACLE_HOME and oraInventory before you do the above, in case software recovery is required.
6) Create a new instance using the Database Configuration Assistant (dbca), selecting a custom database template and unchecking Oracle OLAP in the Database Components wizard step.
2.Reinstall:
How to Reinstall the OLAP Option
Case A)
Assuming that you created your database manually or via DBCA, add the OLAP option to an existing Enterprise Edition Database.
Then open a terminal session on the database server machine, set ORACLE_HOME, ORACLE_SID environment variables, and execute some script as user SYS AS SYSDBA, details below:
ORACLE_HOME=your_oracle_home
ORACLE_SID=your_db_sid
PATH=$ORACLE_HOME/bin:$PATH
sqlplus /as sysdba
SQL> @?/olap/admin/olap.sql SYSAUX TEMP; Case B)
In order to reinstall Oracle OLAP in the ORACLE_HOME, then it needs to use the Oracle Univeral Installer (OUI),
(for example, using the 10.2.0.4 installer)
1) Start OUI from rdbms 10.2.0.4 patchset (clicking on Disk1setup.exe).
2) Click on Next.
2) Select the correct Oracle_Home and click on Next.
4) Once finished successfully the Prerequisite Checks, then click on Next.
5) In Available Product Components, expand:
5.1) Oracle OLAP 10.2.0.1.0 and check Patch 10.2.0.4.0
5.2) Oracle OLAP API 10.2.0.1.0 and check Patch 10.2.0.4.0
5.3) OLAP SQL Scripts 10.2.0.1.0 and check Patch 10.2.0.4.0
6) Click on Next.
7) Click on Install
8) Add the OLAP components to the database by executing these sqlplus commands:
SQL> spool add_olap.log
SQL> @?/olap/admin/olap.sql SYSAUX TEMP;
SQL> @?/rdbms/admin/utlrp.sql
SQL> spool off