1 Reply Latest reply on Jan 4, 2013 12:31 PM by Piotr Jasiński

    I get ora-22293 with application and plugin files

    Piotr Jasiński
      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
          Piotr Jasiński
          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