After an upgrade, you have invalid components in you registry.
To fix the OLAP components you have followed "Oracle Olap API Invalid After Adding or Upgrading OLAP (Doc ID 466363.1)" and created the
xoq_validate_verboseprocedure in the SYS schema.
You run it with the following output:
exec xoq_validate_verbose compatible:11.2.0.4.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.
Now, reload the OLAP API:
sqlplus / as sysdba@$ORACLE_HOME/olap/admin/xoqrelod.sql
If the output from the above script shows that the index XDB.XDB$ACL_XIDX is disabled, make sure to enable it first:
alter index xdb.XDB$ACL_XIDX enable;Then rerun the xoqrelod.sql script.
Check the registry, OLAP API should now be valid:
select comp_id, comp_name, version,status from dba_registry where comp_id='XOQ' /
COMP_ID COMP_NAME VERSION STATUS -------------------- ---------------------------------------- ------------------------------ ----------- XOQ Oracle OLAP API 11.2.0.4.0 VALID
No comments:
Post a Comment