This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Feb 12, 2010 1:32 PM by 753518 RSS

Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86

750475 Newbie
Currently Being Moderated
Current Version:
Oracle Database 10g Release 10.2.0.4.0 – Linux x86

Now wanted to apply patch:
9119284 DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)
I have run
opatch prereq CheckConflictAgainstOHWithDetail

Now report is like:
Patches that can be applied now without any conflicts are :
*9119284*

Following patches are not required, as they are subset of the patches in Oracle Home or subset of the patches in the given list :
8568405, 8568404, 8568402, 8568398, 8568397, 8568395, 8534387, 8309642, 8309637, 8309632, 8309623, 8309592, 8309587, 7609058, 7609057, 7375617, 7375613, 7375611, 7197583, 7155254, 7155253, 7155252, 7155251, 7155250, 7155249, 7155248

Following patches will be rolled back from Oracle Home on application of the patches in the given list :
8568405, 8568404, 8568402, 8568398, 8568397, 8568395, 8534387, 8309642, 8309637, 8309632, 8309623, 8309592, 8309587, 7609058, 7609057, 7375617, 7375613, 7375611, 7197583, 7155254, 7155253, 7155252, 7155251, 7155250, 7155249, 7155248

Conflicts/Supersets for each patch are:

Patch : 9119284

Bug Superset of 8568405
Super set bugs are:
8568405

Bug Superset of 8568404
Super set bugs are:
8568404

Bug Superset of 8568402
Super set bugs are:
6870937, 8568402

Bug Superset of 8568398
Super set bugs are:
6392076, 8568398

Bug Superset of 8568397
Super set bugs are:
8568397

Bug Superset of 8568395
Super set bugs are:
8309639, 8568395

Bug Superset of 8534387
Super set bugs are:
8534387, 8290506, 7375644, 7150470, 7592346

Bug Superset of 8309642
Super set bugs are:
8309642

Bug Superset of 8309637
Super set bugs are:
8309637

Bug Superset of 8309632
Super set bugs are:
8309632

Bug Superset of 8309623
Super set bugs are:
8309623

Bug Superset of 8309592
Super set bugs are:
8309592

Bug Superset of 8309587
Super set bugs are:
8309587

Bug Superset of 7609058
Super set bugs are:
7609058

Bug Superset of 7609057
Super set bugs are:
7609057

Bug Superset of 7375617
Super set bugs are:
7375617

Bug Superset of 7375613
Super set bugs are:
7375613

Bug Superset of 7375611
Super set bugs are:
7375611

Bug Superset of 7197583
Super set bugs are:
7197583

Bug Superset of 7155254
Super set bugs are:
7155254

Bug Superset of 7155253
Super set bugs are:
7155253

Bug Superset of 7155252
Super set bugs are:
7155252

Bug Superset of 7155251
Super set bugs are:
7155251

Bug Superset of 7155250
Super set bugs are:
7155250

Bug Superset of 7155249
Super set bugs are:
7155249

Bug Superset of 7155248
Super set bugs are:
7155248

OPatch succeeded.


First time i am applying this type of patch ,somebody please help me, what should be the next step

Thanks
  • 1. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    729338 Expert
    Currently Being Moderated
    Hi,

    You need to apply patches using following command.

    opatch apply

    It will ask for your confirmation if it can deinstall any conflicting patches before it can install the patches. You have to provide yes answer to those questions.

    Regards
  • 2. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    750475 Newbie
    Currently Being Moderated
    Thank you so much

    need one more help

    will you please give me idea about psu_root.sh

    and howmuch it is important to take a backup of DB before patch apply

    Edited by: user12294181 on Feb 2, 2010 3:13 AM
  • 3. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    Anurag Tibrewal Guru
    Currently Being Moderated
    It says that out of all the patches available in cpujan2010, it need to apply only patch 9119284, because all the other patches are subset of this patch or its allready applied.

    It also said that it would rollback some of the patches as it is either subset/conflict with patch 9119284.

    In short you are good to go ahead.
    I suppose you remembered to backup up your oracle binaries/db before applying patch.

    Regards
    Anurag
  • 4. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    750475 Newbie
    Currently Being Moderated
    okay Got it :)

    Many thanks Anurag
  • 5. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    729338 Expert
    Currently Being Moderated
    Hi,

    I am not sure about psu_root.sh. I have not heared about it.In Oracle notmally you have root.sh for many post installation task. Also for the patch, you can get more details about any post installation task by reading the patch readme document.

    Regards
  • 6. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    Anurag Tibrewal Guru
    Currently Being Moderated
    As you run root.sh after database installation, same way you run psu_root.sh after applying PSU(Patch Set Update).
    It does similar thing as what root.sh does but only for specific files which were changed/installed by PSU.
    How to run and when to run- These details are mentioned in Readme.txt Generally for patch I suppose it has some permission change on binaries used by job scheduiling system.

    Regards
    Anurag.
  • 7. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    750475 Newbie
    Currently Being Moderated
    thanks for your help
  • 9. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    750475 Newbie
    Currently Being Moderated
    Hello

    Need more Help

    I have done all steps


    catbundle.sql
    recompile_precheck_jan2008cpu.sql

    view_recompile_jan2008cpu.sql

    utlrp.sql


    But still in version it shows old one

    Thanks
  • 10. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    750475 Newbie
    Currently Being Moderated
    Have done all steps

    but it doesn't shows 10.2.0.4.0 to 10.2.0.4.3

    Edited by: user12294181 on Feb 2, 2010 4:26 AM
  • 11. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    Anurag Tibrewal Guru
    Currently Being Moderated
    Hi,

    Sorry I did not understand,
    Can you tell me what are you checking.
    And what was the previous value
    and what is the current value.

    If you are looking for change in version number then I doubt it would be.
    You can check whether the patch was installed or not using
    opatch lsinventory
    Here you should find the patch number that was installed.

    Regards
    Anurag
  • 12. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    Anurag Tibrewal Guru
    Currently Being Moderated
    user12294181 wrote:
    Have done all steps

    but it doesn't shows 10.2.0.4.0 to 10.2.0.4.3

    Edited by: user12294181 on Feb 2, 2010 4:26 AM
    Did you install CPU january patch or patchset 3.

    Regards
    Anurag
  • 13. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    750475 Newbie
    Currently Being Moderated
    Thank you Anurag


    Actually i am checking

    select * from v$version

    and it shows 10.2.0.4.0

    and i am expecting this as 10.2.0.4.3 (is it true)

    as patch update :
    DATABASE PSU 10.2.0.4.3 (INCLUDES CPUJAN2010)

    opatch lsinventory

    Invoking OPatch 10.2.0.4.8

    Oracle Interim Patch Installer version 10.2.0.4.8
    Copyright (c) 2009, Oracle Corporation. All rights reserved.


    Oracle Home : /u01/app/oracle/product/10.2.0/db_1
    Central Inventory : /home/oracle/oraInventory
    from : /etc/oraInst.loc
    OPatch version : 10.2.0.4.8
    OUI version : 10.2.0.4.0
    OUI location : /u01/app/oracle/product/10.2.0/db_1//oui
    Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2010-02-02_12-27-32PM.log

    Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt

    Lsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2010-02-02_12-27-32PM.txt

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

    Oracle Database 10g 10.2.0.1.0
    Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
    There are 2 products installed in this Oracle Home.


    Interim patches (1) :

    Patch  9119284      : applied on Tue Feb 02 11:24:57 GMT 2010
    Unique Patch ID: 11999265
    Created on 17 Dec 2009, 03:32:08 hrs PST8PDT
    Bugs fixed:
    6418420, 7835247, 7207654, 7592346, 6724797, 7936993, 7331867, 9093300
    7552067, 5879114, 5457450, 8344348, 7272297, 7136866, 7196894, 7013124
    6512622, 7196532, 8568395, 8309587, 7557226, 6509115, 8568397, 8568398
    6052226, 7424804, 6817593, 7553884, 6741425, 7513673, 8437213, 6452766
    6469211, 7527650, 8309592, 5991038, 6945157, 9119226, 6403091, 7552082
    6711853, 8304589, 6052169, 8199266, 6327692, 5756769, 7460818, 6268409
    8232056, 6687381, 6972843, 8230457, 6800507, 7027551, 6778714, 6200820
    6645719, 7393804, 6775231, 3934160, 6683178, 6650256, 7528105, 6378112
    6151380, 6844866, 4723109, 8544896, 5126719, 5890312, 7036453, 8426816
    8433026, 7270434, 7172531, 6451626, 8247855, 6324944, 6874522, 7175513
    6960489, 7341598, 8576156, 6797677, 8342923, 5895190, 7150470, 7593835
    7356443, 7044551, 8227106, 4695511, 7298688, 5747462, 8556340, 7197445
    5348308, 7937113, 8341623, 7569205, 6053134, 8409848, 6163771, 6181488
    6375150, 7295780, 6345573, 7033630, 7523475, 6954722, 7457766, 7309458
    8324577, 6840740, 6804746, 7375611, 8268054, 6512811, 6988017, 7375613
    8344399, 7340448, 8362683, 7375617, 8251247, 5933656, 6599920, 7238230
    6379441, 6452375, 6352003, 6833965, 7136489, 6610218, 7612639, 6392076
    5476236, 7609057, 7609058, 6374297, 6193945, 4693355, 8217795, 7039896
    7432514, 7330909, 6952701, 7190270, 8287155, 7207932, 6802650, 7189447
    4598439, 6615740, 7155655, 6749617, 7159505, 5868257, 5727166, 7173005
    6917874, 7013768, 7691766, 7385253, 7225720, 7257770, 7244238, 7363767
    6941717, 8267348, 7710551, 7247217, 8328954, 8909984, 6681695, 8702276
    9119284, 8217011, 7661251, 6265559, 6823287, 6991626, 6954829, 5259835
    6500033, 5923486, 7432601, 8534387, 5147386, 7697802, 6653934, 7375644
    6490140, 7662491, 8331466, 5623467, 6070225, 6635214, 7396409, 6638558
    7038750, 6714608, 6838714, 6870937, 7219752, 7263842, 7278117, 6882739
    5404871, 8836667, 8373286, 6678845, 6903051, 7936793, 6600051, 7155248
    4966512, 7155249, 7197637, 8836308, 8568402, 8568404, 8568405, 5704108
    6343150, 7280764, 6923450, 7643632, 6145177, 8836671, 8310931, 6640411
    8347704, 8836675, 7155250, 7155251, 8836677, 7155252, 8836678, 7155253
    7155254, 8292378, 6219529, 7411865, 8227091, 8340379, 7276960, 7659217
    5863926, 7022905, 7123643, 6413089, 6596564, 6851438, 8836681, 8836683
    8836684, 7579469, 8836686, 7494333, 7315642, 8340383, 8340387, 6926448
    7462072, 7600026, 6679303, 7197583, 7172752, 7326645, 7008262, 9173244
    9173248, 7573151, 7477934, 6733655, 6799205, 6980597, 6084232, 7499353
    6014513, 7140204, 7254987, 8833280, 6760697, 7693128, 6120004, 6051177
    8247215, 6858062, 6844739, 7189645, 5630796, 7196863, 6768251, 7378661
    7378735, 8290506, 5970301, 6658484, 9173253, 8309623, 7599944, 7125408
    7257461, 6987790, 7568556, 6919819, 5883691, 8886674, 6955744, 6074620
    7149004, 6857917, 8283650, 7552042, 8210889, 8287504, 6506617, 6271590
    5386204, 6976005, 8330783, 7606362, 7043989, 8309632, 7575925, 6870047
    8309637, 8309639, 6827260, 7588384, 6752765, 6024730, 6628122, 8315482
    8239142, 4637902, 8309642, 7345904, 6994160, 6404447, 6919764, 7597354
    7523787, 6029179, 5231155, 6455659



    --------------------------------------------------------------------------------

    OPatch succeeded.

    Edited by: user12294181 on Feb 2, 2010 4:49 AM
  • 14. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
    Anurag Tibrewal Guru
    Currently Being Moderated
    Hi,

    Check the version in
    select * from product_component_version
    Regards
    Anurag
1 2 Previous Next

Legend

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