Sunday, 11 May 2014

Installing APEX 4.2 to run on Oracle XE

Oracle 11gXE database currently comes with an older version of Application Express  This blog is aimed at giving you a step by step approach to upgrading to APEX 4.2

First of all download the software
Step 1

Step 2
Download APEX 4.2 from
Next install the database
Step 3
Install Oracle XE by double clicking on the OracleXE.exe file  
– specify the destination folder such as  c:\oraclexe
– specify the database password – this will be used for both the SYS AND SYSTEM users

Step 4
Make a note of the port numbers allocated as part of the installation eg
Port for the HTTP listener = 8080
Port for the database listener = 1521

Step 5
Once XE is installed rename/empty the existing apex  folder at c:\oraclexe\app\oracle\product\11.2.0\server\apex (this holds an older version of APEX and unzip the APEX 4.2 file into the following folder c:\oraclexe\apex

Next upgrade to APEX 4.2
The following steps assume you have the following directory structures:
c:\oraclexe\apex (this is the unzipped Version 4.2 file)
c:\oraclexe\app (this is created by the Oracle XE installation) 

Step 6
Open DOS window and change the default directory to the directory of the unzipped APEX file.
CMD> cd c:\oraclexe\apex

Step 7 – Now upgrade to Version 4.2 - replace the word password  below with the password you created in Step 3 above
CMD> sqlplus system/password as sysdba
NB if you have problems accessing sqlplus you may need to set the environment variables in the DOS session eg:
set ORACLE_HOME = c:\oraclexe\app\oracle\product\11.2.0\server

Once this step has completed you will automatically be logged out of SQLPlus.

Step 8 - Set the images directory - replace the word password  below with the password you created in Step 3 above
CMD> sqlplus system/password as sysdba
SQL> @apxldimg.sql c:\oraclexe

Step 9 - Set the Admin password - replace the word password  below with your own value – this will be used to log into the internal workspace
SQL> @apxxepwd.sql password

Step 10 - Enable remote http connections - set l_access to TRUE to restrict the EPG to listen on the localhost only or set it to FALSE to listen on both localhost and non-localhost interfaces.
SQL> exec dbms_xdb.setListenerLocalAccess (l_access => FALSE);

Your upgrade should now be complete.
To test it open up a browser and type the following URL:

This should take you to the Oracle Application Express login page

Enter the following values replacing password with the one you created at Step 9 above
Workspace: Internal
Username: Admin
Password: password


  1. Thanks for sharing this post. This post really helped me Installing APEX 4.2

    Oracle Training

  2. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Oracle 11g, kindly contact us
    MaxMunus Offer World Class Virtual Instructor led training on Oracle 11g. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us:
    Name : Arunkumar U
    Email :
    Skype id: training_maxmunus
    Contact No.-+91-9738507310
    Company Website –