My Oracle Support Banner

DBA_REGISTRY Shows Oracle OLAP Components in Status REMOVED (Doc ID 1064322.1)

Last updated on OCTOBER 22, 2019

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.