Skip to Content
0
Former Member
Jun 28, 2011 at 01:09 PM

DBUA.sh database not open during 11g upgrade from 10.2.0.4

277 Views

Hi,

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 11.2.0.2 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 10.2.0.4 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 10.2.0.4 to 11.2.0.2?

Regards

Richie Lovell

SAP Basis