Re: move 9i r2 database on host 1 to 10g r1 on another host

From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Tue, 11 Aug 2009 12:00:16 -0400
Message-ID: <7d81ec570908110900v75e0a4bflc3dbb9adc6219942_at_mail.gmail.com>

Hi Martin,
I read through the link that you provided. Personally, i woud prefer DBUA to do the upgrade. To my understanding, DBUA requires the database to up. In my case, there are no 9i binaries on Host 2. Host 1 is completely 9i and Host 2 is completely 10gr1. So I cannot bring the 9i database up on 10gr1. In this scenario, I believe the options I have are: 1) to install 10gr1 software on Host 1 and do the upgrade with DBUA and then copy all the datafiles to Host2 later and startup the database. 2) Create a database on host 2 and use export/import from host1 (9i). Whats your say?

On Mon, Aug 10, 2009 at 12:53 PM, Martin Berger <martin.a.berger_at_gmail.com>wrote:

> Hi Sundar,
>
> you are correct. shutdown the DB, copy all datafiles, controlfiles,
> redologs to the same path in the new environment.
> don't forget the spfile/init.ora
>
> I found a quite good walkthrough which should help you to perform the
> upgrade:
>
> http://www.oracle-base.com/articles/10g/UpgradingTo10g.php
>
> I hope this helps.
>
> best regards,
> Martin
>
>
> On Mon, Aug 10, 2009 at 17:47, sundar
> mahadevan<sundarmahadevan82_at_gmail.com> wrote:
> >
> > Both of them have the same OS. These are test machines. Host 1 is 933 Mhz
> > intel processor and Host 2 is 1.83 Ghz Intel T2400. Please find below cat
> > /proc/cpuinfo from both hosts. Both of them belong to the same CPU family
> :
> > 6
> >
> > You said" In this case you just can copy the database and upgrade
>
>
>
> --
> Martin Berger martin.a.berger_at_gmail.com
> Lederergasse 27/2/14 +43 660 660 83306
> 1080 Wien http://berx.at/
>

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

Received on Tue Aug 11 2009 - 11:00:16 CDT