Issues Upgrading to Database 11.1.0.6 or 11.1.0.7.x When Database Contains Application Express Prior to Upgrade
(Doc ID 761769.1)
Last updated on FEBRUARY 09, 2023
Applies to:
Oracle Database Exadata Cloud Machine - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Application Express (APEX) - Version 2.2 and later
Information in this document applies to any platform.
Symptoms
** Please read this article fully before proceeding with the steps **
It has become apparent of some upgrade issues with Application Express when a database is upgraded to 11.1.0.6 or 11.1.0.7, and the database being upgraded also contains Application Express.
Scenario 1: Database Contains Application Express 3.0.0.00.20 and is Upgraded to 11.1.0.7.x
In this scenario, the database upgrade process incorrectly tries to apply a patch to Application Express. At the end of the database upgrade Application Express will be invalid.
Scenario 2: Database contains Application Express 3.1 or later and also contains a FLOWS_ schema from Application Express 2.2 or earlier (but does not contain the FLOWS_030000 schema), and then is upgraded to database 11.1.0.6 or 11.1.0.7.x
In this scenario, during the database upgrade to 11.1.0.6 or 11.1.0.7.x, Application Express is downgraded from 3.1 or later to 3.0.1.00.08 or 3.0.1.00.12.
Cause
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
Symptoms |
Cause |
Solution |
References |