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

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Fri, 31 Oct 2008 09:34:45 -0400
Message-ID: <55264C4C0484A547B34C0B1A28E219EA1952D15C81@ENHBGMBX01.PA.LCL>

You need to follow the steps at <BLOCKED::http://download.oracle.com/docs/cd/B19306_01/win.102/b15688/create.htm#CHDGCBFJ> 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
<mailto: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<mailto: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<mailto: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 Received on Fri Oct 31 2008 - 08:34:45 CDT