ETCC in 12.x

Beauty_and_dBest

    Hi ALL,

     

     

    Is ETCC applicable in EBS 12.1 and 12.0?

     

     

    Kind regards,jc

      • 1. Re: ETCC in 12.x
        Narsi M-Oracle

        Hello JC,

         

        ETCC is only applicable to EBS 12.2.

        ETCC is not applicable for 12.0 or 12.1

         

         

        Regards,

        Narsi

        • 2. Re: ETCC in 12.x
          Beauty_and_dBest

          Thanks Narsi,

           

           

          Is it both the Apps Tier and Db Tier of 12.2 ? or If my database is 12c does it qualifies for ETCC on the Db side even if the apps is 12.1?

           

           

          Kind regards,

          • 3. Re: ETCC in 12.x
            Narsi M-Oracle

            Hello,

             

            Yes. You have ETCC patches for both DB Tier & Apps Tier in 12.2. checkDBpatch.sh for DB Tier & checkMTpatch.sh for Appl.Tier

             

            ETCC is not applicable for 12.0 or 12.1 for any versions of DB. So, for 12c DB also, ETCC is not applicable for EBS 12.1.

             

            Hope this clarifies.

             

             

            Regards,

            Narsi

            • 4. Re: ETCC in 12.x
              Beauty_and_dBest

              Thanks Narsi,

               

              But we are planning to upgrade our EBS 12.1 to 12.2.

              And we have upgraded already the database to 12c first.

              Is it not possible to install the ETCC patch on the 12c database (first)?

               

              Why is that the patch ETCC is not tagged as 12.2 version?

               

              I am confused of the ETCC readme

               

              Usage Scenarios

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

               

              - If you are upgrading to Release 12.2 with an existing Oracle Database Release 11.2.0.3, 11.2.0.4, 12.1.0.1 or 12.1.0.2, before you run Rapid Install to create the upgrade file system you must run DB-ETCC to ensure you have installed all the required one-off database bugfixes.

               

              - If you are applying the latest AD-TXK release update packs, you must run DB-ETCC and MT-ETCC (in that order) to ensure you have applied all the required database and middle tier technology one-off bugfixes. (Note that for Oracle WebLogic Server, MT-ETCC verifies patches rather than bugfixes.)

               

               

              So right now, we are upgrading our 12.1  to 12.2  and our existing database is now 12.1.0.2 , so I will run DB-ETCC?

               

              Please shed lights....

               

              Kind regards,

              • 5. Re: ETCC in 12.x
                Kirushna

                Hi,

                 

                Yes you can run the ETCC for DB 12.1.0.2 if you have upgrades as part of R12.2 application upgrade. You need to call the right script as mentioned by Narsi (checkDBpatch.sh for DB Tier).

                 

                The script will check if the required patches available/applied.

                 

                Regards,

                Kirushna

                • 6. Re: ETCC in 12.x
                  Beauty_and_dBest

                  Thanks Kirushna and ALL,

                   

                  I have upgraded our EBS 12.1.3  whose database is 11.1.0.7 .

                  This database is upgraded to 12.1.0.2.

                   

                  I run the DB-ETCC on this upgraded database, and I got below:

                  Please advise what to do with all the long list of patches

                  Do I need to apply ALL?

                   

                   

                  Connecting to database.

                  Database connection successful.

                   

                  Database PROD is in READ WRITE mode.

                   

                  Identifying APPS and APPLSYS schema names.

                  - APPS schema : APPS

                  - APPLSYS schema : APPLSYS

                   

                  Checking for DB-ETCC results table.

                  Creating DB-ETCC results table.

                  Created the table to store DB-ETCC results.

                   

                  Checking if InMemory option is enabled.

                  InMemory option is not enabled in the database.

                   

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

                  DB-ETCC is compatible with this opatch version.

                   

                  Found patch records in the inventory.

                   

                  Checking Mapping XML file for 12.1.0.2

                   

                    Missing Bugfix: 14666816  ->  Patch 27264965

                    Missing Bugfix: 16359751  ->  Patch 19779059

                    Missing Bugfix: 18485835  ->  Patch 27062381

                    Missing Bugfix: 18607546  ->  Patch 26113202

                    Missing Bugfix: 18674024  ->  Patch 27872956

                    Missing Bugfix: 18689530  ->  Patch 22098146

                    Missing Bugfix: 18793246  ->  Patch 18793246

                    Missing Bugfix: 18964939  ->  Patch 27872956

                    Missing Bugfix: 18966843  ->  Patch 18966843

                    Missing Bugfix: 19239846  ->  Patch 27872956

                    Missing Bugfix: 19291380  ->  Patch 19291380

                    Missing Bugfix: 19472320  ->  Patch 19472320

                    Missing Bugfix: 19487147  ->  Patch 27872956

                    Missing Bugfix: 19536415  ->  Patch 27872956

                    Missing Bugfix: 19591608  ->  Patch 19591608

                    Missing Bugfix: 19791273  ->  Patch 26113202

                    Missing Bugfix: 19835133  ->  Patch 19835133

                    Missing Bugfix: 19896336  ->  Patch 27872956

                    Missing Bugfix: 20093776  ->  Patch 20093776

                    Missing Bugfix: 20181016  ->  Patch 20181016

                    Missing Bugfix: 20245930  ->  Patch 27872956

                    Missing Bugfix: 20294666  ->  Patch 20294666

                    Missing Bugfix: 20413820  ->  Patch 27872956

                    Missing Bugfix: 20476776  ->  Patch 27264965

                    Missing Bugfix: 20588502  ->  Patch 27872956

                    Missing Bugfix: 20627866  ->  Patch 27872956

                    Missing Bugfix: 20766180  ->  Patch 20766180

                    Missing Bugfix: 20798891  ->  Patch 20798891

                    Missing Bugfix: 20825533  ->  Patch 27872956

                    Missing Bugfix: 20868862  ->  Patch 27264965

                    Missing Bugfix: 20887355  ->  Patch 20887355

                    Missing Bugfix: 20936905  ->  Patch 27872956

                    Missing Bugfix: 21028698  ->  Patch 22098146

                    Missing Bugfix: 21091431  ->  Patch 27872956

                    Missing Bugfix: 21106027  ->  Patch 27872956

                    Missing Bugfix: 21153266  ->  Patch 21153266

                    Missing Bugfix: 21321429  ->  Patch 21321429

                    Missing Bugfix: 21387964  ->  Patch 27872956

                    Missing Bugfix: 21614112  ->  Patch 27062381

                    Missing Bugfix: 21751519  ->  Patch 27264965

                    Missing Bugfix: 21813400  ->  Patch 27872956

                    Missing Bugfix: 21864513  ->  Patch 21864513

                    Missing Bugfix: 21904072  ->  Patch 21904072

                    Missing Bugfix: 21967332  ->  Patch 21967332

                    Missing Bugfix: 22024071  ->  Patch 27872956

                    Missing Bugfix: 22223463  ->  Patch 22223463

                    Missing Bugfix: 22229581  ->  Patch 27264965

                    Missing Bugfix: 22452653  ->  Patch 27264965

                    Missing Bugfix: 22496904  ->  Patch 22496904

                    Missing Bugfix: 22568797  ->  Patch 27872956

                    Missing Bugfix: 22660003  ->  Patch 27062381

                    Missing Bugfix: 22666802  ->  Patch 27872956

                    Missing Bugfix: 22731026  ->  Patch 22731026

                    Missing Bugfix: 22737974  ->  Patch 27264965

                    Missing Bugfix: 23089357  ->  Patch 23089357

                    Missing Bugfix: 23125826  ->  Patch 26113202

                    Missing Bugfix: 23220453  ->  Patch 27872956

                    Missing Bugfix: 23604553  ->  Patch 27264965

                    Missing Bugfix: 23632545  ->  Patch 27872956

                    Missing Bugfix: 23645516  ->  Patch 27872956

                    Missing Bugfix: 24326444  ->  Patch 27872956

                    Missing Bugfix: 24385983  ->  Patch 27872956

                    Missing Bugfix: 24560906  ->  Patch 24560906

                    Missing Bugfix: 24589081  ->  Patch 27872956

                    Missing Bugfix: 25099339  ->  Patch 27872956

                    Missing Bugfix: 25139545  ->  Patch 27264965

                    Missing Bugfix: 25305405  ->  Patch 25305405

                    Missing Bugfix: 25643931  ->  Patch 25643931

                    Missing Bugfix: 25906117  ->  Patch 25906117

                    Missing Bugfix: 25971286  ->  Patch 27872956

                    Missing Bugfix: 25919622  ->  Patch 27872956

                    Missing Bugfix: 26336977  ->  Patch 27872956

                    Missing Bugfix: 26654363  ->  Patch 27872956

                    Missing Bugfix: 26658759  ->  Patch 27872956

                    Missing Bugfix: 26911000  ->  Patch 27062381

                    Missing Bugfix: 26742604  ->  Patch 27264965

                   

                  Generating Patch Recommendation Summary.

                   

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

                  PATCH RECOMMENDATION SUMMARY

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

                  The default patch recommendations to install these missing bugfixes are:

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

                  Oracle Database Release 12.1.0.2  (No PSU applied)

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

                    Patch 27264965

                      - Filename: p27264965_121020_Linux-x86-64.zip

                   

                    Patch 19779059

                      - Filename: p19779059_121020_Linux-x86-64.zip

                   

                    Patch 27062381

                      - Filename: p27062381_121020_Linux-x86-64.zip

                   

                    Patch 26113202

                      - Filename: p26113202_121020_Linux-x86-64.zip

                   

                    Patch 27872956

                      - Filename: p27872956_121020_Linux-x86-64.zip

                   

                    Patch 22098146

                      - Filename: p22098146_121020_Linux-x86-64.zip

                   

                    Patch 18793246

                      - Filename: p18793246_121020_Generic.zip

                   

                    Patch 18966843

                      - Filename: p18966843_121020_Generic.zip

                   

                    Patch 19291380

                      - Filename: p19291380_121020_Linux-x86-64.zip

                   

                    Patch 19472320

                      - Filename: p19472320_121020_Linux-x86-64.zip

                   

                    Patch 19591608

                      - Filename: p19591608_121020_Linux-x86-64.zip

                   

                    Patch 19835133

                      - Filename: p19835133_121020_Linux-x86-64.zip

                   

                    Patch 20093776

                      - Filename: p20093776_121020_Linux-x86-64.zip

                   

                    Patch 20181016

                      - Filename: p20181016_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 20887355

                      - Filename: p20887355_121020_Generic.zip

                   

                    Patch 21153266

                      - Filename: p21153266_121020_Linux-x86-64.zip

                   

                    Patch 21321429

                      - Filename: p21321429_121020_Generic.zip

                   

                    Patch 21864513

                      - Filename: p21864513_121020_Linux-x86-64.zip

                   

                    Patch 21904072

                      - Filename: p21904072_121020_Linux-x86-64.zip

                   

                    Patch 21967332

                      - Filename: p21967332_121020_Linux-x86-64.zip

                   

                    Patch 22223463

                      - Filename: p22223463_121020_Linux-x86-64.zip

                   

                    Patch 22496904

                      - Filename: p22496904_121020_Linux-x86-64.zip

                   

                    Patch 22731026

                      - Filename: p22731026_121020_Generic.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

                   

                  You should check the patch READMEs for minimum opatch version requirements.

                  The latest opatch is available from My Oracle Support via Patch 6880880.

                   

                   

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

                  A consolidated zip file with the required patches for Database release

                  12.1.0.2.0 is available on My Oracle Support via:

                   

                    Patch 27557445 [12.1.0.2.0 version]

                      - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR APR 2018

                   

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

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

                   

                  See Doc ID 1594274.1 for any special instructions for these patches.

                  Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

                   

                  Stored Technology Codelevel Checker results in the database PROD successfully.

                   

                  Finished checking fixes for Oracle Database: Sun Jul  1 17:19:57 PHT 2018

                   

                  Log file for this session: ./checkDBpatch_18527.log

                   

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

                  • 7. Re: ETCC in 12.x
                    Narsi M-Oracle

                    Hello JC,

                     

                    Yes. You need to apply all the patches from the following:

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

                    PATCH RECOMMENDATION SUMMARY

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

                     

                    Ensure you review following as well:

                    Database Preparation Guidelines for an E-Business Suite Release 12.2 Upgrade (Doc ID 1349240.1)

                     

                    Hope this helps

                     

                     

                    Regards,

                    Narsi

                    • 8. Re: ETCC in 12.x
                      Beauty_and_dBest

                      Thanks Narsi and ALL,

                       

                      The recommended patch list count is = 32

                      Do I need to follow the sequencing in applying the patches? Does the first patch in the list (Patch 27264965) should be applied first, and so on...?

                       

                       

                      Kind regards,

                      • 9. Re: ETCC in 12.x
                        Beauty_and_dBest

                        Hi ALL,

                         

                        Re: below ETCC notes:

                         

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

                        A consolidated zip file with the required patches for Database release

                        12.1.0.2.0 is available on My Oracle Support via:

                         

                          Patch 27557445 [12.1.0.2.0 version]

                            - EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR APR 2018

                         

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

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

                         

                         

                        Which of the following patches do I need?