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

    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
          1 person found this helpful
          • 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
              • 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.
                  1 person found this helpful
                  • 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