Steps to Upgrade to Apex 4.0.2

V4 is as easy to upgrade as any previous version, however, V4 has a lot of new themes.

Download latest application express.

I have downloaded apex_4.0.2.zip.

Installing in Windows :  

Unzip the apex into c:\apex\  

 All the unzipped files will now be in C:\apex\apex

Open Command prompt. 

Change the directory to the location where the file apexins.sql is present(c:\apex\apex\apexins.sql).

Run SQLPLUS. 

Login as SYSDBA user.

Run the command - @apexins SYSAUX SYSAUX TEMP /i/

(as shown below)

After the above steps are done, the next step is to upload the images.

Open Command prompt again if it was closed previously.

Change the directory to the location where the file apxldimg.sql is present(c:\apex\apex\apxldimg.sql).

Once again run SQLPLUS and Login as SYSDBA user.

Move the new images in (the last parameter is the directory where you unzipped apex from, in this case apex) : @apxldimg.sql c:\apex

Last step,
You need to set the admin password : @apxxepwd.sql password


Now log into apex in a browser: http://127.0.0.1:8080/apex/apex_admin


User : admin
Passwd : password

 

You can change the admin password and check for all the users and add any new user in case you want to.

Now log into apex in a browser: http://127.0.0.1:8080/apex/

Thats it, Enjoy Apex 4.

Thanks for helping me set this up, Vishwa(my colleague). :)