2 Replies Latest reply: Jan 4, 2013 1:57 AM by Bas de Klerk RSS

    oracle epg configuration issue


      We have installed Oracle 4.0 on 11gR2 and we have configured it to run with APEX Listener (Listener is on separate machine) and everything is running fine.

      Now we want to configure EPG, so we are just following steps mentions in below documentation.


      When we run
      SQL> @apex_epg_config.sql /u05/apex
      we are getting following error.
      PL/SQL procedure successfully completed.
      PL/SQL procedure successfully completed.
      old   1: create directory APEX_IMAGES as '&1/apex/images'
      new   1: create directory APEX_IMAGES as '/u05/apex/apex/images'
      Directory created.
      old  47:     if '&IMGUPG' != '' then
      new  47:     if '' != '' then
      old  48:         l_mv_folder := '&IMGUPG';
      new  48:         l_mv_folder := '';
      ERROR at line 1:
      ORA-22288: file or LOB operation FILEOPEN failed
      No such file or directory
      ORA-06512: at "SYS.XMLTYPE", line 296
      ORA-06512: at line 18
      Can someone guide what could be the issue.

        • 1. Re: oracle epg configuration issue
          Andreas Wismann
          if '&IMGUPG' != '' then
          A comparison between 'SOMETHING' and NULL (the empty string in Oracle) using =, != or <> never yields TRUE but always NULL.
          See http://stackoverflow.com/questions/7286047/oracle-pl-sql-string-compare-issue

          It should read
          if '&IMGUPG' is not NULL then
          • 2. Re: oracle epg configuration issue
            Bas de Klerk

            looks like you're using the wrong directory as a parameter ( error message is telling you "create directory APEX_IMAGES as '/u05/apex/apex/images'" which includes apex twice in the path ).

            So try the command without the apex dir which is added in the script :
            @apex_epg_config.sql /u05