Database Upgrade Fails with Error :”database is not open on the default instance”


Error:
Unexpected error encountered in catctlMain; Error Stack Below; exiting
Died at /u01/app/oracle/product/12.2.0.1/rdbms/admin/catctl.pl line 7822.
at /u01/app/oracle/product/12.2.0.1/rdbms/admin/catctl.pl line 7822.

Cause

OS authentication was not there for sys user

catctl.pl will use sys user which should have OS authentication

Solution

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 catctl.pl :
$ cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl catctl.pl -u SYS -n 6 -l $ORACLE_HOME/diagnostics catupgrd.sql

  • September 23, 2018 | 25 views
  • Comments