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

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_at_gmail.com> 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_at_gmail.com> 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
>
>

--
http://www.freelists.org/webpage/oracle-l