RE: 9i 32-bit to 10g 64-bit upgrade on a seperate server
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: "'ashdbablog@xxxxxxxxx'" <ashdbablog@xxxxxxxxx>, Paul Drake <bdbafh@xxxxxxxxx>
- Date: Fri, 31 Oct 2008 09:34:45 -0400
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@xxxxxxxxxxx>
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxx<mailto: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<mailto: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:
