Friday 24 September 2010

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.

3. Connect to your XE installation

4. Run the installation script

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

!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

No comments: