Upgrading Oracle Application Express creates new database objects in a new schema and migrates the application metadata to the new release.
If you have release 1.5.x, 1.6.x, 2.0.x, 2.2.x, 3.0.x, 3.1.x, 3.2.x, 4.0x, 4.1x ,4.2.x or 5.0x of Oracle Application Express, following any of the installation scenarios in this guide upgrades your Oracle Application Express instance to release 5.1 and creates Oracle Application Express 5.1 database objects in a new schema and migrates the application metadata to the new release.
Common upgrade scenarios include upgrading from prior release, upgrading from a point release, and installing an Oracle Database release which include Oracle Application Express.
Both Patch sets and point releases are available for download from My Oracle Support. Table 1-2 lists common upgrade scenarios.
Table 1-2 Sample Upgrade Scenarios
Upgrade from a prior Oracle Application Express release
Download the latest files from the Downloads page.
Upgrade from a major Oracle Application Express to point release.
Download the point release from My Oracle Support.
You install Oracle Database which include Oracle Application Express.
Download the latest files from the Downloads page.
You can view the release version of Oracle Application Express on the workspace home page.
To determine which release of Oracle Application Express you are currently running:
The Workspace home page appears.
The current release version displays in bottom right corner.
Locate the Help menu at the top of the page.
From the Help menu, select About.
The About Application Express page appears.
You can view the version of Oracle REST Data Services on the About Application Express page.
If you are using Oracle REST Data Services as your web listener for Oracle Application Express, view the About Application Express page . The version of Oracle REST Data Services (ORDS) will be in the CGI Environment section, next to
APEX_LISTENER_VERSION does not appear, then your Oracle Application Express instance is not using ORDS as its web listener.
Learn about the Oracle Application Express release included with the Oracle Database release.
Oracle Application Express is included with the following Oracle Database releases:
Oracle Database 11g Release 1 (11.1) - Oracle Application Express Release 3.0.
Oracle Database 11g Release 1 (11.2) - Oracle Application Express Release 3.2.
Oracle Database 12c Release 1 (12.1) - Oracle Application Express Release 4.2.
Oracle Database 12c Release 2 (12.2)- Oracle Application Express Release 5.0.
The Oracle Database releases less frequently than Oracle Application Express. Therefore, Oracle recommends updating to the latest Oracle Application Express release available on Oracle Technology Network. To learn more, see the installation instructions for the appropriate Web Listener in your environment.
If upgrading Oracle Application Express from a release that ships from the database do not alter any Oracle Application Express files in the Oracle home directory (for example,
If you install a new release of Oracle Application Express, the installation process updates existing applications to the latest release.
The upgrade process is designed to not alter the application user interface or application components. As a result, application components that may impact the user interface are left untouched by the upgrade process. It is the developer's responsibility to manually review these components and update them, or leave them as is. Examples of components which may impact existing functionality include new features added to interactive reports, charts, certain validations, and so on.
Charts that use custom XML must be updated manually otherwise the custom XML will be lost.
"Running Advisor to Check Application Integrity" in Oracle Application Express App Builder User’s Guide
You can specify the compatibility mode in the application definition within each application.
Within each application, you can also specify the Compatibility Mode in the Application Definition. Changing the application Compatibility Mode changes certain runtime behaviors. Compatibility Mode options include Pre 4.1, 4.1, 4.2, and 5.0.
Determining the appropriate amount of regression testing when upgrading Oracle Application Express depends upon the complexity, size, and number of applications you are upgrading.
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.
Following the successful upgrade of all of the environments to the latest release of Oracle Application Express, you should clean-up the environments.
Once you start developing with the newer release, the Oracle Application Express 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 Application Express 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 SQL*Plus.
You can revert to a previous release of Oracle Application Express.
Because Oracle Application Express 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 Application Express 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.