This discussion is archived
1 Reply Latest reply: Jan 4, 2013 4:31 AM by 707752 RSS

I get ora-22293 with application and plugin files

707752 Explorer
Currently Being Moderated
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 -> 11.2.0.3.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 := ?;
begin
owa.init_cgi_env( ?, nm, vl );
htp.init; htp.HTBUF_LEN := 63;
? := sys_context('USERENV','SID');
end;
SID:144
CALL:
begin
wwv_flow_file_mgr.get_file(p_plugin_id=>?,
p_file_name=>?,
p_security_group_id=>?);
commit;
end;
BINDS

p_plugin_id:2561747736258884498
p_file_name:apex.jquery.maskedinput-1.2.2.min.js
p_security_group_id:2000002
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.

Regards
piotr
  • 1. Re: I get ora-22293 with application and plugin files
    707752 Explorer
    Currently Being Moderated
    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').

    Regards
    piotr

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points