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

(Doc ID 469342.1)

Last updated on JANUARY 19, 2018

Applies to:

Oracle Application Express (APEX) - Version and later
Information in this document applies to any platform.


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.

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




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