Re: 32 to 64 and version upgrade

From: John Smith <>
Date: Mon, 21 Dec 2009 09:55:03 -0600
Message-ID: <>

No, no IOT's. But another question (from my boss, wants to reduce downtime). Would it be possible to do this:

Run an rman hot backup, copy files over, set compatible to in my installation, restore and recover, ship last set of archive logs and recover, then shutdown, startup upgrade, and run catupgrd? Do I need to/would it be possible to do an alter database open resetlogs before I bring it up in upgrade mode?

On Mon, Dec 21, 2009 at 8:45 AM, Martin Bach <>wrote:

> Hi John!
> John Smith wrote:
>> Hello. I am looking at upgrading from linux 32 to linux 64 bit, and to
>> upgrade from at the same time.
>> [avoid overquoting]
>> Am I missing anything? the way I read the doc, the conversion to 64 bit
>> will happen during the catupgrade script. Do I also need to run utlirp.sql?
>> Am I missing anything?
> Metalink note 62290.1 states: "2) Normally an upgrade to a newer release
> will automatically take care of a word size change from 32-bit to 64-bit.
> However, upgrading 10gR1 to 10gR2 is an exception."
> So I'd assume that the catalog upgrade takes care of this. Further down:
> "If you are installing 64-bit Oracle Database 10g software but were
> previously using a 32-bit Oracle Database installation, then the databases
> will automatically be converted to 64-bit during the upgrade to Oracle
> Database 10g except when upgrading from Release 1 (10.1) to Release 2
> (10.2)"
> I also found 341880.1 to be promising, but haven't read it. But there is
> nothing like testing, testing and testing the procedure all over again until
> you ironed out all the quirks. Are you using IOTs at all?
> Hope this helps,
> Martin
> --
> Martin Bach
> OCM 10g

Received on Mon Dec 21 2009 - 09:55:03 CST

Original text of this message