Hi,
We are trying to migrate an Oracle 8.1.7 database to an Oracle 9i(9.2) database. I moved all the database files to the appr folder and I created a new instance using:
oradim -new -sid PROD -intpwd Oracle -startmode a -pfile C:\oracle\OraDb\Neuropace\initPROD.ORA.
I checked the alter log file and I get the following error:
ORA-10827: database must be opened with MIGRATE option.
When I create the instance.

How should one go about restoring a database (different versions). I went ahead with the migration. I opened the database using
alter database open resetlogs migrate.
But when i log into the database, I get an internal code error.
Any pointers would be appreciated?.
Regards,
Sachin.