Wednesday, 1 February 2012

Installing Oracle APEX 4.1 to run on Oracle XE

If you are currently running Oracle 10g XE database then you may be aware that it comes with  Oracle Application Express (APEX) version 2.1. If you are using the newer Oracle 11gXE database then that currently comes with Application Express 3.2. This blog is aimed at giving you a step by step approach to upgrading to APEX 4.1. The steps are the same regardless of whether you are upgrading using 10gXE or 11gXE.
 
First of all download the software

Step 1
Download Oracle XE from here for Oracle 10gXE or here for Oracle11gXE

Step 2
Download APEX 4.1 from here

Install the database
Step 3
Install Oracle XE by double clicking on the OracleXE.exe file  
– specify the destination folder as c:\oraclexe
– specify the database password

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\apex (this holds either version 4.0 or 2.1 depending on the version of XE you have downloaded ) and unzip APEX 4.1 into the folder c:\oraclexe\apex

Upgrade to APEX 4.1

The following steps assume you have the following directory structures:
c:\oraclexe\apex (this is the unzipped Version 4.1 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.
e.g.
CMD> cd c:\oraclexe\apex

Step 7 - Upgrade to Version 4.1 - replace the word password  below with the password you created in Step 3 above
CMD> sqlplus system/password as sysdba
SQL> @apexins SYSAUX SYSAUX TEMP /i/
NB if you have problems accessing sqlplus you may need to set the environment variables in the DOS session as follows:
set ORACLE_HOME = c:\oraclexe\app\oracle\product\10.2.0\server
set ORACLE_SID = XE
Change the 10.2.0 folder in the above to match the relevant XE version

Step 8 - Set 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 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
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:
 http://localhost:8080/apex

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



No comments:

Post a Comment