OLAP Analytic Workspace Component Fails To Install with ORA-43856 In SYS.DBMS_AW_BUILD (Doc ID 1565321.1)

Last updated on FEBRUARY 02, 2017

Applies to:

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

Symptoms

An attempt to install OLAP in 11.2.0.2 or later fails and OLAP Analytic Workspace component in the DBA Registry shows a status of INVALID:

COMP_ID    COMP_NAME                      VERSION         STATUS
---------- ------------------------------ --------------- ----------
APS        OLAP Analytic Workspace        11.2.0.2.0      INVALID
XOQ        Oracle OLAP API                11.2.0.2.0      VALID
AMD        OLAP Catalog                   11.2.0.2.0      VALID

Furthermore, the following error is shown in the install log:

BEGIN dbms_aw_build.build('EXPRESS', FALSE); END;

*
ERROR at line 1:
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP
technical support.
ORA-33263: Could not create analytic workspace SYS.EXPRESS
ORA-33269: while operating on '"SYS"."AW$EXPRESS"'
ORA-43856: Unsupported LOB type for SECUREFILE LOB operation
ORA-06512: at "SYS.DBMS_AW_BUILD", line 107
ORA-06512: at line 1

 

Changes

 OLAP is newly installed in Oracle Database 11g, Release 2 or an upgrade to that version is attempted with OLAP installed.

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