RE: Upgrading 11.2.0.1 RAC to 11.2.0.2 RAC anyone?
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: Andrew Kerber <andrew.kerber@xxxxxxxxx>, "cicciuxdba@xxxxxxxxx" <cicciuxdba@xxxxxxxxx>
- Date: Fri, 24 Jun 2011 16:21:29 -0400
Thanks to Andrew and Alan for their replies.
To answer some questions, yes, GI home was previously upgraded to 11.2.0.2.
I pre-staged the binaries for 11.2.0.2 DB Home, and that was successful to all
5 nodes.
When I ran 'dbua', later, I got the error.
Problem was, I set ORACLE_SID to the local instance of the db I wanted to
upgrade, and ORACLE_HOME to the new 11.2.0.2 home and put the ORACLE_HOME/bin
in my PATH. When I did that, I got the bizarre error shown below.
The solution was to log out, log in, cd my_11.2.0.2_db_home/bin and then run
'./dbua'. When I did that, it worked. (No environment variables set.)
Oh, and yes, dbua wants you to choose the name of the database, not the local
instance.
So, anyhow, all is well, and my upgrades are on the way.
-Mark
From: Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
Sent: Friday, June 24, 2011 4:13 PM
To: cicciuxdba@xxxxxxxxx
Cc: Bobak, Mark; oracle-l@xxxxxxxxxxxxx
Subject: Re: Upgrading 11.2.0.1 RAC to 11.2.0.2 RAC anyone?
Did you upgrade the grid infrastructure first? The upgrade process requires
you to upgrade the GI, then the databases. Also, remember to install the April
CPU and the patch for the april CPU, there are some pretty major bugs evidently.
If you have not done the GI yet, you will probably run into issues with
multicast, which will also require a patch download.
On Fri, Jun 24, 2011 at 2:56 PM, Guillermo Alan Bort
<cicciuxdba@xxxxxxxxx<mailto:cicciuxdba@xxxxxxxxx>> wrote:
Have you tried choosing mstmfgpe instead of mstmfgpe1?
I am preparing one of those myself.
Also, I don't think 11.2.0.1 to 11.2.0.2 is an upgrade, I think it's a
patchset, so perhaps there is a catcpu.
I'm not much of a fan of DBUA, I usually use the scripts for upgrades.
hth
Alan.-
On Fri, Jun 24, 2011 at 2:23 PM, Bobak, Mark
<Mark.Bobak@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>> wrote:
Has anyone done an upgrade of 11.2.0.1 RAC to 11.2.0.2 RAC on Linux-x86-64?
I have pre-staged the binaries, and now I'm attempting to run DBUA. (Running
dbua from 11.2.0.2.0 ORACLE_HOME.)
I'm trying to do this for the first time on RAC (dev and test are single
instance, they were no problem), and, I'm getting the following problem:
When I start DBUA, I get a list (from /etc/oratab) of all the local instance
names, as well as the (dummy?) database names listed there.
So, when I select the local instance name, in my case, 'mstmfgpe1', I get the
following error:
First I get the "Getting database information..." dialog, and then quickly
followed by:
'The database "mstmfgpe1" does not has the cluster configuration and also not
listed in the registry of remote cluster nodes. Do you want the Database
Upgrade Assistant to upgrade it as a single instance database?
Click Yes to upgrade it as a single instance database.
Click No to upgrade it as a cluster database.'
So, question is, *why* does it not recognize this instance as part of a cluster
database? Has anyone else done 11.2.0.1->11.2.0.2 on RAC? Successfully? Ever
seen this problem?
Thanks in advance,
-Mark
Mark J. Bobak, Senior Database Administrator, DTG, ProQuest | 789 E. Eisenhower
Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | +1 734 997
4059<tel:%2B1%20734%20997%204059>
mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
ProQuest...Start here. 2010 InformationWeek 500 Top Innovator
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
