1 2 Previous Next 20 Replies Latest reply: Feb 12, 2010 3:32 PM by 753518 RSS

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

    750475
      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
          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
            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
              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
                okay Got it :)

                Many thanks Anurag
                • 5. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
                  729338
                  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
                    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.
                    • 9. Re: Oracle Patch : 9119284(CPUJAN2010) At Oracle R2 10.2.0.4.0 Linux x86
                      750475
                      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
                        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
                          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
                            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
                              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
                                Hi,

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