

Upgrade Oracle APEX 3.2.1 to 4.0.1 on Oracle Database 10g Express Edition (XE)
Posted by: Andrei in Database, Linux, Oracle, Programming, UbuntuApex is a great tool for rapid web applications based on Oracle Database. It’s free, and if you’re happy with Oracle XE’s limitations, then it’s perfect, you have the database free as well. I’ve been following APEX for long time ago, since it was called HTML DB, and wrote 2+ years ago a guide how to install APEX on XE.
Now APEX 4.0.1 is GA and most of the people would like to upgrade. It’s very simple.
1. Download APEX from OTN
2. Unzip it making sure you don’t change the name of the apex folder inside the zip.
cd /tmp/apex
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!
Related posts:
Hey,
I just did a clean install of oracle 10g express edition and I also did a cleaan install of APEX 4. After installation I have to enter a workspace, user and password.
I can’t login, because I never created a workspace…
I already altered the admin password. Can you help me?
Thx
you should go first to /apex/apex_admin and there you’ll set the workspace and everything else.
AWS ami-986f11ca image upgrade from Apex 3 to 4.0.3 issue upgrade ran but cannot get images to show up. I have run:
1) SQL>@apxldimg.sql /tmp
2) SQL>@apxldimg.sql /usr/lib/oracle/xe/app/oracle/product/10.2.0/server (ORACLE_HOME)
but this does not work
Any suggestions
Thanks Dan
why i need to upgrade to APEX 4.0
please i need to know what’s th a advantages of Apex4
Connect / as sysdba
SQL>@apxchpwd
When prompted enter a password for the ADMIN account.
Then go to the apex admin URL
/apex/apex_admin
and login with your newly created password
@nona: let me google this for you:
http://www.google.com/search?q=apex+4+new+features
… then click any link on the first page, it should answer your question
@Ahmad: yes, it seems that, please recheck all the steps, especially the one with the images
@Dan Brody: The path supplied is wrong. it seems you didn’t unzip apex into /tmp. Just search the folder where you unzipped APEX (the folder that have an “apex” subfolder inside) and provide that top folder as parameter.
I would like to get an APEX Developers Guide. Any suggestions?
Dear,
Works fine for me when upgrading from 3.0.2 to 4.1 on Oracle 11g Release 2 Enterprise Edition.
Thanks,
Renaud
i followed the same steps. But at last iam not getting image. i have done all the steps and configuration also. kindly can u help me regarding this
Image path : /u04/appx/upgrade/apex/images
I upgraded 4.1 to 4.2 up gradation has been completed. listener has been configured but in url image is not comming. kindly assist me to get it completed.