Oracle 11g RAC – PSU

oracleoracle-11g-r2oracle-grid-controlrac

Simple question, when patching two nodes of 11g RDBMS, do I need to patch GRID as well, or only RDMBS is enough?

Thank you in advance

Best Answer

https://mikedietrichde.com/2017/04/26/keep-your-patch-versions-between-grid-infrastructure-and-databases-homes-in-synch/

Can you have different PSU/BP versions between Database and GI homes? Yes, you can have a higher version PSU or BP in the Database home than in the Grid Infrastructure home managing the resources. This is implicitly documented in MOS Note 337737.1 – Oracle Clusterware (CRS/GI) – ASM – Database Version Compatibility where it 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.“

Therefore you can deviate that this rule does not apply for the 5th digit anymore.

Related Solutions

Why is the OCR&Vote disk group servicing SCAN name

That is the Oracle Cluster Registry (OCR) where information about clusterware components is stored.

http://docs.oracle.com/cd/E11882_01/rac.112/e41959/intro.htm#CWADD90952

Its size is 256 MB, or 0.26GB, you can check this with ocrcheck:

# ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       2948
         Available space (kbytes) :     259172
         ID                       : 1703252243
         Device/File Name         :       +OCR
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check succeeded

Oracle 11g – Aggregate Function and Query

Simple, but "dirty":

with t as (
  select 1 as id, 'Y' as received from dual union
  select 1 as id, 'N' as received from dual union
  select 2 as id, 'N' as received from dual union
  select 2 as id, 'N' as received from dual union
  select 2 as id, 'Y' as received from dual union
  select 3 as id, 'N' as received from dual union
  select 3 as id, 'Y' as received from dual 
)
select min(max(received)) from t group by id;

M
-
Y

Change input (e.g. change id to 4 in last line):

with t as (
  select 1 as id, 'Y' as received from dual union
  select 1 as id, 'N' as received from dual union
  select 2 as id, 'N' as received from dual union
  select 2 as id, 'N' as received from dual union
  select 2 as id, 'Y' as received from dual union
  select 3 as id, 'N' as received from dual union
  select 4 as id, 'Y' as received from dual 
)
select min(max(received)) from t group by id;

M
-
N

Best Answer

Related Solutions

Why is the OCR&Vote disk group servicing SCAN name

Oracle 11g – Aggregate Function and Query

Related Question