Oracle & MySQL Support

InfraStack-Labs Oracle & MySQL DBA Services help you manage, maintain, and optimize your critical Oracle systems. We deliver 24/7, year-round support with flexible monthly contracts that don’t lock you in.

Please contact me :- ajith.narayanan@infrastack-labs.in

Tuesday, May 5, 2015

Upgrade Oracle APEX (4.0.2.00.09 to 5.0.0.00.31) In Oracle 11g Express Edition

Hi Friends,

It's been a while with a blogpost, and this time its APEX, One of my favorite product from Oracle.

Oracle 11g XE is quick to download from OTN and install in the laptop for trial & learning purposes and many of us already have this installed in laptop and use it for creating small applications for our own use. 


Scenario:- Today, I had to install a packaged application provided by Oracle into my express edition. By default the APEX version in express edition is 4.0.2.00.09, When I was trying to import the packaged application into my 11g XE database, It was failing with an INCOMPATIBLE error.

I did careful reading through the details of packaged application which clearly mentioned Oracle developed the application in APEX version 4.2 and thus my XE APEX version of 4.0 was incompatible. I did not want to install a 12c R1 database which by default comes with APEX 4.2, Instead decided to upgrade the APEX version in XE to newly released 5.0 version directly. 

This post shows step by step method to upgrade our APEX from version 4.0.2.00.09 to 5.0.0.00.31.


1. Download the latest Oracle APEX (5.0) version from OTN

download

























2. Unzip the downloaded zip file:
  • Linux: Unzip .zip
  • Windows: Double click .zip in Windows Explorer







3. Start CMD prompt and Change your working directory to apex.



4. Start SQL*Plus and connect to the Oracle XE database:

 

5. Install Application Express:



5. Log back into SQL*Plus (as above) and load images:

Confirm is the APEX was upgraded to version 5.0



7. In a Web browser, navigate to the Oracle Application Express Administration Services application:


 











After the APEX 5.0 upgrade my packaged application import was smooth without any issues.

HAPPY LEARNING!

8 comments:

  1. after loading browser it says that
    "There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have copied the images directory to your application server as instructed in the Installation Guide. In addition, please verify that your image prefix path is correct. Your current path is /i/ (it should contain both starting and ending forward slashes, such as the default /i/). Use the SQL script reset_image_prefix.sql if you need to change it."
    now what i have to do.
    Thank you!

    ReplyDelete
  2. yes.copy the path where u unzip the apex and paste it on cmd then enter @apxldimg.sql

    ReplyDelete
  3. Fantastic! Worked like a dream!

    Best set of instructions.

    Many Thanks!

    ReplyDelete
  4. Hello, i've just used your guide and it worked perfectly, but i was trying to access to the "Get started with Oracle Database 11g Express Edition" icon and it displays ERR-7620 Could not determine workspace for application (4950). ORA-01403: no data found. Does that interface is no longer available when you upgrade the version? And if it does, is there anyway to access that interface again? Thanks for the guide

    ReplyDelete
  5. Perfecto muchas gracias...

    Perfect, thanks a lot..

    http://127.0.0.1:8080/apex/f?p=4050 access the administrative services page.

    ReplyDelete

Thanks for you valuable comments !