DB Upgrade from 19c to 21c fails with "SP2-0310: unable to open file <21c OH>/rdbms/admin/backport_files/bug_32003908_apply.sql"
(Doc ID 3056348.1)
Last updated on JANUARY 28, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 21.5 to 21.16 [Release 21.0]Microsoft Windows x64 (64-bit)
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
DB Upgrade from 19c to 21.14 / 15 fails with below error-
*** WARNING: ERRORS FOUND DURING UPGRADE ***
1. Evaluate the errors found in the upgrade logs
and determine the proper action.
2. Rerun the upgrade when the problem is resolved
REASON:
ERRORS FOUND: During Upgrade
FILENAME: <ORACLE_BASE>\cfgtoollogs\dbua\upgrade2024-10-23_11-22-16AM\<SID>\catupgrdcdbroot2Rcdbroot0.log AT LINE NUMBER: 622033
------------------------------------------------------
Identifier CATALOG 24-10-23 12:58:07
SCRIPT = [<21c OH>\rdbms\admin\rdbms_preapply.sql]
ERROR = [SP2-0310: unable to open file "<21c OH>/rdbms/admin/backport_files/bug_32003908_apply.sql"]
STATEMENT = [alter session set "_ORACLE_SCRIPT" = false;]
------------------------------------------------------
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 |