Apply PSU7 on GRID INFRASTRUCTURE (11.2.0.3)

Applying PSU7 on Grid Infrastructure
====================================
Step-1
------
Backup both Global Inventory and Local Inventory

Step-2
------
export ORACLE_HOME=/u01/app/grid/11.2.0/grid

create ocm response file
--------------------------
Enter Into oracle user and run the below command

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp  -no_banner -output /u02/ocm.rsp


Applying PSU path Using auto option
-------------------------------------
* for PSU7 patching opatch version should be more than or equal to 11.2.0.3.4
So need to download the latest opatch for applying psu7

* unzip the PSU patch to a empty directory
on grid user you run the below command

$mkdir PSU7

$unzip -d /u01/PSU7 p16742216_112030_AIX64-5L.zip

This has two patches

16619892 --rdbms PATCH
16619898 --GRID patch


$chmod -R 777 /u01/PSU7

Now run the below commands from root User

#cd  /u01/PSU7
OPatch auto for GI

The Opatch utility has automated the patch application for the Oracle
Grid Infrastructure (GI) home and the Oracle RAC database homes
when run with root privileges.It must be executed on each node in the cluster
if the GI home or Oracle RAC database home is in non-shared storage.

The utility should not be run in parallel on the cluster nodes.

#/u01/app/grid/11.2.0/grid/OPatch/opatch auto ./ -ocmrf /u02/ocm.rsp

This will patch Both ORACLE_HOME AND GRID_HOME

The auto command will do the below steps

* try to shutdown the local database instance
* Then it applies the patch on ORACLE_HOME

* After that It stops the crs services
* After complete shutdown of services it applies the Patch on GRID_HOME
* After completion of patch apply it start the crs services


POST PATCH STEPS IN GRID ENVIRONMENT
=======================================

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

ROLLBACK FOR THE PS7
=====================
Case 1: GI Home and Database Homes that are not shared and ACFS file system is not configured.

#opatch auto <UNZIPPED_PATCH_LOCATION> -rollback -ocmrf <ocm response file>

Case 2: GI Home is not shared, Database Home is shared and ACFS may be used.

$ <ORACLE_HOME>/bin/srvctl stop database –d <db-unique-name>

# opatch auto <UNZIPPED_PATCH_LOCATION> -oh <GI_HOME> -rollback -ocmrf <ocm response file>

# opatch auto <UNZIPPED_PATCH_LOCATION> -oh <DATABASE_HOME> -rollback -ocmrf <ocm response file>

$ <ORACLE_HOME>/bin/srvctl start instance –d <db-unique-name> -n <nodename>

# opatch auto <UNZIPPED_PATCH_LOCATION> -oh <GI_HOME> -rollback -ocmrf <ocm response file>

$ <ORACLE_HOME>/bin/srvctl start instance –d <db-unique-name> -n <nodename>

Patch Post-Deinstallation Instructions for an Oracle RAC Environment
====================
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle_PSU_<database SID PREFIX>_ROLLBACK.sql
SQL> QUIT

Incase of Inventory failure
==============================

Sometime there may be a chance of Inventory failure for which opatch lsinventory could show wrong information or Error

So we need to create a new inventory or need to copy from a backup oraInventory directory
For creating new Inventory in a GRID ENVIRONMENT

STEP-1 INVENTORY FOR ORACLE_HOME IN A CLUSTER ENVIRONMENT
=========
$ORACLE_HOME/oui/bin/runInstaller -attachHome -noClusterEnabled ORACLE_HOME=$ORACLE_HOME \
ORACLE_HOME_NAME=OraDb11g_home1 CLUSTER_NODES=ehdb5,ehdb6 "INVENTORY_LOCATION=/u01/app/grid/oraInventory" \
-invPtrLoc "/etc/oraInst.loc" LOCAL_NODE=ehdb6

run the above command as a one line you can remove \ from end of each line

STEP-2
========
$GRID_HOME/oui/bin/runInstaller -attachHome -noClusterEnabled ORACLE_HOME=$GRID_HOME \
 ORACLE_HOME_NAME=Ora11g_gridinfrahome1 CLUSTER_NODES=ehdb5,ehdb6 CRS=true  "INVENTORY_LOCATION=/u01/app/grid/oraInventory" \
-invPtrLoc "/etc/oraInst.loc" LOCAL_NODE=ehdb6

run the above command as a one line you can remore \ from end of each line 

Thanks for viewing this article

Hope it will help you.


Feel free to ask viewssharings.blogspot.in@gmail.com