This discussion is archived
4 Replies Latest reply: Sep 20, 2012 11:04 AM by Srini Chavali-Oracle RSS

OPatch inventory doesn't show latest PSU

eman Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points