Oracle Technologies Blog

By ASKM

Applying PSU Patch 11.2.0.1.2 To A Two Node RAC – Part2

Posted by Srikrishna Murthy Annam on May 6, 2011

This article is continuation to the previous article Applying PSU Patch 11.2.0.1.2 To A Two Node RAC

In this article i want to show you the session output for PSU patch application and the session output for  roll backing a PSU patch.

This is the best example to show the hot patching in RAC 11gR2. The patch is applied in a rolling fashion on each node of the cluster. The clusterware automatically relocates the services to other node while patching is running on some node. The end user does not feel any service interruption.

PSU Patch On GRID_HOME(Node1 and Node2)
On b600e6tr01:

[root@b600e6tr01 ~]# cd /u01/home/oracle/product/11.2.0/db_1/patches/psupatch
[root@b600e6tr01 psupatch]# opatch auto . -oh /u01/home/11.2.0/grid
Executing /usr/bin/perl /u01/home/11.2.0/grid/OPatch/crs/patch112.pl -patchdir . -patchn . -oh /u01/home/11.2.0/grid -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-04-19_11-28-59.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/11.2.0/grid/ocm.rsp

Unable to determine if /u01/home/11.2.0/grid is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
Successfully unlock /u01/home/11.2.0/grid
patch ././9655006  apply successful for home  /u01/home/11.2.0/grid
patch ././9654983  apply successful for home  /u01/home/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@b600e6tr01 psupatch]#

On b600e6tr02:

[root@b600e6tr02 psupatch]# opatch auto . -oh /u01/home/11.2.0/grid
Executing /usr/bin/perl /u01/home/11.2.0/grid/OPatch/crs/patch112.pl -patchdir . -patchn . -oh /u01/home/11.2.0/grid -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-04-19_12-26-36.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/11.2.0/grid/ocm.rsp

Unable to determine if /u01/home/11.2.0/grid is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
Successfully unlock /u01/home/11.2.0/grid
patch ././9655006  apply successful for home  /u01/home/11.2.0/grid
patch ././9654983  apply successful for home  /u01/home/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@b600e6tr02 psupatch]#

PSU Patch On RDBMS_HOME(Node1 and Node2)
On b600e6tr01 :

[root@b600e6tr01 psupatch]# /u01/home/oracle/product/11.2.0/db_1/OPatch/opatch auto . -oh  /u01/home/oracle/product/11.2.0/db_1
Executing /usr/bin/perl /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/patch112.pl -patchdir . -patchn . -oh /u01/home/oracle/product/11.2.0/db_1 -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2011-04-19_13-52-07.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/oracle/product/11.2.0/db_1/ocm.rsp

Unable to determine if /u01/home/oracle/product/11.2.0/db_1 is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
patch ././9655006/custom/server/9655006  apply successful for home  /u01/home/oracle/product/11.2.0/db_1
patch ././9654983  apply successful for home  /u01/home/oracle/product/11.2.0/db_1
[root@b600e6tr01 psupatch]#

On b600e6tr02:

[root@b600e6tr02 psupatch]# /u01/home/oracle/product/11.2.0/db_1/OPatch/opatch auto . -oh  /u01/home/oracle/product/11.2.0/db_1
Executing /usr/bin/perl /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/patch112.pl -patchdir . -patchn . -oh /u01/home/oracle/product/11.2.0/db_1 -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2011-04-19_13-28-55.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/oracle/product/11.2.0/db_1/ocm.rsp

Unable to determine if /u01/home/oracle/product/11.2.0/db_1 is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
patch ././9655006/custom/server/9655006  apply successful for home  /u01/home/oracle/product/11.2.0/db_1
patch ././9654983  apply successful for home  /u01/home/oracle/product/11.2.0/db_1
[root@b600e6tr02 psupatch]#

RollBack PSU Patch On GRID_HOME(Node1 and Node2)
On b600e6tr01:

[oracle@b600e6tr01 ~]$ sudo su -
[root@b600e6tr01 ~]# /u01/home/11.2.0/grid/OPatch/opatch auto /u01/home/oracle/product/11.2.0/db_1/patches/psupatch -rollback -oh /u01/home/11.2.0/grid
Executing /usr/bin/perl /u01/home/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /u01/home/oracle/product/11.2.0/db_1/patches -patchn psupatch -rollback -oh /u01/home/11.2.0/grid -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-05-04_07-27-40.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/11.2.0/grid/ocm.rsp

Unable to determine if /u01/home/11.2.0/grid is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
Successfully unlock /u01/home/11.2.0/grid
patch 9655006  rollback successful for home /u01/home/11.2.0/grid
patch 9654983  rollback successful for home /u01/home/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@b600e6tr01 ~]#

On b600e6tr02:

[oracle@b600e6tr02 ~]$ sudo su -
[root@b600e6tr02 ~]# /u01/home/11.2.0/grid/OPatch/opatch auto /u01/home/oracle/product/11.2.0/db_1/patches/psupatch -rollback -oh /u01/home/11.2.0/grid
Executing /usr/bin/perl /u01/home/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /u01/home/oracle/product/11.2.0/db_1/patches -patchn psupatch -rollback -oh /u01/home/11.2.0/grid -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2011-05-04_07-41-37.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/11.2.0/grid/ocm.rsp

Unable to determine if /u01/home/11.2.0/grid is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
Successfully unlock /u01/home/11.2.0/grid
patch 9655006  rollback successful for home /u01/home/11.2.0/grid
patch 9654983  rollback successful for home /u01/home/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.
[root@b600e6tr02 ~]#

RollBack PSU Patch ON RDBMS_HOME(Node1 and Node2)
On b600e6tr01 :

[root@b600e6tr01 ~]# /u01/home/oracle/product/11.2.0/db_1/OPatch/opatch auto /u01/home/oracle/product/11.2.0/db_1/patches/psupatch -rollback  -oh  /u01/home/oracle/product/11.2.0/db_1
Executing /usr/bin/perl /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/patch112.pl -patchdir /u01/home/oracle/product/11.2.0/db_1/patches -patchn psupatch -rollback -oh /u01/home/oracle/product/11.2.0/db_1 -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2011-05-04_07-54-30.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/oracle/product/11.2.0/db_1/ocm.rsp

Unable to determine if /u01/home/oracle/product/11.2.0/db_1 is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
patch 9655006  rollback successful for home /u01/home/oracle/product/11.2.0/db_1
patch 9654983  rollback successful for home /u01/home/oracle/product/11.2.0/db_1
[root@b600e6tr01 ~]#

On b600e6tr02:

[root@b600e6tr02 ~]#
[root@b600e6tr02 ~]# /u01/home/oracle/product/11.2.0/db_1/OPatch/opatch auto /u01/home/oracle/product/11.2.0/db_1/patches/psupatch -rollback  -oh  /u01/home/oracle/product/11.2.0/db_1
Executing /usr/bin/perl /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/patch112.pl -patchdir /u01/home/oracle/product/11.2.0/db_1/patches -patchn psupatch -rollback -oh /u01/home/oracle/product/11.2.0/db_1 -paramfile /u01/home/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/home/oracle/product/11.2.0/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2011-05-04_08-01-19.log
Detected Oracle Clusterware install
Using configuration parameter file: /u01/home/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/u01/home/oracle/product/11.2.0/db_1/ocm.rsp

Unable to determine if /u01/home/oracle/product/11.2.0/db_1 is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
patch 9655006  rollback successful for home /u01/home/oracle/product/11.2.0/db_1
patch 9654983  rollback successful for home /u01/home/oracle/product/11.2.0/db_1
[root@b600e6tr02 ~]#

Hope it helps

SRI

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: