Last updated on MAY 08, 2017

Applies to:

Symptoms

Oracle OLAP API becomes  invalid after running XOQ_VALIDATE procedure.


You are  preparing to upgrade database  from 11.2.0.4 to 12.1.0.2. 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 11.2.0.4 (Doc ID 1951630.1))

SQL> exec xoq_validate_verbose
compatible:11.2.0.0.0 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';

OWNER INDEX_NAME STATUS FUNCIDX_
------------------------------ ------------------------------ -------- --------
XDB XDB$ACL_XIDX VALID ENABLED

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).

Cause