Re: 32 to 64 and version upgrade

  • From: lyallbarbour@xxxxxxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 21 Dec 2009 11:08:28 -0500

wow, that was a lot of outofoffice replies.  Does everyone make a filter to go 
to their spam folder for those things?  I wish i was on vacation right now...

-----Original Message-----
From: lyallbarbour@xxxxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Sent: Mon, Dec 21, 2009 11:01 am
Subject: 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.

-----Original Message-----
From: Thomas Roach <troach@xxxxxxxxx>
To: john40855@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> wrote:

Hello.  I am looking at upgrading from linux 32 to linux 64 bit, and to upgrade 
from 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

Other related posts: