This discussion is archived
2 Replies Latest reply: Jan 3, 2013 11:57 PM by Bas de Klerk RSS

oracle epg configuration issue

982857 Newbie
Currently Being Moderated
Hello,

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.

http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21673/otn_install.htm#CHDEIGGI

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 := '';
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 18
Can someone guide what could be the issue.

Regards,
Bala
  • 1. Re: oracle epg configuration issue
    Andreas Wismann Explorer
    Currently Being Moderated
    Hi,
    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 Pro
    Currently Being Moderated
    Hi,

    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
    Regards
    Bas

Legend

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