How to remove the Oracle OLAP Option from a 12c Database during 19c Upgrade

Check the OLAP option is enabled in database.

select parameter, value from v$option where parameter = ‘OLAP’;

select comp_id, comp_name, version, status, schema from dba_registry where comp_name like ‘%OLAP%’;

OLAP option is FALSE and no OLAP usage in the database.

OLAP can be removed from the database.

The next step is to check whether we have OLAP data that we need to check into before the removal.

For this please run the following query as SYS

select owner,aw_name from dba_aws where owner !=’SYS’

no rows selected

The next step is to run the scripts that remove the Oracle OLAP option

SQL> conn / as sysdba
SQL> spool remove_olap.log
—-> Remove OLAP Catalog
SQL> @?/olap/admin/catnoamd.sql
—-> Remove OLAP API
SQL> @?/olap/admin/catnoxoq.sql
—-> Deinstall APS – OLAP AW component
SQL> @?/olap/admin/catnoaps.sql
—-> Recompile invalids
SQL> @?/rdbms/admin/utlrp.sql

Now the Oracle OLAP option has been removed from the database.