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

Thanks everyone.
I will keep you posted on this

Regards,
Ashwin

On Fri, Oct 31, 2008 at 6:34 AM, Freeman, Donald <dofreeman_at_state.pa.us>wrote:

> You need to follow the steps at
> http://download.oracle.com/docs/cd/B19306_01/win.102/b15688/create.htm#CHDGCBFJ
> under the section entitled 'Migrating an Oracle Database 10g Release 1
> (10.1) or Older Database'
>
> Donald Freeman
> Database Administrator II
> Commonwealth of Pennsylvania
> Department of Health
> Bureau of Information Technology
> 2150 Herr Street
> Harrisburg, PA 17103
> <dofreeman_at_state.pa.us>
>
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ashwin
> *Sent:* Thursday, October 30, 2008 5:30 PM
> *To:* Paul Drake
> *Cc:* ORACLE-L
> *Subject:* 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