Autoupgrade fails with error unable to open file LOGIN.SQL

 Recently I faced one error while upgrading oracle database 11.2.0.4 to 19.3.0 using auto upgrade utility.

I checked the status of the job and found it was errored out.

So I quickly gone through the log files as mentioned in above and found few error messages like

2021-12-09 20:27:53.940 ERROR Database Upgrade Error in File [D:\oracle\autoupg19c\upg_logs\ORCL\orcl\101\dbupgrade\catupgrd20211209193550orcl6.log] on Database [D:\oracle\autoupg19c\upg_logs\ORCL\orcl\101\dbupgrade\catupgrd20211209193550orcl6.log] - CatctlThread.catctl

2021-12-09 20:27:54.202 ERROR

DATABASE NAME: orcl

         CAUSE: ERROR at Line 58498 in [D:\oracle\autoupg19c\upg_logs\ORCL\orcl\101\dbupgrade\catupgrd20211209193550orcl7.log]

        REASON: SP2-0310: unable to open file "LOGIN.SQL"

        ACTION: [MANUAL]

        DETAILS:   - CheckForErrors.checkForErrors

Solution:-

Perform the below solution:

1. Set SQLPATH (and ORACLE_PATH) variable to desired directory path.

2. Move login.sql to the directory defined in SQLPATH (and ORACLE_PATH)

NOTE: If you do not have a login.sql file, then perform any ONE of the following :

a. if you have a backup of the original installation, check there and see if you can retrieve the login.sql if it existed.

-or-

b. try obtaining it from another similar/like installation and modify if needed.

-or-

c. create one:

 

Reference:- SP2-0310: Unable To Open File "LOGIN.SQL"(Doc ID 2277751.1)