Skip to Content
Former Member
Jun 28, 2011 at 01:09 PM database not open during 11g upgrade from



My server was rebooted during my 11g upgrade just as the post upgrade scripts were beginning to run. I re-ran the upgrade dbua script again and this time is stopped due to not enough processes being available. It seems to have installed the database because I can connect to it, start it up, shut it down, select data etc.

I changed the number of processes from 150 to 300 in the initsid.ora file, started the database up and created a new spfile from pfile. Shut this down again to start the upgrade process.

Now when I try to run the dbua script it complains that it cannot open the old database in order for the upgrade to begin again.Keep getting an error ;

ORA-01092: ORACLE instance terminated. Disconnection forced

What do I have to do to complete the upgrade from to


Richie Lovell

SAP Basis