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

From: Ashwin <ashdbablog@xxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 30 Oct 2008 14:15:21 -0700

Hi,

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?

Regards,
Ashwin

Follow-Ups:

Elapsed time of active running query
From: Michael Schmitt

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

Other related posts: