ORA-22288 When Running apex_epg_config.sql or apxldimg.sql

(Doc ID 469342.1)

Last updated on JULY 14, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 3.0.0.0.20 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Jan-2013***
***Checked for relevance on 15-Jul-2014***

Symptoms

When attempting to run apxldimg.sql  or apex_epg_config.sql for the PL/SQL Gateway (EPG), the following error occurs when the script is attempting to load the APEX image files.


Steps to Reproduce


1. Change your working directory to the location where you have unzipped the Application Express software on the database server. This is the location of the apxldimg.sql and apex_epg_config.sql scripts.

ERROR
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ORA-06512: at "SYS.DBMS_LOB", line 523
ORA-06512: at "SYS.XMLTYPE", line 287
ORA-06512: at line 18

 

Ex. /u01/oracle/products/apex42/apex


2. Start SQL*Plus and connect the database where Oracle Application Express is installed as SYS.
For example:
$ sqlplus sys/SYS_password as sysdba

3. Run apex_epg_config.sql:

->         @apex_epg_config /tmp

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms