Upgrade Oracle Apex from 5.1.x to 18.2

Upgrade Oracle Apex from 5.1.x to 18.2

Upgrade APEX to 18.2.0.00.12

PURPOSE: All documents are provided on this Blog just for educational purposes only.  Please make sure that you run it in your test environment before to move on to production environment. 

Download the following file in your download location or in temporary directory.

apex_18.2.zip

      Check the current Version.

col COMP_NAME format a30;

select comp_name, version from dba_registry where comp_name = 'Oracle Application Express';

COMP_NAME                      VERSION

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

Oracle Application Express     5.1.4.00.08

Check Tablespace and create it,  If does not exist:

col FILE_NAME format a45;

set linesize 200;

select tablespace_name,file_name,bytes/1024/1024 mb from dba_temp_files;

select tablespace_name,file_name,bytes/1024/1024 mb from dba_data_files;

select TABLESPACE_NAME  from dba_tablespaces where tablespace_name like '%APEX%';

TABLESPACE_NAME

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

APEX18

APEX18_FILE

You can create it as follow.

Creating tablespace:

create tablespace apex18 DATAFILE '+DATA' SIZE 256M REUSE AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;

create tablespace apex18_file DATAFILE '+DATA' SIZE 256M REUSE AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED;

Execute following commands.

n  If you want, you can remove complete old Installation.

cd /apps/oracle/product/18.0.0/db_18c/apex

rm -rf *

unzip following file in the $ORACLE_HOME location.

cd /download/apex_18.2/

unzip apex_18.2.zip -d /oracle/product/18.0.0/db_18c/

/oracle/product/18.0.0/db_18c/apex

$ sqlplus / as sysdba

@apexins.sql APEX18 APEX18_FILE TEMP /i/

Create an instance administrator user, if it does not exist and set their password

@apxchpwd.sql

user=apexadmin

PW=xxxx

Create the APEX_LISTENER and APEX_REST_PUBLIC_USER users, if it does not exist

@apex_rest_config.sql

Enter a password for the APEX_LISTENER user              []

xxxx

Make sure the APEX_PUBLIC_USER account is unlocked.

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY xxxx ACCOUNT UNLOCK;

ALTER USER APEX_PUBLIC_USER IDENTIFIED BY xxxx ACCOUNT UNLOCK;

select COMP_ID, VERSION, STATUS from dba_registry where COMP_ID like 'APEX%';

COMP_ID                        VERSION                        STATUS

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

APEX                           18.2.0.00.12                   VALID

If you want, you can drop the old user.

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 FROM dba_registry WHERE comp_id = 'APEX'

);

DROP USER APEX_030200 CASCADE;

DROP USER APEX_050100 CASCADE;

The Installation is completed.