My Oracle Support Banner

Oracle Olap API Invalid After Adding or Upgrading OLAP (Doc ID 466363.1)

Last updated on FEBRUARY 22, 2024

Applies to:

Oracle OLAP - Version to [Release 9.2 to 11.2]
Information in this document applies to any platform.


After adding OLAP,  the OLAP API is INVALID in dba_registry.  Re-ran the utlrp.sql script to re-compile all the database objects and the OLAP API still shows up as INVALID.


XOQ        Oracle OLAP API            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
 Use the script below to create the xoq_validate_verbose procedure for version <
 In the xoq_validate has been expanded with couple of more checks.

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