I've got problem with files for plugins and application files. For some reason they are not loaded when page opens. Our machine is oracle 11.2 SE1 with all patches -> 22.214.171.124.4.
It stands with new APEX Listener 2.0 (don't think it matters thou)
EXEC FAILED:ORA-22293: lob already opened in the same transaction
ORA-06512: at "SYS.DBMS_LOB", line 1001
ORA-06512: at "APEX_040200.WWV_FLOW_UTILITIES", line 8150
ORA-06512: at "APEX_040200.WWV_FLOW_FILE_MGR", line 737
ORA-06512: at line 2
We read the metalink entry and found out that the we need to change db_securefile to 'PERMITTED'. We had this set to 'ALWAYS' at the beginning of server start (security issue from audit).
I think we tried everything:
Remove the file, remove the app etc. Reset of the servers etc.
We have a bypass for plugin files but APP_IMAGES are different story and need to be fixed.