Saturday, August 1, 2015

Apex 5-unpublished requirement (ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "APEX5")

After one year pause from blogging, I have decided to write one post. Subject is mine love-Apex!
Finally the day when I decided to upgrade to Apex 5 has come. Time shift of initial Apex 5 release and curiosity to see how mine apps will fit in new Apex were main sparks to upgrade mine Apex 4.2x version to current latest, Apex version 5.0.1.
As I always do, I install Apex in separate tablespace. For this occasion I create tablespace which was replica from 4.2x release, just changed the name and datafile
CREATE TABLESPACE APEX5 DATAFILE 
  'F:\ORADATA\XESSD\APEX5.DBF' SIZE 256M AUTOEXTEND ON NEXT 4M MAXSIZE 1G
LOGGING
ONLINE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;
And then later started installation in a way:
@apexins APEX5 APEX5 TEMP /i/ 
But very soon after, I get an error ... here is the end of the log.
...Internal messages
WWV_FLOW_API.FLOWS_API_LAST_EXTENDED20130101
WWV_FLOW_API.CURRENT_FLOWS_VERSION20130101
WWV_FLOW_API.IMPORT_COMPATIBLE_WITH_VERSION 20130101
WWV_FLOW_API.COMPATIBLE
--application/set_environment
APPLICATION 4411 - Oracle APEX  System Messages and Native Types
--application/delete_application
begin
*
ERROR at line 1:
ORA-04063: package body "APEX_050000.WWV_FLOW_UTILITIES" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APEX_050000.WWV_FLOW_UTILITIES"
ORA-06512: at "APEX_050000.WWV_FLOW_AUDIT", line 92
ORA-06512: at "APEX_050000.WWV_FLOW_API", line 2148
ORA-06512: at line 2
The whole installation log file can be downloaded from here
As this was the end of log, I look for the first error in log and found:
Table created.

create table wwv_flow_collection_members$ (
*
ERROR at line 1:
ORA-43853: SECUREFILE lobs cannot be used in non-ASSM tablespace "APEX5"
A-ha ... Apex 5 must be installed in ASSM tablespace!!!
Then I removed Apex 5 failed installation
@apxremov.sql
Exit that session. Drop and recreated new APEX5 tablespace with ASSM:
CREATE TABLESPACE APEX5 DATAFILE 
  'F:\ORADATA\XESSD\APEX5.DBF' SIZE 256M AUTOEXTEND ON NEXT 4M MAXSIZE 2G
LOGGING
ONLINE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
Repeated installation (as before) and all went with no problems!

The End

I found one blog on similar subject (Installation of APEX 4.0.2 with Oracle 11g 11.2.0.2.0 Failed - ORA-43853) but mine is related to fresh new 5.0 version and ... somehow... mine previous 4.2 was 100% on MSSM tablespace on Oracle 11.2.0.3.
So, seems to me this is new(old) missing Apex requirement.
Hope this helps.

Cheers!
P.S. Latest Apex4 tablespace was 407 MB and new, Apex5 is 1.39 GB. Difference is quite big! I found out that fact in a harder way (tablespace had 1 GB limitation!):
apxsqler.sql
...Page Designer metadata install
Enter YES (or hit enter) to load system messages and NO to skip it (NO should only be used during installation)

Property Editor - Metadata

declare
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace APEX5
ORA-06512: at line 508
ORA-06512: at line 5181
So leave unlimited or at least 2 GB.

No comments :

Post a Comment

Zagreb u srcu!

Copyright © 2009-2014 Damir Vadas

All rights reserved.


Sign by Danasoft - Get Your Sign