Apply bundle patch in exadata - Eg Patch 17380185

Apply bundle patch in exadata example Patch 17380185: TRACKING BUG FOR 11.2.0.2 EXADATA DATABASE RECOMMENDED PATCH 22(BP22)

Reference: Bug Fix List: the 11.2.0.2 Patch Bundles for Oracle Exadata Database Machine (Doc ID 1314319.1)

Download latest Exadata Bundle patch for 11202,

11.2.0.2.0 Bundle Patch 22 For Exadata (11.2.0.2 BP22) - Patch 17380185

BP22 from 17380185 and unzip in /tmp of Exadata server.

++ Check the version of OPatch both in Grid and Oracle Home.

The version should be more than 11.2.0.1.8 if not download the latest version of OPatch 6880880 and install.

If not follow the link to upgrade to latest version of OPatch

<< http://oracletechdba.blogspot.com/2014/07/installing-latest-version-of-opatch.html >>

++ Run OPatch Conflict Check

/u01/app/11.2.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/Exadata_patch_test/17380185/17380185

Sample Output:

/u01/app/11.2.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/Exadata_patch_test/17380185/17053903

/u01/app/11.2.0/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/Exadata_patch_test/17380185/13603796

For Database home, as home user:

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/Exadata_patch_test/17380185/17380185

Sample output:

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/Exadata_patch_test/17380185/17053903/custom/server/17053903

++ Check for SystemSpace Check

For Grid Infrastructure Home, as home user:

/u01/app/11.2.0/OPatch/opatch prereq CheckSystemSpace -phBaseDir /tmp/Exadata_patch_test/17380185/17380185

Sample Output:

/u01/app/11.2.0/OPatch/opatch prereq CheckSystemSpace -phBaseDir /tmp/Exadata_patch_test/17380185/17053903

/u01/app/11.2.0/OPatch/opatch prereq CheckSystemSpace -phBaseDir /tmp/Exadata_patch_test/17380185/13603796

For Database home, as home user:

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckSystemSpace -phBaseDir /tmp/Exadata_patch_test/17380185/17380185

Sample Output:

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckSystemSpace -phBaseDir /tmp/Exadata_patch_test/17380185/17053903/custom/server/17053903

++ Check the status of the components in HAS

As gird user

crsctl config has

crs_stat –t

++ Stop crs/has(in my case HAS )

crsctl stop has

Check DB or ASM is up

++ Manual applying of patch

Run pre root script. As the root user execute

/u01/app/11.2.0/crs/install/roothas.pl -unlock

As grid user

/u01/app/11.2.0/OPatch/opatch napply -oh /u01/app/11.2.0 -local /tmp/Exadata_patch_test/17380185/17053903

Sample Output:

/u01/app/11.2.0/OPatch/opatch napply -oh /u01/app/11.2.0 -local /tmp/Exadata_patch_test/17380185/17380185

/u01/app/11.2.0/OPatch/opatch napply -oh /u01/app/11.2.0 -local /tmp/Exadata_patch_test/17380185/13603796

++Apply the patch in Oracle Home

As the database home owner execute

/tmp/Exadata_patch_test/17380185/17053903/custom/server/17053903/custom/scripts/prepatch.sh -dbhome /u01/app/oracle/product/11.2.0/db_1

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0/db_1 -local /tmp/Exadata_patch_test/17380185/17053903/custom/server/17053903

/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0/db_1 -local /tmp/Exadata_patch_test/17380185/17380185

/tmp/Exadata_patch_test/17380185/17053903/custom/server/17053903/custom/scripts/postpatch.sh -dbhome u01/app/oracle/product/11.2.0/db_1

++ As the root user execute

/u01/app/11.2.0/rdbms/install/rootadd_rdbms.sh

/u01/app/11.2.0/crs/install/roothas.pl -patch

Check the HAS status.

++ Post installation for Database.

SQL> @?/rdbms/admin/catbundle.sql exa apply

Note: For details other components check README of the patch(BP22)

Note: This is a hand test in vmware exadata