Re: 32 to 64 and version upgrade

From: Thomas Roach <troach_at_gmail.com>
Date: Sun, 20 Dec 2009 16:15:59 -0500
Message-ID: <b86ffce60912201315l39742f16yeb15417e9a7e167f_at_mail.gmail.com>

Prior to running catupgrd, you will need to run utlirp. Then when you run the catupgrd, then shutdown, startup normal, utlrp.sql

Also look at the parameters in your spfile. Some will be deprecated. There is a script you can run after installing the 10g binaries to give you some guidelines. I don't know what it is off the top of my head, or you can run dbua.

Good Luck.

On Sun, Dec 20, 2009 at 3:59 PM, John Smith <john40855_at_gmail.com> wrote:

> Hello. I am looking at upgrading from linux 32 to linux 64 bit, and to
> upgrade from 9.2.0.8 10.2.0.4 at the same time.
>
> I think I can just install the new Oracle home on the new server, copy the
> datafiles, spfile, controlfiles, etc, from a cold backup, startup upgrade,
> and run the catupgrd script.
>
> 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?
>

-- 
Thomas Roach
813-404-6066
troach_at_gmail.com

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

Received on Sun Dec 20 2009 - 15:15:59 CST