Re: Oracle Instance Failed to start

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 11 Jun 2002 19:26:15 +1000
Message-ID: <ae4fo1$dgo$1@lust.ihug.co.nz>

And did you read the *extensive* documentation on how to migrate a 9.0.1 database to a 9.2 one? They aren't the same database, you know. It takes a bit more work than obliterating all the old executables and hoping for the best.

Go back and read the migration advice from Oracle, and do what it says.

Regards
HJR "Seow Chuen Cain" <seowcc_at_magix.com.sg> wrote in message news:ae3jdf$qi7$1_at_clematis.singnet.com.sg...
> Hi all,
>
> After I installed Oracle 9i release 2 over release 1. My database instance
> cannot start
> (the database is created in 9i release 1). The alert log shows :
>
> Errors in file d:\oracle\admin\ccseow\udump\ccseow_ora_1444.trc:
> ORA-10827: database must be opened with MIGRATE option
>
> Error 10827 happened during db open, shutting down database
> USER: terminating instance due to error 10827
> Instance terminated by USER, pid = 1444
> ORA-1092 signalled during: ALTER DATABASE OPEN...
>
> I tried to put in migrate parameter in startup command but it was not
valid.
>
>
Received on Tue Jun 11 2002 - 04:26:15 CDT