Cannot Add Olap Catalog After An Upgrade (Doc ID 1434423.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle OLAP - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Reviewed 12-July-2012.

Symptoms

While trying to add Olap Option in an 11g Enterprise Edition database, i.e.:

SQL> @?/olap/admin/olap.sql SYSAUX TEMP;


then the Olap Catalog remains as invalid even if executing many times again the script:

SQL> @?/olap/admin/amdrelod.sql;


the dba_registry shows always the Olap components as:

SQL> select comp_name, version, status from dba_registry where comp_name like '%OLAP%';

COMP_NAME VERSION STATUS
----------------------------------- -------------------- ----------
OLAP Analytic Workspace 11.1.0.7.0 VALID
Oracle OLAP API 11.1.0.7.0 VALID
OLAP Catalog 11.1.0.7.0 INVALID


even if the OLAPSYS schema hasn't any invalid object:

SQL> select owner, object_name, object_type, status from dba_objects where status = 'INVALID' and OWNER = 'OLAPSYS';

No rows.

Cause

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