Codemuch 01010101011101101010110001...

Before we install anymore software, the Clusterware install should be upgraded from 10.2.0.1 to 10.2.0.3.

The first thing to do is to download the patch 5337014 from Metalink.

Unzip the patch to a temporary directory on any of the two nodes and run setup.exe and click Next.

Select the Clusterware home and click Next.

Cluster installation should already be selected at this point. Click Next to continue.

The summary screen should be displayed at this point. Click Next to continue.

At this point the patch software will be deployed to all the nodes in the cluster.

The patch software should be now be deployed to each node. Click Exit to close the installer.

At this point, the patch has not been installed. It has only be staged to each node in the cluster. We now need to apply the patch on a rolling basis to each node. NOTE: the following steps need to be repeated for each node in the cluster.

The first thing we need to do is to stop all the Oracle services. From a command prompt, execute the following commands:

To verify that all Oracle services have stopped, there should be no output from the following command:

It is also a good idea to stop the Microsoft Distributed Transaction Coordinator, as it may have loaded some Oracle libraries that need to be patched.

Now, go to the $CLUSTER_HOME\install directory and run the patch installer:

The command may fail with the following error message:

Failed to patch all the files in the ORA_CRS_HOME C:\oracle\product\10.2.0\crs
Please ensure that all processes running from the home have been
stopped.

If the MSDTC has already been stopped, this is most likely due to two ons.exe processes that are still running. Using the Windows Task Manager to kill these two processes.

Now execute the command again and if successful it should display the following message:

Successful upgrade of this node to Oracle Cluster Ready Services 10203