This discussion is archived
7 Replies Latest reply: Nov 7, 2011 5:59 AM by 893117 RSS

Problem with 4.1 Install new Image directory

patfmnd Newbie
Currently Being Moderated
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

Legend

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