My Oracle Support Banner

autoUpgrade Fails With UPG-1400#UPGRADE FAILED (Doc ID 2593418.1)

Last updated on OCTOBER 20, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle 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:

upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------+------------+
|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 :

2019-09-03 15:12:31.654 INFO DbUpgrade returned error AutoUpgException [UPG-1400#UPGRADE FAILED [orcl]] - ExecuteDbUpgrade.executeStage

upg_summary.log shows :

Datapatch
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 :

2021-02-15 11:12:05.158 ERROR Exception Error in Database Upgrade [ORCL] - DbUpgrade.upgradeStartUp
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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.