3 Replies Latest reply on Feb 14, 2018 8:51 AM by #MVivek

    adop phase=apply failed

    #MVivek

      bash-3.2$ adop phase=apply patches=22023064

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

      Validating credentials...

      Initializing...

          Run Edition context  : /oradbf2/oracle/DEV9/fs2/inst/apps/DEV9_egluatfidb/appl/admin/DEV9_egluatfidb.xml

          Patch edition context: /oradbf2/oracle/DEV9/fs1/inst/apps/DEV9_egluatfidb/appl/admin/DEV9_egluatfidb.xml

      Reading driver file (up to 50000000 bytes).

          Patch file system freespace: 50.34 GB

      Validating system setup...

          Node registry is valid.

      Checking for pending adop sessions...

          Continuing with existing session [Session id: 66]...

              Session Id            :   66

              Prepare phase status  :   COMPLETED

              Apply phase status    :   ATLEAST ONE PATCH IS ALREADY APPLIED

              Cutover  phase status :   NOT COMPLETED

              Abort phase status    :   NOT COMPLETED

              Session status        :   FAILED

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

      ADOP (C.Delta.6)

      Session ID: 66

      Node: egluatfidb

      Phase: apply

      Log: /oradbf2/oracle/DEV9/fs_ne/EBSapps/log/adop/66/adop_20180206_002826.log

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

      Applying patch 22023064 with adpatch utility...

          Log: /oradbf2/oracle/DEV9/fs_ne/EBSapps/log/adop/66/apply_20180206_002826/DEV9_egluatfidb/22023064/log/u22023064.log

      AutoPatch error:

      Error running SQL and EXEC commands in parallel

      You should check the file

      /oradbf2/oracle/DEV9/fs_ne/EBSapps/log/adop/66/apply_20180206_002826/DEV9_egluatfidb/22023064/log/u22023064.log

      for errors.

          [UNEXPECTED]Error occurred while executing "adpatch workers=8      console=no interactive=no 

      defaultsfile=/oradbf2/oracle/DEV9/fs1/EBSapps/appl/admin/DEV9_patch/adalldefaults.txt patchtop=/oradbf2/oracle/DEV9/fs_ne/EBSapps/patch/22023064 driver=u22023064.drv

      logfile=u22023064.log"

          [UNEXPECTED]Please check the adpatch log files.

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

      [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)

      bash-3.2$

        • 1. Re: adop phase=apply failed
          #MVivek

          bash-3.2$ adopscanlog -latest=yes

          Scanning /oradbf2/oracle/DEV9/fs_ne/EBSapps/log/adop/66/ directory ...

          /oradbf2/oracle/DEV9/fs_ne/EBSapps/log/adop/66/adop_20180206_002826.log:

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

          Lines #(206-210):

              [EVENT]     Log: /oradbf2/oracle/DEV9/fs_ne/EBSapps/log/adop/66/apply_20180206_002826/DEV9_egluatfidb/22023064/log/u22023064.log

              [PROCEDURE] Running: adpatch  abandon=yes restart=no workers=8      console=no interactive=no 

          defaultsfile=/oradbf2/oracle/DEV9/fs1/EBSapps/appl/admin/DEV9_patch/adalldefaults.txt patchtop=/oradbf2/oracle/DEV9/fs_ne/EBSapps/patch/22023064 driver=u22023064.drv

          logfile=u22023064.log acp=yes

              [UNEXPECTED]Error occurred while executing "adpatch  abandon=yes restart=no workers=8      console=no interactive=no 

          defaultsfile=/oradbf2/oracle/DEV9/fs1/EBSapps/appl/admin/DEV9_patch/adalldefaults.txt patchtop=/oradbf2/oracle/DEV9/fs_ne/EBSapps/patch/22023064 driver=u22023064.drv

          logfile=u22023064.log"

              [UNEXPECTED]Please check the adpatch log files.

              [STATEMENT] sql stmt : <     update ad_adop_session_patches set  status='F'

          Lines #(207-211):

              [PROCEDURE] Running: adpatch  abandon=yes restart=no workers=8      console=no interactive=no 

          defaultsfile=/oradbf2/oracle/DEV9/fs1/EBSapps/appl/admin/DEV9_patch/adalldefaults.txt patchtop=/oradbf2/oracle/DEV9/fs_ne/EBSapps/patch/22023064 driver=u22023064.drv

          logfile=u22023064.log acp=yes

              [UNEXPECTED]Error occurred while executing "adpatch  abandon=yes restart=no workers=8      console=no interactive=no 

          defaultsfile=/oradbf2/oracle/DEV9/fs1/EBSapps/appl/admin/DEV9_patch/adalldefaults.txt patchtop=/oradbf2/oracle/DEV9/fs_ne/EBSapps/patch/22023064 driver=u22023064.drv

          logfile=u22023064.log"

              [UNEXPECTED]Please check the adpatch log files.

              [STATEMENT] sql stmt : <     update ad_adop_session_patches set  status='F'

               where adop_session_id=66

          Lines #(213-217):

          >

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

              [PROCEDURE] [START 2018/02/06 00:30:18] Updating ADOP session status

              [STATEMENT] SQL statement : "  update ad_adop_sessions

          /oradbf2/oracle/DEV9/fs_ne/EBSapps/log/adop/66/apply_20180206_002826/DEV9_egluatfidb/22023064/log/u22023064.log:

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

          Lines #(1204-1208):

          Time is: Tue Feb 06 2018 00:30:07

             FAILED: file adutlrcmp.sql on worker  1 for product ad  username APPLSYS.

          Time is: Tue Feb 06 2018 00:30:10

          Lines #(1218-1222):

          Time is: Tue Feb 06 2018 00:30:10

             FAILED: file adutlrcmp.sql on worker  1 for product ad  username APPLSYS.

          Time is: Tue Feb 06 2018 00:30:13

          Lines #(1230-1234):

          Time is: Tue Feb 06 2018 00:30:13

             FAILED: file adutlrcmp.sql on worker  1 for product ad  username APPLSYS.

          Time is: Tue Feb 06 2018 00:30:16

          Lines #(1237-1241):

          ATTENTION: All workers either have failed or are waiting:

                     FAILED: file adutlrcmp.sql on worker  1.

          ATTENTION: Please fix the above failed worker(s) so the manager can continue.

          Lines #(1252-1256):

          Connecting to APPS......Connected successfully.

          AutoPatch error:

          Error running SQL and EXEC commands in parallel

          bash-3.2$

          • 2. Re: adop phase=apply failed
            mdtaylor

            Hi Vivek,

             

            Please try increasing your SYSTEM tablespace so objects have room for parallel recompilation.

             

            12.2 Windows: FAILED: file adutlrcmp.sql on worker x (Doc ID 1633132.1)

             

            Also make sure your init parameters are set properly.

             

            bde_chk_cbo.sql - EBS initialization parameters - Healthcheck (Doc ID 174605.1)

             

            Please open adworker001.log in /oradbf2/oracle/DEV9/fs_ne/EBSapps/log/adop/66/apply_20180206_002826/DEV9_egluatfidb/22023064/log/ and post the error which caused that process to fail.

             

            Regards,

            Michael

            1 person found this helpful
            • 3. Re: adop phase=apply failed
              #MVivek

              Hi Michael,

               

              Thanks for your suggestion.

              Fixed the issue by recompile invalid objects.

               

              select owner, table_name, stattype_locked

              from dba_tab_statistics

              where stattype_locked is not null;

               

              exec dbms_stats.unlock_schema_stats('schema_owner');

              exec dbms_stats.unlock_table_stats('table_owner','table_name');

               

              Thanks

              Vivek

              1 person found this helpful