RE: 32 to 64 and version upgrade
- From: "DOBSON L." <lisa.dobson@xxxxxxxxxxxx>
- To: <lyallbarbour@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Dec 2009 16:23:27 -0000
I'd also suggest taking a look at Metalink note 316889.1 'Complete
Checklist for manual upgrades to 10gR2'. I went from 10gR2 32-bit to
64-bit then to 11gR1 and found it helpful.
It also has details about the script to run to check for deprecated
parameters.
It was a pretty painless exercise - but watch out for Unpublished BUG
5079213 - ORA-06544 [56319] DURING UPGRADE FROM 10.1.0.5 32BIT TO
10.2.0.2 64BIT
I hit it going from 10.2 32-bit to 10.2 64-bit. There's an easy fix for
it so it's not so bad.
Good Luck!
Lisa.
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
lyallbarbour@xxxxxxxxxxxxxxx
Sent: 21 December 2009 16:02
To: oracle-l@xxxxxxxxxxxxx
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.
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:
