My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.