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>
Date: Thu, 30 Oct 2008 14:15:21 -0700
Message-ID: <f8e425c00810301415u6b7239f3g632a4a1b3cc05c4e@mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 30 2008 - 16:15:21 CDT