Upgrade APEX from 4.02 to 4.2.5 on Ubuntu

The version of APEX installed along with Oracle 11g R2 Express Edition is V4.0.2 which is not the latest version. Here is a tutorial of how to upgrade APEX from version 4.0.2 to version 4.2.5.

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

unzip apex_4.2.5_en.zip
#change the working directory to unzip folder
cd apex

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

sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter Password: 
SYS_Password

3. Install Application Express:

SQL> @apexins SYSAUX SYSAUX TEMP /i/

4. Copy images folder from apex/images to a different location to prevent failure of loading images in the next step

mkdir -p /tmp/apex/images/
cp -r imges/* /tmp/apex/images

5. Log back into SQL*Plus (as above) and load images:

SQL> @apxldimg.sql /tmp

6. Upgrade Application Express password:

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

7. 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 6