Hello everybody :)
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)
The log is shouting with this error:
[#|2013-01-04T09:17:03.894+0000|SEVERE|glassfish3.1.2|null|_ThreadID=73;_ThreadName=Thread-2;|_init_: # headers=47
declare nm owa.vc_arr := ?;
vl owa.vc_arr := ?;
owa.init_cgi_env( ?, nm, vl );
htp.init; htp.HTBUF_LEN := 63;
? := sys_context('USERENV','SID');
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.
Do anyone had this kind of problem?
Will appreciate any help.
Found it :)
The parameter db_securefile changed to 'ALWAYS' changes all blob columns to secure files :/
This mean that you need to change not the parameter but column storage to basicfile.
After that all should be OK - checked :)
BTW - i think that there is a need to change in couple of places in APEX installation scripts so the blobs have forced BASIC FILE not default SECURE FILE (if db_securefile = 'ALWAYS').