Patching RAC

From: Koivu, Lisa <>
Date: Tue, 27 May 2008 12:16:10 -0400
Message-ID: <>

Hello all,  

I am the proud mother of a new RAC installation :-)  

My first task with this RAC system was to patch it. I successfully completed a rolling patch on the clusterware, and then patched the asm and db homes separately. I was thinking through how the database patches had to be applied (catpatch.sql) and it makes sense to me that the database should be unavailable throughout the execution of this script, as we are updating the data dictionary within the database
(which there is only one of.)

Now I'm testing the April 2008 CPU. The docs say that the database can be up and available while executing catcpu.sql. It also makes no mention of patching the clusterware.  

My questions are:  

  1. Has anyone ever had a CPU patch go south because the database was in use?
  2. Am I the only one who is nervous running something that is modifying the data dictionary while the database is open for general use?
  3. Are there CPU patches for the clusterware? I don't see any.

And as a tidbit, to those of you who may not already know this: When creating a database with dbca, don't use the template databases if you can avoid it (general purpose, data warehouse, transaction processing). These preconfigured databases save time within the database creation process, but they include the java engine within the database. It takes a long time to patch the jvm.  

(May eons ago I had a major patch end up in a recovery because of the
database jvm. What a nightmare that was)    

Lisa Koivu

Oracle Database Administrator

desk: 407-903-4691

cell: 954-683-4459  

This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the "From:" field.

Received on Tue May 27 2008 - 11:16:10 CDT

Original text of this message