autoUpgrade Fails With UPG-1400#UPGRADE FAILED
(Doc ID 2593418.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle Database - Standard Edition - Version 19.12.0.0.0 to 19.12.0.0.0 [Release 19]
Information in this document applies to any platform.
Symptoms
Database upgrade using autoupgrade fails with error:UPG-1400#UPGRADE FAILED
Symptom 1:
+----+-------+---------+---------+-------+--------------+--------+--------+------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME|END_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------+------------+
| 103| orcl|DBUPGRADE|EXECUTING|RUNNING|19/09/02 15:17| N/A|15:09:41|91%Upgraded |
+----+-------+---------+---------+-------+--------------+--------+----
autoupgrade_<timestamp>.log shows :
upg_summary.log shows :
Error: prereq checks failed!
$ORACLE_BASE/cfgtoollogs/sqlpatch/sqlpatch_<timestamp>/sqlpatch_invocation.log
Connecting to database...OK
Gathering database info...done
Bootstrapping registry and package to current versions...done
Error: prereq checks failed!
verify_queryable_inventory returned ORA-06502: PL/SQL: numeric or value error: string buffer too small
Prereq check failed, exiting without installing any patches.
Symptom 2:
autoupgrade_<timestamp>.log shows :
oracle.upgrade.autoupgrade.utils.errors.AutoUpgException: AutoUpgException [UPG-1400#UPGRADE FAILED [orcl]]
autoupgrade_err.log shows:
2021-02-15 11:11:55.360 ERROR
DATABASE NAME: orcl
CAUSE: ERROR at Line 7 in [\temp\upg_logs_orcl\orcl\103\dbupgrade\catupgrd20210215113712orcl0.log]
REASON: SP2-0556: Invalid file name.
ACTION: [MANUAL]
DETAILS: - CheckForErrors.checkForErrors
2021-02-15 13:11:58.767 ERROR
DATABASE NAME: orcl
CAUSE: ERROR at Line 771093 in [\temp\upg_logs_orcl\orcl\103\dbupgrade\catupgrd20210215113712orcl0.log]
REASON: SP2-0310: unable to open file "LOGIN.SQL"
ACTION: [MANUAL]
DETAILS: - CheckForErrors.checkForErrors
2021-02-15 13:12:00.752 ERROR Database Upgrade Error in File [C:\temp\upg_logs_orcl\orcl\108\dbupgrade\catupgrd20210215123712orcl3.log] on Database
2021-02-15 13:12:00.767 ERROR Exception Error in Database Upgrade [UPG-1400#UPGRADE FAILED [orcl]] - CallUpgrade.doUpgrade
2021-02-15 13:12:05.158 ERROR UPGRADE FAILED [orcl] - DbUpgrade.upgradeDriver
2021-02-15 13:12:05.158 ERROR Exception Error in Database Upgrade [orcl] - DbUpgrade.upgradeStartUp
oracle.upgrade.autoupgrade.utils.errors.AutoUpgException: AutoUpgException [UPG-1400#UPGRADE FAILED [orcl]]
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 |
| Symptom 1: |
| Symptom 2: |
| Cause |
| Cause 1: |
| Cause 2: |
| Solution |
| Solution 1: |
| Solution 2: |
| References |