Case A) Remove OLAP objects from the database

In order to remove OLAP from database you need to open a terminal session on the database server machine, set ORACLE_HOME, ORACLE_SID environment variables, and execute the following scripts
as user SYS AS SYSDBA:

ORACLE_HOME=your_oracle_home
ORACLE_SID=your_db_sid
PATH=$ORACLE_HOME/bin:$PATH
sqlplus /nolog
SQL> conn / AS sysdba
SQL> spool remove_olap.log
----> 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
SQL> @?/olap/admin/cwm2drop.SQL
----> Recompile invalids
SQL> @?/rdbms/admin/utlrp.SQL
SQL> spool off

Case B) Remove Oracle OLAP from the ORACLE_HOME.

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk olap_off
make -f ins_rdbms.mk ioracle

Installing OLAP Manually in 10g/11g database

Step 1: Check the OLAP Option:

SELECT VALUE FROM v$option WHERE parameter = 'OLAP'

if TRUE, OLAP is turned on. Go to Step 2.
If FALSE, shutdown DB and turn it on:

make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk olap_on
make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk ioracle

Step 2: Verify ‘JServer JAVA Virtual Machine’ is present and VALID in the database instance:

SELECT comp_id, comp_name, STATUS, substr(version,1,10) AS version FROM dba_registry WHERE comp_id LIKE 'JAVAVM';

if this is not present or INVALID then execute these commands when connected as SYSDBA:


GeSHi Error: GeSHi could not find the language quotsql (using path /home/pansoftds/onlinedbasupport.com/wp-content/plugins/codecolorer/lib/geshi/) (code 2)

Step 3: Once the JAVAVM is installed, without errors and is VALID then we need to check and possibly install the components for the XML Database. Please check Document 1292089.1 when installing in 11g Release 2.


GeSHi Error: GeSHi could not find the language quotsql (using path /home/pansoftds/onlinedbasupport.com/wp-content/plugins/codecolorer/lib/geshi/) (code 2)

If this does not return something like:

COMP_NAME                 VERSION                        STATUS
------------------------- ---------------------------    --------
Oracle XDK                10.2.0.4.0                     VALID
Oracle XML Database       10.2.0.4.0                     VALID

then you need to following the following note: Document 1292089.1 :Master Note for Oracle XML Database (XDB) Install / Deinstall.

Step 4: Check the remaining requirements:

COMP_NAME                 VERSION     STATUS
------------------------- ----------- -----------
Oracle Expression Filter  10.2.0.4.0  VALID

If that is missing, please run the following as SYS:


GeSHi Error: GeSHi could not find the language quotsql (using path /home/pansoftds/onlinedbasupport.com/wp-content/plugins/codecolorer/lib/geshi/) (code 2)

Step 5: Now to the final steps to install OLAP itself:


GeSHi Error: GeSHi could not find the language quotsql (using path /home/pansoftds/onlinedbasupport.com/wp-content/plugins/codecolorer/lib/geshi/) (code 2)

Check the install with the following:


GeSHi Error: GeSHi could not find the language quotsql (using path /home/pansoftds/onlinedbasupport.com/wp-content/plugins/codecolorer/lib/geshi/) (code 2)

Reference :
How To Manually Install Oracle OLAP In 9i, 10g Or 11g Database After The DB Has Been Created [ID 296187.1]
How To Remove The OLAP Option In 10g And 11g [ID 332351.1]

Share →
0 comments
Skip to toolbar