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

Last updated on MAY 08, 2017

Applies to:

Oracle OLAP - Version 11.2.0.4 and later
Information in this document applies to any platform.

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

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 hundreds of Community platforms