Re: GI and DB PSU Patch

From: Rajesh Aialavajjala <r.aialavajjala_at_gmail.com>
Date: Thu, 30 Jan 2014 11:08:15 -0500
Message-ID: <CAGvtKv4m9RqSnPF0ZxBdBqwMWAhdZUv+0KwKMsOK6hqpU7ViYQ_at_mail.gmail.com>

Sanjay,
 Not sure I follow what you are saying - my understanding was that you had 2 questions around this

1. Whether GI/CRS ORACLE_HOME requires to be patched - or is it adequate to only patch RDBMS ORACLE_HOMEs' w/ RDBMS PSUs'

Answer: Oracle recommends that you apply GI patches to both the GI and RDBMS ORACLE_HOMEs' ...

2) ASM vs RDBMS compatibility...in terms of major release #s' - 4th digit <11.2.0.*x>*

Note *337737.1 *states that for the purpose of version compatibility - you do not need to delve into the 5th digit when validating combinations of ASM+RDBMS - for example - the January 2014 PSU for 11.2.0.3 will bring the 5th digit to 11.2.0.3.*9 *- however when you're checking compatibility - you can only run an RDBMS that is equal to or lower than 11.2.0.3 - the 5th digit does not matter - in theory you could have an RDBMS _at_ 11.2.0.3.*9*managed by a 11.2.0.3.
*7* CRS_ORACLE_HOME Refer "Patching Considerations" contained in RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent) (Doc ID 810394.1)...

I'd guess - yes you can continue to only patch RDBMS ORACLE_HOMEs' - but it might not be the best option...in light of recommendations that Oracle makes - of course subject to whatever factors/constraints you're dealing w/ :-) - it's not always possible to follow 'recommendations'....

Thanks,

--Rajesh

On Thu, Jan 30, 2014 at 10:49 AM, Sanjay Mishra <smishra_97_at_yahoo.com>wrote:

> Thanks Rajesh, I checked and one of the Links (337737.1) says
> The Oracle Grid Infrastructure (GI) /Clusterware (CRS) version must be of
> the highest version down to the 4th digit in the possible combinations at
> all times.
> This means, you have to upgrade Oracle Grid Infrastructure / Clusterware
> first.
>
> - The 5th digit does not have to be greater and can be excluded from
> these version considerations.
>
>
> So does that mean that as PSU patch only update the last Fifth digit we
> can continue with only PSU patch to RDBMS home and not to GI
>
> Sanjay
>
>
> On Thursday, January 30, 2014 10:25 AM, Rajesh Aialavajjala <
> r.aialavajjala_at_gmail.com> wrote:
> Sanjay,
> Oracle recommends that in a Grid Infrastructure environmetn - that GI
> patches be applied to both the GI and RDBMS ORACLE_HOMEs' ...
>
>
> *Which Patch Needs to be Applied to Which Home in GI/CRS and RAC
> Environment (Doc ID 1474914.1) *
>
> *FAQ: OPatch/Patch Questions/Issues for Oracle Clusterware (Grid
> Infrastructure or CRS) and RAC Environments (Doc ID 1339140.1) *
>
> Of course - there can be exceptions - as occurred w/ the January 2014
> Critical Patch Update....where there was no 11.2.0.4 GI PSU <this may not
> apply in the case you're mentioning since your e-mail states the highest
> version is 11.2.0.3>
>
> Will there be a Grid Infrastructure (GI) PatchSet Update (PSU) 11.2.0.4.1
> (Jan 2014)? (Doc ID 1611875.1)
>
> As relates to ASM-RDBMS version compatibility...
>
> *Oracle Clusterware (CRS/GI) - ASM - Database Version Compatibility (Doc
> ID 337737.1)*
>
> Thanks,
>
> --Rajesh
>
> On Thu, Jan 30, 2014 at 10:11 AM, Sanjay Mishra <smishra_97_at_yahoo.com>wrote:
>
> Hi
>
> Is it fine to only apply PSU patch to DB and ignore GI ? I thought ASM
> should be same or higher version that RDBMS. In one of the existing client,
> I saw patches are only applied to RDBMS and never to GI. There is no other
> reason except look like anyone never looked to it and follow the standard
> going on. Current version is 11g 2( 11.2.0.1-11.2.0.3).
>
> So if someone share any Oracle metalink docs or suggestion as what is best
> practices and why? Greatly appreciate it.
>
> TIA
> Sanjay
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 30 2014 - 17:08:15 CET