Saturday, June 05, 2021

Upgrading Oracle APEX has never been easier

On May 12th Oracle APEX 21.1 was released. 

This post is not about why Oracle APEX 21.1 is worth an upgrade. You can see for yourself if you like the improvements in the Release Notes. Some companies upgrade once a year, some wait for the patch set bundle, and some upgrade very fast.

We upgraded our production instance this weekend. I blogged about how we do the upgrades and try to minimize downtime in the past. But upgrades have become even easier!

While the Oracle APEX kept running; 15 minutes install which of 5 minutes downtime, and we were done!

Note: it's always good to read the installation guide

Below what we did: 

  1. Download Oracle APEX
  2. Unzip
  3. Go into the directory 
  4. Connect to the Oracle Database with SQLcl or SQLPlus 
  5. Run 1 command:
@apexins.sql SYSAUX SYSAUX TEMP /i/

That was it! ... the installation did everything for us... and again this was in a live environment!
ORDS knows now that an APEX install is busy and suspends traffic for a certain time and next it comes up again:

Phase 1: no downtime


Phase 2 and 3: small downtime during phase 3 switch:


And done:


During Phase 3 downtime, I copied the new images folder.

I believe it wasn't really necessary as everything was working, but I did run the ORDS validate after the APEX install just to check it (while ORDS was still running):


And the proof of the max 5 minutes downtime:


I'm really impressed by the install and upgrade, it's basically an autonomous process these days 😀 

7 comments:

  1. using sysaux for apex is actually bad practice.

    ReplyDelete
  2. There are many discussions about the usage of SYSAUX or not.
    e.g. https://community.oracle.com/tech/developers/discussion/4184427/usage-of-sysaux-tablespace-for-apex

    I believe you need to decide for yourself if in your case it makes sense to have a dedicated APEX tablespace or not.

    ReplyDelete
  3. Hi Dimitri,

    We run Apex version 5.0.4.00.12 with EPG. Should I install ORDS 21.1.1 first and then do the Apex 21.1 upgrade?

    Thanks,
    Leo

    ReplyDelete
  4. Hi Leo,

    It doesn't really matter which you do first.
    Typically I would install APEX first, then ORDS.

    Dimitri

    ReplyDelete
  5. Hi Dimitri,

    I really enjoyed the new Apex 21.1 features. Is the release date for the oracle cloud environment available anywhere?

    Thanks,
    Robert

    ReplyDelete
  6. can i directly install latest release on existing old instance or i need to uninstall old apex instance then install new instance.

    Regards,

    ReplyDelete
  7. You can directly install the new version, no need to uninstall.

    ReplyDelete