Re: 32 to 64 and version upgrade

That script is useful. Look for something under the $ORACLE_HOME/rdbms/admin called utlu101*.sql where the 101 is whichever version number you are going to... THere's on for a utility upgrade information tool and a upgrade status tool in my directory currently. Lyall

-----Original Message-----

From: Thomas Roach <troach_at_gmail.com> To: john40855_at_gmail.com
Cc: oracle-l_at_freelists.org
Sent: Sun, Dec 20, 2009 4:15 pm
Subject: Re: 32 to 64 and version upgrade

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 Mon Dec 21 2009 - 10:01:49 CST