13 Replies Latest reply on Nov 10, 2018 9:06 AM by Beauty_and_dBest

    Applying PATCH 12.2.8 (26787767)

    Beauty_and_dBest

      ESB 12.2.7

      12c

      OL6

       

       

      Hi ALL,

       

      I am applying patch  26787767  to our EBS 12.2.7

      But I got below error:

       

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

      ADOP (C.Delta.10)

      Session ID: 61

      Node: trnsrvr2

      Phase: apply

      Log: /u03/apptest/TEST/fs_ne/EBSapps/log/adop/61/20181104_013619/adop.log

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

       

      Applying patch 26787767.

          Log: /u03/apptest/TEST/fs_ne/EBSapps/log/adop/61/20181104_013619/apply/trnsrvr2/26787767/log/u26787767.log

       

      AutoPatch error:

      Please apply adgrants.sql file in database tier before applying this patch

       

      You should check the file

      /u03/apptest/TEST/fs_ne/EBSapps/log/adop/61/20181104_013619/apply/trnsrvr2/26787767/log/u26787767.log

       

      for errors.

       

          [UNEXPECTED]Error occurred executing "adpatch  abandon=no restart=yes workers=4      console=no interactive=no  defaultsfile=/u03/apptest/TEST/fs2/EBSapps/appl/admin/TEST_patch/adalldefaults.txt patchtop=/u01/PATCH/P1228/26787767 driver=u26787767.drv logfile=u26787767.log"

          [UNEXPECTED]Refer to the log files for more information.

          [UNEXPECTED]Apply phase has failed.

       

       

      [STATEMENT] Please run adopscanlog utility, using the command

       

      "adopscanlog -latest=yes"

       

      to get the list of the log files along with snippet of the error message corresponding to each log file.

       

       

      adop exiting with status = 1 (Fail)

       

       

      I already run adgrants.sql but still the the issue persist.

       

      Please help...

       

       

      Kind regards,

      jc

        • 1. Re: Applying PATCH 12.2.8 (26787767)
          mdtaylor

          Hi jc,

           

          You need to run adgrants.sql again from patch 27254132 directory per the AD/TXK doc.

           

          Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

           

          Regards,

          Michael

          • 2. Re: Applying PATCH 12.2.8 (26787767)
            Beauty_and_dBest

            Thanks Michael,

             

            I am confused

            I inderstand 27254132  is supposed to be merge with (R12.AD.C.Delta.10) and applied as "hot patch"?

            Do merged patches still appeared or recorded in "ad_bugs" table?

            So ...do I need to apply it alone?

             

            I thought I have the latest AD/TXK/ATG patches but I am not sure yet.

            Below are the list in my database, do I miss some more patches?

             

            17919161                R12.2.4
            19676458                R12.2.5
            21900901                R12.2.6
            24690690                R12.2.7
            25820806                R12.AD.C.DELTA.10
            17766337                R12.AD.C.DELTA.4
            18283295                R12.AD.C.DELTA.5
            19197270                R12.AD.C.DELTA.6
            20745242                R12.AD.C.DELTA.7
            21841299                R12.AD.C.DELTA.8
            25178222                R12.AD.C.DELTA.9
            17909318                R12.ATG_PF.C.Delta.4
            19245366                R12.ATG_PF.C.Delta.5
            21900895                R12.ATG_PF.C.Delta.6
            24690680                R12.ATG_PF.C.Delta.7
            25828573                R12.TXK.C.DELTA.10
            17893964                R12.TXK.C.DELTA.4
            18288881                R12.TXK.C.DELTA.5
            19330775                R12.TXK.C.DELTA.6
            20784380                R12.TXK.C.DELTA.7
            21830810                R12.TXK.C.DELTA.8
            25180736                R12.TXK.C.DELTA.9

             

            22 rows selected.

             

             

            Kind regards,

            • 3. Re: Applying PATCH 12.2.8 (26787767)
              mdtaylor

              Hi jc,

               

              Please review the readme for the AD Consolidated patch:

               

              Patch 27294892:R12.TXK.C CONSOLIDATED PATCH ON TOP OF TXK DELTA 10

              https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=27294892

               

              There is a requirement to copy the adgrants.sql from the 27294892 admin directory to the $ORACLE_HOME/appsutil/admin directory on the DB server and run as sysdba.

               

              Once you do that, you should be able to restart your 12.2.8 patch.

               

              Regards,

              Michael

              • 4. Re: Applying PATCH 12.2.8 (26787767)
                Beauty_and_dBest

                Thanks Michael,

                 

                But I am not sure if I need to apply the patch 27254132 first before I copy the adgrants, because I am not sure if it was merged applied with R12.TXK.C.DELTA.10

                How do I know if the patch 27254132 was already applied, via merged process?

                 

                 

                Kind regards,

                • 5. Re: Applying PATCH 12.2.8 (26787767)
                  mdtaylor

                  Hi jc,

                   

                  You can check to see if the patch was applied by running the following as apps:

                   

                  select * from ad_bugs where bug_number = '27294892';

                   

                  Make sure you ran the adgrants.sql from this admin folder.

                   

                  Regards,

                  Michael

                  • 6. Re: Applying PATCH 12.2.8 (26787767)
                    Beauty_and_dBest

                    Hi Michael,

                     

                    SQL> select * from ad_bugs where bug_number = '27294892';

                     

                    no rows selected

                     

                     

                    My question is if this patch was merged with R12.TXK.C.DELTA.10 and applied,

                    Will it be recorded as well in ad_bugs? or only R12.TXK.C.DELTA.10 is being recorded?

                     

                    So if the patch is not applied yet, then I need to apply it via hotpatch.

                    But now there is pending patch 12.2.8, so I need to abandon it first

                     

                    Or is it ok to run the adgrants.sql without applying the patch, just to continue my pending 12.2.8 patch?

                     

                     

                    Kind regards,

                    • 7. Re: Applying PATCH 12.2.8 (26787767)
                      Beauty_and_dBest

                      Hi Michael,

                       

                      I run ETCC again on the dbTier,  and I got the following:

                       

                      [oratest@trnsrvr2 ETCC]$ ./checkDBpatch.sh

                       

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

                      |    Copyright (c) 2005, 2018 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/oratest/TEST/12.1.0/appsutil/TEST_trnsrvr2.xml

                       

                       

                      Starting Database EBS Technology Codelevel Checker, Version 120.69

                      Mon Nov  5 21:24:40 PHT 2018

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

                       

                      Identifying database release.

                      Database release set to 12.1.0.2.

                       

                      Connecting to database.

                      Database connection successful.

                       

                      Database TEST 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.43

                      This file will be used for identifying missing bugfixes.

                       

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

                      This file will be used for mapping bugfixes to patches.

                       

                       

                      [WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 30 days old.

                      Check if a newer version is available in patch 17537119.

                       

                      Checking Bugfix XML file for 12.1.0.2_PSU

                       

                      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.170814

                       

                      Patch mapping not available.

                      Patch mapping data is not available for 12.1.0.2 (PATCHSET UPDATE 12.1.0.2.170814)

                      Refer to Doc ID 1147107.1 for the required overlay patches for PSUs and Oracle E-Business Suite

                       

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

                      The missing bugfixes are:

                      19509982

                      20801452

                      23604553

                      24589081

                      25099339

                      25139545

                      25305405

                      25906117

                      25971286

                      26336977

                      26654363

                      26742604

                      26911000

                      27997875

                      27547329

                       

                      ** Refer to MOS Doc ID "1147107.1:Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite" to find the corresponding overlay patch that delivers the bug fix. **

                       

                      Apply the missing bugfixes and then rerun the script.

                       

                      Stored Technology Codelevel Checker results in the database TEST successfully.

                       

                      Finished checking fixes for Oracle Database: Mon Nov  5 21:24:53 PHT 2018

                       

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

                       

                       

                       

                       

                      Is it ok to apply EBS patch 12.2.8 even if the database ETCC patches are not applied all?

                       

                       

                      Kind regards,

                      • 8. Re: Applying PATCH 12.2.8 (26787767)
                        mdtaylor

                        Hi jc,

                         

                        It appears that TXK_TCC_RESULTS is not aware of the rollback.  Please run the following as apps:

                         

                        delete from TXK_TCC_RESULTS where COMPONENT_NAME = 'RDBMS';

                         

                        Then run ETCC on the DB again.

                         

                        Normally, you should pass ETCC on DB and MT before applying 12.2.8.  Since you are in the middle of patching, I recommend running the latest adgrants.sql as directed, and restart the patch.  Then complete any ETCC recommendations after 12.2.8 completes before you restart the applications.

                         

                        Regards,

                        Michael

                        • 9. Re: Applying PATCH 12.2.8 (26787767)
                          Beauty_and_dBest

                          Thanks Michael, 

                           

                          I will try that....brb

                          • 10. Re: Applying PATCH 12.2.8 (26787767)
                            Beauty_and_dBest

                            Hi Michael,

                             

                            Sorry I messed up the instance.

                            I restored the backup and want to start anew / again.

                             

                            First I run ETCC on the database and below is the result:

                             

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

                            |    Copyright (c) 2005, 2018 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/oratest/TEST/12.1.0/appsutil/TEST_trnsrvr2.xml

                             

                             

                            Starting Database EBS Technology Codelevel Checker, Version 120.69

                            Tue Nov  6 17:48:54 PHT 2018

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

                             

                            Identifying database release.

                            Database release set to 12.1.0.2.

                             

                            Connecting to database.

                            Database connection successful.

                             

                            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.43

                            This file will be used for identifying missing bugfixes.

                             

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

                            This file will be used for mapping bugfixes to patches.

                             

                             

                            [WARNING] DB-ETCC: Bugfix XML file (./db/onprem/txk_R1220_DB_base_bugs.xml) is more than 30 days old.

                            Check if a newer version is available in patch 17537119.

                             

                            Checking Bugfix XML file for 12.1.0.2_PSU

                             

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

                            Now checking Database ORACLE_HOME.

                            DB-ETCC is compatible with this opatch version.

                             

                            Found patch records in the inventory.

                             

                            Checking Mapping XML file for 12.1.0.2.170814

                             

                            Patch mapping not available.

                            Patch mapping data is not available for 12.1.0.2 (PATCHSET UPDATE 12.1.0.2.170814)

                            Refer to Doc ID 1147107.1 for the required overlay patches for PSUs and Oracle E-Business Suite

                             

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

                            The missing bugfixes are:

                            19509982

                            20801452

                            23604553

                            24589081

                            25099339

                            25305405

                            25971286

                            26336977

                            26654363

                            26742604

                            26911000

                            27997875

                            27547329

                             

                            ** Refer to MOS Doc ID "1147107.1:Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite" to find the corresponding overlay patch that delivers the bug fix. **

                             

                            Apply the missing bugfixes and then rerun the script.

                             

                            Stored Technology Codelevel Checker results in the database TEST successfully.

                             

                            Finished checking fixes for Oracle Database: Tue Nov  6 17:49:08 PHT 2018

                             

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

                             

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

                             

                             

                             

                            I tried to apply all the thirteen (3) missing bug fixes above but they all have conflicts

                             

                            Can you guide me, How do I fix the conflicts again for all the 13 missing bug fixes?

                             

                             

                            Kind regards,

                            jc

                            • 11. Re: Applying PATCH 12.2.8 (26787767)
                              mdtaylor

                              Hi jc,

                               

                              I recommend rolling back the PSU.  Please execute the following.

                               

                              opatch rollback -id 26609783

                               

                              It will fail with a message that looks similar this:

                               

                              OPatch will not roll back patch(es) "23054246,22291127,21948354,21359755,20831110,20299023,19769480" until you have rolled back dependent patch(es)

                               

                              My 12.2.6 had an earlier PSU applied so the patches applied on top of the PSU will be different.

                               

                              Rollback each patch listed in your error message like this:

                               

                              opatch rollback -id 23559827

                              opatch rollback -id 23531118

                              opatch rollback -id 21967332

                              opatch rollback -id 21321429

                              opatch rollback -id 20627866

                              opatch rollback -id 22338374

                              opatch rollback -id 21286665

                              opatch rollback -id 22223463

                              opatch rollback -id 23054246

                               

                              Then rollback the PSU:

                               

                              opatch rollback -id 26609783

                               

                              Then run datapatch:

                               

                              cd $ORACLE_HOME/OPatch

                              sqlplus "/as sysdba"

                              startup

                              ./datapatch -verbose

                               

                              Apply the 12.2.8 prereq patch:

                               

                              Patch 28500816 MERGE REQUEST ON TOP OF 12.1.0.2.0 FOR BUGS 28498555 26654363

                              https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=28500816

                               

                               

                              cd /stage/software/12.2.2/12.1.0.2/28500816

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              Then run ETCC:

                               

                              cd /stage/software/12.2.2/etcc

                              sh checkDBpatch.sh

                               

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

                              PATCH RECOMMENDATION SUMMARY

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

                              The default patch recommendations to install these missing bugfixes are:

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

                              Oracle Database Release 12.1.0.2  (No PSU applied)

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

                              Patch 19779059

                                  - Filename: p19779059_121020_Linux-x86-64.zip

                               

                               

                              Patch 27069421

                                  - Filename: p27069421_121020_Linux-x86-64.zip

                               

                               

                              Patch 26113202

                                  - Filename: p26113202_121020_Linux-x86-64.zip

                               

                               

                              Patch 18793246

                                  - Filename: p18793246_121020_Generic.zip

                               

                               

                              Patch 27591442

                                  - Filename: p27591442_121020_Generic.zip

                               

                               

                              Patch 19291380

                                  - Filename: p19291380_121020_Linux-x86-64.zip

                               

                               

                              Patch 19393542

                                  - Filename: p19393542_121020_Linux-x86-64.zip

                               

                               

                              Patch 19591608

                                  - Filename: p19591608_121020_Linux-x86-64.zip

                               

                               

                              Patch 19627012

                                  - Filename: p19627012_121020_Linux-x86-64.zip

                               

                               

                              Patch 19649152

                                  - Filename: p19649152_121020_Linux-x86-64.zip

                               

                               

                              Patch 19835133

                                  - Filename: p19835133_121020_Linux-x86-64.zip

                               

                               

                              Patch 20093776

                                  - Filename: p20093776_121020_Linux-x86-64.zip

                               

                               

                              Patch 20294666

                                  - Filename: p20294666_121020_Linux-x86-64.zip

                               

                               

                              Patch 20766180

                                  - Filename: p20766180_121020_Generic.zip

                               

                               

                              Patch 20798891

                                  - Filename: p20798891_121020_Linux-x86-64.zip

                               

                               

                              Patch 27264965

                                  - Filename: p27264965_121020_Linux-x86-64.zip

                               

                               

                              Patch 21153266

                                  - Filename: p21153266_121020_Linux-x86-64.zip

                               

                               

                              Patch 21321429

                                  - Filename: p21321429_121020_Generic.zip

                               

                               

                              Patch 21967332

                                  - Filename: p21967332_121020_Linux-x86-64.zip

                               

                               

                              Patch 22223463

                                  - Filename: p22223463_121020_Linux-x86-64.zip

                               

                               

                              Patch 23089357

                                  - Filename: p23089357_121020_Linux-x86-64.zip

                               

                               

                              Patch 24560906

                                  - Filename: p24560906_121020_Linux-x86-64.zip

                               

                               

                              Patch 25305405

                                  - Filename: p25305405_121020_Linux-x86-64.zip

                               

                               

                              Patch 25643931

                                  - Filename: p25643931_121020_Linux-x86-64.zip

                               

                               

                              Patch 25906117

                                  - Filename: p25906117_121020_Linux-x86-64.zip

                               

                               

                               

                               

                              Apply the required patches and rerun this script

                               

                              Download the consolidated EBS patch and apply all listed patches:

                               

                              +-----------------------------------------------------------------------------+

                              A consolidated zip file with the required patches for Database release

                              12.1.0.2.0 is available on My Oracle Support via:

                               

                               

                              Patch 28128412 [12.1.0.2.0 version]

                                  - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JUL 2018

                               

                               

                              Note: This zip does not include any database bundle patches or PSUs.

                              +-----------------------------------------------------------------------------+

                               

                               

                              Patch 28128412 EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR JUL 2018

                              https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=28128412

                               

                               

                              cd /stage/software/12.2.2/12.1.0.2/etcc-bundle/LINUX_X86-64/database/12.1.0.2

                               

                               

                              cd 19779059

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 27069421

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 26113202

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 18793246

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 27591442

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 19291380

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 19393542

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 19591608

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 19627012

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 19649152

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 19835133

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 20093776

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 20294666

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 20766180

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 20798891

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 27264965

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 21153266

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 21321429

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 21967332

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 22223463

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 23089357

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 24560906

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 25305405

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 25643931

                              opatch rollback -id 19908836

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              cd ..

                              cd 25906117

                              opatch prereq CheckConflictAgainstOHWithDetail -ph ./

                              opatch apply

                               

                               

                              Rerun datapatch:

                               

                              cd $ORACLE_HOME/OPatch

                              sqlplus "/as sysdba"

                              startup

                              ./datapatch -verbose

                               

                              Check ETCC again:

                               

                              cd /stage/software/12.2.2/etcc

                              sh checkDBpatch.sh

                               

                              Checking Bugfix XML file for 12.1.0.2

                               

                              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.1.0.1.10.

                              DB-ETCC is compatible with this opatch version.

                               

                              Found patch records in the inventory.

                               

                              Checking Mapping XML file for 12.1.0.2

                               

                              All the required one-off bugfixes are present in Database ORACLE_HOME.

                               

                              Stored Technology Codelevel Checker results in the database prd122 successfully.

                               

                              Finished checking fixes for Oracle Database: Mon Nov  5 13:08:15 PST 2018

                               

                              Regards,

                              Michael

                              • 12. Re: Applying PATCH 12.2.8 (26787767)
                                Beauty_and_dBest

                                Thanks Michael,

                                 

                                Will do it...brb

                                • 13. Re: Applying PATCH 12.2.8 (26787767)
                                  Beauty_and_dBest

                                  Hi Michael,

                                   

                                  The adgrants worked and I was able to  apply patch 12.2.8.

                                   

                                  But I have not finished apply ETCC patched both on database and apps tiers.

                                  I still need to before backup before I run those conflicting overlay patches.

                                   

                                   

                                  Kind regards,