autoUpgrade Fails With UPG-1400#UPGRADE FAILED / SP2-0556: Invalid file name. (Doc ID 2593418.1)

Last updated on JULY 20, 2024

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:

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]]

Symptom 3 :

ERROR
DATABASE NAME: l8d1
CAUSE: ERROR at Line 97453 in [D:\...\< job id>\dbupgrade\catupgrd< Datetime>< Database>.log]
REASON: SP2-0556: Invalid file name.
ACTION: [MANUAL]
DETAILS:
2024-05-15 10:22:57.976 ERROR Database Error in File

catupgrd<timestamp>.log

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 15 09:31:54 2024
Version 19.23.0.0.0

SP2-0556: Invalid file name.
SQL> Connected.