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/ line 7822.
at /u01/app/oracle/product/ line 7822.


OS authentication was not there for sys user will use sys user which should have OS authentication


Explicitly  provide  the sys user in upgrade command as below :

For 12.1.x
You need to be in $ORACLE_HOME/rdbms/admin directory to run the :
$ cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl -u SYS -n 6 -l $ORACLE_HOME/diagnostics catupgrd.sql

  • September 23, 2018 | 25 views
  • Comments