Previous Next JavaScript must be enabled to correctly display this content

## 4 Upgrading from a Previous APEX Release

Upgrading creates new database objects in a new schema and migrates the application metadata to the new release.

Note:

Direct upgrades are only supported for Oracle APEX release 18.1 or later. If your current release is older than APEX 18.1, first upgrade to APEX 24.2, then upgrade to APEX 26.1. Alternatively, you can manually export your workspaces and applications from the current instance and import them into a newly installed APEX 26.1 instance.

If you have APEX release 24.2 or earlier, following any of the installation scenarios in this guide upgrades your APEX instance to the current release, creates APEX 26.1 database objects in a new schema, and migrates the application metadata to the new release.

- About Release Numbering Conventions
  New releases of Oracle APEX correlate to the calendar year.
- Sample Upgrade Scenarios
  Review common upgrade scenarios including upgrading from a prior release and upgrading when an Oracle Database release includes Oracle APEX.
- Viewing the APEX Release Number
  View your Oracle APEX release number on the Workspace home page or on the About APEX page.
- Viewing the Oracle REST Data Services Release Number
  View the Oracle REST Data Services release number on the About Oracle APEX page.
- About Installing an APEX Release Included with the Oracle Database
  Learn about which Oracle AI Database releases include Oracle APEX and the importance of updating to the lastest APEX release.
- About Upgrading Existing Applications
  Installing a new release of Oracle APEX, updates existing applications to the latest release, but does not alter application user interface or application components.
- About Testing Requirements
  Determining the appropriate amount of regression testing when upgrading Oracle APEX depends upon the complexity, size, and number of applications you are upgrading.
- About Cleaning Up Your Environment
  Following the successful upgrade of all of the environments to the latest release of Oracle APEX, you should clean up the environments.
- About Reverting to a Previous Release
  You can revert to a previous release of Oracle APEX.
- Viewing Install and Upgrade Logs
  View a log of installation or upgrade phases and their corresponding metrics.

See Also:

- Understanding the Installation Process
- Maximizing Uptime During an APEX Upgrade
- Control Oracle APEX Upgrades in Using Oracle Autonomous Database Serverless

### 4.1 About Release Numbering Conventions

New releases of Oracle APEX correlate to the calendar year.

In 2018 and starting with release 18.1 and 18.2, APEX introduced correlating the release number to the calendar year.

In addition, APEX now only offers full releases and no longer provides patch set releases (such as 5.1.1). Eliminating patch set releases reduces downtime when updating existing installations. APEX architecture also enables developers to revert releases if necessary.

Patch set exceptions (PSEs) may still be delivered for major defects. To learn more about PSEs, visit the Oracle APEX 26.1 Known Issues page or the Prior Release Archives for earlier releases.

Parent topic: Upgrading from a Previous APEX Release

### 4.2 Sample Upgrade Scenarios

Review common upgrade scenarios including upgrading from a prior release and upgrading when an Oracle Database release includes Oracle APEX.

Table 4-1 lists common upgrade scenarios.

Table 4-1 Sample Upgrade Scenarios

Upgrade Scenarios | Action
--- | ---
Upgrade from a prior Oracle APEX release. | Download the most recent ZIP file from the Oracle APEX download page and run a script to upgrade to the latest release. For details, see Installing APEX.
You install an Oracle Database which includes Oracle APEX. | Download the most recent ZIP file from the Oracle APEX download page and run a script to upgrade to the latest release. For details, see Installing APEX.

Caution:

When upgrading from APEX 18.1 to APEX 24.2, upgrade to APEX 24.1 first, and then to APEX 24.2. For more information, review Oracle APEX 24.2 Known Issues.

Related Topics

- Downloading and Installing Oracle APEX
- Oracle APEX Release Notes

Parent topic: Upgrading from a Previous APEX Release

### 4.3 Viewing the APEX Release Number

View your Oracle APEX release number on the Workspace home page or on the About APEX page.

You can view the APEX release number on the Workspace home page or on the About APEX page:

- Workspace home page:

  - Sign in to APEX.

    On the Workspace home page, the current release number displays in the bottom right corner.

- About APEX page:

  - Sign in to APEX.

  - Click the Help menu in the upper right and select About.

    On the About APEX page, the release number appears next to Product Build.

Parent topic: Upgrading from a Previous APEX Release

### 4.4 Viewing the Oracle REST Data Services Release Number

View the Oracle REST Data Services release number on the About Oracle APEX page.

Oracle APEX requires access to the web server, Oracle REST Data Services (ORDS) 23.3 or later.

To view the Oracle REST Data Services release number:

1. Sign in to Oracle APEX.
2. Click the Help menu in the upper right and select About.
3. Under the CGI Environment section, find `APEX_LISTENER_VERSION`.

Parent topic: Upgrading from a Previous APEX Release

### 4.5 About Installing an APEX Release Included with the Oracle Database

Learn about which Oracle AI Database releases include Oracle APEX and the importance of updating to the lastest APEX release.

APEX is included with the following Oracle AI Database releases:

- Oracle Database 19c - Oracle Application Express release 18.1.
- Oracle Database 18c - Oracle Application Express release 5.1.
- Oracle Database 12c Release 2 (12.2)- Oracle Application Express release 5.0.
- Oracle Database 12c Release 1 (12.1) - Oracle Application Express release 4.2.
- Oracle Database 11g Release 2 (11.2) - Oracle Application Express release 3.2.
- Oracle Database 11g Release 1 (11.1) - Oracle Application Express release 3.0.

Since Oracle AI Database releases less frequently than APEX, Oracle recommends updating to the latest APEX release available. To learn more, see Downloading and Installing Oracle APEX.

Note:

If upgrading APEX from a release that ships with the database, do not alter any APEX files in the Oracle home directory (for example, `/u01/app/oracle/product/18.0.0/dbhome_1/apex`) .

Parent topic: Upgrading from a Previous APEX Release

### 4.6 About Upgrading Existing Applications

Installing a new release of Oracle APEX, updates existing applications to the latest release, but does not alter application user interface or application components.

Once you upgrade an Oracle APEX instance from a previous release, existing applications will work without modification. However, to keep applications maintainable, up-to-date, and to leverage new functionality, developers should perform the steps outlined in Upgrading APEX Applications in Oracle APEX App Builder User’s Guide.

Parent topic: Upgrading from a Previous APEX Release

### 4.7 About Testing Requirements

Determining the appropriate amount of regression testing when upgrading Oracle APEX depends upon the complexity, size, and number of applications you are upgrading.

You should include the majority of complex pages, particularly those that incorporate significant JavaScript or extensive PL/SQL computations or processes. Developers should ensure pages which they manually update based on the Upgrade Application or Advisor are also included in regression tests. Not all remaining pages have to be included in regression testing. Oracle recommends you include a good representation of different page types includes reports, charts, and forms. An application should always be included in regression testing if its compatibility mode was modified post-upgrade.

While regression testing of upgraded applications is imperative to minimize risk of disrupting the end users, it is important that testing is not drawn out for an extended period. As a general rule:

- Step 1: Upgrade your development environment first. Allow developers to review the applications and make initial updates as needed.

- Step 2: Upgrade your QA/Test environment.

- Step 3: Upgrade applications from development are built into this environment.

- Step 4: Upgrade your production environment.

- Step 5: Build upgraded applications into this environment.

Parent topic: Upgrading from a Previous APEX Release

### 4.8 About Cleaning Up Your Environment

Following the successful upgrade of all of the environments to the latest release of Oracle APEX, you should clean up the environments.

Once you start developing with the newer release, the Oracle APEX schema associated with the prior release can be deleted. If you installed the prior release into a separate tablespace, you can simply drop the specific tablespace. Oracle recommends leaving the older Oracle APEX schema(s) for a few weeks and then remove them from the development, test, and production environments. This cleanup process releases disk space and ensures that no one accesses an outdated schema using tools such as SQL Developer or SQLcl.

Parent topic: Upgrading from a Previous APEX Release

### 4.9 About Reverting to a Previous Release

You can revert to a previous release of Oracle APEX.

Because Oracle APEX creates a new schema for each major release, reverting back to a prior release is a relatively simple process. If you revert to a prior release, any modifications made in the current Oracle APEX instance are lost. The main task is to switch the public synonyms and grants to point at the previous schema instead of the new schema.

See Also:

Reverting to a Previous Release After a Failed Upgrade Installation

Parent topic: Upgrading from a Previous APEX Release

### 4.10 Viewing Install and Upgrade Logs

View a log of installation or upgrade phases and their corresponding metrics.

To view Install and Upgrade Logs:

1. Sign in to Administration Services.
2. Click Manage Instance.
3. Under Manage Logs and Files, click Install / Upgrade Logs.
   The Install / Upgrade Logs page appears displaying a report.
4. To view log details, click the View icon in the Details column.

   The Details report displays all actions and potential errors listed during a certain installation or upgrade phase.

Parent topic: Upgrading from a Previous APEX Release