7 Replies Latest reply: Nov 7, 2011 7:59 AM by 893117 RSS

    Problem with 4.1 Install new Image directory

    patfmnd
      Hi,
      I ran the upgrade install in the directory where the new apex was unzipped to and that was successful. Since this is an upgrade using embedded pl/sql gateway I ran the apxldimg.sql in same directory but I am getting an error and when I go to the apex_admin URL I am getting a blank page. Also, the script asked for a value--which was indication of an issue.

      See results below--

      SQL> @apxldimg.sql

      PL/SQL procedure successfully completed.

      Enter value for 1:
      old   1: create directory APEX_IMAGES as '&1/apex/images'
      new   1: create directory APEX_IMAGES as '/apex/images'

      Directory created.

      declare
      *+
      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 15

      PL/SQL procedure successfully completed.

      PL/SQL procedure successfully completed.

      Commit complete.

      timing for: Load Images
      Elapsed: 00:01:08.64

      Directory dropped.

      Any help would be appreciated to help resolve the problem. Can the apxldimg.sql be run again at this point?

      Thanks,
      Pat