My Oracle Support Banner

ORA-22288 When Running apex_epg_config.sql or apxldimg.sql (Doc ID 469342.1)

Last updated on AUGUST 15, 2019

Applies to:

Oracle Application Express (APEX) - Version 3.0.0.0.20 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.