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

Last updated on FEBRUARY 07, 2017

Applies to:

Oracle Application Express (formerly HTML DB) - Version 4.0.0.00 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.
***Checked for relevance on 10-Jan-2014***

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms