Installation of APEX 4.0.1 with Oracle 11g 11.2.0.2.0 Failed - ORA-43853

(Doc ID 1271697.1)

Last updated on JULY 07, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.0.0 and later
Information in this document applies to any platform.
Checked for relevance on 05-Jun-2013

Symptoms

 


In a new installation of APEX, APEX fails against RDBMS 11.2.0.2. The installation log shows the following error:

ERROR at line 1:
ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "APEX_DATA"
ORA-06512: at line 7


Where APEX_DATA is the table space associated with the APEX installation.

Errors for PACKAGE BODY WWV_FLOW_WS_API:

LINE/COL ERROR
-------- -----------------------------------------------------------------
6927/20 PL/SQL: SQL Statement ignored
6928/25 PL/SQL: ORA-01775: looping chain of synonyms
6931/13 PL/SQL: Statement ignored
6931/27 PLS-00364: loop index variable 'C1' use is invalid
8550/16 PL/SQL: SQL Statement ignored
8551/23 PL/SQL: ORA-01775: looping chain of synonyms
8557/9 PL/SQL: Statement ignored
8557/12 PLS-00364: loop index variable 'C1' use is invalid
8568/9 PL/SQL: Statement ignored
8574/46 PLS-00364: loop index variable 'C1' use is invalid


What works

 

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