How To Find the Cause Of Invalid OLAP Catalog Component In DBA_REGISTRY
(Doc ID 752523.1)
Last updated on NOVEMBER 07, 2023
Applies to:Oracle OLAP - Version 10.2.0.1 to 184.108.40.206 [Release 10.2 to 11.2]
Information in this document applies to any platform.
This article intends to help getting further diagnostic information to find the cause why the OLAP Catalog component is not VALID in the DBA_REGISTRY.
E.g. the STATUS column of the DBA_REGISTRY shows that OLAP Catalog component is INVALID:
Usually this is due to improper installation or state of OLAP Catalog objects, however the sys.cwm2_olap_installer.Validate_CWM2_Install procedure, which sets the OLAP Catalog to VALID or to INVALID in the DBA_REGISTRY, is wrapped, and may not output any diagnostic information (e.g. error) even when it sets the OLAP Catalog to INVALID.
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