RAC Clusterware Upgradation(11,1,0.6.0 to 11.1.0.7.0)

For upgrading the RAC Database, first we need to upgrade the clusterware. This is a  two node RAC installation.

Steps to follow for a clusterware installation:

Note: Always before starting upgradation, take a backup of the ORACLE_HOME, incase upgradation fails, this will be used for downgrading the Oracle Instance back to our original version. i.e.,(11.1.0.7.0------>11.1.0.6.0)

1. Stop the instance  on the particular node, srvctl stop instance -d prod_db -i prod1
2. 
   

   If an Automatic Storage Management instance is present, then shut down the Automatic Storage Management instance on the node on which you intend to perform the rolling upgrade.   "srvctl stop asm -n rac1"
3. 
   

   Stop all the nodeapp services on that node "rac1", nodeapps includes GSD,Listener daemons   "srvctl stop nodeapps -n rac1"

unzip the patchset, there will be a executable file(runInstaller.sh), Execute that it will be followed by a GUI based installation steps:

1.      On the Welcome screen, click Next.

2.      In the Specify Home Details screen, select the name of the Oracle home that you want to update, or select the Path that you want to update from the list, then click Next.

3. Click Next.

4. For Oracle RAC cluster, the Selected Nodes screen appears. The patch set will be installed on these nodes. Click Next.

5. Check for errors, if any, in the Product-Specific Prerequisite Checks and click Next.

6. On the Summary screen, click Install.


7. On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer.

Finally once the installation completes, we will be prompted to run the script "root111.sh"

Clusterware is successfully upgraded.

 $ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.1.0.6.0]

$ crsctl query crs softwareversion
Oracle Clusterware version on node [RAC1] is [11.1.0.7.0]

The above commands is to check the clusterware version, note here the software version is 11.1.0.7.0 that is the upgraded version, whereas the active version is still the older. Once the clusterware is successfully upgraded in other participating node, then the active version will change to 11.1.0.7.0

$ crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.1.0.7.0]

$ crsctl query crs softwareversion
Oracle Clusterware version on node [RAC2] is [11.1.0.7.0]