ORA-22288 When Running apex_epg_config.sql or apxldimg.sql
Last updated on JANUARY 19, 2018
Applies to:Oracle Application Express (APEX) - Version 126.96.36.199.20 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
2. Start SQL*Plus and connect the database where Oracle Application Express is installed as SYS.
$ sqlplus sys/SYS_password as sysdba
3. Run apex_epg_config.sql:
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