Re: Moving and upgrading DB at the same time

From: joel garry <joel-garry_at_home.com>
Date: Mon, 28 Apr 2008 12:27:08 -0700 (PDT)
Message-ID: <4cad7888-0b93-4f9e-bc18-737bdb590460@w5g2000prd.googlegroups.com>


On Apr 27, 3:35 pm, Rick Denoire <100.17..._at_germanynet.de> wrote:
> In order to upgrade a 9i DB (Oracle 9.2.0.5 on Redhat Linux Adv.
> Server 2.1 32 bit) to version 10g (Oracle 10.2.0.3 on Redhat Linux
> Ent. Ed. V 4 64 bit) I will move all files of the shut down DB to a
> new server where the target version of Oracle is istalled and take
> care that datafile paths on the new server are the same as on the old
> one (no need to rename anything in the controlfile of the cold copy).
>
> Since on the new server only the new Version of Oracle is installed,
> the only thing I can do is just upgrade the DB copy without being able
> to open it in order to check that everything is all right.
>
> May I assume that there won't be any platform related issues?
> I just don't know if this switch is considered a platform change.
> After all, both Linux boxes are rather different versions of Redhat
> (running on Intel hardware).
>
> Even if there is no platform issue, which are going to be the pits and
> falls?
>
> I would like to avoid exp/imp because for a schemawise transfer I
> would need to precreate users with all privileges, tablespaces, etc.
> Full exp/imp is not adequate when going to a different version of
> Oracle.
>
> Thanks in advance
>
> Rick Denoire

See metalink Note:62290.1

exp/imp is adequate for me, but YMMV.

jg

--
@home.com is bogus.
“I thought that was a dumb thing to say.  My brain couldn't register
that it was real.” Diana Noble of San Marcos was swimming 10 to 20
feet behind David Martin when she heard someone yell, “Shark!”   They
were part of a group of triathletes training, when a Great White bit
through both Martin's legs, leaving a massive pool of blood.  First
person to die from a shark attack in the area for 50 years.
Received on Mon Apr 28 2008 - 14:27:08 CDT

Original text of this message