Tuesday, March 29, 2011

Implement Grid Infrastructure Patch (10110978)

We have prepared below action plan for our implementation:

-- -------------------------------------------------------------------------------------------
-- BUNDLE Patch for Base Bug 10110978, Grid Infrastructure 11.2.0.1 Bundle Patch 4 for Exadata
-- -------------------------------------------------------------------------------------------
-- -------------
-- Prerequisites
-- -------------
1. latest Opatch [already installed for BP8 ] and dismount all DBFS

2. Verify the OUI Inventory:

** Logon to each(4) DB Machine and follow below steps:

For GI HOME:
------------
$ /u01/app/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /u01/app/11.2.0/grid

For DB HOME:
------------
$ /u01/app/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/11.2.0/dbhome_1

This should list the components and the list of nodes.
[If the command errors out, contact Oracle Support]

3. Create a location PATCH_TOP

** Logon All 4 DB Machine and follow below steps:

$ mkdir /u01/app/patch/p10110978_112010_LINUX.X64
$ export PATCH_TOP=/u01/app/patch/p10110978_112010_LINUX.X64
$ unzip -d $PATCH_TOP p10110978_112010_LINUX.X64.zip
[** make the $PATCH_TOP directory empty except the two patch folders]
4. When run the "opatch auto" command, it prompts the user to enter the OCM (Oracle Configuration Manager) response file path.
If the OCM (NOT OCR) response file is already created in your environment, enter the absolute file path of the OCM responsefile.
Otherwise, you can create the OCM response file with the command:

$ /u01/app/11.2.0/grid/OPatch/ocm/bin/emocmrsp
--- created at /home/oracle/BP8/ocm.rsp
as root run below:[ID 1128528.1]
$mkdir /u01/app/11.2.0/grid/crs/admin
$cd /u01/app/11.2.0/grid/crs/
$chown oracle:oinstall admin
$touch /u01/app/11.2.0/grid/install/params.crs
$cd /u01/app/11.2.0/grid/install/
$chown oracle:oinstall params.crs
$chmod 755 params.crs
-- ------------
-- Installation
-- ------------
5. apply the patch [from GRIH_HOME] to the Grid Home and all applicable RDBMS homes
** as in our case both DB & GI Home are owned by same user we will go for "opatch auto"
** for each DB node run blow commands as *root* user:

# export ORACLE_HOME=/u01/app/11.2.0/grid
# export PATH=$PATH:$ORACLE_HOME/OPatch
# which opatch
/u01/app/11.2.0/grid/OPatch/opatch
# export PATCH_TOP=/u01/app/patch/p10110978_112010_LINUX.X64
# cd $PATCH_TOP
# opatch auto

6. On success you can determine whether the patch has been installed by using the following command:
** for each(4) DB Machine and follow below steps:
For GI HOME:
------------
$ /u01/app/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /u01/app/11.2.0/grid

For DB HOME:
------------
$ /u01/app/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/11.2.0/dbhome_1

This should list the components and the list of nodes.

-- --------------
-- Deinstallation
-- --------------
7. ** for each DB nodes follow all the steps above except "opatch auto" in step 4.
** instead of "opatch auto" in step 4. use below command:
$ opatch auto -rollback $PATCH_TOP

8. Check deinstallation using step 6.


No comments:

Post a Comment