10 Replies Latest reply on Feb 14, 2019 1:18 PM by Beauty_and_dBest

    ETCC DB Patches

    Beauty_and_dBest

      EBS 12.2.7

      12c

      OL6

       

      Hi ALL,

       

      I run ETCC on our EBS database and it reports the following missing patches:

       

      I tried to download in from Oracle Support these patches but I see lots of different versions

      For example, the patch 26336977,   have the following versions:

      (Our Db version is 12.1.0.2)

       

       

      There are 17 choices for this patch. Can I choose any of them?

      Why is that  there are lots of choices?

       

       

      Please help...

       

       

      Kind regards,

      jc

        • 1. Re: ETCC DB Patches
          Kanda-Oracle

          Hi JC

           

          Its for the different DB version with different patch levels . There is one release Oracle 12.1.0.2.0 . Please check it and choose it

           

          Thanks

           

          N Kandasamy

          • 2. Re: ETCC DB Patches
            Beauty_and_dBest

            Thanks Kanda,

             

            I have download the 12.1.0.2 versions, but one patch 28259867 is superseded by a very big patch 28833531 (3Gb).

            Patch 28833531 - Database Proactive Bundle Patch 12.1.0.2.190115

            How do you apply this big patch? Do I need to apply this patch? Is ETCC really reliable?

            I understand there are lots of conflicts it will take, and need to rollback?

             

             

            Please help....

            • 4. Re: ETCC DB Patches
              Kanda-Oracle

              can you share are you using  Database In-Memory option ?

              • 5. Re: ETCC DB Patches
                Beauty_and_dBest

                I think we are not using in-memory?

                We only use generic cheap server configuration.

                • 6. Re: ETCC DB Patches
                  Beauty_and_dBest

                  Hi Kanda, and ALL,

                   

                  Why does ETCC is listing missing patches but all have conflicts

                  It seems ETCC is "useless" after all?

                  Do I just ignore all?

                   

                  I tried to apply patch  26336977, but it has conflict, and so with all the rest.

                   

                  Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

                  26336977, 26925263, 27322338

                  Whole composite patch Conflicts/Supersets are:

                  Patch : 26336977

                   

                  Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

                  26654363, 26925263, 27322338

                  Whole composite patch Conflicts/Supersets are:

                  Patch : 26654363

                   

                  Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

                  26742604, 27322748

                  Conflicts/Supersets for each patch are:

                  Patch : 26742604

                   

                  Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

                  26925263, 27322338, 28500816

                  Whole composite patch Conflicts/Supersets are:

                  Patch : 28500816

                   

                  Following patches have conflicts. Please contact Oracle Support and get the merged patch of the patches :

                  26925263, 28507324

                  Whole composite patch Conflicts/Supersets are:

                  Patch : 28507324

                   

                   

                  Please help....

                   

                  Kind regards,

                  • 7. Re: ETCC DB Patches
                    Kanda-Oracle

                    not sure. DB support team may suggest you to go for latest DATABASE PATCH SET UPDATE .

                     

                    for example  12.1.0.2.190115

                     

                    Patch 28729169: DATABASE PATCH SET UPDATE 12.1.0.2.190115

                    • 8. Re: ETCC DB Patches
                      lmu

                      Oracle just updated the ETCC yesterday to include the latest update.

                       

                      Find the patch in the patches and update tab -> Search for the patch.  When the patch page comes up, click the 'Analyze with Opatch' button. That will take you to the patch conflict checker.

                       

                       

                      You need to upload opatch lsinventory -details..

                       

                      It gave me details of the merge patches I needed right away.  There was no waiting.   it also gave me the patches I could download.

                      • 9. Re: ETCC DB Patches
                        Beauty_and_dBest

                        Thanks Imu,

                         

                        I will try that...brb

                        • 10. Re: ETCC DB Patches
                          Beauty_and_dBest

                          Hi Imu,

                           

                          I download latest ETCC.

                          Then I run checking and still the same output as before

                          Can you please explain further the process you have done?

                          Where do I upload the "opatch lsinventory -detail? to Oracle Support?

                          Where do I search the missing patch?

                           

                          Thanks a lot.

                           

                          $ ./checkDBpatch.sh

                           

                          +===============================================================+

                          |    Copyright (c) 2005, 2019 Oracle and/or its affiliates.     |

                          |                     All rights reserved.                      |

                          |             Oracle E-Business Suite Release 12.2              |

                          |          Database EBS Technology Codelevel Checker            |

                          +===============================================================+

                           

                          Using context file from currently set database environment:

                          /u03/ora1228p/P1228/12.1.0/appsutil/P1228_testsvr3.xml

                           

                           

                          Starting Database EBS Technology Codelevel Checker, Version 120.70

                          Thu Feb 14 21:05:58 +08 2019

                          Log file for this session : /u01/PATCH/ETCC/log/checkDBpatch_15692.log

                           

                          Identifying database release.

                          Database release set to 12.1.0.2.

                           

                          Connecting to database.

                          Database connection successful.

                           

                          Database P1228 is in READ WRITE mode.

                           

                          Identifying APPS and APPLSYS schema names.

                          - APPS schema : APPS

                          - APPLSYS schema : APPLSYS

                           

                          Checking for DB-ETCC results table.

                          Table to store DB-ETCC results already exists in the database.

                           

                          Checking if InMemory option is enabled.

                          InMemory option is not enabled in the database.

                           

                          Bugfix file ./db/onprem/txk_R1220_DB_base_bugs.xml : 120.0.12020000.45

                          This file will be used for identifying missing bugfixes.

                           

                          Mapping file ./db/onprem/txk_R1220_DB_mappings.xml : 120.0.12020000.20

                          This file will be used for mapping bugfixes to patches.

                           

                          Checking Bugfix XML file for 12.1.0.2_BP

                           

                          Obtained list of bugfixes to be applied and the list to be rolled back.

                          Now checking Database ORACLE_HOME.

                           

                          The opatch utility is version 12.2.0.1.8.

                          DB-ETCC is compatible with this opatch version.

                           

                          Found patch records in the inventory.

                           

                          Checking Mapping XML file for 12.1.0.2.180116ProactiveBP

                           

                          Patch mapping not available.

                          Patch mapping data is not available for 12.1.0.2 ProactiveBP

                          Some required one-off bugfixes are missing from the Database ORACLE_HOME.

                          The missing bugfixes are:

                          26336977

                          26654363

                          26742604

                          28507324

                          28731800

                           

                          ** Refer to MOS Doc ID "1594274.1:Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes" to find the corresponding patch that delivers the bug fix. If an overlay patch is needed for any particular patch listed, the footnote for that patch also applies to the overlay patch. **

                           

                          Apply the missing bugfixes and then rerun the script.

                           

                          Stored Technology Codelevel Checker results in the database P1228 successfully.

                           

                          Finished checking fixes for Oracle Database: Thu Feb 14 21:06:20 +08 2019

                           

                          Log file for this session: /u01/PATCH/ETCC/log/checkDBpatch_15692.log

                           

                          ===============================================================================