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/
