4 Replies Latest reply: Sep 20, 2012 1:04 PM by Srini Chavali-Oracle RSS

    OPatch inventory doesn't show latest PSU

    eman
      We just finished applying the 11.2.0.2.7 PSU patch to one of our stand-alone Linux servers. Both GI and DB were already at 11.2.0.2.6. We applied it to both GI and DB together as a bundle and it was successfull. However whenever we do an opatch lsinventory from the GRID_HOME, we don't see 11.2.0.2.7 for GI. We see it for DB but not GI. Is that something to be concerned about? Any explanation to help understand this would be greatly appreciated. Thanks
        • 1. Re: OPatch inventory doesn't show latest PSU
          eman
          attached is the output from lsinventory:

          --------------------------------------------------------------------------------
          Installed Top-level Products (1):

          Oracle Grid Infrastructure 11.2.0.2.0
          There are 1 products installed in this Oracle Home.


          Interim patches (2) :

          Patch 13923804 : applied on Wed Sep 19 16:05:22 CDT 2012
          Unique Patch ID: 14966512
          Patch description: "Database Patch Set Update : 11.2.0.2.7 (13923804)"
          Created on 11 Jun 2012, 07:29:27 hrs PST8PDT
          Sub-patch 13696224; "Database Patch Set Update : 11.2.0.2.6 (13696224)"
          Bugs fixed:
          10378005, 10115630, 9835264, 10422126, 10373381, 11818335, 10281887
          10035737, 11707302, 12737666, 11065646, 13769501, 12639234, 10317487
          12586488, 13386082, 10630870, 10151017, 9727147, 10322959, 12586495
          12880299, 9715581, 10245086, 10218814, 10332111, 10205230, 10158965
          11937253, 11733179, 10367188, 9829397, 12830339, 10278773, 14107387
          9651350, 11882425, 11683713, 12586489, 10419629, 12586494, 12337012
          14107388, 10097711, 10388660, 12950644, 9788588, 10113990, 12370722
          10239480, 12586491, 6523037, 9842573, 10417716, 9414040, 12879027
          11724916, 12586492, 10200404, 10232083, 13769503, 9578670, 12685431
          9881076, 10399808, 10285022, 11877623, 10248523, 10157402, 9709292
          12586493, 11830778, 9972680, 10207092, 10092858, 12586490, 12546006
          11800170, 9683047, 12797765, 12391602, 10417216, 10635701, 12586487
          11830777, 13769509, 10055063, 9869401, 10157249, 10131867, 10648873
          10419984, 10077191, 11063191, 13632725, 9970255, 10220033, 13468884
          11830776, 11858315, 11061775, 10633840, 12976376, 11695333, 11708510
          10127360, 10396041, 10190642, 10233732, 10200390, 10142909, 10209232
          10237773, 12366627, 11664046, 10019218, 12569737, 11666137, 10061015
          14107389, 13001379, 9672816, 11695416, 13099577, 9744252, 10222719
          9873405, 9858539, 10620808, 11694127, 9819805, 11872103, 10165083
          10193846, 13769502, 11894889, 10285394, 12827726, 9375300, 9382956
          10204358, 14040433, 11723722, 10264696, 10264680, 13769508, 11842991
          10080579, 11738259, 10084145, 9436324, 10358019, 10089333, 10363186
          12670165, 14038791, 10324294, 14107384, 10158493, 10013177, 10155605
          13343424, 8672862, 10013431, 9956713, 12586496, 11674485, 13476583
          12639177, 11853815, 10126822, 10180307, 10284570, 10048701, 10329146
          12828071, 10079168, 12423475, 10326338, 11064851, 13923804, 12655433
          10314582, 9771278, 10356782, 10051315, 12326246, 14127510, 10332589
          13769506, 10368698, 10229719, 12340939, 9966609, 12586486, 9724970
          11651810, 13769507, 11815753, 9905049, 9078442, 10053725, 10229886
          10137324, 13769504, 10219576, 12378147, 9735237, 9869287, 10217802
          10142788, 12846268, 10129643, 12539000, 12400751, 11724984, 10022980
          9735282, 13503598, 10040921, 11695285, 12595730, 9591812, 13343244
          9906422, 12371955, 12633340, 9746210, 13257247, 10039731, 12917230
          9770451, 10021022, 12846269, 11674898, 10110863, 13769505, 12579349
          11067567, 10411618, 11699057, 10425676, 13916709, 9824435, 12635537
          6892311, 11841309, 10031806, 11707699, 9895207, 11076894, 11890804
          10170431, 10018789, 10299224, 12748240, 9965655, 12323180, 11800854
          11866952, 12531263, 10636231, 10384285, 10219583, 11069199, 12417369
          9539440, 12419331, 11689702, 10324526, 10427260, 12543639, 13696224
          10622001, 14107385, 10227288, 11867127, 11814891, 10258337, 11690639
          9847634, 9285259, 10621169, 10284838, 10159846, 10142857, 10082277
          10187168, 10269503, 11785390, 10310299, 12596444, 10412247, 9564886
          12431716, 14107386, 10102506, 11785938, 10238786, 10132870, 11827088
          10302581, 12569482, 10278372, 12397410, 9953542, 9795214, 9707965
          9443361, 10126094, 10073683, 9572787, 11811073, 10230571, 12419321
          12656535, 10312847, 11800959, 9943960, 13769510, 10052141, 12408350
          10052956, 10040531, 9903826, 11056082, 10040035, 10026601, 12620422
          8685446, 8223165, 9401552, 10094823, 12780098, 11716621, 12589039
          10228151, 10623249, 11893621, 10249791, 10356513, 12345717, 11788856
          11057263, 11664719, 9748749, 11670161, 13554409, 11924400, 11889177, 10094201

          Patch 13696242 : applied on Wed May 02 12:10:26 CDT 2012
          Unique Patch ID: 14617280
          Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.2.6 (13696242)"
          Created on 4 Apr 2012, 05:37:11 hrs PST8PDT
          Bugs fixed:
          13696242, 10157506, 10178670, 10425672, 12311357, 12419353, 12827731
          13343447, 13653086, 9959110, 10374874, 10272615, 10314123, 10014392
          10089120, 10057296, 11692271, 9864003, 11775080, 13635562, 9916145
          12695202, 12593451, 10044622, 11705438, 10365625, 12767231, 9935308
          12399977, 11882456, 12421404, 12862012, 11744343, 12340700, 10056713
          10637741, 9939306, 9795321, 9902536, 10007185, 10376847, 10038791
          11741224, 12823479, 11655840, 10048487, 10322157, 11768599, 10260251
          10052721, 10028235, 10027079, 12412303, 10357258, 11664015, 11871469
          10045436, 10231906, 12722095, 10622973, 11724464, 9891341, 10072474
          10036834, 10029900, 9974223, 10161846, 10016083, 12597463, 9918485
          11781515, 10040647, 13332363, 12651595, 12345151, 11925641, 10069541
          10029119, 12709476, 10233159, 12332919, 9812956, 10036193, 10015210
          12424479, 12340501, 10621175, 9686152, 12556028, 12605690, 11877079
          8906163, 10111010, 12366642, 11777648, 10115514, 10104377, 10121931
          10057680, 10280665, 10078086, 9944948, 10146768, 10052529, 10011084
          10012319, 10073075, 10233811, 12720728, 10299006, 12426375, 10248739
          10236074, 10128191, 11071429, 10019726, 9975837, 10253630, 12615394
          10420872, 9949676, 11936945, 11820787, 10637483, 13036424, 13396479
          10379703, 12677816, 10157622, 11698552, 10385838, 10053985, 12718811
          10229297, 10425674, 9812970, 11828633, 12538907, 12359585, 11899801
          10083789, 12728585, 9876201, 10073372, 9963327, 10428946, 11077756
          10375649, 12398492, 9336825, 11682409, 10062301, 12767563, 12546712
          10018215, 10105195, 10419987, 13355549, 10071992, 11807012, 10634513
          9926027, 10103954, 12743755, 12406573, 10028343, 12425730, 11768055
          11866171, 10065216, 9907089, 9897335, 10190153, 11744313, 10175855
          12600343, 12422324, 10284828, 10028637, 10361177, 12800501, 9979706
          12950415, 10324594, 10015460, 11818524, 9971646, 11782423, 11654726
          9978765, 10398810, 11904778, 10397652, 13768473, 9915329, 10107380
          10110969, 10305361, 10331452, 10083009, 10631693, 10008467, 10048027
          10040109, 9944978, 10370797, 10033106, 12700217, 11840629, 10042143
          9978195, 10284693, 12639016, 10638381, 11839004, 9679401, 11663339
          10075643, 10057719, 11834289, 9458055, 10205290, 10124517, 12680491
          13334158, 11069614, 10165314, 9593552, 10168006, 12645334, 10241696
          9942881, 12724761, 10157625, 10216878, 10045316, 10425675, 10061534
          11789566, 10283549, 12700050, 12732899, 12433819, 12378675, 10113899
          13019958, 12614853, 9861790, 13396487, 10146744, 10326548, 9975343
          9936659, 10244210, 10029794, 12545774, 13025879, 13410987, 10268642
          13247273, 12862020, 12747467, 10283596, 12594736, 9867867, 11846686
          13255295, 10228079, 10015603, 10283058, 10252497, 9758286, 10283167
          13045518, 9906432, 12932852, 10150020, 10311856, 12421420, 13146653
          12681864, 13258062, 12810890, 12694821, 10069698, 13502441, 10056808
          10087118, 12433511, 10019796, 13768482, 10266447, 13446398, 10193581
          11804097, 12318560, 10070563, 11058691, 13637590, 13068077, 12591990



          --------------------------------------------------------------------------------
          • 2. Re: OPatch inventory doesn't show latest PSU
            Srini Chavali-Oracle
            Pl post OS details along with the exact patch number that was applied and the OPatch log for the GI home

            The database 11.2.0.2.7 patch is 13923804, while the 11.2.0.2.7 GI patch is 14192201

            Oracle Recommended Patches -- Oracle Database [ID 756671.1]

            HTH
            Srini
            • 3. Re: OPatch inventory doesn't show latest PSU
              eman
              The OS is OEL 5.7.
              uname -a
              Linux uxdpsdbd1.alldata.net 2.6.32-200.13.1.el5uek #1 SMP Wed Jul 27 21:02:33 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

              We downloaded patch 14192201 (p14192201_112020_Linux-x86-64.zip), which as you mentioned is GI 11.2.0.2.7. When we unzipped it, it created two directories ... 13923804 (DB 11.2.0.2.7) and 13696242 (GI 11.2.0.2.6). I thought that was odd because I was expecting a directory 14192201.

              Below is the OPatch log. You'll notice in the log that first 13696242 is applied to the DB home. Then it attempted to apply 13923804 to the DB home but failed because of some active processes. Next it attempted to apply 13696242 to the GI home but it was already at the level so nothing happened there. Lastly it applied 13923804 to the GI home. Now I'm wondering if the zip file for 14192201 ever came with GI 11.2.0.2.7? I'm getting more confused. Any help to clarify this would be greatly appreciated.

              PS - we ran opatch again so that 13923804 was applied to the DB home (it failed earlier because of some active processes)
              ****************
              ...
              2012-09-19 16:03:43: s_run_as_user2: Running /bin/su oracle -c ' /develop/dbawork/software/patches/11.2.0.2.7/13696242/custom/server/13696242/custom/scripts/prepatch.sh -dbhome /develop/u00/
              app/oracle/product/11.2.0/database '
              2012-09-19 16:03:43: Removing file /tmp/fileKgxwDJ
              2012-09-19 16:03:43: Successfully removed file: /tmp/fileKgxwDJ
              2012-09-19 16:03:43: /bin/su successfully executed

              2012-09-19 16:03:43: Running as user oracle: true
              2012-09-19 16:03:43: s_run_as_user2: Running /bin/su oracle -c ' true '
              2012-09-19 16:03:43: Removing file /tmp/file5Pp4Ya
              2012-09-19 16:03:43: Successfully removed file: /tmp/file5Pp4Ya
              2012-09-19 16:03:43: /bin/su successfully executed

              2012-09-19 16:03:43: prepatch execution for DB home ... success
              2012-09-19 16:03:43: Oracle user for /develop/u00/app/oracle/product/11.2.0/database is oracle
              2012-09-19 16:03:43: Executing command /develop/u00/app/oracle/product/11.2.0/database/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13696242/custom/server/13696242 -loca
              l -silent -ocmrf /develop/u00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/database as oracle
              2012-09-19 16:03:43: Running as user oracle: /develop/u00/app/oracle/product/11.2.0/database/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13696242/custom/server/13696242
              -local -silent -ocmrf /develop/u00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/database
              2012-09-19 16:03:43: s_run_as_user2: Running /bin/su oracle -c ' /develop/u00/app/oracle/product/11.2.0/database/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13696242/cu
              stom/server/13696242 -local -silent -ocmrf /develop/u00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/database '
              2012-09-19 16:04:09: Removing file /tmp/fileTux4nC
              2012-09-19 16:04:09: Successfully removed file: /tmp/fileTux4nC
              2012-09-19 16:04:09: /bin/su successfully executed

              2012-09-19 16:04:09: status of apply patch is 0
              2012-09-19 16:04:09: The apply patch output is Oracle Interim Patch Installer version 11.2.0.3.0
              Copyright (c) 2012, Oracle Corporation. All rights reserved.


              Oracle Home : /develop/u00/app/oracle/product/11.2.0/database
              Central Inventory : /develop/u00/app/oraInventory
              from : /develop/u00/app/oracle/product/11.2.0/database/oraInst.loc
              OPatch version : 11.2.0.3.0
              OUI version : 11.2.0.2.0
              Log file location : /develop/u00/app/oracle/product/11.2.0/database/cfgtoollogs/opatch/opatch2012-09-19_16-03-44PM_1.log

              Verifying environment and performing prerequisite checks...
              OPatch continues with these patches: 13696242

              Do you want to proceed? y
              Y (auto-answered by -silent)
              User Responded with: Y
              All checks passed.

              Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
              (Oracle Home = '/develop/u00/app/oracle/product/11.2.0/database')


              Is the local system ready for patching? y
              Y (auto-answered by -silent)
              User Responded with: Y
              Backing up files...
              Applying interim patch '13696242' to OH '/develop/u00/app/oracle/product/11.2.0/database'

              Patching component oracle.rdbms, 11.2.0.2.0...

              Verifying the update...

              OPatch found the word "warning" in the stderr of the make command.
              Please look at this stderr. You can re-run this make command.
              Stderr output:
              ins_srvm.mk:68: warning: overriding commands for target `libsrvm11.so'
              ins_srvm.mk:31: warning: ignoring old commands for target `libsrvm11.so'
              ins_srvm.mk:71: warning: overriding commands for target `libsrvmocr11.so'
              ins_srvm.mk:34: warning: ignoring old commands for target `libsrvmocr11.so'
              ins_srvm.mk:74: warning: overriding commands for target `libsrvmhas11.so'
              ins_srvm.mk:37: warning: ignoring old commands for target `libsrvmhas11.so'


              Patch 13696242 successfully applied.
              OPatch Session completed with warnings.
              Log file location: /develop/u00/app/oracle/product/11.2.0/database/cfgtoollogs/opatch/opatch2012-09-19_16-03-44PM_1.log

              OPatch completed with warnings.

              2012-09-19 16:04:09: patch /develop/dbawork/software/patches/11.2.0.2.7/13696242/custom/server/13696242 apply successful for home /develop/u00/app/oracle/product/11.2.0/database
              2012-09-19 16:04:09: Executing command /develop/u00/app/oracle/product/11.2.0/database/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13923804 -local -silent -ocmrf /devel
              op/u00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/database as oracle
              2012-09-19 16:04:09: Running as user oracle: /develop/u00/app/oracle/product/11.2.0/database/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13923804 -local -silent -ocmrf
              /develop/u00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/database
              2012-09-19 16:04:09: s_run_as_user2: Running /bin/su oracle -c ' /develop/u00/app/oracle/product/11.2.0/database/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13923804 -l
              ocal -silent -ocmrf /develop/u00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/database '
              2012-09-19 16:04:14: Removing file /tmp/file4PNGYg
              2012-09-19 16:04:14: Successfully removed file: /tmp/file4PNGYg
              2012-09-19 16:04:14: /bin/su exited with rc=0
              73
              2012-09-19 16:04:14: status of apply patch is 18688
              2012-09-19 16:04:14: The apply patch output is Oracle Interim Patch Installer version 11.2.0.3.0
              Copyright (c) 2012, Oracle Corporation. All rights reserved.


              Oracle Home : /develop/u00/app/oracle/product/11.2.0/database
              Central Inventory : /develop/u00/app/oraInventory
              from : /develop/u00/app/oracle/product/11.2.0/database/oraInst.loc
              OPatch version : 11.2.0.3.0
              OUI version : 11.2.0.2.0
              Log file location : /develop/u00/app/oracle/product/11.2.0/database/cfgtoollogs/opatch/opatch2012-09-19_16-04-10PM_1.log

              Verifying environment and performing prerequisite checks...
              Prerequisite check "CheckActiveFilesAndExecutables" failed.
              The details are:


              Following executables are active :
              /develop/u00/app/oracle/product/11.2.0/database/bin/oracle
              /develop/u00/app/oracle/product/11.2.0/database/bin/rman
              UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
              Log file location: /develop/u00/app/oracle/product/11.2.0/database/cfgtoollogs/opatch/opatch2012-09-19_16-04-10PM_1.log

              OPatch failed with error code 73

              2012-09-19 16:04:14: patch /develop/dbawork/software/patches/11.2.0.2.7/13923804 apply failed for home /develop/u00/app/oracle/product/11.2.0/database
              2012-09-19 16:04:14: Running as user oracle: /develop/dbawork/software/patches/11.2.0.2.7/13696242/custom/server/13696242/custom/scripts/postpatch.sh -dbhome /develop/u00/app/oracle/product/
              11.2.0/database
              2012-09-19 16:04:14: s_run_as_user2: Running /bin/su oracle -c ' /develop/dbawork/software/patches/11.2.0.2.7/13696242/custom/server/13696242/custom/scripts/postpatch.sh -dbhome /develop/u00
              /app/oracle/product/11.2.0/database '
              2012-09-19 16:04:14: Removing file /tmp/filex0kT28
              2012-09-19 16:04:14: Successfully removed file: /tmp/filex0kT28
              2012-09-19 16:04:14: /bin/su successfully executed

              2012-09-19 16:04:14: Running as user oracle: true
              2012-09-19 16:04:14: s_run_as_user2: Running /bin/su oracle -c ' true '
              2012-09-19 16:04:14: Removing file /tmp/fileapHh51
              2012-09-19 16:04:14: Successfully removed file: /tmp/fileapHh51
              2012-09-19 16:04:14: /bin/su successfully executed

              2012-09-19 16:04:14: postpatch execution for DB home ... success
              2012-09-19 16:04:14: Processing oracle home /develop/u00/app/oracle/product/11.2.0/grid
              2012-09-19 16:04:14: Opening file /etc/oracle/ocr.loc
              2012-09-19 16:04:14: Value (TRUE) is set for key=local_only
              2012-09-19 16:04:14: Home type of /develop/u00/app/oracle/product/11.2.0/grid is HA
              2012-09-19 16:04:14: Unlock Oracle Restart home...
              2012-09-19 16:04:14: Exclude file used is /develop/u00/app/oracle/product/11.2.0/grid/OPatch/crs/installPatch.excl
              2012-09-19 16:04:14: Home location in olr.loc is /develop/u00/app/oracle/product/11.2.0/grid
              2012-09-19 16:04:14: Executing /develop/u00/app/oracle/product/11.2.0/grid/bin/crsctl stop has -f
              2012-09-19 16:04:14: Executing cmd: /develop/u00/app/oracle/product/11.2.0/grid/bin/crsctl stop has -f
              2012-09-19 16:04:27: Command output:
              CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'uxdpsdbd1'
              CRS-2673: Attempting to stop 'ora.DATA_EXD1.dg' on 'uxdpsdbd1'
              CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'uxdpsdbd1'
              CRS-2677: Stop of 'ora.DATA_EXD1.dg' on 'uxdpsdbd1' succeeded
              CRS-2673: Attempting to stop 'ora.asm' on 'uxdpsdbd1'
              CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'uxdpsdbd1' succeeded
              CRS-2677: Stop of 'ora.asm' on 'uxdpsdbd1' succeeded
              CRS-2673: Attempting to stop 'ora.cssd' on 'uxdpsdbd1'
              CRS-2677: Stop of 'ora.cssd' on 'uxdpsdbd1' succeeded
              CRS-2673: Attempting to stop 'ora.diskmon' on 'uxdpsdbd1'
              CRS-2677: Stop of 'ora.diskmon' on 'uxdpsdbd1' succeeded
              CRS-2673: Attempting to stop 'ora.evmd' on 'uxdpsdbd1'
              CRS-2677: Stop of 'ora.evmd' on 'uxdpsdbd1' succeeded
              CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'uxdpsdbd1' has completed
              CRS-4133: Oracle High Availability Services has been stopped.
              End Command output
              2012-09-19 16:04:27: stopOracleRestart output is CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'uxdpsdbd1' CRS-2673: Attempting to stop 'ora.DATA_EXD1
              .dg' on 'uxdpsdbd1' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'uxdpsdbd1' CRS-2677: Stop of 'ora.DATA_EXD1.dg' on 'uxdpsdbd1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'u
              xdpsdbd1' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'uxdpsdbd1' succeeded CRS-2677: Stop of 'ora.asm' on 'uxdpsdbd1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'uxdpsdbd1' CRS-2677:
              Stop of 'ora.cssd' on 'uxdpsdbd1' succeeded CRS-2673: Attempting to stop 'ora.diskmon' on 'uxdpsdbd1' CRS-2677: Stop of 'ora.diskmon' on 'uxdpsdbd1' succeeded CRS-2673: Attempting to stop '
              ora.evmd' on 'uxdpsdbd1' CRS-2677: Stop of 'ora.evmd' on 'uxdpsdbd1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'uxdpsdbd1' has completed CRS-4133
              : Oracle High Availability Services has been stopped.
              2012-09-19 16:04:37: Executing cmd: /develop/u00/app/oracle/product/11.2.0/grid/bin/crsctl check has
              2012-09-19 16:04:39: Command output:
              CRS-4639: Could not contact Oracle High Availability Services
              End Command output
              2012-09-19 16:04:48: Invoking removeproc to clean oracle client procs
              2012-09-19 16:04:48: Executing cmd: /sbin/fuser -k /develop/u00/app/oracle/product/11.2.0/grid/bin/crsctl.bin
              2012-09-19 16:04:48: fuser command output for /develop/u00/app/oracle/product/11.2.0/grid/bin/crsctl.bin is
              2012-09-19 16:04:48: Oracle user for /develop/u00/app/oracle/product/11.2.0/grid is oracle
              2012-09-19 16:04:48: Running as user oracle: /develop/u00/app/oracle/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /develop/dbawork/software/patches/11.2.0.2.7/13696242 -oh /d
              evelop/u00/app/oracle/product/11.2.0/grid
              2012-09-19 16:04:48: s_run_as_user2: Running /bin/su oracle -c ' /develop/u00/app/oracle/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /develop/dbawork/software/patches/11.2.0
              .2.7/13696242 -oh /develop/u00/app/oracle/product/11.2.0/grid '
              2012-09-19 16:04:50: Removing file /tmp/fileY0Wmyu
              2012-09-19 16:04:50: Successfully removed file: /tmp/fileY0Wmyu
              2012-09-19 16:04:50: /bin/su successfully executed

              2012-09-19 16:04:50: Running as user oracle: /develop/u00/app/oracle/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /develop/dbawork/software/patches/11.2.0.2.7/13923804 -oh /d
              evelop/u00/app/oracle/product/11.2.0/grid
              2012-09-19 16:04:50: s_run_as_user2: Running /bin/su oracle -c ' /develop/u00/app/oracle/product/11.2.0/grid/OPatch/opatch prereq CheckApplicable -ph /develop/dbawork/software/patches/11.2.0
              .2.7/13923804 -oh /develop/u00/app/oracle/product/11.2.0/grid '
              2012-09-19 16:04:52: Removing file /tmp/filezjffx3
              2012-09-19 16:04:52: Successfully removed file: /tmp/filezjffx3
              2012-09-19 16:04:52: /bin/su successfully executed

              2012-09-19 16:04:52: Status of Applicable check for /develop/u00/app/oracle/product/11.2.0/grid is 1
              2012-09-19 16:04:52: Oracle user for /develop/u00/app/oracle/product/11.2.0/grid is oracle
              2012-09-19 16:04:52: Executing command /develop/u00/app/oracle/product/11.2.0/grid/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13696242 -local -silent -ocmrf /develop/u
              00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/grid as oracle
              2012-09-19 16:04:52: Running as user oracle: /develop/u00/app/oracle/product/11.2.0/grid/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13696242 -local -silent -ocmrf /dev
              elop/u00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/grid
              2012-09-19 16:04:52: s_run_as_user2: Running /bin/su oracle -c ' /develop/u00/app/oracle/product/11.2.0/grid/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13696242 -local
              -silent -ocmrf /develop/u00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/grid '
              2012-09-19 16:04:57: Removing file /tmp/fileXPidLJ
              2012-09-19 16:04:57: Successfully removed file: /tmp/fileXPidLJ
              2012-09-19 16:04:57: /bin/su successfully executed

              2012-09-19 16:04:57: status of apply patch is 0
              2012-09-19 16:04:57: The apply patch output is Oracle Interim Patch Installer version 11.2.0.3.0
              Copyright (c) 2012, Oracle Corporation. All rights reserved.


              Oracle Home : /develop/u00/app/oracle/product/11.2.0/grid
              Central Inventory : /develop/u00/app/oraInventory
              from : /develop/u00/app/oracle/product/11.2.0/grid/oraInst.loc
              OPatch version : 11.2.0.3.0
              OUI version : 11.2.0.2.0
              Log file location : /develop/u00/app/oracle/product/11.2.0/grid/cfgtoollogs/opatch/opatch2012-09-19_16-04-53PM_1.log

              Verifying environment and performing prerequisite checks...

              The following patch(es) are already installed in the Oracle Home.
              [13696242]
              Please roll back the existing identical patch(es) first.


              OPatch Session completed with warnings.
              Log file location: /develop/u00/app/oracle/product/11.2.0/grid/cfgtoollogs/opatch/opatch2012-09-19_16-04-53PM_1.log

              OPatch completed with warnings.

              2012-09-19 16:04:57: patch /develop/dbawork/software/patches/11.2.0.2.7/13696242 apply successful for home /develop/u00/app/oracle/product/11.2.0/grid
              2012-09-19 16:04:57: Executing command /develop/u00/app/oracle/product/11.2.0/grid/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13923804 -local -silent -ocmrf /develop/u
              00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/grid as oracle
              2012-09-19 16:04:57: Running as user oracle: /develop/u00/app/oracle/product/11.2.0/grid/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13923804 -local -silent -ocmrf /dev
              elop/u00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/grid
              2012-09-19 16:04:57: s_run_as_user2: Running /bin/su oracle -c ' /develop/u00/app/oracle/product/11.2.0/grid/OPatch/opatch napply /develop/dbawork/software/patches/11.2.0.2.7/13923804 -local
              -silent -ocmrf /develop/u00/app/oracle/product/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -oh /develop/u00/app/oracle/product/11.2.0/grid '
              2012-09-19 16:05:42: Removing file /tmp/filewf1rtC
              2012-09-19 16:05:42: Successfully removed file: /tmp/filewf1rtC
              2012-09-19 16:05:42: /bin/su successfully executed

              2012-09-19 16:05:42: status of apply patch is 0
              2012-09-19 16:05:42: The apply patch output is Oracle Interim Patch Installer version 11.2.0.3.0
              Copyright (c) 2012, Oracle Corporation. All rights reserved.


              Oracle Home : /develop/u00/app/oracle/product/11.2.0/grid
              Central Inventory : /develop/u00/app/oraInventory
              from : /develop/u00/app/oracle/product/11.2.0/grid/oraInst.loc
              OPatch version : 11.2.0.3.0
              OUI version : 11.2.0.2.0
              Log file location : /develop/u00/app/oracle/product/11.2.0/grid/cfgtoollogs/opatch/opatch2012-09-19_16-04-57PM_1.log

              Verifying environment and performing prerequisite checks...
              OPatch continues with these patches: 13923804

              Do you want to proceed? y
              Y (auto-answered by -silent)
              User Responded with: Y
              All checks passed.

              Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
              (Oracle Home = '/develop/u00/app/oracle/product/11.2.0/grid')


              Is the local system ready for patching? y
              Y (auto-answered by -silent)
              User Responded with: Y
              Backing up files...
              Applying sub-patch '13923804' to OH '/develop/u00/app/oracle/product/11.2.0/grid'
              ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found.

              Patching component oracle.rdbms.rsf, 11.2.0.2.0...

              Patching component oracle.rdbms, 11.2.0.2.0...

              Patching component oracle.rdbms.dbscripts, 11.2.0.2.0...

              Patching component oracle.rdbms.rman, 11.2.0.2.0...

              Patching component oracle.network.rsf, 11.2.0.2.0...

              Patching component oracle.network.listener, 11.2.0.2.0...

              Verifying the update...
              Composite patch 13923804 successfully applied.
              Log file location: /develop/u00/app/oracle/product/11.2.0/grid/cfgtoollogs/opatch/opatch2012-09-19_16-04-57PM_1.log

              OPatch succeeded.

              2012-09-19 16:05:42: patch /develop/dbawork/software/patches/11.2.0.2.7/13923804 apply successful for home /develop/u00/app/oracle/product/11.2.0/grid
              2012-09-19 16:05:42: Performing Post patch actions
              2012-09-19 16:05:42: norestart flag is set to
              2012-09-19 16:05:42: Opening file /etc/oracle/ocr.loc
              2012-09-19 16:05:42: Value (TRUE) is set for key=local_only
              2012-09-19 16:05:42: Performing Post patch actions for HA Home /develop/u00/app/oracle/product/11.2.0/grid
              2012-09-19 16:05:42: Executing cmd: /develop/u00/app/oracle/product/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
              2012-09-19 16:05:42: setrdbmsfileperms succeeded
              2012-09-19 16:05:42: Patching Oracle Restart
              2012-09-19 16:05:42: norestart flag is set to
              2012-09-19 16:05:43: Executing cmd: /bin/rpm -q sles-release
              2012-09-19 16:05:43: Command output:
              package sles-release is not installed
              End Command output
              ...
              • 4. Re: OPatch inventory doesn't show latest PSU
                Srini Chavali-Oracle
                eman wrote:
                The OS is OEL 5.7.
                uname -a
                Linux uxdpsdbd1.alldata.net 2.6.32-200.13.1.el5uek #1 SMP Wed Jul 27 21:02:33 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

                We downloaded patch 14192201 (p14192201_112020_Linux-x86-64.zip), which as you mentioned is GI 11.2.0.2.7. When we unzipped it, it created two directories ... 13923804 (DB 11.2.0.2.7) and 13696242 (GI 11.2.0.2.6). I thought that was odd because I was expecting a directory 14192201.
                This MOS Doc has an explanation for the two directories -

                What is included in 11.2.0.2.7 GI PSU7 (patch 14192201) [ID 1476704.1]
                Below is the OPatch log. You'll notice in the log that first 13696242 is applied to the DB home. Then it attempted to apply 13923804 to the DB home but failed because of some active processes. Next it attempted to apply 13696242 to the GI home but it was already at the level so nothing happened there. Lastly it applied 13923804 to the GI home. Now I'm wondering if the zip file for 14192201 ever came with GI 11.2.0.2.7? I'm getting more confused. Any help to clarify this would be greatly appreciated.

                PS - we ran opatch again so that 13923804 was applied to the DB home (it failed earlier because of some active processes)
                ****************
                Pl see the above MOS Doc for an explanation

                HTH
                Srini