Control Oracle Application Express Upgrades

By default, Autonomous Database applies Oracle Application Express upgrades as soon as they are released in your region. You can set an option to defer upgrades for major Oracle Application Express releases, such as an upgrade from 20.1 to 20.2, for up to 45 days.

Note:

The latest Oracle Application Express Patch Set Bundles are automatically applied on Autonomous Database and cannot be deferred.

Defer Oracle Application Express Upgrades

Deferring Oracle Application Express upgrades allows you to do the following:

  • Control when Oracle Application Express is upgraded on your Autonomous Database. While there should be minimal disruption on a live system, you can still choose to upgrade at a time or on a day with less activity, for example on a weekend day.

  • Validate your applications against the new version of Oracle Application Express before you upgrade your production system.

    To validate and test before you upgrade your production system, do the following:

To defer Oracle Application Express upgrades, do the following:

  1. Open Oracle Application Express Administration Services.
  2. Open the Available Updates dialog by clicking the gear icon next to Available Updates.

    This shows the Available Updates dialog.

  3. In the Available Updates dialog select the Defer Upgrade option, Yes.
  4. Click Apply Changes.

Notes for deferred Oracle Application Express upgrades:

  • If the Defer Upgrade setting is Yes and updates are available, then on the date indicated in the Available Updates dialog, Oracle Application Express updates are automatically applied to your Autonomous Database instance. You cannot postpone the updates beyond the listed date.

  • If the Defer Upgrade setting is Yes and updates are available, you cannot schedule the Oracle Application Express upgrades for a specific date and time. When you are ready to upgrade, access Oracle Application Express Administration Services and click Upgrade Now. See Apply Oracle Application Express Upgrades for details.

  • If your Autonomous Database is stopped at the time when the new Oracle Application Express release becomes available in your region, the update is automatically applied the next time you start your database, regardless of the Defer Upgrade setting.

  • When you change the Defer Upgrade setting, the change applies to future upgrades and does not impact an Oracle Application Express upgrade that is already available to your Autonomous Database.

Apply Oracle Application Express Upgrades

When you have deferred upgrades and an upgrade is available, you have the option to apply the upgrade at any time before the specified upgrade date.

When Oracle Application Express upgrades are not available the Available Updates area shows System is up-to-date.

When the Defer Upgrade setting is Yes, if an Oracle Application Express upgrade is available and you take no action, the upgrade is applied automatically on the date specified in the Available Updates area.

Description of adb_apex_updates_deferred.png follows
Description of the illustration adb_apex_updates_deferred.png

If you previously deferred upgrades as specified in Defer Oracle Application Express Upgrades, then you can upgrade at any time, as follows:

  1. Open Oracle Application Express Administration Services.
  2. Open the Available Updates dialog by clicking the gear icon next to Available Updates.
  3. On the Available Updates dialog click Upgrade Now.

This starts the Oracle Application Express upgrade process in the background. You can continue using Administration Services and App Builder as well as running apps during most of the upgrade process.