Re: 32 to 64 and version upgrade
- From: lyallbarbour@xxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 21 Dec 2009 11:01:49 -0500
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@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 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@xxxxxxxxx
Other related posts:
