Hello,
I want to patch 2 node RAC 10gR2 DB (Standard Edition) on SLES 11. I have patched signle instance DB with OPATCH, but never patched RAC DB, kind of very nervous. I am not able to find generally and also from MOS regarding step by step process to patch RAC 10gR2 on SLES OS. In the readme of the Patch, I do not find step by step detail of how to ....regarding RAC. Following is the information regarding the current setup, please have a look and suggest/help me, as it's a production DB and I'm little afraid to Patch it.
I've also other general questions please, like:
- In RAC, how many homes are normall there to patch? DB,CRS, Grid?
- Clusterware (CRS) and ASM has same home?. Are they same?. Pathing any one means pathing both ASM and CRS, right?
oracle@dba01 [ec]: /home/oracle > echo $CRS_HOME
/oracle/app/11.2.0/grid
oracle@dba01 [ec]: /home/oracle > echo $ASM_HOME
/oracle/app/11.2.0/grid
oracle@dba01 [ec]: /oracle/app/10.2.0/db1/OPatch > opatch lsinventory
Invoking OPatch 11.2.0.1.0
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home
- -
Rac system comprising of multiple nodes
Local node = dba01
Remote node = dba02
Connected to:
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
With the Real Application Clusters option
####### According to MOS patch advisor for the DB, found this patch for Linux-x86-64:
Patch 12879929 - 10.2.0.4.11 Patch Set Update ## DATABASE PATCH SET UPDATE 10.2.0.4.11 (PRE-REQ 10.2.0.4.4|INCLUDES CPUJAN2012)
Patch 9352164 - 10.2.0.4.4 Patch Set Update
# Both are in Downloads folder on my local machine.
SYS@rac1p1 AS SYSDBA> select * from registry$history;
ACTION_TIME ACTION NAMESPACE VERSION ID COMMENTS BUNDLE_SERIES
----------------- ------------------------------ -----------------------------
30-MAR-10 07.38.3 APPLY SERVER 10.2.0.4 6 CPUJan2010 CPU 6.877725 AM
30-MAR-10 07.43.4 CPU 6452863 view recompilation 5.716832 AM
14-JUN-10 10.55.1 APPLY SERVER 10.2.0.4 7 CPUApr2010 CPU 8.089709 PM
oracle@dba01 [ec]: /home/oracle > echo $CRS_HOME
/oracle/app/11.2.0/grid
oracle@dba01 [ec]: /oracle/app/11.2.0/grid/OPatch > opatch lsinventory
Patch 9352191 : applied on Mon Jun 14 22:28:04 CEST 2010 # Latest patch installed ..
- - -
# I think patch option for RAC which I read,,,rolling I cannot perform because its not Enterprise edition DB, minimum downtime also doesn't look like suitable, then I think I will adopt ALL NODE patching,isn'it?
# In DB, I can find out through registry$history the latest PSU installed, but how would I find out which patch to install now in CRS/ASM home?
# I was looking at srvctl and crsctl,etc commands....I am little confused between these both type of command to perform ...like to Shutdown instances,services,listener,nodes,etc...what commands do I need for this process, please?
Bundle of thanks.
Regards