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 23, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 21.5 to 21.16 [Release 21.0]Microsoft Windows x64 (64-bit)
Symptoms
DBUA is officially desupported in Oracle 23ai release.
AutoUpgrade is the official and supported method for upgrading Oracle databases in the 19c and 23c releases.
AutoUpgrade is the recommended tool for database upgrades starting from Oracle 19c.
AutoUpgrade is the ONLY supported tool for database upgrades in Oracle 23ai.
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 and Oracle 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 |