My Oracle Support Banner

How to Prevent a Lower Version of APEX From Being Installed When the Database is Upgraded (Doc ID 1286029.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Application Express (APEX) - Version 4.0.0.00 and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Applies to any APEX 4.0.X version installed in 10.2.0.3, 10.2.0.4 or 10.2.0.5 DB.

Goal

Every version of the database comes with a specific version of APEX:

10.2.0 - Includes APEX 1.6
11.2 - Includes APEX 3.2.1
12.1 - Includes APEX 4.2.x

The example below discusses upgrading from 10.2 to 11.2, but the concepts apply to any database upgrade where the the version of APEX in the database to be upgraded is greater than the default APEX version in the database.
For example, if the existing 11.2 database has APEX 5.0 installed and you are upgrading to 12.1.0.2 where 4.2.3 is the default APEX version in the 12.1.0.2 database.
___________________

 

Since the installation of the 11.2 DB installs APEX 3.2.1 by default, the goal is to upgrade a 10.2.0.3 (or 10.2.0.4 or 10.2.0.5) DB that contains APEX 4.0 to 11.2 and avoid the installation of APEX 3.2.1.

Note that when the Oracle Database 11.2 Pre-Upgrade Information Tool is run against the 10.2 DB the following is shown which indicates APEX 4.0 will be upgraded or a new version of APEX will be installed ->


**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Real Application Clusters [upgrade] INVALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> Oracle Application Express [upgrade] VALID

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.