Database Upgrade Fails with Error :”database is not open on the default instance”
Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at /u01/app/oracle/product/220.127.116.11/rdbms/admin/catctl.pl line 7822.
at /u01/app/oracle/product/18.104.22.168/rdbms/admin/catctl.pl line 7822.
OS authentication was not there for sys user
catctl.pl will use sys user which should have OS authentication
Explicitly provide the sys user in upgrade command as below :
You need to be in $ORACLE_HOME/rdbms/admin directory to run the catctl.pl :
$ cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl catctl.pl -u SYS -n 6 -l $ORACLE_HOME/diagnostics catupgrd.sql