RE: Upgrading 11.2.0.1 RAC to 11.2.0.2 RAC anyone?

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Sat, 25 Jun 2011 16:58:12 -0400
Message-ID: <20e50043-7a91-44ae-9c34-f7c88f8c2f2f_at_blur>

Thanks the the suggestion, Martin. I actually noticed a post from Andrew Kerber, earlier today, and forwarded to my colleagues. I'm sure it will be a topic of discussion on Monday.

Thanks,

-Mark

Sent from my Motorola ATRIX™ 4G on AT&T

-----Original message-----

From: Martin Bach <development_at_the-playground.de> To: "Bobak, Mark" <Mark.Bobak_at_proquest.com>, &apos;Andrew Kerber&apos; <andrew.kerber_at_gmail.com>, "cicciuxdba_at_gmail.com" <cicciuxdba_at_gmail.com> Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Sat, Jun 25, 2011 19:50:54 GMT+00:00 Subject: RE: Upgrading 11.2.0.1 RAC to 11.2.0.2 RAC anyone?

Hi Mark,

I’d also recommend you patch to 11.2.0.2.2 whilst you are at it, there’s a rather interesting note on MOS (1318986.1 - ORA-600 / corruption possible during shutdown in RAC) as part of the 11.2.0.2 Patch Set - Availability and Known Issues [ID 1179474.1] document.

Best regards,

Martin

Martin Bach
http://martinbach-consulting.com
http://uk.linkedin.com/in/martincarstenbach

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark Sent: 24 June 2011 21:21
To: Andrew Kerber; cicciuxdba_at_gmail.com Cc: oracle-l_at_freelists.org
Subject: RE: Upgrading 11.2.0.1 RAC to 11.2.0.2 RAC anyone?

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:<span lang="EN-US" style="font-size:10.
--

http://www.freelists.org/webpage/oracle-l Received on Sat Jun 25 2011 - 15:58:12 CDT