preupgrade_fixups.sql failed with "ORA-04068: existing state of packages has been discarded" error while upgrading from 11.2.0.4 to 19c
(Doc ID 3048491.1)
Last updated on JANUARY 28, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
Announcement
DBUA is officially desupported in Oracle 23ai. This is reflected in the Oracle documentation and AutoUpgrade MOS Note 2485457.1 along with a warning message to alert customers who execute DBUA or manual upgrade methods. AutoUpgrade is the official and only supported method of upgrade.
Note: DBUA for "RAC on Windows" is supported only for the short term until this functionality is available in AutoUpgrade.
Further information on how to use this Tool is documented in Note 2485457.1, Oracle 19c documentation and Oracle 23ai documentation.
To get latest version of AutoUpgrade Tool refer Note 2485457.1
Reference : AutoUprade Blog
Database upgrade from 11.2.0.4 to 19c.
preupgrade.jar was executed successfully.
DBMS_PREUP package and package body created in valid state.
While running preupgrade_fixups.sql file, getting below error.
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 |