Date: Tue, 27 May 2008 12:16:10 -0400
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:
- Has anyone ever had a CPU patch go south because the database was in use?
- Am I the only one who is nervous running something that is modifying the data dictionary while the database is open for general use?
- 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)
Oracle Database Administrator
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