How to add Oracle OLAP to a 12c Database? (Doc ID 1936550.1)

The initial checks are identical for a Multitenant and non-Multitenbant environment:

1. The Oracle OLAP option is only available as part of the Enterprise Edition (EE) of the Oracle RDBMS.

Therefore the first thing to check is whether you have an Oracle EE environment or not. Please follow

How To Determine If An Oracle Installation Is An Enterprise Or A Standard Edition? (Doc ID 735550.1)

 

2. The second step is to see whether OLAP is installed in your ORACLE_HOME

Check whether the directory 'olap' exists in your database ORACLE_HOME and that it has
at least the directories 'admin' and 'api' under it that should also contain a number of files.
If this is the case, then you have the OLAP option installed. If not, please follow

How to Install Or Remove Oracle OLAP from your ORACLE_HOME? (Doc ID 1936445.1)

 

3. The second step is to check whether the Oracle OLAP option is linked to the Oracle executable. For this please check

How to Enable Or Disable the Oracle OLAP option in the Oracle Executable? (Doc ID 1934968.1)

 

Unless all 3 steps have been confirmed , there is no point to continue with the next ones that will add OLAP to an instance.
Please note that it is highly recommended to take a complete cold back-up from your instance
before proceeding.

 

A: Non-CDB Instance

A non-CDB instance is comparable to the instances as they were in 11g Release 2 and earlier.
The steps to install OLAP are as follows:

* The OLAP option has dependencies on other options in the database: XDK and Java.

For XML DB there is a Master Note for all versions:

Master Note for Oracle XML Database (XDB) Install / Deinstall (Doc ID 1292089.1)

For Java, please refer to the Java documentation

Oracle® Database Java Developer's Guide 12c Release 1 (12.1) E50793-03

Java Installation and Configuration

* Once the preparations have been made, the main OLAP installation can be performed:

As the SYS user, just run:

!?/olap/admin/olap.sql SYSAUX TEMP

 The installation will create an OLAPSYS user schema and the parameters after the script
just provide the information about the location of this user schema ('SYSAUX' should be used
as this is part of the OLAP option) and about the temporary tablespace that you wish to use
(could be 'TEMP' but also any other temporary tablespace will do).

It is recommended to collect the results from the script in a spool file as the output is fairly lengthy
and will exceed most terminal Windows. If everything goes well, OLAP should now be ready to use.

You should now see:

SQL> select comp_name, version,status from dba_registry;

COMP_NAME                      VERSION                        STATUS
------------------------------ ------------------------------ -----------
...

OLAP Analytic Workspace        12.1.0.1.0                     VALID
Oracle OLAP API                12.1.0.1.0                     VALID

 

...

If you have seen OLAP in versions prior to 12c, you will notice that the OLAP Catalog component
is no longer there. It has been deprecated with Oracle 12c. See

Oracle® Database Upgrade Guide 12c Release 1 (12.1) E41397-07

http://docs.oracle.com/database/121/UPGRD/deprecated.htm#UPGRD60024

for more details on this.