5 Replies Latest reply on Mar 26, 2015 5:52 AM by User172075

    Patch  17204589 failed

    User172075

      Hi ,

       

      I am trying to apply the patch to EBS 12.2.0 instance as a pre-req patch for 12.2.4 upgrade using adop. Patch did not complete successfully and now adop -status is showing following

       

      Current Patching Session ID: 2

       

       

      Node Name       Node Type       Phase       Status          Started                        Finished                       Elapsed

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

      ebs122          master          APPLY       FAILED          26-MAR-15 12:13:25 +05:30      26-MAR-15 12:14:15 +05:30      0:00:50

                                      PREPARE     NOT APPLICABLE

                                      CUTOVER     NOT APPLICABLE

                                      CLEANUP     NOT STARTED

       

      Kindly help me to resolve the issue

       

      Rgds/Nihal

        • 1. Re: Patch  17204589 failed
          Kj - Kiran Jadhav

          Hi Nihal,

          What is the error in patch log?

           

          -Kj

          • 2. Re: Patch  17204589 failed
            User172075

            Hi Kj,

             

            Please find below patch log file

             

            [STATEMENT] [End   2015/03/26 12:13:45] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop

                [STATEMENT] 1 Value of actual_command : <adpatch  restart=yes  workers=3    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv>

                [STATEMENT] 3 Value of actual_command : <adpatch  restart=yes  workers=3    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log>

                [STATEMENT] Calling: adpatch  restart=yes  workers=3    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log

                [STATEMENT] ADPATCH Log directory: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20150326_121033/PROD_ebs122/17204589/log

                [STATEMENT] Running: adpatch  restart=yes  workers=3    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log stdin=yes

                [ERROR]     Error occurred while executing <adpatch  restart=yes  workers=3    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/u01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/u01/oracle/PROD/fs_ne/EBSapps/patch/17204589 driver=u17204589.drv logfile=u17204589.log>

                [ERROR]     Please check the adpatch log files.

                [STATEMENT] Autopatch completed with errors/warnings. Please check logfiles

                [STATEMENT] SQL Statement:       update ad_adop_sessions

                    set status='F'

                     where adop_session_id = 2 and appltop_id = 195 and node_name='ebs122'

             

             

                [STATEMENT] SQL Statement:         update ad_adop_sessions

                    set apply_end_date=to_date('26-03-2015 12:14:15','DD-MM-YYYY HH24:MI:SS')

                    where  adop_session_id=2

             

             

                [STATEMENT] APPLY Phase END TIME: 26-03-2015 12:14:15

                [STATEMENT] [START 2015/03/26 12:14:18] Unlocking sessions table

                  [STATEMENT] SQL stmt: <       begin

                      AD_ZD_ADOP.UNLOCK_SESSIONS_TABLE('ebs122',60,2);

                   end;

            >

             

             

                [STATEMENT] [END   2015/03/26 12:14:19] Unlocking sessions table

                [STATEMENT] SQL Statement:       update ad_adop_sessions

                    set status='F'

                     where adop_session_id = 2 and appltop_id = 195 and node_name='ebs122'

             

             

                [STATEMENT] Log file: /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/adop_20150325_115636.log

            • 3. Re: Patch  17204589 failed
              User172075

              And adpatch logfile

               

              STOP_TASK: [Get Oracle E-Business Suite Release and read driver file] [] [Thu Mar 26 2015 12:14:05]

               

               

               

               

               

               

              STRT_TASK: [Prereq checking logic] [] [Thu Mar 26 2015 12:14:05]

               

               

              For the Current View:

                 l_appl_top_id .............. 195

                 l_eav_patch_release_name ... 12.0.0

              Current View - 17204589:US is EXPLICIT

               

               

              This Patch seems to have been applied already.

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

               

               

              You should check the file

              /u01/oracle/PROD/fs_ne/EBSapps/log/adop/2/apply_20150326_121033/PROD_ebs122/17204589/log/u17204589.log

               

               

              for errors.

              • 4. Re: Patch  17204589 failed
                Kj - Kiran Jadhav

                As per logs :

                 

                This Patch seems to have been applied already.

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

                 

                It seems that patch is already applied.

                When you try to apply the patch which is already exist then adop automatically puts 'N' as the answer for the prompt and the patch exits.

                So you need to apply this patch with "options=forceapply"

                 

                Please see this note for details- How to bypass the error "This Patch seems to have been applied already. Would you like to continue anyway" when applying a patch via ADOP ? (Doc ID 1920187.1)

                 

                -Kj

                • 5. Re: Patch  17204589 failed
                  User172075

                  Hi kj,

                   

                  Patch went successfully. Thanks for the support

                   

                  Rgds/Nihal