Upgrade Oracle APEX 3.2.1 to 4.0.1 on Oracle Database 10g Express Edition (XE)
Posted by: andreiash 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:
Entries (RSS)
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.
Hey,
I followed your instructions exactly then I open the browser to http://127.0.0.1:8080/apex/apex_admin and entered admin as the username and the password I set for the apex admin but nothing happened when I click the Login button. This webpage looks like a dead page where there is no response after clicking the Login button. Am I missing something?
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.