Oracle CRS 10.2.0.4 patching..

It has been a while, I have posted something on my blog. I hate my blog to look like a ghost town. I'll discuss the Oracle 10.2.0.4 patching proceess here.

I used to install Oracle 10g r2 base binaries right after installing Oracle CRS. I was hit by a OCR corruption issue which created lot of core dumps and was forced to rebuilt my OCR files. The avoid any such issue, I would suggest Patch oracle CRS first and the install RDBMS software.

1) The first step to apply 10.2.0.4 patch to CRS is to shutdwon CRS on both nodes.

Usually the "root" user will have the privileges to shitdown the CRS. The SA or root user can shutdown crs using the command

$> crsctl stop crs or

$/etc/init.d/init.crs stop

Make sure CRS is shut down.

$ps -ef grep crs

root 968 1 0 12:11:45 ? 0:00 /bin/sh /etc/init.d/init.crsd run

2) Make sure you change the ownership of "VIPCA" back to "oracle" from "root".

3) Set the environment varaiable for "crs".

$> ./.oraenv crs

check the oracle_home variable is to CRS_HOME.

env grep ORACLE_HOME

4) cd to the 10.2.0.4 patch set directory and execute "runInstaller". The crs and rdbms use the same 10.20.4 patset(there is no seperate 10204 patch set for CRS).

5) DBA confirms the CRSHOME and hit next

6) DBA confirms the node names in cluster and hit next

7) Validate the summary page and start installation.

8) At the end of the installation, Pl execute the root102.sh on all the nodes as instructed in the GUI.

9)log in as root and execute on all nodes one by one. you canignore the warnings below.

$/u01/app/oracle/cluster/crs/install/root102.shCreating pre-patch directory for saving pre-patch clusterware filesCompleted patching clusterware files to /u01/app/oracle/cluster/crsRelinking some shared libraries.ar: writing /u01/app/oracle/cluster/crs/lib/libn10.aar: writing /u01/app/oracle/cluster/crs/lib32/libn10.aar: writing /u01/app/oracle/cluster/crs/lib/libn10.aRelinking of patched files is complete.WARNING: directory '/u01/app/oracle/cluster' is not owned by rootWARNING: directory '/u01/app/oracle' is not owned by rootPreparing to recopy patched init and RC scripts.Recopying init and RC scripts.Startup will be queued to init within 30 seconds.Starting up the CRS daemons.Waiting for the patched CRS daemons to start. This may take a while on some systems..10204 patch successfully applied.clscfg: EXISTING configuration version 3 detected.clscfg: version 4 is 10G Release 2.Successfully accumulated necessary OCR keys.Using ports: CSS=32845 CRS=45632 EVMC=43567 and EVMR=34834.node : node 0: nodeA nodea-priv1 nodeBCreating OCR keys for user 'root', privgrp 'dba'..Operation successful.clscfg -upgrade completed successfully

10) Check CRS by issueing crs_stat -t and exit OUI.

$>crs_stat -t

Name Type Target State Host

-----------------------------

ora.node1.gsd application ONLINE ONLINE node1

ora.node1.ons application ONLINE ONLINE node1

ora.node1.vip application ONLINE ONLINE node1

ora.node2.gsd application ONLINE ONLINE node2

ora.node2.ons application ONLINE ONLINE node2

ora.node2.vip application ONLINE ONLINE node2