Applying a PSU patch on the GI Home and the Database Home using a Rolling fashion
In this post I’m demonstrating on the startegies involved in applying a PSU patch on the Grid Home and the Database Home using a rolling fashion.
2 Node RAC : 10gnode1 and 10gnode2 Database & Grid Version : 11.2.0.3 PSU Patch : 11.2.0.3.4 (14275572) Database Running : PRIMT DB Service : PRIMT_APPL
on node 10gnode1:
List of patches that have been applied on the GRID Home:
[oracle@10gnode1 ~]$ opatch lsinventory -oh /u01/app/11.2.0/grid3 Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/11.2.0/grid3 Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /u01/app/11.2.0/grid3/cfgtoollogs/opatch/opatch2014-08-24_08-46-26AM.log Lsinventory Output file location : /u01/app/11.2.0/grid3/cfgtoollogs/opatch/lsinv/lsinventory2014-08-24_08-46-26AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Grid Infrastructure 11.2.0.3.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 = 10gnode1 Remote node = 10gnode2 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@10gnode1 ~]$
List of Patches applied on DB Home:
[oracle@10gnode1 ~]$ opatch lsinventory -oh /u01/app/oracle/product/11.2.0/db3 Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db3 Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /u01/app/oracle/product/11.2.0/db3/cfgtoollogs/opatch/opatch2014-08-24_08-46-40AM.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db3/cfgtoollogs/opatch/lsinv/lsinventory2014-08-24_08-46-40AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.3.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 = 10gnode1 Remote node = 10gnode2 --------------------------------------------------------------------------------
On node 10gnode2:
List of patches applied on GRID Home:
[oracle@10gnode2 ~]$ opatch lsinventory -oh /u01/app/11.2.0/grid3 Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/11.2.0/grid3 Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /u01/app/11.2.0/grid3/cfgtoollogs/opatch/opatch2014-08-24_08-50-37AM.log Lsinventory Output file location : /u01/app/11.2.0/grid3/cfgtoollogs/opatch/lsinv/lsinventory2014-08-24_08-50-37AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Grid Infrastructure 11.2.0.3.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 = 10gnode2 Remote node = 10gnode1 -------------------------------------------------------------------------------- OPatch succeeded.
List of Patches applied on DB Home:
[oracle@10gnode2 ~]$ opatch lsinventory -oh /u01/app/oracle/product/11.2.0/db3 Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db3 Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /u01/app/oracle/product/11.2.0/db3/cfgtoollogs/opatch/opatch2014-08-24_08-50-54AM.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db3/cfgtoollogs/opatch/lsinv/lsinventory2014-08-24_08-50-54AM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.3.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 = 10gnode2 Remote node = 10gnode1 -------------------------------------------------------------------------------- OPatch succeeded.
It could be see that there are no patches currently applied on either GRID or DB Homes on both the nodes.
Let’s check the DB instances running on these nodes:
[oracle@10gnode1 ~]$ srvctl status database -d primt -v -f Instance primt1 is running on node 10gnode1 with online services PRIMT_APPL. Instance status: Open. Instance primt2 is running on node 10gnode2. Instance status: Open.
Check if there are any conflicts occurring with the apply of the 11.2.0.3.4 PSU patch on GRID and DB HOME
[oracle@10gnode1 ~]$ opatch prereq CheckConflictAgainstOHWithDetail -ph /opt/112034_GI_PSU/14275605/14275605 -oh /u01/app/11.2.0/grid3 Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/11.2.0/grid3 Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /u01/app/11.2.0/grid3/cfgtoollogs/opatch/opatch2014-08-24_09-54-37AM.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@10gnode1 ~]$ [oracle@10gnode1 ~]$
[oracle@10gnode1 ~]$ opatch prereq CheckConflictAgainstOHWithDetail -ph /opt/112034_GI_PSU/14275605/14275605 -oh /u01/app/oracle/product/11.2.0/db3 Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/11.2.0/db3 Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /u01/app/oracle/product/11.2.0/db3/cfgtoollogs/opatch/opatch2014-08-24_09-54-54AM.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@10gnode1 ~]$
[oracle@10gnode1 ~]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/112034_GI_PSU/14275572 -oh /u01/app/11.2.0/grid3 Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/11.2.0/grid3 Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /u01/app/11.2.0/grid3/cfgtoollogs/opatch/opatch2014-08-24_09-55-30AM.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded. [oracle@10gnode1 ~]$
[oracle@10gnode1 ~]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /opt/112034_GI_PSU/14275572/custom/server/14275572 -oh /u01/app/oracle/product/11.2.0/db3 Invoking OPatch 11.2.0.1.7 Oracle Interim Patch Installer version 11.2.0.1.7 Copyright (c) 2011, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/oracle/product/11.2.0/db3 Central Inventory : /u01/app/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.7 OUI version : 11.2.0.3.0 Log file location : /u01/app/oracle/product/11.2.0/db3/cfgtoollogs/opatch/opatch2014-08-24_09-55-55AM.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
Now, as ROOT user, apply the GI PSU Patch on both GRID Home and DB Home only on node 10gnode1 using OPATCH AUTO command.
[root@10gnode1 ~]# opatch auto /opt/112034_GI_PSU/ -ocmrf /home/oracle/ocm.rsp Executing /u01/app/11.2.0/grid3/perl/bin/perl /u01/app/11.2.0/grid3/OPatch/crs/patch11203.pl -patchdir /opt -patchn 112034_GI_PSU -ocmrf /home/oracle/ocm.rsp -paramfile /u01/app/11.2.0/grid3/crs/install/crsconfig_params This is the main log file: /u01/app/11.2.0/grid3/cfgtoollogs/opatchauto2014-08-24_11-42-53.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/11.2.0/grid3/cfgtoollogs/opatchauto2014-08-24_11-42-53.report.log 2014-08-24 11:42:53: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/11.2.0/grid3/crs/install/crsconfig_params Stopping RAC /u01/app/oracle/product/11.2.0/db3 ... Stopped RAC /u01/app/oracle/product/11.2.0/db3 successfully patch /opt/112034_GI_PSU/14275572/custom/server/14275572 apply successful for home /u01/app/oracle/product/11.2.0/db3 patch /opt/112034_GI_PSU/14275605 apply successful for home /u01/app/oracle/product/11.2.0/db3 Stopping CRS... Stopped CRS successfully patch /opt/112034_GI_PSU/14275572 apply successful for home /u01/app/11.2.0/grid3 patch /opt/112034_GI_PSU/14275605 apply successful for home /u01/app/11.2.0/grid3 Starting CRS... CRS-4123: Oracle High Availability Services has been started. Starting RAC /u01/app/oracle/product/11.2.0/db3 ... Started RAC /u01/app/oracle/product/11.2.0/db3 successfully opatch auto succeeded. [root@10gnode1 ~]#
From the above log, its clear that the patch has been applied successfully on both GRID and DB Homes of node 10gnode1
Lets verify the same.
[oracle@10gnode1 grid3]$ opatch lsinventory -oh /u01/app/11.2.0/grid3
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid3
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid3/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/11.2.0/grid3/cfgtoollogs/opatch/opatch2014-08-24_12-08-16PM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid3/cfgtoollogs/opatch/lsinv/lsinventory2014-08-24_12-08-16PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Grid Infrastructure 11.2.0.3.0
There are 1 product(s) installed in this Oracle Home.
Interim patches (2) :
Patch 14275605 : applied on Sun Aug 24 12:01:58 IST 2014
Unique Patch ID: 15398795
Patch description: "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Created on 3 Oct 2012, 23:24:57 hrs PST8PDT
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
14480676, 13566938, 13419660, 10350832, 13632717, 14063281, 12919564
13624984, 13430938, 13467683, 13588248, 13420224, 14548763, 13080778
12646784, 13804294, 12861463, 12834027, 13377816, 13036331, 12880299
14664355, 13499128, 14409183, 12998795, 12829021, 13492735, 12794305
13503598, 10133521, 12718090, 13742433, 12905058, 12401111, 13742434
13257247, 12849688, 13362079, 12950644, 13742435, 13464002, 12917230
13923374, 12879027, 14613900, 12585543, 12535346, 14480675, 12588744
11877623, 14480674, 13916709, 12847466, 13773133, 14076523, 13649031
13340388, 13366202, 13528551, 13981051, 12894807, 13343438, 12582664
12748240, 12797765, 13385346, 12923168, 13384182, 13612575, 13466801
13484963, 12971775, 11063191, 13772618, 13070939, 12797420, 13035804
13041324, 12976376, 11708510, 13742437, 13737746, 14062795, 13035360
12693626, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
13001379, 14390252, 13099577, 13370330, 13059165, 14062797, 14275605
9873405, 13742436, 9858539, 14062794, 13358781, 12960925, 13699124
12662040, 9703627, 12617123, 13338048, 12938841, 12658411, 12620823
12845115, 12656535, 14062793, 12678920, 12764337, 13354082, 13397104
14062792, 13250244, 12594032, 9761357, 12612118, 13742464, 13550185
13457582, 13527323, 12780983, 12583611, 13502183, 12780098, 13705338
13696216, 13476583, 11840910, 13903046, 13572659, 13718279, 13554409
13657605, 13103913, 14063280
Patch 14275572 : applied on Sun Aug 24 11:58:24 IST 2014
Unique Patch ID: 15398795
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.4 (14275572)"
Created on 12 Oct 2012, 05:40:32 hrs PST8PDT
Bugs fixed:
14275572, 13919095, 13696251, 13348650, 12659561, 13039908, 13825231
13036424, 12794268, 13011520, 13569812, 12758736, 13000491, 13498267
13077654, 13001901, 13550689, 13430715, 13806545, 11675721, 14082976
12771830, 12538907, 13947200, 13066371, 13483672, 12594616, 13540563
12897651, 12897902, 13241779, 12896850, 12726222, 12829429, 12728585
13079948, 12876314, 13090686, 12925041, 12995950, 13251796, 12650672
12398492, 12848480, 13582411, 13652088, 12990582, 13857364, 12975811
12917897, 13082238, 12947871, 13037709, 13371153, 12878750, 10114953
11772838, 13058611, 13001955, 11836951, 12965049, 13440962, 12765467
13727853, 13425727, 12885323, 13965075, 13339443, 12784559, 13332363
13074261, 12971251, 13811209, 12709476, 13460353, 13523527, 12857064
13719731, 13396284, 12899169, 13111013, 13323698, 12867511, 12639013
12959140, 13085732, 12829917, 10317921, 13843080, 12934171, 12849377
12349553, 13924431, 13869978, 12680491, 12914824, 13789135, 12730342
13334158, 12950823, 10418841, 13355963, 13531373, 13776758, 12720728
13620816, 13002015, 13023609, 13024624, 12791719, 13886023, 13255295
13821454, 12782756, 14625969, 14152875, 14186070, 12873909, 14214257
12914722, 13243172, 12842804, 13045518, 12765868, 12772345, 12663376
13345868, 14059576, 13683090, 12932852, 13889047, 12695029, 13146560
13038806, 14251904, 14070200, 13820621, 14304758, 13396356, 13697828
13258062, 12834777, 12996572, 13941934, 13657366, 13019958, 12810890
13888719, 13502441, 13726162, 13880925, 14153867, 13506114, 12820045
13604057, 12823838, 13877508, 12823042, 14494305, 13582706, 13617861
12825835, 13263435, 13025879, 13853089, 14009845, 13410987, 13570879
13637590, 12827493, 13247273, 13068077
Rac system comprising of multiple nodes
Local node = 10gnode1
Remote node = 10gnode2
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@10gnode1 grid3]$
[oracle@10gnode1 grid3]$ opatch lsinventory -oh /u01/app/oracle/product/11.2.0/db3
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db3
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db3/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db3/cfgtoollogs/opatch/opatch2014-08-24_12-08-26PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db3/cfgtoollogs/opatch/lsinv/lsinventory2014-08-24_12-08-26PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 product(s) installed in this Oracle Home.
Interim patches (2) :
Patch 14275605 : applied on Sun Aug 24 11:49:55 IST 2014
Unique Patch ID: 15398795
Patch description: "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Created on 3 Oct 2012, 23:24:57 hrs PST8PDT
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
14480676, 13566938, 13419660, 10350832, 13632717, 14063281, 12919564
13624984, 13430938, 13467683, 13588248, 13420224, 14548763, 13080778
12646784, 13804294, 12861463, 12834027, 13377816, 13036331, 12880299
14664355, 13499128, 14409183, 12998795, 12829021, 13492735, 12794305
13503598, 10133521, 12718090, 13742433, 12905058, 12401111, 13742434
13257247, 12849688, 13362079, 12950644, 13742435, 13464002, 12917230
13923374, 12879027, 14613900, 12585543, 12535346, 14480675, 12588744
11877623, 14480674, 13916709, 12847466, 13773133, 14076523, 13649031
13340388, 13366202, 13528551, 13981051, 12894807, 13343438, 12582664
12748240, 12797765, 13385346, 12923168, 13384182, 13612575, 13466801
13484963, 12971775, 11063191, 13772618, 13070939, 12797420, 13035804
13041324, 12976376, 11708510, 13742437, 13737746, 14062795, 13035360
12693626, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
13001379, 14390252, 13099577, 13370330, 13059165, 14062797, 14275605
9873405, 13742436, 9858539, 14062794, 13358781, 12960925, 13699124
12662040, 9703627, 12617123, 13338048, 12938841, 12658411, 12620823
12845115, 12656535, 14062793, 12678920, 12764337, 13354082, 13397104
14062792, 13250244, 12594032, 9761357, 12612118, 13742464, 13550185
13457582, 13527323, 12780983, 12583611, 13502183, 12780098, 13705338
13696216, 13476583, 11840910, 13903046, 13572659, 13718279, 13554409
13657605, 13103913, 14063280
Patch 14275572 : applied on Sun Aug 24 11:45:00 IST 2014
Unique Patch ID: 15398795
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.4 (14275572)"
Created on 12 Oct 2012, 05:40:32 hrs PST8PDT
Bugs fixed:
14275572, 13919095, 13696251, 13348650, 12659561, 13039908, 13825231
13036424, 12794268, 13011520, 13569812, 12758736, 13000491, 13498267
13077654, 13001901, 13550689, 13430715, 13806545, 11675721, 14082976
12771830, 12538907, 13947200, 13066371, 13483672, 12594616, 13540563
12897651, 12897902, 13241779, 12896850, 12726222, 12829429, 12728585
13079948, 12876314, 13090686, 12925041, 12995950, 13251796, 12650672
12398492, 12848480, 13582411, 13652088, 12990582, 13857364, 12975811
12917897, 13082238, 12947871, 13037709, 13371153, 12878750, 10114953
11772838, 13058611, 13001955, 11836951, 12965049, 13440962, 12765467
13727853, 13425727, 12885323, 13965075, 13339443, 12784559, 13332363
13074261, 12971251, 13811209, 12709476, 13460353, 13523527, 12857064
13719731, 13396284, 12899169, 13111013, 13323698, 12867511, 12639013
12959140, 13085732, 12829917, 10317921, 13843080, 12934171, 12849377
12349553, 13924431, 13869978, 12680491, 12914824, 13789135, 12730342
13334158, 12950823, 10418841, 13355963, 13531373, 13776758, 12720728
13620816, 13002015, 13023609, 13024624, 12791719
Rac system comprising of multiple nodes
Local node = 10gnode1
Remote node = 10gnode2
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@10gnode1 grid3]$
Now proceed with the same step of applying the PSU patch on GRID and DB home using OPATCH AUTO command as ROOT user on node 10gnode2.
[root@10gnode2 ~]# opatch auto /opt/112034_GI_PSU/ -ocmrf /home/oracle/ocm.rsp
Executing /u01/app/11.2.0/grid3/perl/bin/perl /u01/app/11.2.0/grid3/OPatch/crs/patch11203.pl -patchdir /opt -patchn 112034_GI_PSU -ocmrf /home/oracle/ocm.rsp -paramfile /u01/app/11.2.0/grid3/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid3/cfgtoollogs/opatchauto2014-08-24_12-26-02.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid3/cfgtoollogs/opatchauto2014-08-24_12-26-02.report.log
2014-08-24 12:26:02: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid3/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db3 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db3 successfully
patch /opt/112034_GI_PSU/14275572/custom/server/14275572 apply successful for home /u01/app/oracle/product/11.2.0/db3
patch /opt/112034_GI_PSU/14275605 apply successful for home /u01/app/oracle/product/11.2.0/db3
Stopping CRS...
Stopped CRS successfully
patch /opt/112034_GI_PSU/14275572 apply successful for home /u01/app/11.2.0/grid3
patch /opt/112034_GI_PSU/14275605 apply successful for home /u01/app/11.2.0/grid3
Starting CRS...
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/db3 ...
Started RAC /u01/app/oracle/product/11.2.0/db3 successfully
opatch auto succeeded.
As stated, from the above log, the patch has been applied successfully on both the homes of both nodes.
Just crosschecking using "opatch lsinventory" on both the homes.
[oracle@10gnode2 ~]$ /u01/app/11.2.0/grid3/OPatch/opatch lsinventory -oh /u01/app/11.2.0/grid3
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid3
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid3/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/11.2.0/grid3/cfgtoollogs/opatch/opatch2014-08-24_12-48-00PM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid3/cfgtoollogs/opatch/lsinv/lsinventory2014-08-24_12-48-00PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Grid Infrastructure 11.2.0.3.0
There are 1 product(s) installed in this Oracle Home.
Interim patches (2) :
Patch 14275605 : applied on Sun Aug 24 12:43:06 IST 2014
Unique Patch ID: 15398795
Patch description: "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Created on 3 Oct 2012, 23:24:57 hrs PST8PDT
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
14480676, 13566938, 13419660, 10350832, 13632717, 14063281, 12919564
13624984, 13430938, 13467683, 13588248, 13420224, 14548763, 13080778
12646784, 13804294, 12861463, 12834027, 13377816, 13036331, 12880299
14664355, 13499128, 14409183, 12998795, 12829021, 13492735, 12794305
13503598, 10133521, 12718090, 13742433, 12905058, 12401111, 13742434
13257247, 12849688, 13362079, 12950644, 13742435, 13464002, 12917230
13923374, 12879027, 14613900, 12585543, 12535346, 14480675, 12588744
11877623, 14480674, 13916709, 12847466, 13773133, 14076523, 13649031
13340388, 13366202, 13528551, 13981051, 12894807, 13343438, 12582664
12748240, 12797765, 13385346, 12923168, 13384182, 13612575, 13466801
13484963, 12971775, 11063191, 13772618, 13070939, 12797420, 13035804
13041324, 12976376, 11708510, 13742437, 13737746, 14062795, 13035360
12693626, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
13001379, 14390252, 13099577, 13370330, 13059165, 14062797, 14275605
9873405, 13742436, 9858539, 14062794, 13358781, 12960925, 13699124
12662040, 9703627, 12617123, 13338048, 12938841, 12658411, 12620823
12845115, 12656535, 14062793, 12678920, 12764337, 13354082, 13397104
14062792, 13250244, 12594032, 9761357, 12612118, 13742464, 13550185
13457582, 13527323, 12780983, 12583611, 13502183, 12780098, 13705338
13696216, 13476583, 11840910, 13903046, 13572659, 13718279, 13554409
13657605, 13103913, 14063280
Patch 14275572 : applied on Sun Aug 24 12:39:47 IST 2014
Unique Patch ID: 15398795
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.4 (14275572)"
Created on 12 Oct 2012, 05:40:32 hrs PST8PDT
Bugs fixed:
14275572, 13919095, 13696251, 13348650, 12659561, 13039908, 13825231
13036424, 12794268, 13011520, 13569812, 12758736, 13000491, 13498267
13077654, 13001901, 13550689, 13430715, 13806545, 11675721, 14082976
12771830, 12538907, 13947200, 13066371, 13483672, 12594616, 13540563
12897651, 12897902, 13241779, 12896850, 12726222, 12829429, 12728585
13079948, 12876314, 13090686, 12925041, 12995950, 13251796, 12650672
12398492, 12848480, 13582411, 13652088, 12990582, 13857364, 12975811
12917897, 13082238, 12947871, 13037709, 13371153, 12878750, 10114953
11772838, 13058611, 13001955, 11836951, 12965049, 13440962, 12765467
13727853, 13425727, 12885323, 13965075, 13339443, 12784559, 13332363
13074261, 12971251, 13811209, 12709476, 13460353, 13523527, 12857064
13719731, 13396284, 12899169, 13111013, 13323698, 12867511, 12639013
12959140, 13085732, 12829917, 10317921, 13843080, 12934171, 12849377
12349553, 13924431, 13869978, 12680491, 12914824, 13789135, 12730342
13334158, 12950823, 10418841, 13355963, 13531373, 13776758, 12720728
13620816, 13002015, 13023609, 13024624, 12791719, 13886023, 13255295
13821454, 12782756, 14625969, 14152875, 14186070, 12873909, 14214257
12914722, 13243172, 12842804, 13045518, 12765868, 12772345, 12663376
13345868, 14059576, 13683090, 12932852, 13889047, 12695029, 13146560
13038806, 14251904, 14070200, 13820621, 14304758, 13396356, 13697828
13258062, 12834777, 12996572, 13941934, 13657366, 13019958, 12810890
13888719, 13502441, 13726162, 13880925, 14153867, 13506114, 12820045
13604057, 12823838, 13877508, 12823042, 14494305, 13582706, 13617861
12825835, 13263435, 13025879, 13853089, 14009845, 13410987, 13570879
13637590, 12827493, 13247273, 13068077
Rac system comprising of multiple nodes
Local node = 10gnode2
Remote node = 10gnode1
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@10gnode2 ~]$
[oracle@10gnode2 ~]$ /u01/app/11.2.0/grid3/OPatch/opatch lsinventory -oh /u01/app/oracle/product/11.2.0/db3
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db3
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db3/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db3/cfgtoollogs/opatch/opatch2014-08-24_12-48-10PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db3/cfgtoollogs/opatch/lsinv/lsinventory2014-08-24_12-48-10PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 product(s) installed in this Oracle Home.
Interim patches (2) :
Patch 14275605 : applied on Sun Aug 24 12:31:43 IST 2014
Unique Patch ID: 15398795
Patch description: "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Created on 3 Oct 2012, 23:24:57 hrs PST8PDT
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
14480676, 13566938, 13419660, 10350832, 13632717, 14063281, 12919564
13624984, 13430938, 13467683, 13588248, 13420224, 14548763, 13080778
12646784, 13804294, 12861463, 12834027, 13377816, 13036331, 12880299
14664355, 13499128, 14409183, 12998795, 12829021, 13492735, 12794305
13503598, 10133521, 12718090, 13742433, 12905058, 12401111, 13742434
13257247, 12849688, 13362079, 12950644, 13742435, 13464002, 12917230
13923374, 12879027, 14613900, 12585543, 12535346, 14480675, 12588744
11877623, 14480674, 13916709, 12847466, 13773133, 14076523, 13649031
13340388, 13366202, 13528551, 13981051, 12894807, 13343438, 12582664
12748240, 12797765, 13385346, 12923168, 13384182, 13612575, 13466801
13484963, 12971775, 11063191, 13772618, 13070939, 12797420, 13035804
13041324, 12976376, 11708510, 13742437, 13737746, 14062795, 13035360
12693626, 13742438, 13326736, 13332439, 14038787, 14062796, 12913474
13001379, 14390252, 13099577, 13370330, 13059165, 14062797, 14275605
9873405, 13742436, 9858539, 14062794, 13358781, 12960925, 13699124
12662040, 9703627, 12617123, 13338048, 12938841, 12658411, 12620823
12845115, 12656535, 14062793, 12678920, 12764337, 13354082, 13397104
14062792, 13250244, 12594032, 9761357, 12612118, 13742464, 13550185
13457582, 13527323, 12780983, 12583611, 13502183, 12780098, 13705338
13696216, 13476583, 11840910, 13903046, 13572659, 13718279, 13554409
13657605, 13103913, 14063280
Patch 14275572 : applied on Sun Aug 24 12:27:58 IST 2014
Unique Patch ID: 15398795
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.4 (14275572)"
Created on 12 Oct 2012, 05:40:32 hrs PST8PDT
Bugs fixed:
14275572, 13919095, 13696251, 13348650, 12659561, 13039908, 13825231
13036424, 12794268, 13011520, 13569812, 12758736, 13000491, 13498267
13077654, 13001901, 13550689, 13430715, 13806545, 11675721, 14082976
12771830, 12538907, 13947200, 13066371, 13483672, 12594616, 13540563
12897651, 12897902, 13241779, 12896850, 12726222, 12829429, 12728585
13079948, 12876314, 13090686, 12925041, 12995950, 13251796, 12650672
12398492, 12848480, 13582411, 13652088, 12990582, 13857364, 12975811
12917897, 13082238, 12947871, 13037709, 13371153, 12878750, 10114953
11772838, 13058611, 13001955, 11836951, 12965049, 13440962, 12765467
13727853, 13425727, 12885323, 13965075, 13339443, 12784559, 13332363
13074261, 12971251, 13811209, 12709476, 13460353, 13523527, 12857064
13719731, 13396284, 12899169, 13111013, 13323698, 12867511, 12639013
12959140, 13085732, 12829917, 10317921, 13843080, 12934171, 12849377
12349553, 13924431, 13869978, 12680491, 12914824, 13789135, 12730342
13334158, 12950823, 10418841, 13355963, 13531373, 13776758, 12720728
13620816, 13002015, 13023609, 13024624, 12791719
Rac system comprising of multiple nodes
Local node = 10gnode2
Remote node = 10gnode1
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@10gnode2 ~]$
Here we go !!
COPYRIGHT
© Shivananda Rao P, 2012 to 2018. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Shivananda Rao and http://www.shivanandarao-oracle.com with appropriate and specific direction to the original content.
DISCLAIMER
The views expressed here are my own and do not necessarily reflect the views of any other individual, business entity, or organization. The views expressed by visitors on this blog are theirs solely and may not reflect mine.
Shivananda Rao 
Leave a Reply