13 Replies Latest reply on Feb 13, 2019 4:28 AM by Beauty_and_dBest

    EBS 12.2.7 - Merging patches

    Beauty_and_dBest

      EBS 12.2.7

      12c

      OL6

       

      Hi ALL,

       

      I am applying patches using merge option, but I got error

       

      $ adop phase=apply patches=27254132,27294892,28394214,27638770,28714940 merge=yes patchtop=/u01/PATCH/R1228

       

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

       

      Validating credentials.

       

      Initializing.

          Run Edition context  : /u03/app1228p/P1228/fs1/inst/apps/P1228_testsvr3/appl/admin/P1228_testsvr3.xml

          Patch edition context: /u03/app1228p/P1228/fs2/inst/apps/P1228_testsvr3/appl/admin/P1228_testsvr3.xml

          Patch file system free space: 337.27 GB

       

      Validating system setup.

          Node registry is valid.

          [WARNING]   ETCC: The following required database fixes have not been applied to node testsvr3:

                        26336977

                        26654363

                        26742604

                        28507324

                        28259867

                      Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

       

      Checking for existing adop sessions.

          Continuing with existing session [Session ID: 35].

       

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

      ADOP (C.Delta.10)

      Session ID: 35

      Node: testsvr3

      Phase: apply

      Log: /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/35/20190211_230859/adop.log

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

       

      Starting patch merge.

          Merging patches where applicable.

          Log: /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/35/20190211_230859/apply/testsvr3/admrgpch.log -console off

       

      Executing the merge of the patch drivers

      -- Processing patch: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27294892

      -- Processing file: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27294892/u27294892.drv

      -- Done processing patch: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27294892

       

      -- Processing patch: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/28714940

      -- Processing file: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/28714940/u28714940.drv

      -- Done processing file: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/28714940/u28714940.drv

      -- Done processing patch: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/28714940

       

      -- Processing patch: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27638770

      -- Processing file: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27638770/u27638770.drv

      -- Done processing file: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27638770/u27638770.drv

      -- Done processing patch: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27638770

       

      -- Processing patch: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/28394214

      -- Processing file: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/28394214/u28394214.drv

      -- Done processing file: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/28394214/u28394214.drv

      -- Done processing patch: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/28394214

       

      -- Processing patch: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27254132

      -- Processing file: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27254132/u27254132.drv

      -- Done processing file: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27254132/u27254132.drv

      -- Done processing patch: /u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772/src/27254132

       

       

       

      Copying files...

       

      5% complete. Copied 4 files of 79...

      10% complete. Copied 8 files of 79...

      15% complete. Copied 12 files of 79...

      20% complete. Copied 16 files of 79...

      25% complete. Copied 20 files of 79...

      30% complete. Copied 24 files of 79...

      35% complete. Copied 28 files of 79...

      40% complete. Copied 32 files of 79...

      45% complete. Copied 36 files of 79...

      50% complete. Copied 40 files of 79...

      55% complete. Copied 44 files of 79...

      60% complete. Copied 48 files of 79...

      65% complete. Copied 52 files of 79...

      70% complete. Copied 56 files of 79...

      75% complete. Copied 60 files of 79...

       

      Character-set converting files...

       

        4 unified drivers merged.

       

      Patch merge completed successfully

       

      Please check the log file at /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/35/20190211_230859/apply/testsvr3/admrgpch.log.

       

      Applying patch ADOP_MRG_20190211_1549897772:u_ad_3452059375.drv.

          Log: /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/35/20190211_230859/apply/testsvr3/ADOP_MRG_20190211_1549897772/log/u_ad_3452059375.log

       

      You should check the file

      /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/35/20190211_230859/apply/testsvr3/ADOP_MRG_20190211_1549897772/log/u_ad_3452059375.log

       

      for errors.

       

          [UNEXPECTED]Error occurred executing "adpatch  workers=4      console=no interactive=no  defaultsfile=/u03/app1228p/P1228/fs2/EBSapps/appl/admin/P1228_patch/adalldefaults.txt patchtop=/u03/app1228p/P1228/fs1/EBSapps/appl/admin/P1228/log/ADOP_MRG_20190211_1549897772 driver=u_ad_3452059375.drv logfile=u_ad_3452059375.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)

      [app1228p@testsvr3 ~]$

       

      STRT_TASK: [Prereq checking logic] [] [Mon Feb 11 2019 23:09:46]

       

       

      The description for the entity 'ad' in the patch driver

      does not match with the current description.

       

      The current description is      :'Applications DBA'

      The description in the patch is :'Oracle Applications DBA'

       

      Updating current description in AD_TRACKABLE_ENTITIES ...

       

      Done updating AD_TRACKABLE_ENTITIES.

       

      For the Current View:

         l_appl_top_id .............. 196

         l_eav_patch_release_name ... 12.0.0

      Current View - 27254132:US is EXPLICIT

      Current View - 27638770:US is EXPLICIT

      Current View - 28394214:US is EXPLICIT

      Current View - 28714940:US is EXPLICIT

       

      This Patch seems to have been applied already.

      Would you like to continue anyway  [N] ? N *

       

       

       

      Please help how to find the error.

       

       

      Kind regards,

      jc

        • 1. Re: EBS 12.2.7 - Merging patches
          mdtaylor

          Hi jc,

           

          Please read the AD/TXK document carefully.  You are trying to merge too many AD patches together which is not allowed.  You will need to abort this patching session and start a new one.

           

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

           

          Note: Do not merge Patch 25820806 with any other patches, except for Patch 27254132:R12.AD.C.

           

          UNIX:

          $ adop phase=apply patches=25820806,27254132 merge=yes hotpatch=yes

           

          Then merge the remaining critical AD patches from the bottom of the note.

           

          Regards,

          Michael

          • 2. Re: EBS 12.2.7 - Merging patches
            Beauty_and_dBest

            Thanks Michael,

             

            But my command is below:

             

            $ adop phase=apply patches=27254132,27294892,28394214,27638770,28714940 merge=yes patchtop=/u01/PATCH/R1228

             

            I did not merge or include the patch 25820806

             

            Ok, I will read the doc 1617461.1  first ...brb 

             

             

             

             

            Kind regards,

            • 3. Re: EBS 12.2.7 - Merging patches
              mdtaylor

              Hi jc,

               

              I noticed you are already on AD C Delta 10, so you have to follow that section.

               

              $ adop phase=apply patches=27254132

               

              Then merge the others.

               

              Regards,

              Michael

              • 4. Re: EBS 12.2.7 - Merging patches
                Beauty_and_dBest

                Thanks michael

                • 5. Re: EBS 12.2.7 - Merging patches
                  Beauty_and_dBest

                  Hi Michael,

                   

                  I queried the ad_bugs table and the patches were aleady recorded there, even if they were aborted?

                  How do I check if they are really succesfully applied or not?

                   

                  select bug_number from ad_bugs where bug_number in(28394214,27638770,28714940,27254132,27294892);

                   

                  BUG_NUMBER

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

                  27254132

                  27638770

                  28394214

                  28714940

                  27294892

                   

                  SQL>

                   

                   

                  Please help....

                   

                   

                  Kind regards,

                  • 6. Re: EBS 12.2.7 - Merging patches
                    Beauty_and_dBest

                    Hi Michael,

                     

                    I applied the patch, but still the same error

                    Please help...

                     

                    Kind regards,

                     

                    $ adop phase=apply patches=27254132 patchtop=/u01/PATCH/R1228

                    Enter the APPS password:

                    Enter the SYSTEM password:

                    Enter the WLSADMIN password:

                     

                    Validating credentials.

                     

                    Initializing.

                        Run Edition context  : /u03/app1228p/P1228/fs1/inst/apps/P1228_testsvr3/appl/admin/P1228_testsvr3.xml

                        Patch edition context: /u03/app1228p/P1228/fs2/inst/apps/P1228_testsvr3/appl/admin/P1228_testsvr3.xml

                        Patch file system free space: 337.13 GB

                     

                    Validating system setup.

                        Node registry is valid.

                        [WARNING]   ETCC: The following required database fixes have not been applied to node testsvr3:

                                      26336977

                                      26654363

                                      26742604

                                      28507324

                                      28259867

                                    Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.

                     

                    Checking for existing adop sessions.

                        Continuing with existing session [Session ID: 36].

                     

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

                    ADOP (C.Delta.10)

                    Session ID: 36

                    Node: testsvr3

                    Phase: apply

                    Log: /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/36/20190212_152352/adop.log

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

                     

                    Applying patch 27254132.

                        Log: /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/36/20190212_152352/apply/testsvr3/27254132/log/u27254132.log

                     

                    You should check the file

                    /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/36/20190212_152352/apply/testsvr3/27254132/log/u27254132.log

                     

                    for errors.

                     

                        [UNEXPECTED]Error occurred executing "adpatch  workers=4      console=no interactive=no  defaultsfile=/u03/app1228p/P1228/fs2/EBSapps/appl/admin/P1228_patch/adalldefaults.txt patchtop=/u01/PATCH/R1228/27254132 driver=u27254132.drv logfile=u27254132.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)

                    • 7. Re: EBS 12.2.7 - Merging patches
                      raghu_ram

                      Hi ,

                       

                      Use the below query  by replacing 16910001 with the patches which  you are trying to apply.

                       

                      select ad_patch.is_patch_applied('R12',-1,'16910001') from dual;

                       

                      If they are already applied and valid perhaps its not needed to apply again.

                       

                      Regards

                      Ram

                      • 8. Re: EBS 12.2.7 - Merging patches
                        Beauty_and_dBest

                        Hi Raghu,

                         

                        SQL> select ad_patch.is_patch_applied('R12',-1,'27254132') from dual;

                         

                        AD_PATCH.IS_PATCH_APPLIED('R12',-1,'27254132')

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

                        NOT_APPLIED

                         

                         

                        So what the cause of my patching error?

                         

                        Why is the log  saying below?

                         

                        The description for the entity 'ad' in the patch driver

                        does not match with the current description.

                         

                        The current description is      :'Applications DBA'

                        The description in the patch is :'Oracle Applications DBA'

                         

                        Updating current description in AD_TRACKABLE_ENTITIES ...

                         

                        Done updating AD_TRACKABLE_ENTITIES.

                         

                        For the Current View:

                           l_appl_top_id .............. 196

                           l_eav_patch_release_name ... 12.0.0

                        Current View - 27254132:US is EXPLICIT

                         

                        This Patch seems to have been applied already.

                        Would you like to continue anyway  [N] ? N *

                         

                        [EVENT] Applying patch 27254132.
                        [STATEMENT] [Start 2019/02/12 15:24:24] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
                        [STATEMENT] Reading defaults file /u03/app1228p/P1228/fs2/EBSapps/appl/admin/P1228_patch/adalldefaults.txt
                        [STATEMENT] Substituting tokens.
                        [STATEMENT] Regenerating defaults file.
                        [STATEMENT] [End   2019/02/12 15:24:24] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
                        [STATEMENT] [Start 2019/02/12 15:24:24] ADOP::DefaultsFileUtil::searchTokenInDefaultsFile
                        [STATEMENT] Reading defaults file /u03/app1228p/P1228/fs2/EBSapps/appl/admin/P1228_patch/adalldefaults.txt
                        [STATEMENT] Searching for tokens and values.
                        [STATEMENT] Checking if the patch 27254132_US has already been applied.
                        [STATEMENT] Release : 12.0.0
                        [STATEMENT] Appltop Id : 196
                        [STATEMENT] Bug number : 27254132
                        [STATEMENT] Language : US
                        [STATEMENT] Is patch applied : NOT_APPLIED
                        [STATEMENT] 1 Value of actual_command : "adpatch  workers=4  console=no interactive=no  defaultsfile=/u03/app1228p/P1228/fs2/EBSapps/appl/admin/P1228_patch/adalldefaults.txt patchtop=/u01/PATCH/R1228/27254132 driver=u27254132.drv"
                        [STATEMENT] 2 Value of actual_command : "adpatch  workers=4  console=no interactive=no  defaultsfile=/u03/app1228p/P1228/fs2/EBSapps/appl/admin/P1228_patch/adalldefaults.txt patchtop=/u01/PATCH/R1228/27254132 driver=u27254132.drv logfile=u27254132.log"

                         

                         

                        Kind regards,

                        • 9. Re: EBS 12.2.7 - Merging patches
                          raghu_ram

                          HI,

                           

                          With the previous query please check if the pre-requisite patch 25820806 has been applied

                          before you are trying to apply the patch  27254132.

                          I hope you have downloaded the correct version of patch for your server.

                           

                          Regards

                          Ram

                          • 10. Re: EBS 12.2.7 - Merging patches
                            Beauty_and_dBest

                            Hi Raghu,

                             

                            It seems the query always returns  >  NOT_APPLIED ?

                            I am sure the latest AD & TXK patches  25820806,25828573 are already applied, because this is EBS 12.2.7

                             

                            sql> select ad_patch.is_patch_applied('R12',-1,'25820806') from dual

                             

                            AD_PATCH.IS_PATCH_APPLIED('R12',-1,'25820806')

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

                            NOT_APPLIED

                             

                             

                            SQL>  select ad_patch.is_patch_applied('R12',-1,'25828573') from dual

                             

                            AD_PATCH.IS_PATCH_APPLIED('R12',-1,'25828573')

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

                            NOT_APPLIED

                             

                            I got a query I found in google below:

                             

                             

                             

                            Kind regards,

                            • 11. Re: EBS 12.2.7 - Merging patches
                              mdtaylor

                              Hi jc,

                               

                              You need to open the adpatch log to see why it failed.

                               

                              cd /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/36/20190212_152352/apply/testsvr3/27254132/log

                               

                              tail -1000 u27254132.log

                               

                              When you find, the error, you may need to open adworker log files to see the exact error.  They will be in the same directory.

                               

                              Regards,

                              Michael

                              • 12. Re: EBS 12.2.7 - Merging patches
                                Beauty_and_dBest

                                Hi Micheal,

                                 

                                 

                                That is the log I posted above, but only the last part 

                                 

                                How can I attach here 1000 -line logfile

                                I only cut & paste first and last page of the log below:

                                 

                                app1228p@testsvr3:[app1228p@testsvr3 ~]$ cd /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/36/20190212_152352/apply/testsvr3/27254132/log

                                app1228p@testsvr3:/u03/app1228p/P1228/fs_ne/EBSapps/log/adop/36/20190212_152352/apply/testsvr3/27254132/log

                                [app1228p@testsvr3 log]$ tail -1000 u27254132.log

                                 

                                ************* Start of AutoPatch session *************

                                AutoPatch version: 12.2.0

                                AutoPatch started at: Tue Feb 12 2019 15:24:25

                                 

                                APPL_TOP is set to /u03/app1228p/P1228/fs2/EBSapps/appl

                                 

                                Defaults Feature Enabled = YES.

                                Non-Interactive Mode = YES.

                                Num Workers = 4.

                                Patch Top = "/u01/PATCH/R1228/27254132".

                                Patch Driver File = "u27254132.drv".

                                 

                                NLS_LANG value from the environment is    : American_America.AL32UTF8

                                NLS_LANG value for this AD utility run is : AMERICAN_AMERICA.AL32UTF8

                                 

                                You can be notified by email if a failure occurs.

                                Do you wish to activate this feature [No] ? No *

                                 

                                Please enter the batchsize [1000] : 1000 *

                                 

                                 

                                Please enter the name of the Oracle E-Business Suite System that this

                                APPL_TOP belongs to.

                                 

                                The Applications System name must be unique across all Oracle

                                Applications Systems at your site, must be from 1 to 30 characters

                                long, may only contain alphanumeric and underscore characters,

                                and must start with a letter.

                                 

                                Sample Applications System names are: "prod", "test", "demo" and

                                "Development_2".

                                 

                                Applications System Name [P1228] : P1228 *

                                 

                                 

                                NOTE: If you do not currently have certain types of files installed

                                in this APPL_TOP, you may not be able to perform certain tasks.

                                 

                                .......

                                Determining target release...

                                 

                                Current target    release is  12.2.7

                                 

                                 

                                STOP_TASK: [Other driver and release-related logic] [] [Tue Feb 12 2019 15:24:35]

                                 

                                 

                                 

                                STOP_TASK: [Get Oracle E-Business Suite Release and read driver file] [] [Tue Feb 12 2019 15:24:35]

                                 

                                 

                                 

                                STRT_TASK: [Prereq checking logic] [] [Tue Feb 12 2019 15:24:35]

                                 

                                 

                                The description for the entity 'ad' in the patch driver

                                does not match with the current description.

                                 

                                The current description is      :'Applications DBA'

                                The description in the patch is :'Oracle Applications DBA'

                                 

                                Updating current description in AD_TRACKABLE_ENTITIES ...

                                 

                                Done updating AD_TRACKABLE_ENTITIES.

                                 

                                For the Current View:

                                   l_appl_top_id .............. 196

                                   l_eav_patch_release_name ... 12.0.0

                                Current View - 27254132:US is EXPLICIT

                                 

                                This Patch seems to have been applied already.

                                Would you like to continue anyway  [N] ? N *

                                 

                                You should check the file

                                /u03/app1228p/P1228/fs_ne/EBSapps/log/adop/36/20190212_152352/apply/testsvr3/27254132/log/u27254132.log

                                 

                                for errors.

                                 

                                app1228p@testsvr3:/u03/app1228p/P1228/fs_ne/EBSapps/log/adop/36/20190212_152352/apply/testsvr3/27254132/log

                                [app1228p@testsvr3 log]$ exit

                                 

                                 

                                 

                                 

                                 

                                Kind regards,

                                • 13. Re: EBS 12.2.7 - Merging patches
                                  Beauty_and_dBest

                                  Hi Michael,

                                   

                                  I emailed the 27254132 adop error log file

                                   

                                   

                                  Kind regards,