Unpack apex to a directory( in my case is c:/oraclexe/apex)
1- go to cd c:/oraclexe/apex
2- sqlplus sys as sysdba
Enter the password for sys
The follow the following:
1- install apex by
SQL> @apexins SYSAUX SYSAUX TEMP /i/
2- upgrade img folder
SQL> @apxldimg.sql c:\oraclexe
3- removing prior installations
finding old installations
SELECT username
FROM dba_users
WHERE (username LIKE ‘FLOWS_%’ OR USERNAME LIKE ‘APEX_%’)
AND USERNAME NOT IN (
SELECT ‘FLOWS_FILES’
FROM DUAL
UNION
SELECT ‘APEX_PUBLIC_USER’ FROM DUAL
UNION
SELECT SCHEMA s
FROM dba_registry
WHERE comp_id = ‘APEX’);
4- removing old installations.
DROP USER APEX_040000 CASCADE;
Note: When having Permission issues by loading the images on Linux, like..
ORA-22288: file or LOB operation FILEOPEN failed
Permission denied
ORA-06512: at “SYS.DBMS_LOB”, line 523
ORA-06512: at “SYS.XMLTYPE”, line 287
ORA-06512: at line 15
The workaround is to copy the images to a different directory.
rm -rf /tmp/apex/images/
then
mkdir -p /tmp/apex/images/
then
cp -r /root/apex/images/* /tmp/apex/images/
then back in sqlplus
@apxldimg.sql /tmp
All is done!
