Applying PSU 12.1.0.2.160119 (JAN2016) for GI and DB Oracle RAC

This article is created just as a refferal to apply the PSU 12.1.0.2.160119 (JAN2016) for 3 node cluster and few tiff's which I have faced. Do refer the readme file before executing the PSU. Perform below steps before you execute the Patch.

1. Take a backup of Optach lsinventory on each node for GRID as well as ORACLE user.
2. Download the latest and gretest patches.
3. Create the ocm response files.
4. Have proper permission set for the patches.

If you need further in details do refer to Apply the latest PSU5 for 12.1.0.2 RAC Database ( http://sajidkhadarabad.blogspot.com/2015/08/apply-latest-psu5-for-12102-rac-database.html ) (Scroll down) in my blog .

So lets jump in and start executing the patch.

[root@SajidServer01 ~]# cd /usr/12.1.0.2/grid/OPatch/
[root@SajidServer01 OPatch]# ./opatchauto apply  <Location of your Patch> -ocmrf  <Location of your ocm.rsp file>
OPatch Automation Tool
Copyright (c)2014, Oracle Corporation. All rights reserved.

OPatchauto Version : 12.1.0.1.10
OUI Version        : 12.1.0.2.0
Running from       : /usr/12.1.0.2/grid

opatchauto log file: /usr/12.1.0.2/grid/cfgtoollogs/opatchauto/22191349/opatch_gi_deploy.log

Parameter Validation: Successful

Configuration Validation: Successful

Patch Location: /usr/oracle/patches/psu/22191349
Grid Infrastructure Patch(es): 21436941 21948341 21948344 21948354
DB Patch(es): 21948344 21948354


The following patch(es) are duplicate patches with patches installed in the Oracle Home.
 [ 21436941]
You have already installed same patch(es) with same UPI(s) or same version(s).
These patch(es) will be skipped.

Opatchauto skipped installing the above patch in /usr/12.1.0.2/grid


The following patch(es) are duplicate patches with patches installed in the Oracle Home.
 [ 21359755]
You have already installed same patch(es) with same UPI(s) or same version(s).
These patch(es) will be skipped.

Opatchauto skipped installing the above patch in /usr/12.1.0.2/grid


The following patch(es) are duplicate patches with patches installed in the Oracle Home.
 [ 20831110]
You have already installed same patch(es) with same UPI(s) or same version(s).
These patch(es) will be skipped.

Opatchauto skipped installing the above patch in /usr/12.1.0.2/grid


The following patch(es) are duplicate patches with patches installed in the Oracle Home.
 [ 20299023]
You have already installed same patch(es) with same UPI(s) or same version(s).
These patch(es) will be skipped.

Opatchauto skipped installing the above patch in /usr/12.1.0.2/grid


The following patch(es) are duplicate patches with patches installed in the Oracle Home.
 [ 19769480]
You have already installed same patch(es) with same UPI(s) or same version(s).
These patch(es) will be skipped.

Opatchauto skipped installing the above patch in /usr/12.1.0.2/grid

Patch Validation: Successful
Grid Infrastructure home:
/usr/12.1.0.2/grid
DB home(s):
/usr/oracle/product/12.1.0.2



Performing prepatch operations on CRS Home...

Applying patch(es) to "/usr/oracle/product/12.1.0.2" ...
Patch "/usr/oracle/patches/psu/22191349/21948344" successfully applied to "/usr/oracle/product/12.1.0.2".
Patch "/usr/oracle/patches/psu/22191349/21948354" successfully applied to "/usr/oracle/product/12.1.0.2".

Applying patch(es) to "/usr/12.1.0.2/grid" ...
Patch "/usr/oracle/patches/psu/22191349/21436941" applied to "/usr/12.1.0.2/grid" with warning.
Patch "/usr/oracle/patches/psu/22191349/21948341" applied to "/usr/12.1.0.2/grid" with warning.
Patch "/usr/oracle/patches/psu/22191349/21948344" applied to "/usr/12.1.0.2/grid" with warning.
Patch "/usr/oracle/patches/psu/22191349/21948354" applied to "/usr/12.1.0.2/grid" with warning.

Performing postpatch operations on CRS Home...

SQL changes, if any, are applied successfully on the following database(s): SajidDB

Apply Summary:
Following patch(es) are successfully installed:
DB Home: /usr/oracle/product/12.1.0.2: 21948344,21948354

opatchauto ran into some warnings during patch installation (Please see log file for details):
GI Home: /usr/12.1.0.2/grid: 21436941,21948341,21948344,21948354

opatchauto completed with warnings.


Hallelujah patch installation is done.

########
Issue 1:
########
Clusterware is either not running or not configured. You have the following 2 options:

1. Configure and start the Clusterware on this node and re-run the tool
2. Run the tool with '-oh <GI_HOME>' to first patch the Grid Home, then invoke tool with '-database <oracle database name>' or '-oh <RAC_HOME>' to patch the RAC home
Parameter Validation: FAILED

Opatchauto Session failed: Parameter validation failed
Exception in thread "main" java.lang.RuntimeException: java.io.IOException: Stream closed
        at oracle.opatchauto.gi.GILogger.writeWithoutTimeStamp(GILogger.java:432)
        at oracle.opatchauto.gi.GILogger.printStackTrace(GILogger.java:447)
        at oracle.opatchauto.gi.OPatchauto.main(OPatchauto.java:97)
Caused by: java.io.IOException: Stream closed
        at java.io.BufferedWriter.ensureOpen(BufferedWriter.java:98)
        at java.io.BufferedWriter.write(BufferedWriter.java:203)
        at java.io.Writer.write(Writer.java:140)
        at oracle.opatchauto.gi.GILogger.writeWithoutTimeStamp(GILogger.java:426)
        ... 2 more

Workaround:

Make sure rootcrs.pl is in lock mode. Reboot the cluster services and do a clean patch install as super user.

#########
Issue 2:
#########
Running prerequisite checks…
Prerequisite check “Check Patch Applicable On Current Platform” failed.
Patch is not applicable on current platform.
Platform ID needed is : 46
Platform IDs supported by patch are: 226
UtilSession failed: Prerequisite check “CheckPatchApplicableOnCurrentPlatform” failed.
OPatch failed with error code 73

Workaround:

export OPATCH_PLATFORM_ID=226 and kickoff the patch again