Questions on How to upgrade and patch CRS,ASM and Database components in different homes on the same server.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: Questions on How to upgrade and patch CRS,ASM and Database components in different homes on the same server.


Solution:




Assume you have 3 Oracle Homes on the same server and you want to upgrade them from 10.2.0.3 to 10.2.0.4.4, some worries might arise:
1. ASM Version is 10.2.0.3
2. CRS Version is 10.2.0.3
3. Database Version is 10.2.0.3

1. Is it necessary to upgrade all components (crs,asm,db) to I can just upgrade the database only to 10.2.0.4 and if so in which order?
Answer:
You must upgrade all Oracle home in following sequence.
CRS first
ASM second
RDBMS last
You can upgrade all above 3 Oracle homes together in same scheduled downtime window or upgrade it separately one-by-one.
CRS can be upgraded in rolling so doesn’t require cluster wide downtime.
Upgrading from 10.2.0.3 to 10.2.0.4.4 is a two step process.
viz:
A) upgrade to patch set 10.2.0.4 (refer to patch set README for steps to apply patch set)
B) apply PSU-4 to make it 10.2.0.4.4 (refer to patch README for steps to apply)
Note.
1) CRS PSU is different from RDBMS PSU
2) Both the PSU can be applied in rolling

You can find patch (PSU) numbers for CRS and RDBMS in doc :
Note 756671.1 Title: Oracle Recommended Patches -- Oracle Database
2. How does the ASM database upgrade works? What are the steps?
a. ASM upgrade requires just installing the patchset software and then applying the PSU,
b. There is nothing you need to do for upgrading ASM except installing the software binaries in ASM HOME, the internl ASM metadata gets upgraded automatically when you startup ASM with new patched binaries.
3. Can I keep ASM home and ASM database to 10.2.0.3 only and upgrade only CRS and database Home.
a. No, you cannot have ASM running in lower version and RDBMS database running with higher version.


References:
Note 756671.1 Title: Oracle Recommended Patches -- Oracle Database

Get Oracle Certifications for all Exams
Free Online Exams.com