Oracle OLAP API Invalid After Upgrade To 11.2.0.4 (Doc ID 1951630.1)

Last updated on SEPTEMBER 30, 2016

Applies to:

Oracle OLAP - Version 11.2.0.4 and later
Information 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
========
Comp ID Component Status Version Org_Version Prv_Version
------- ---------------------------------- --------- -------------- -------------- --------------
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-01775: looping chain of synonyms
.   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

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