Upgrade Oracle Apex from 4.2.x to 5.0 on CentOS

Here is a tutorial of how to upgrade APEX from version 4.2.x to version 4.2.5.

1. Download the latest version of Application Express from the Oracle Technology Network and Unzip the downloaded file:

#unzip files to /tmp folder
unzip apex_5.0_en.zip -d /tmp
#change the working directory to unzip folder
cd /tmp/apex

2. Start SQL*Plus and connect to the Oracle XE database:

sqlplus / as sysdba 

3. Install Application Express:

SQL> @apexins SYSAUX SYSAUX TEMP /i/

4. Updating the images directory

@apex_epg_config.sql /tmp

5. If you are using ORDS, copy images to your application server. I am using Tomcat,

sudo cp /tmp/apex/images/* /var/lib/tomcat6/webapps/i/

6. Prepare two new database accounts for ORDS

@apex_rest_config.sql
when prompted enter password for these two accounts:
APEX_LISTENER: APEXLISTENER
APEX_REST_PUBLIC_USER:APEXREST

7. Modify account profiles for APEX_PUBLIC_USER,APEX_LISTENER,APEX_REST_PUBLIC_USER to disable password expire:

# UNLIMITED_PASSWORD_LIFETIMEhas been created
alter USER APEX_PUBLIC_USER PROFILE UNLIMITED_PASSWORD_LIFETIME;
alter USER APEX_LISTENER PROFILE UNLIMITED_PASSWORD_LIFETIME;
alter USER APEX_REST_PUBLIC_USER PROFILE UNLIMITED_PASSWORD_LIFETIME;

8. Modify instance admin password if you wish. Old password is preserved and carried over.

SQL> @apxchpwd
Enter password for Application Express ADMIN account.

9. In a Web browser, navigate to the Oracle Application Express Administration Services application:
http://127.0.0.1:8080/apex/apex_admin
In Username, enter ADMIN
In Password, enter the password entered in (Step 8.)

Problems and Solution:
1. Q.There is a problem with your environment because the Application Exress files have not been loaded....

A. Copy files in /tmp/apex/images/* to your web application folder, see step (5.)

2. Q. There are issues with the configuration of the Static Files in your environment. Please ...

A. Have you run @apex_rest_config.sql to preapre the accounts required for ORDS? Step (6.)