X

The Oracle APEX blog is your source for APEX news, technical tips and strategic direction

  • June 9, 2020

Control when APEX is upgraded on your Oracle Autonomous Database

Joel Kallman
Senior Director, Software Development

Oracle Application Express - APEX was launched on Oracle Autonomous Database in Oracle Cloud in 2019, and it's been a smashing success.  The combination of low-code application development with a fully-managed and autonomous database cloud service has already proven to be a successful platform for customers to deliver enterprise applications at greater speed and lower cost.

Major version upgrades of Oracle APEX on Oracle Autonomous Database are accomplished via an internal patch delivery system, specifically built for Autonomous Database.  As there are a large number of Oracle Cloud Data Center Regions around the globe, patching of the Oracle Autonomous Database doesn't happen at the same time for everyone.  When Oracle APEX 19.2 was made available on Autonomous Database, the specific time of day that this upgrade occurred was fairly unpredictable.  Customers were made aware of the week that their region was to be upgraded, but they certainly didn't know if the upgrade was going to happen at 0800 on a Saturday or 1400 on a Tuesday afternoon.  A number of customers and partners had correctly complained about this.  Not only did they want to control when the Oracle APEX upgrade happened, but they also wanted the ability to test their production APEX applications before the actual APEX upgrade occurred.  You spoke, and we listened.

Beginning with the forthcoming APEX 20.1 upgrade and for all future APEX upgrades on Oracle Autonomous Database, you can now control if the APEX upgrade is performed immediately when available, or defer the upgrade for up to 45 days.  This enables you to:

  • Precisely control when APEX is upgraded on your Autonomous Database.  While there should be minimal disruption on a live system, you can still choose to upgrade at 0500 on a weekend, if you wish.
  • Validate your applications against the new version of APEX.  This is as simple as cloning your production or testing environment, enabling the APEX upgrade on the clone, and testing.  It's that easy.

 

To defer the upgrade of APEX on your Autonomous Database, perform the following steps:

  1. Access Oracle Application Express Administration Services (fully documented here).
  2. Click the gear icon in the Available Updates section on the right.
  3. Set Defer Upgrade to Yes.
  4. Click Apply Changes.

That's all there is to it!

 

You can choose to change your upgrade preference at any time prior to the APEX updates being made available in your region.  All customers will be notified via email a number of weeks in advance when the APEX upgrade is planned.  If there is a pending APEX upgrade for your service, the Available Updates region in Oracle Application Express Administration Services will show that there is an available update, and if you do nothing, your service will be upgraded automatically on a specific date.

 

If you wish to perform the APEX upgrade on-demand, access Oracle Application Express Administration Services, click the gear icon in the Available Updates section on the right, and click the Upgrade Now button.

 

Frequently Asked Questions

 

What happens if I do nothing?

The default setting is apply the APEX upgrade immediately, and APEX on your Autonomous Database will be upgraded when the patches are deployed in your region data center.

What happens if I elect to defer the APEX upgrade and 45 days pass?

APEX on your Autonomous Database will be upgraded automatically.

How will I know when an APEX upgrade is available?

Customers will be notified in advance via email when an APEX upgrade is near.  A precise date and time cannot be provided, but a general timeframe will be communicated.  When an APEX upgrade is made available for your service and you have elected to defer APEX upgrades, the "Available Updates" region in Oracle Application Express Administration Services will show that this version is available, as well as the date when APEX will be automatically upgraded if you do nothing.

How do I test the APEX upgrade against my production Autonomous Database?

  • Clone your Autonomous Database
  • Access Available Updates from Oracle Application Express Administration Services for your clone
  • Click the Upgrade Now button
  • Wait for the APEX upgrade to complete and then test.

How do I precisely control when the APEX upgrade occurs?

  • Ensure that the preference to Defer Upgrade of APEX is set to Yes.
  • Access Available Updates from Oracle Application Express Administration Services for your clone
  • Click the Upgrade Now button

Can the upgrade of APEX be scheduled at a time of my choosing?

It can be performed at a time of your choosing, but it can't be scheduled at a specific date and time.  You will need to access Oracle Application Express Administration Services and click the Upgrade Now button.

Is this available for both Autonomous Data Warehouse and Autonomous Transaction Processing?

Yes, this is available for both services.

Is this available for Autonomous Database on the Oracle Cloud Free Tier?

Yes, this is available on the Oracle Cloud Free Tier.