My Oracle Support Banner

Expected XDB Resources Are Not There Running XOQ_VALIDATE (Doc ID 2260160.1)

Last updated on MARCH 02, 2018

Applies to:

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


Oracle OLAP API becomes  invalid after running XOQ_VALIDATE procedure.

You are  preparing to upgrade database  from to The status of all components in DBA_REGISTRY are VALID.  You run their validation scripts for good measure.

Now component XOQ has status INVALID.

Running xoq_validate_verbose gives the following (See Oracle OLAP API Invalid After Upgrade To (Doc ID 1951630.1))

SQL> exec xoq_validate_verbose
compatible: ok:True
No install errors were found so component remains valid. ok:True
expected XDB resources are not there. ok:False

PL/SQL procedure successfully completed.

You  check that Function-based index XDB.XDB$ACL_XIDX and it's NOT disabled.

SQL> select owner, index_name, status, funcidx_status from dba_indexes where index_name = 'XDB$ACL_XIDX';

------------------------------ ------------------------------ -------- --------

and you have  determined that sys.registry$error contains no rows.

SQL> select * from sys.registry$error;

no rows selected

Running xoqrelod.sql, utlrp.sql and xoq_validate_verbose still leaves XOQ invalid (with the same message from xoq_validate_verbose).




To view full details, 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 a vibrant support community of peers and Oracle experts.