9i 32-bit to 10g 64-bit upgrade on a seperate server

From: Ashwin <ashdbablog_at_gmail.com>
Date: Thu, 30 Oct 2008 14:15:21 -0700
Message-ID: <f8e425c00810301415u6b7239f3g632a4a1b3cc05c4e@mail.gmail.com>


I took a cold backup of 9i datafiles and copied them to the new 10g 64-bit server
I installed the 10g 64-bit Oracle Home

On the new 10g server,

I recreated the controlfile to point to the new location of the datafiles and ran
SQL> startup upgrade

It failed saying that database should be open in resetlogs or no resetlogs mode

I shutdown the db and did a startup mount and SQL>alter database open resetlogs;

This time it failed saying that database should be opened in upgrade option.

I am unable to proceed with the upgrade. Anyone ever faced this issue?


Received on Thu Oct 30 2008 - 16:15:21 CDT

Original text of this message