My Oracle Support Banner

DATAPACH Failed With ORA-37002: Oracle OLAP Failed To Initialize (Doc ID 2784131.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s)
or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner

Opatch completed successfully, but datapatch failed with:

ERROR at line 10:
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP
technical support.
ORA-04067: not executed, package "SYS.DBMS_AW" does not exist

SQL> CREATE OR REPLACE VIEW olapsys.ALL$OLAP2_AW_PHYS_OBJ_PROP AS
2 SELECT AW.AWOWNER as AW_OWNER,
3 AW.AWNAME as AW_NAME,
4 AW.AWOBJECT as AW_OBJECT_NAME,
5 AW.COL1 as AW_PROP_NAME,
6 AW.COL2 as AW_PROP_VALUE
7 FROM
8 TABLE(CAST (OLAP_TABLE('SYS.AWMD duration query', 'olapsys.ALL_OLAP2_AW_METADATA_T',
9 'ACTIVE_CATALOG ''ALL_OLAP2_AW_PHYS_OBJ_PROP'' ''ALL''',
10 'MEASURE AWOWNER FROM sys.awmd!PROPS_AWOWNER
11 MEASURE AWNAME FROM sys.awmd!PROPS_AWNAME
12 MEASURE AWOBJECT FROM sys.awmd!PROPS_AWOBJECT
13 MEASURE COL1 FROM sys.awmd!PROPS_AWOBJECTPROPNAME
14 MEASURE COL2 FROM sys.awmd!PROPS_AWOBJECTPROPVALUE
15 DIMENSION AWMDKEY FROM sys.awmd!AWMDKEY_PROPS')
16 AS olapsys.ALL_OLAP2_AW_METADATA_T)) AW
17 /
TABLE(CAST (OLAP_TABLE('SYS.AWMD duration query', 'olapsys.ALL_OLAP2_AW_METADATA_T',
*
ERROR at line 8:
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP
technical support.
ORA-04067: not executed, package "SYS.DBMS_AW" does not exist

 

OLAP is installed and valid per dba_registry:

 

Comp ID Component Status Version Org_Version Prv_Version
------- ---------------------------------- --------- -------------- -------------- --------------
APS OLAP Analytic Workspace VALID 19.0.0.0.0 19.0.0.0.0

XOQ Oracle OLAP API VALID 19.0.0.0.0 19.0.0.0.0

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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.