Olap Api Invalid After 10203 and Patch 18 for Windows (Patch:6812784) - ORA-37111 Running Xoq_validate (Doc ID 565433.1)

Last updated on JANUARY 07, 2010

Applies to:

Oracle OLAP - Version: 10.2.0.3
z*OBSOLETE: Microsoft Windows Server 2003
Microsoft Windows Itanium (64-bit)

Symptoms

ORACLE OLAP API component is invalid after applying 10.2.0.3 plus Patch 18 (<<Patch :6812784>>) for Windows:
CATALOG Oracle Database Catalog Views 10.2.0.3.0 VALID
CATPROC Oracle Database Packages and Types 10.2.0.3.0 VALID
OWM Oracle Workspace Manager 10.2.0.1.0 VALID
JAVAVM JServer JAVA Virtual Machine 10.2.0.3.0 VALID
XML Oracle XDK 10.2.0.3.0 VALID
CATJAVA Oracle Database Java Packages 10.2.0.3.0 VALID
EXF Oracle Expression Filter 10.2.0.3.0 VALID
XDB Oracle XML Database 10.2.0.3.0 VALID
RUL Oracle Rule Manager 10.2.0.3.0 VALID
ORDIM Oracle interMedia 10.2.0.3.0 VALID
EM Oracle Enterprise Manager 10.2.0.3.0 VALID
RAC Oracle Real Application Clusters 10.2.0.3.0 VALID
APS OLAP Analytic Workspace 10.2.0.3.0 VALID
XOQ Oracle OLAP API 10.2.0.3.0 INVALID             ***
AMD OLAP Catalog 10.2.0.3.0 VALID

Output of modified xoq_validate (as described in <<Note 466363.1>>) is:
SQL> exec xoq_validate;
compat -> 10.2.0.2
BEFORE BOOTSTRAP
ORA-37111: Unable to load the OLAP API sharable library: (The specified module could not be found.)
AFTER BOOTSTRAP: REGISTRY.INVALID
comp_name: Oracle OLAP API
version: 10.2.0.3.0
status: INVALID

PL/SQL procedure successfully completed.


.

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