Apex 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.

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 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!

Related posts:

Tags: , , , , , , , ,
12 Responses to “Upgrade Oracle APEX 3.2.1 to 4.0.1 on Oracle Database 10g Express Edition (XE)”
  1. Bram PintelonNo Gravatar says:

    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

  2. andreiashNo Gravatar says:

    you should go first to /apex/apex_admin and there you’ll set the workspace and everything else.

  3. Dan BrodyNo Gravatar says:

    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

  4. nonaNo Gravatar says:

    why i need to upgrade to APEX 4.0
    please i need to know what’s th a advantages of Apex4

  5. Mahesh BhayaNo Gravatar says:

    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

  6. andreiashNo Gravatar says:

    @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

  7. andreiashNo Gravatar says:

    @Ahmad: yes, it seems that, please recheck all the steps, especially the one with the images

  8. andreiashNo Gravatar says:

    @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.

  9. Dianna StroscheNo Gravatar says:

    I would like to get an APEX Developers Guide. Any suggestions?

  10. Renaud ClaeysNo Gravatar says:

    Dear,

    Works fine for me when upgrading from 3.0.2 to 4.1 on Oracle 11g Release 2 Enterprise Edition.

    Thanks,

    Renaud

  11. M JainNo Gravatar says:

    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

  12. M JainNo Gravatar says:

    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.

Leave a Reply