1 2 3 Previous Next 34 Replies Latest reply on Nov 9, 2015 12:52 AM by Beauty_and_dBest

    How to run ETCC in Apps Tier & Db Tier?

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.2.4

      RHEL 6.5

       

      I want to apply the patch R12.TXK.C.delta.7 , but it failed because I did not run ETCC.

      I downloaded and am reading readme of ETCC, but the instruction is not clear

      Can you share me links to blogs with ETCC articles?

       

      Where do I run ETCC? Can I run it on any folder? What environment to source in:

      a.Db Tier

      b.Apps Tier

       

      Is it distructive? Can I run it over and over if I get error?

       

      Thanks a lot,

      jc

        • 1. Re: How to run ETCC in Apps Tier & Db Tier?
          Chiranjeevi M A

          Hello JC,

           

          Please refer below :

           

          How To Run The 12.2 EBS Technology Code Level Checker (ETCC) ? (Doc ID 2008451.1)

          https://blogs.oracle.com/stevenChan/entry/enhanced_etcc_for_database_and

           

          -Chiranjeevi M A

          1 person found this helpful
          • 3. Re: How to run ETCC in Apps Tier & Db Tier?
            Beauty_and_dBest

            Hi ALL,

             

            I run ETCC on the Db Tier:

             

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

            The missing bugfixes are:

            12608451

            14046443

            14255128

            16075609

            16299727

            16359751

            17250794

            17401353

            17901041

            18260550

            18282562

            18284763

            18331812

            18331850

            18440047

            18485835

            18604144

            18607546

            18689530

            18708921

            18730542

            18828868

            18893947

            18966843

            19291380

            19393542

            19472320

            19487147

            19791273

            19835133

            19879144

            19896336

            19949371

            20245930

            20294666

            20476776

            20825533

            20887355

            20936905

            20949558

            21091431

             

            ** Please 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.**

             

            Why soooo many

            Is there a command to patch all in one batch run?

             

            I can not understand what 1594274.1 is talking about???

            Please help....

             

            Thanks.

            • 4. Re: How to run ETCC in Apps Tier & Db Tier?
              Chiranjeevi M A

              Hello JC,

               

              Refer

              "Table 3 Release 11.2.0.4 PSUs and Patch Lists for EBS r12.2" in the following MOS: Database Patch Set Update Overlay Patches Required for Use with PSUs and Oracle E-Business Suite (Doc ID 1147107.1)

               

              -Chiranjeevi M A

              1 person found this helpful
              • 5. Re: How to run ETCC in Apps Tier & Db Tier?
                Beauty_and_dBest

                Thanks Chi,

                 

                Can Oracle not make a big patch that will apply all the missing patches? It would be better if they will create a big patch file, that will selectively apply missing ones both on the apps tier and db tier.

                To think that it is an intelligent dataabse

                 

                Kind regards.

                • 6. Re: How to run ETCC in Apps Tier & Db Tier?
                  Beauty_and_dBest

                  Hi Chi and ALL,

                   

                  For the Apps tier side:

                   

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

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

                  |                     All rights reserved.                      |

                  |             Oracle E-Business Suite Release 12.2              |

                  |           Middle Tier Technology Codelevel Checker            |

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

                   

                   

                  Using context file from command line argument:

                  /u01/install/APPS/fs1/inst/apps/EBSDB_apps/appl/admin/EBSDB_apps.xml

                   

                  Starting Middle Tier Technology Codelevel Checker, Version: 120.0.12020000.21.

                  Wed Nov  4 04:06:23 EST 2015

                  Log file for this session: /u01/PATCHES/R12.2.5/17537119/checkMTpatch_21368.log

                   

                  Bugfix XML file version: 120.0.12020000.20

                  This file will be used as the reference for identifying missing bugfixes.

                   

                   

                  Checking for prerequisite bugfixes in File Edition: run

                  stty: standard input: Inappropriate ioctl for device

                   

                  Enter the password for the APPS user: stty: standard input: Inappropriate ioctl for device

                   

                  Database connection successful.

                  The installed AD.C.7 codelevel supports storing the results in the database.

                   

                  Table to store results already exists in database.

                   

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

                  Oracle Forms and Reports

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

                  Now examining product Oracle Forms and Reports.

                   

                  Oracle Home = /u01/install/APPS/fs1/EBSapps/10.1.2.

                  Product version = 10.1.2.3.0.

                  Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.

                    Missing Bugfix: 15900214

                    Missing Bugfix: 18620223

                    Missing Bugfix: 6161079

                    Missing Bugfix: 10226288

                    Missing Bugfix: 17352288

                    Missing Bugfix: 17371380

                    Missing Bugfix: 18106849

                    Missing Bugfix: 18113008

                    Missing Bugfix: 18780976

                    Missing Bugfix: 19180118

                    Missing Bugfix: 19190343

                    Missing Bugfix: 17353142

                    Missing Bugfix: 20643256

                    Missing Bugfix: 16041055

                    Missing Bugfix: 16910762

                    Missing Bugfix: 20270659

                    Missing Bugfix: 17372642

                    Missing Bugfix: 17566694

                    Missing Bugfix: 20240480

                    Missing Bugfix: 19304738

                  The above list shows missing bugfixes for Oracle Forms and Reports.

                  These results have been stored in the database.

                   

                  Checking required bugfixes for RSF within Forms 10.1.0.5.0.

                  All required bugfixes are present for RSF within Forms.

                  These results have been stored in the database.

                   

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

                  Oracle Fusion Middleware (FMW) - Web Tier

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

                  Now examining product Oracle Fusion Middleware (FMW) - Web Tier.

                   

                  Oracle Home = /u01/install/APPS/fs1/FMW_Home/webtier.

                  Product Version = 11.1.1.6.0

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

                  [WARNING]

                  Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.6.0 is no longer

                  recommended for use with Oracle E-Business Suite Release 12.2.

                  Details of required bugfixes and patches are no longer

                  maintained for this version, so ETCC output may be out of date

                  and inapplicable.

                   

                  For information on recommended versions, refer to My Oracle Support Knowledge

                  Document 1594274.1, "Oracle E-Business Suite Release 12.2: Consolidated List

                  of Patches and Technology Bug Fixes".

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

                   

                  Checking required bugfixes for FMW - Web Tier 11.1.1.6.0.

                    Missing Bugfix: 13055259

                    Missing Bugfix: 13873275

                    Missing Bugfix: 13895314

                    Missing Bugfix: 14144116

                    Missing Bugfix: 17526668

                    Missing Bugfix: 17555224

                    Missing Bugfix: 17988318

                    Missing Bugfix: 18025250

                    Missing Bugfix: 19848621

                  The above list shows missing bugfixes for FMW - Web Tier.

                  These results have been stored in the database.

                   

                  Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.

                  All required bugfixes are present for RSF within FMW Web tier.

                  These results have been stored in the database.

                   

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

                  Oracle Fusion Middleware (FMW) - oracle_common

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

                  Now examining product Oracle Fusion Middleware (FMW) - oracle_common.

                   

                  Oracle Home = /u01/install/APPS/fs1/FMW_Home/oracle_common.

                  Product Version = 11.1.1.6.0

                   

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

                  [WARNING]

                  Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.6.0 is no longer

                  recommended for use with Oracle E-Business Suite Release 12.2.

                  Details of required bugfixes and patches are no longer

                  maintained for this version, so ETCC output may be out of date

                  and inapplicable.

                   

                  For information on recommended versions, refer to My Oracle Support Knowledge

                  Document 1594274.1, "Oracle E-Business Suite Release 12.2: Consolidated List

                  of Patches and Technology Bug Fixes".

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

                   

                  Checking required bugfixes for FMW - oracle common 11.1.1.6.0.

                    Missing Bugfix: 14803792

                    Missing Bugfix: 14754223

                    Missing Bugfix: 17284368

                    Missing Bugfix: 13490778

                    Missing Bugfix: 13826887

                    Missing Bugfix: 16298679

                    Missing Bugfix: 10329500

                    Missing Bugfix: 16363702

                    Missing Bugfix: 19775074

                    Missing Bugfix: 20484781

                  The above list shows missing bugfixes for FMW - oracle common.

                  These results have been stored in the database.

                   

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

                  Oracle WebLogic Server (WLS)

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

                  Now examining product Oracle WebLogic Server.

                   

                  Oracle Home = /u01/install/APPS/fs1/FMW_Home/wlserver_10.3.

                  Product Version = 10.3.6.0.7

                   

                  Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.

                   

                  Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.7.

                    Missing Patch ID: 11781879

                    Missing Patch ID: 13337000

                    Missing Patch ID: 13729611

                    Missing Patch ID: 17319481

                    Missing Patch ID: 19687084

                    Missing Patch ID: 19600486

                    Missing Patch ID: 20474010

                  The above list shows missing patches for Oracle WebLogic Server.

                  If you have applied other Oracle WebLogic Server patches, they may have included the bugfixes needed.

                  Contact Oracle Support if you require assistance in determining whether this is the case.

                  These results have been stored in the database.

                   

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

                   

                  One or more products have bugfixes missing.

                  Apply the missing bugfixes and rerun this script.

                   

                  See Doc ID 1594274.1 for the patches that provide the bugfixes.

                  The footnotes for patches also apply to corresponding overlay patches.

                   

                  Finished checking prerequisite patches for File Edition: run.

                  Wed Nov  4 04:06:47 EST 2015

                   

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

                  [applmgr@apps 17537119]$

                   

                  Please help me how to resolve these tasks

                   

                  Thanks a lot.

                  • 7. Re: How to run ETCC in Apps Tier & Db Tier?
                    Chiranjeevi M A

                    12.2 E-Business Suite Patching - How To Determine The Correct Patch Number For The Missing Database (DB) And Middle Tier (MT)Patches Listed By The EBS Technology Code Level Checker (ETCC) (Doc ID 2057925.1)

                    Oracle E-Business Suite Release 12.2: Consolidated List of Patches and Technology Bug Fixes (Doc ID 1594274.1)

                     

                    -Chiranjeevi M A

                    1 person found this helpful
                    • 8. Re: How to run ETCC in Apps Tier & Db Tier?
                      Pravin Takpire

                      You will have to apply the patches

                      ************************************************************************************
                      Oracle Forms and Reports 10.1.2.3.0
                      Apply patches -- 15900214,21103001 which will fix below bugs
                      Missing Bugfix: 15900214
                      Missing Bugfix: 18620223
                      Missing Bugfix: 6161079
                      Missing Bugfix: 10226288
                      Missing Bugfix: 17352288
                      Missing Bugfix: 17371380
                      Missing Bugfix: 18106849
                      Missing Bugfix: 18113008
                      Missing Bugfix: 18780976
                      Missing Bugfix: 19180118
                      Missing Bugfix: 19190343
                      Missing Bugfix: 17353142
                      Missing Bugfix: 20643256
                      Missing Bugfix: 16041055
                      Missing Bugfix: 16910762
                      Missing Bugfix: 20270659
                      Missing Bugfix: 17372642
                      Missing Bugfix: 17566694
                      Missing Bugfix: 20240480
                      Missing Bugfix: 19304738
                      ********************************************************************************
                      Oracle Fusion Middleware (FMW) - Web Tier -- 11.1.1.6.0
                      Apply patches -- 17555224,20213778,20816425 which will fix below bugs
                      Missing Bugfix: 13055259
                      Missing Bugfix: 13873275
                      Missing Bugfix: 13895314
                      Missing Bugfix: 14144116
                      Missing Bugfix: 17526668
                      Missing Bugfix: 17555224
                      Missing Bugfix: 17988318
                      Missing Bugfix: 18025250
                      Missing Bugfix: 19848621
                      ******************************************************************************************
                      FMW - oracle common 11.1.1.6.0.
                      Apply patches -- 14803792,14754223,17284368,13490778,13826887,16298679,17442957,20642039
                      which will fix below bugs
                      Missing Bugfix: 14803792
                      Missing Bugfix: 14754223
                      Missing Bugfix: 17284368
                      Missing Bugfix: 13490778
                      Missing Bugfix: 13826887
                      Missing Bugfix: 16298679
                      Missing Bugfix: 10329500
                      Missing Bugfix: 16363702
                      Missing Bugfix: 19775074
                      Missing Bugfix: 20484781
                      *****************************************************************************************
                      Oracle WebLogic Server (WLS) 10.3.6.0.7.
                      Apply patches -- 11781879,13337000,13729611,17319481,19687084,19600486,20474010
                      which will fix below bugs
                      Missing Patch ID: 11781879
                      Missing Patch ID: 13337000
                      Missing Patch ID: 13729611
                      Missing Patch ID: 17319481
                      Missing Patch ID: 19687084
                      Missing Patch ID: 19600486
                      Missing Patch ID: 20474010
                      *****************************************************************************************

                       

                      regards

                      Pravin

                      1 person found this helpful
                      • 9. Re: How to run ETCC in Apps Tier & Db Tier?
                        Beauty_and_dBest

                        Thanks Pravin and Chi

                         

                        How about the Db Tier side? Do I need to apply all listed above? I can not understand what are PSU and overlay patches.

                        These patches are pre-requisites only to 100Mb size patch R12.TXK.C.delta.7...How much more for the 10Gb size 12.2.5.


                        Kind regards.

                        • 10. Re: How to run ETCC in Apps Tier & Db Tier?
                          Pravin Takpire

                          How about the Db Tier side? Do I need to apply all listed above?

                          --> You need to apply all patches which came out in ETCC report.

                           

                          How many pre-req are there for patches depends on the patch.

                          regards

                          Pravin

                          1 person found this helpful
                          • 11. Re: How to run ETCC in Apps Tier & Db Tier?
                            Beauty_and_dBest

                            Thanks Pravin,

                             

                            Is it possible to merge them, so I can run one time in a batch mode?

                            • 12. Re: How to run ETCC in Apps Tier & Db Tier?
                              Pravin Takpire

                              Patches which are being applied using opatch you can not merge but application patches applied using adop can merge.

                              regards

                              Pravin

                              1 person found this helpful
                              • 13. Re: How to run ETCC in Apps Tier & Db Tier?
                                Beauty_and_dBest

                                Thanks

                                 

                                The process is so tedious, lots of patches to apply, one patch mistake will ruin the whole upgrade. Very risky to apply in PROD. I am not really sure if I am going the right way. I am afraid my labor will just be wasted

                                 

                                I remember I have done similar to this in previous versions. I keep on applying patches almost completed 50% out of 50 patches both apps & db. I did not encounter error, but when I test to start the apps, it won't start anymore.  So this gives me phobia of upgrading using complicated process. You have to abandon ship at wait for the rapidwiz to create the whole installer package. Maybe I will just wait that the R12.2.5 installer will come out? or its VM virtual appliance counterpart?

                                 

                                Kind regards.

                                • 14. Re: How to run ETCC in Apps Tier & Db Tier?
                                  ora_tech

                                  Hi Jenna,

                                   

                                  The process of Installing the patches is not difficult but for successful upgrades the perfect patch analysis is the key. I totally agree with you that one single mistake may ruin your system. So that is the only reason for any major patches you must backup your system.

                                   

                                  You can wait for 12.2.5 VM availaibility or if you want you can give a try for the upgrade and atleast you will get some experiece on this new release

                                   

                                  thanks,

                                  X A H E E R


                                  1 person found this helpful
                                  1 2 3 Previous Next