Re: Moving and upgrading DB at the same time
Date: Mon, 28 Apr 2008 12:27:08 -0700 (PDT)
On Apr 27, 3:35 pm, Rick Denoire <100.17..._at_germanynet.de> wrote:
> In order to upgrade a 9i DB (Oracle 126.96.36.199 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
> 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
> Thanks in advance
> Rick Denoire
See metalink Note:62290.1
exp/imp is adequate for me, but YMMV.
-- @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