Oracle OLAP API Invalid After Upgrade To 11.2.0.4
(Doc ID 1951630.1)
Last updated on AUGUST 02, 2023
Applies to:
Oracle OLAP - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
Before upgrade, all components in dba_registry are valid.
After upgrade, Few components are invalid
Post upgrade
========
------- ---------------------------------- --------- -------------- -------------- --------------
AMD OLAP Catalog VALID 11.2.0.4.0
APS OLAP Analytic Workspace VALID 11.2.0.4.0
CATALOG Oracle Database Catalog Views VALID
CATJAVA Oracle Database Java Packages VALID 11.2.0.4.0
CATPROC Oracle Database Packages and Types INVALID 11.2.0.4.0
CONTEXT Oracle Text VALID 11.2.0.4.0
EM Oracle Enterprise Manager VALID 11.2.0.4.0
JAVAVM JServer JAVA Virtual Machine VALID 11.2.0.4.0
XDB Oracle XML Database INVALID 11.2.0.4.0
XML Oracle XDK VALID 11.2.0.4.0
XOQ Oracle OLAP API INVALID 11.2.0.4.0
In upgrade log you see these errors:
. ORA-19051: Cannot use fast path insert for this XMLType table
. ORA-06512: at line 20
. ORA-19051: Cannot use fast path insert for this XMLType table
. ORA-06512: at "XDB.DBMS_XDB", line 340
. ORA-06512: at line 10
. ORA-00942: table or view does not exist
. ORA-00942: table or view does not exist
Run @?/olap/admin/xoqrelod.sql to reload OLAP API and xoq_validate_verbose procedure using Note: (Doc ID 466363.1) to validate OLAP API.
This is output:
SQL> set serveroutput on size 10000
SQL> exec xoq_validate_verbose
compatible:11.2.0.0.0 ok:True
xoq errors during installation/upgrade. Query sys.registry$error WHERE
identifier equal to XOQ. ok:False
Let's check XOQ errors in sys.registry$error
SQL> set long 12000
SQL> set lines 1200
SQL> set pages 1200
SQL> select * from sys.registry$error WHERE identifier ='XOQ';
USERNAME TIMESTAMP
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------
SCRIPT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
IDENTIFIER MESSAGE STATEMENT
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
SYS 07-NOV-14 11.53.55.000000 AM
/u01/app/oracle/product/11.2.0/dbhome_1/olap/admin/awmxsrol.sql
XOQ ORA-00942: table or view does not exist grant select on XDB.XS$SECURITYCLASS to olap_xs_admin
SYS 07-NOV-14 11.53.55.000000 AM
/u01/app/oracle/product/11.2.0/dbhome_1/olap/admin/awmxsrol.sql
Changes
You upgraded the database.
Cause
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
Symptoms |
Changes |
Cause |
Solution |