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

  • From: Ashwin <ashdbablog@xxxxxxxxx>
  • To: "Paul Drake" <bdbafh@xxxxxxxxx>
  • Date: Thu, 30 Oct 2008 14:29:34 -0700

The source 9i is on RHEL 4 (32-bit) and target 10g is on RHEL 5 (64-bit)

Regards,
Ashwin



On Thu, Oct 30, 2008 at 2:27 PM, Paul Drake <bdbafh@xxxxxxxxx> wrote:

> please repost listing the operating system.
> Also, check the metalink doc on changing the database word size.
> you will need to run /rdbms/admin/utlirp.sql prior to upgrading the word
> size.
>
> hth.
>
> Pd
>
>
> On Thu, Oct 30, 2008 at 5:15 PM, Ashwin <ashdbablog@xxxxxxxxx> wrote:
>
>> 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.completestreets.org/faq.html
> http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf
>
>

Other related posts: