How to Add the Olap Option in a Database Instance

(Doc ID 727889.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle OLAP - Version: and later   [Release: 10.2 and later ]
Information in this document applies to any platform.
Checked for relevance on 08-Jan-2010.


This article suggests the best method to add the Olap option in a database instance,
where the Olap option has never been installed in previous.

For example, it could happen that once upgraded a instance (with Olap option included) to (without Olap option installed), then the dba_registry would report something as:

COMP_NAME                                STATUS      VERSION
---------------------------------------- ----------- ----------
JServer JAVA Virtual Machine             VALID
OLAP Analytic Workspace                  OPTION OFF
OLAP Catalog                             OPTION OFF
Oracle Data Mining                       VALID
Oracle Database Catalog Views            VALID
Oracle Database Java Packages            VALID
Oracle Database Packages and Types       VALID
Oracle OLAP API                          OPTION OFF
Oracle Text                              VALID
Oracle Workspace Manager                 VALID
Oracle XDK                               VALID
Oracle XML Database                      VALID

Indeed, deselecting the Olap option while a 10.2.0.x instance is being created, after there isn't any possible
to provide the Olap option, for example, upgrading another instance with Olap option installed.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms