DBA_REGISTRY Shows Oracle OLAP Components in Status REMOVED

(Doc ID 1064322.1)

Last updated on JANUARY 11, 2013

Applies to:

Oracle OLAP - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms

After removing Oracle OLAP from the database, the DBA_REGISTRY shows
- the Oracle OLAP components APS and XOQ are in status REMOVED
- no entry for the Oracle OLAP AMD component

select comp_id, comp_name, version, status,schema from dba_registry;

COMP_ID  COMP_NAME                    VERSION     STATUS     SCHEMA
-------- ---------------------------- ----------- ---------- -------
APS      OLAP Analytic Workspace      9.2.0.7.0   REMOVED    SYS
CATALOG  Oracle9i Catalog Views       9.2.0.7.0   VALID      SYS
CATPROC  Oracle9i Packages and Types  9.2.0.7.0   VALID      SYS
OWM      Oracle Workspace Manager     9.2.0.1.0   VALID      WMSYS
XOQ      Oracle OLAP API              9.2.0.7.0   REMOVED    SYS

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