14 Replies Latest reply on Oct 23, 2019 1:13 AM by Beauty_and_dBest

    OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW

    Beauty_and_dBest

      EBS 12.2.8

      12c

      OL6

       

       

      Hi ALL,

       

      I am applying latest ETCC patches for our appsTier.

       

      Below is the ETCC output:

       

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

      PATCH RECOMMENDATION SUMMARY

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

      One or more products have bugfixes missing.

      The default patch recommendations to install these missing bugfixes are:

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

      Oracle Forms and Reports 10.1.2.3.0

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

        Patch 27491934

          - Filename: p27491934_101232_LINUX.zip

       

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

      Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

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

        Patch 27369643

          - Filename: p27369643_111190_Linux-x86-64.zip

       

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

      RSF within FMW Web tier 11.1.0.7.0

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

        Patch 7572595

          - Filename: p7572595_111070_Linux-x86-64.zip

       

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

      Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

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

        Patch 27120730

          - Filename: p27120730_111190_Generic.zip

       

        Patch 27212806

          - Filename: p27212806_111190_Generic.zip

       

        Patch 28708563

          - Filename: p28708563_111190_Generic.zip

       

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

      Oracle WebLogic Server (WLS) 10.3.6.0.171017

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

        Patch 27395085 [SU Patch [GFWX]: WLS PSU 10.3.6.0.180417]

          - Filename: p27395085_1036_Generic.zip

       

      Apply the required patches and rerun this script.

       

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

      A consolidated zip file with the required application tier patches is

      available on My Oracle Support via:

       

        Patch 29778100

          - EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR JUL 2019

       

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

      [WARNING]  Patch 27395085 [SU Patch [GFWX]: WLS PSU 10.3.6.0.180417] is missing.

      This is the current recommended minimum WLS patch set.

      As patch sets are not included in the consolidated zip file, you must obtain it

      (or a later one, if available) from My Oracle Support and install it by

      following its Readme.

      After successful installation, rerun this script to check for any further

      available fixes.

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

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

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

       

      Finished checking prerequisite patches for File Edition: run.

      Tue Oct 15 21:01:39 PST 2019

       

      Log file for this session: /u04/ETCC/log/checkMTpatch_18869.log

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

       

       

       

       

      I am applying FMW patch 27369643, but I got warning below:

       

      [appp1228@trnsrvr 27369643]$ opatch apply

      Oracle Interim Patch Installer version 11.1.0.11.0

      Copyright (c) 2019, Oracle Corporation.  All rights reserved.

       

      Oracle Home       : /u04/appp1228/P1228/fs1/FMW_Home/oracle_common

      Central Inventory : /u03/oraInventory

         from           : /u04/appp1228/P1228/fs1/FMW_Home/oracle_common/oraInst.loc

      OPatch version    : 11.1.0.11.0

      OUI version       : 11.1.0.9.0

      Log file location : /u04/appp1228/P1228/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/27369643_Oct_20_2019_17_40_27/apply2019-10-20_17-40-27PM_1.log

       

      OPatch detects the Middleware Home as "/u04/appp1228/P1228/fs1/FMW_Home"

       

      Applying interim patch '27369643' to OH '/u04/appp1228/P1228/fs1/FMW_Home/oracle_common'

      Verifying environment and performing prerequisite checks...

      OPatch system modification phase did not start:

      Patch "27369643" is not needed since it has no fixes for this Oracle Home. Please see log file for details.

      Log file location: /u04/appp1228/P1228/fs1/FMW_Home/oracle_common/cfgtoollogs/opatch/27369643_Oct_20_2019_17_40_27/apply2019-10-20_17-40-27PM_1.log

       

      OPatch stopped on request.

      [appp1228@trnsrvr 27369643]$

       

       

       

      Did I set the correct Oracle_Home above? Or it is a result of invalid home?

       

      Please help...

       

       

      Kind regards,

      jc

        • 1. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
          Beauty_and_dBest

          Hi ALL,

           

          I lost my notes on how to set Oracle Home of the following

          This is to apply opatch.

           

          1. Oracle Forms and Reports 10.1.2.3.0

          2. Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

          3. RSF within FMW Web tier 11.1.0.7.0

          4. Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

          5. Oracle WebLogic Server (WLS) 10.3.6.0.171017

           

           

          Please help....

           

          Kind regards,

          • 2. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
            mdtaylor

            Hi jc,

             

            You can use this note, and a screenshot for this years OpenWorld conference:

             

            Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)

             

            Screen Shot 2019-10-20 at 3.32.39 PM.png

             

            Regards,

            Michael

            • 3. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
              Beauty_and_dBest

              Thanks Michael,

               

              I am confused

              I did not know I need to set to PATCH  edition environment for all the ETCC patching activities on the appsTier?

              Can you confirm please, that I need to set to the PATCH edition > . EBSapps.env  patch

               

              For all the ETCC patching activity below:

              1. Oracle Forms and Reports 10.1.2.3.0

              2. Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

              3. RSF within FMW Web tier 11.1.0.7.0

              4. Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

              5. Oracle WebLogic Server (WLS) 10.3.6.0.171017

               

               

              Or is it ok to run  on both RUN and PATCH edition?

               

               

              Please help...

               

              Kind regards,

              • 4. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                VishnuVinnakota

                Hi,

                 

                  Always apply on patch edition in EBS 12.2.

                 

                1. .EBSapps.env patch
                2. adop phase=prepare
                3. Apply all ETCC patches on Patch File System
                4. Run cutover, cleanup

                 

                Thanks,

                Vishnu

                • 5. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                  Beauty_and_dBest

                  Thanks Vishnu and ALL,

                   

                  I thought ETCC patches are different from adop patches

                  Because ETCC uses opatch and the database needs to be down.

                   

                  Does the dbTier patches need adop=prepare as well?  or only the MT patches?

                   

                   

                  Kind regards,

                  • 6. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                    Beauty_and_dBest

                    Hi ALL,

                     

                    Re: Oracle E-Business Suite 12.2 Patching Technology Components Guide (Doc ID 1355068.1)

                    Are there other docs that is more correct than this?

                     

                    It does not show the correct OracleHome settings for

                    Oracle Forms and Reports 10.1.2.3.0

                     

                    It only say: Source the OracleAS Oracle Home environment.

                    Which is vague is you do not know it.

                     

                     

                    Are there other Note that mentioned specifically as below sample?

                     

                    $ export ORACLE_HOME=$FMW_HOME/oracle_common

                     

                     

                    Please help...

                     

                    Kind regards,

                    • 7. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                      VishnuVinnakota

                      Hi,

                       

                          Firstly these patches are different from ADOP (EBS) patches but the important thing is to do apply them in patch cycle to just cutover the filesystem. So you won't apply these with adop phase=apply but with opatch or bsu etc. The only reason you start adop patch cycle is to just cutover or flip the file system.

                       

                           Simply set ORACLE_HOME to correct Home which you are going to apply and then apply.

                       

                           For e.g. if applying on 10.1.2 (Forms and Reports),

                       

                            export ORACLE_HOME=/u02/appltest/apps/fs1/EBSapps/10.1.2

                            export PATH=$PATH:$ORACLE_HOME/OPatch

                            cd <Patch_Location>

                            opatch apply

                       

                          You need to patch 3 Homes basically.

                       

                      • WebLogic
                      • Forms and Reports (For e.g. /u02/appltest/apps/fs1/EBSapps/10.1.2 )
                      • Common (For e.g. /u02/appltest/apps/fs1/FMW_Home/oracle_common)

                       

                          Hope its clear .. Let me know.

                       

                      Thanks,

                      Vishnu

                      https://vishnu.ae

                      • 8. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                        Beauty_and_dBest

                        Thanks Vishnu and ALL,

                         

                        Sorry my reading compre is low

                         

                        What happen if I already applied one patch at the opatch run edition?

                        Is it okay to repeat or rerun it again on the Patch edition?

                         

                         

                        Kind regards,

                        • 9. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                          VishnuVinnakota

                          Hi,

                           

                            If you already applied patches in Run file system and you start a new patch cycle, it will sync automatically to Patch File System.

                           

                          Thanks,

                          Vishnu

                          • 10. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                            Beauty_and_dBest

                            Thanks Vishnu,

                             

                            Can you provide the other sample OracleHome settings for below?

                             

                                 export ORACLE_HOME=/u02/appltest/apps/fs1/EBSapps/10.1.2

                                  export PATH=$PATH:$ORACLE_HOME/OPatch

                                  cd <Patch_Location>

                                  opatch apply

                             

                                You need to patch 3 Homes basically. >>> But I have five(5) listed home in ETCC list

                             

                            1. Oracle Forms and Reports 10.1.2.3.0

                            2. Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

                            3. RSF within FMW Web tier 11.1.0.7.0

                            4. Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

                            5. Oracle WebLogic Server (WLS) 10.3.6.0.171017

                             

                            Do you mean #2,3,4  have the same OracleHome?

                             

                            • WebLogic  (is there no home for this?)
                            • Forms and Reports (For e.g. /u02/appltest/apps/fs1/EBSapps/10.1.2 )
                            • Common (For e.g. /u02/appltest/apps/fs1/FMW_Home/oracle_common)

                             

                             

                             

                            But I have other ETCC MT patches left.

                            I will apply them on the patch edition using opatch.

                            Below are the MT ETCC patches to be applied, I already applied the first two patches (Patch 27491934, and  Patch 27369643) and  as run edition.

                             

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

                            PATCH RECOMMENDATION SUMMARY

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

                            One or more products have bugfixes missing.

                            The default patch recommendations to install these missing bugfixes are:

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

                            Oracle Forms and Reports 10.1.2.3.0

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

                              Patch 27491934

                                - Filename: p27491934_101232_LINUX.zip

                             

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

                            Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

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

                              Patch 27369643

                                - Filename: p27369643_111190_Linux-x86-64.zip

                             

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

                            RSF within FMW Web tier 11.1.0.7.0

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

                              Patch 7572595

                                - Filename: p7572595_111070_Linux-x86-64.zip

                             

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

                            Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

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

                              Patch 27120730

                                - Filename: p27120730_111190_Generic.zip

                             

                              Patch 27212806

                                - Filename: p27212806_111190_Generic.zip

                             

                              Patch 28708563

                                - Filename: p28708563_111190_Generic.zip

                             

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

                            Oracle WebLogic Server (WLS) 10.3.6.0.171017

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

                              Patch 27395085 [SU Patch [GFWX]: WLS PSU 10.3.6.0.180417]

                                - Filename: p27395085_1036_Generic.zip

                             

                            Apply the required patches and rerun this script.

                             

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

                             

                             

                             

                             

                            Please help what steps to do next? to apply the remaining patches.

                            .

                            Do I open new patching cycle again and source PATCH edition?

                             

                             

                            Kind regards,

                            • 11. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                              VishnuVinnakota

                              Hi,

                               

                                 Actions needs to be carried out based on readme. Try going through readme and start applying. If you can't apply a specific patch, then we can see it. As I said, follow below process:

                               

                              1. .EBSapps.env patch
                              2. adop phase=prepare
                              3. Apply all patches on Patch File System
                              4. Run cutover, cleanup

                               

                              Thanks,

                              Vishnu

                              • 12. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                                Beauty_and_dBest

                                Thanks Vishnu,

                                 

                                When you say 3 OracleHomes, do below products have only one, or common, or the same home?

                                2. Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

                                3. RSF within FMW Web tier 11.1.0.7.0

                                4. Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

                                 

                                I already applied  patches (Patch 27491934, and  Patch 27369643)

                                How do I validate if which edition was it applied? or if it was really applied?

                                 

                                 

                                Kind regards,

                                • 13. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                                  VishnuVinnakota

                                  Hi,

                                   

                                  Example locations:

                                   

                                  /u02/appuat/UAT/fs1/FMW_Home/webtier

                                  /u02/appuat/UAT/fs1/EBSapps/10.1.2

                                  /u02/appuat/UAT/fs1/FMW_Home/oracle_common

                                   

                                  RSF is within the WebTier.

                                   

                                  You need to set ORACLE_HOME and PATh with OPatch like given before then run "opatch lsinventory" to check if patches are applied.

                                   

                                  Thanks,

                                  Vishnu

                                  • 14. Re: OPatch stopped on request > Opatch apply - EBS 12.2.8 FMW
                                    Beauty_and_dBest

                                    Thanks Vishnu and ALL,

                                     

                                    Its is now clear

                                     

                                     

                                    Kind regards.