My Oracle Support Banner

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 and later
Information in this document applies to any platform.


An attempt to install OLAP in 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      INVALID
XOQ        Oracle OLAP API            VALID
AMD        OLAP Catalog               VALID

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


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



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


To view full details, 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 a vibrant support community of peers and Oracle experts.