Install Apex on Oracle XE database

1. Ensure you are logged into Windows XP/7 with Administrator rights

I assume you already installed OracleXE database.

2. Create home directory for APEX and extract software to that directory

I have created like this C:\ORACLE\product\OracleXE\app\oracle\product\10.2.0\server\apex_4.0.1\apex\all_apex_files

3. Using SQLPLUS, install the APEX software against the XE database you already installed

Login as sysdba

@apexins.sql SYSAUX SYSAUX TEMP /i/

4. Change the APEX ADMIN account password (4:35)

@apxchpwd.sql

5. Run the image loader script (5:25)

@apxldimg.sql C:\ORACLE\product\OracleXE\app\oracle\product\10.2.0\server\apex_4.0.1

6. Login to http://localhost:8080/apex and check it.

That's All !

Enjoy it.

Upgrade/Install Oracle Apex 3.2.1 to 4.0.1 on Oracle Database 10g,11g

1. Download APEX from OTN


2. Unzip it making sure you don't change the name of the apex folder inside the zip.

unzip apex_4.0.1.zip /tmp/
cd /tmp/apex

3. Connect to your XE installation

sqlplus / as sysdba

4. Run the installation script

SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/

5. Wait 10-15 minutes then connect again as sysdba and import images

SQL>@apxldimg.sql /tmp

!do not put the "apex" folder in the path there

That's it, no more unlock account, set password, set port, you already did this on the previous installation.
Enjoy!
*****************************************************************
To do fresh installation follow above steps plus these ::
sql > @apxconf.sql
Enter a password for the ADMIN user and you can change default Port[8080] if you want.
sql > ALTER USER ANONYMOUS ACCOUNT UNLOCK;
Now,login in browser http://127.0.0.1:8080/apex with following detail :
Workspace – internal
Username – Admin
Password – password entered in @apxconf.sqll
That's all!
Enjoy !

Other userful link

http://www.davidghedini.com/pg/entry/install_oracle_11g_xe_on

http://www.truexense.com/2013/03/how-to-upgrade-oracle-apex-41-to-421-on.html