1 Reply Latest reply on Jul 13, 2018 10:39 AM by Hilary Farrell-Oracle

    Application archive - HowTo upgrade from Apex 4.2 to Apex 5.1.3




      I am currently testing the upgrade from Apex 4.2 to Apex 5.1.3. I am using the packaged applicatioin "APEX application archive" in APEX 4.2 in locked mode. I have exported and imported the schema with data into an Oracle 12cR2 database with Oracle APEX 5.1.3.

      I tried to install the new version of the APEX Application archive but following error ocurred (because of the existing schema).

      It is possible to unlock the Application Archive in 4.2 and export/import this application. But then I cannot upgrade to the new version of the APEX application archive with the Universal Scheme.


      So what is the right way to do this? Is there a way to ignore this error message or toget an upgrade option?


      Thank you very much for you answers in advance.


      Best regards,


        • 1. Re: Application archive - HowTo upgrade from Apex 4.2 to Apex 5.1.3
          Hilary Farrell-Oracle

          Hi Reinhard,


          Please note that there's a 5.1.4 patch set available, so you should really consider upgrading to that version as opposed to 5.1.3 - that's if upgrading to 18.1 is too big a step to take.  At least move to the most recent 5.1.x patch set available.


          What steps are you following to actually upgrade your APEX 4.2 instance to 5.1.3?  You've mentioned an import/export but I see no mention of an actual upgrade.  As part of an APEX upgrade, we will detect that you've already got the Packaged App installed, and expose an 'Upgrade' button to you in the upgraded 5.1.x instance.  However, it doesn't sound like you're doing an upgrade, and instead just moving the schema to an instance running APEX 5.1.3.  If you are hitting the 'Prerequisite Check Failed' error, then it sounds like you ran the 'Install' option for the Packaged App in your new 5.1.3 instance, and therefore the instance didn't detect that you already have the app installed.  I would recommend reviewing our Installation Guide, and ensure you're following the correct steps to upgrade your instance: https://docs.oracle.com/database/apex-5.1/HTMIG/toc.htm