Upgrade Oracle Application Express (APEX) manually.

I facing this error because running this scripts using full path like below example.

SQL>@/u02/app/oracle/product/11/db_home1/apex/apexins.sql SYSAUX SYSAUX temp /i/

(sp2-0310 unable to open file "coreins.sql")

First you have to go the apex directory and then run directly from SQL prompt

 cd /u02/app/oracle/product/11/db_home1/apex

sqlplus / as sysdba

SQL>@apexins.sql SYSAUX SYAAUX TEMP /i/

Recommendation 4: Upgrade Oracle Application Express (APEX) manually.

To upgrade to latest Application Express, download the latest version from the below link here

Upgrading APEX

Check the current APEX Version

SQL> Select Comp_name, status, Version

     From Dba_Registry

     where comp_id='APEX';

 

COMP_NAME                                STATUS       VERSION

---------------------------------------- ------------ ------------------------------

Oracle Application Express               VALID        3.2.1.00.12

 

SQL>

From the directory which holds the APEX unzipped software, connect to sqlplus as SYS user and run apexins.sql

cd /u01/app/oracle/product/11/db_home1/apex

sqlplus /as sysdba

SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/