9i 32-bit to 10g 64-bit upgrade on a seperate server
Date: Thu, 30 Oct 2008 14:15:21 -0700
I took a cold backup of 9i datafiles and copied them to the new 10g 64-bit
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
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?