My Oracle Support Banner

Installation of APEX 4.0.1 with Oracle 11g 11.2.0.2.0 Failed - ORA-43853 (Doc ID 1271697.1)

Last updated on AUGUST 11, 2019

Applies to:

Oracle Application Express (APEX) - Version 4.0.0 and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Service - Version N/A 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

 

Changes

 

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


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