Home » , , , , , , , » RAC : Rollback PSU Patch From Standard Cluster 12c

RAC : Rollback PSU Patch From Standard Cluster 12c

Written By Srikrishna Murthy Annam on Wednesday, March 12, 2014 | 7:29 AM


In this article, we are going to see the steps to rollback a patch from RAC 12c standard cluster. Make sure you have all the cluster services up and running before starting the rollback.


1. Make sure you have all the cluster services up and running.
 /u01/app/12.1.0/grid_1/bin/crsctl status res -t

[root@askmrac1 ~]# /u01/app/12.1.0/grid_1/bin/crsctl status res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       askmrac1                 STABLE
               ONLINE  ONLINE       askmrac2                 STABLE
               ONLINE  ONLINE       askmrac3                 STABLE
ora.OCR_VOTE.dg
               ONLINE  ONLINE       askmrac1                 STABLE
               ONLINE  ONLINE       askmrac2                 STABLE
               ONLINE  ONLINE       askmrac3                 STABLE
ora.asm
               ONLINE  ONLINE       askmrac1                 Started,STABLE
               ONLINE  ONLINE       askmrac2                 Started,STABLE
               ONLINE  ONLINE       askmrac3                 Started,STABLE
ora.net1.network
               ONLINE  ONLINE       askmrac1                 STABLE
               ONLINE  ONLINE       askmrac2                 STABLE
               ONLINE  ONLINE       askmrac3                 STABLE
ora.ons
               ONLINE  ONLINE       askmrac1                 STABLE
               ONLINE  ONLINE       askmrac2                 STABLE
               ONLINE  ONLINE       askmrac3                 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       askmrac2                 STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       askmrac2                 169.254.200.16 10.10
                                                             .10.232,STABLE
ora.askmrac1.vip
      1        ONLINE  ONLINE       askmrac1                 STABLE
ora.askmrac2.vip
      1        ONLINE  ONLINE       askmrac2                 STABLE
ora.askmrac3.vip
      1        ONLINE  ONLINE       askmrac3                 STABLE
ora.cvu
      1        ONLINE  ONLINE       askmrac2                 STABLE
ora.oc4j
      1        ONLINE  ONLINE       askmrac3                 STABLE
ora.orcl.db
      1        ONLINE  ONLINE       askmrac1                 Open,STABLE
      2        ONLINE  ONLINE       askmrac2                 Open,STABLE
      3        ONLINE  ONLINE       askmrac3                 Open,STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       askmrac2                 STABLE
--------------------------------------------------------------------------------
[root@askmrac1 ~]# /u01/app/12.1.0/grid_1/bin/crsctl status res -t | grep -i offline
[root@askmrac1 ~]#
2. Use the following syntax to rollback the patch from 12c standard cluster home.
opatchauto rollback <patch location>
[root@askmrac1 ~]# which opatchauto
/u01/app/12.1.0/grid_1/OPatch/opatchauto
[root@askmrac1 ~]# opatchauto rollback /mnt/software/RAC/1201_PSU/17272829
OPatch Automation Tool
Copyright (c) 2013, Oracle Corporation.  All rights reserved.
OPatchauto version : 12.1.0.1.2
OUI version        : 12.1.0.1.0
Running from       : /u01/app/12.1.0/grid_1
opatchauto log file: /u01/app/12.1.0/grid_1/cfgtoollogs/opatchauto/17272829/opatch_gi_2014-03-08_05-34-09_deploy.log
Parameter Validation: Successful
Grid Infrastructure home:
/u01/app/12.1.0/grid_1
RAC home(s):
/u01/app/oracle/product/12.1.0/dbhome_1
Configuration Validation: Successful
Patch Location: /mnt/software/RAC/1201_PSU/17272829
Grid Infrastructure Patch(es): 17027533 17077442 17303297
RAC Patch(es): 17027533 17077442
Patch Validation: Successful
Stopping RAC (/u01/app/oracle/product/12.1.0/dbhome_1) ... Successful
Following database(s) were stopped and will be restarted later during the session: orcl
Rolling back patch(es) from"/u01/app/oracle/product/12.1.0/dbhome_1" ...
Patch "17027533,17077442" successfully rolled back from "/u01/app/oracle/product/12.1.0/dbhome_1".
Stopping CRS ... Successful
Rolling back patch(es) from"/u01/app/12.1.0/grid_1" ...
Patch "17027533,17077442,17303297" successfully rolled back from "/u01/app/12.1.0/grid_1".
Starting CRS ... Successful
Starting RAC (/u01/app/oracle/product/12.1.0/dbhome_1) ... Successful
[WARNING] SQL changes, if any, could not be rolled back on the following database(s): ORCL ... Please refer to the log file for more details.
Rollback Summary:
Following patch(es) are successfully rolled back:
GI Home: /u01/app/12.1.0/grid_1: 17027533, 17077442, 17303297
RAC Home: /u01/app/oracle/product/12.1.0/dbhome_1: 17027533, 17077442
opatchauto succeeded.
[root@askmrac1 ~]# 

Use the above syntax to rollback the patch from grid home and database home on all other cluster nodes.

3. Verify that the patch is rolledback.
From Grid Home:
[root@askmrac1 ~]# su - grid
[grid@askmrac1 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.2
Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/12.1.0/grid_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/12.1.0/grid_1/oraInst.loc
OPatch version    : 12.1.0.1.2
OUI version       : 12.1.0.1.0
Log file location : /u01/app/12.1.0/grid_1/cfgtoollogs/opatch/opatch2014-03-08_06-11-01AM_1.log
Lsinventory Output file location : /u01/app/12.1.0/grid_1/cfgtoollogs/opatch/lsinv/lsinventory2014-03-08_06-11-01AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Grid Infrastructure 12c                                       12.1.0.1.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Patch level status of Cluster nodes :
 Patching Level                  Nodes
 --------------                  -----
 0                               askmrac3,askmrac2,askmrac1
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@askmrac1 ~]$

From Oracle Home : 
[root@askmrac1 ~]# su - oracle
[oracle@askmrac1 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.2
Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.2
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2014-03-08_06-11-27AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-03-08_06-11-27AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c                                                  12.1.0.1.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

Rac system comprising of multiple nodes
  Local node = askmrac1
  Remote node = askmrac2
  Remote node = askmrac3
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@askmrac1 ~]$

Please see my other articles on how to apply PSU patches to standard cluster and flex cluster.
RAC 12c : JAN2014 PSU to 4 node flex cluster
RAC : Apply PSU patch to Standard Cluster 12c

Hope This Helps
SRI

Share this article :

Related Articles By Category



Post a Comment

Thank you for visiting our site and leaving your valuable comment.

 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger