1 2 Previous Next 17 Replies Latest reply on Apr 10, 2018 5:47 AM by Eric Z-Oracle

    12.2 Adop Fails at Prepare Phase

    Shafi Yusuf

      Adop prepare phase is failing with the following error:

       

       

      Beginning application tier FSCloneApply - ohsTechStack Sun Apr  8 09:08:21 2018

       

      /d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -Xmx600M -DCONTEXT_VALIDATED=false  -Doracle.installer.oui_loc=/oui -classpath /d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/jlib/java:/d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/jlib/oui/srvm.jar:/d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/d01/oracle/CBSPROD/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar  oracle.apps.ad.clone.FSCloneApplyAppsTier -e /d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -targ /d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -stage /d01/oracle/CBSPROD/fs1/EBSapps/comn/clone -tmp /tmp -nodbac -component ohsTechStack -nopromptmsg

      Log file located at /d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/admin/log/FSCloneApplyAppsTier_04080908.log

       

      ERROR while running FSCloneApply...

      Sun Apr  8 09:08:37 2018

      *******FATAL ERROR*******

      PROGRAM : (/d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)

      TIME    : Sun Apr  8 09:08:37 2018

      FUNCTION: main::migrateCloneComponentApply [ Level 1 ]

      ERRORMSG: /d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/bin/adclone.pl did not go through successfully.

       

         [ERROR]     Error occurred while executing <perl /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -patchcontextfile=/d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -promptmsg=hide -console=off -mode=migrate -sessionid=4 -timestamp=20180408_084847 -outdir=/d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd>

          [ERROR]     Error occurred while CONFIG_CLONE PATCH FS with RUN FS using command: <perl /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -patchcontextfile=/d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -promptmsg=hide -console=off -mode=migrate -sessionid=4 -timestamp=20180408_084847 -outdir=/d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd>.

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

                      [ERROR]     Error while runPendingConfigClone sub-routine is called

                      [STATEMENT] [START 2018/04/08 09:09:32] Check and Stop Patch Admin Server

                        [STATEMENT] There is a pending clone session for /d01/oracle/CBSPROD/fs2.

                        [STATEMENT] Skipping Check and Stop Patch Admin Server Step.

                      [STATEMENT] [END   2018/04/08 09:09:35] Check and Stop Patch Admin Server

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

                      [STATEMENT] PREPARE Phase END TIME: 08-04-2018 09:09:38

                      [STATEMENT] [START 2018/04/08 09:09:39] Unlocking sessions table

                      [STATEMENT] [END   2018/04/08 09:09:40] Unlocking sessions table

                      [STATEMENT] Log file: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/adop_20180408_084847.log

      adop exiting with status = 1 (Fail)

        • 1. Re: 12.2 Adop Fails at Prepare Phase
          Shaik

          Hi

          Please check the below note

          Adop Phase=prepare - Error occurred while CONFIG_CLONE PATCH FS with RUN FS (Doc ID 1613745.1)

           

          Regards

          Shaik

          • 2. Re: 12.2 Adop Fails at Prepare Phase
            Shaik

            Hi

             

            You can check one more solution

             

            rename or remove the err.log under /tmp and rerun the prepare phase again

             

            Regards

            Shaik

            • 3. Re: 12.2 Adop Fails at Prepare Phase
              Eric Z-Oracle

              Hi,

               

              MInd if you upload the adop logs for the current adop session?

              There should be more details for root cause analysis.

               

              Cheers!

              Eric

              • 4. Re: 12.2 Adop Fails at Prepare Phase
                Shafi Yusuf

                Hi Erick

                 

                this is the adop log

                 

                  [STATEMENT] Log file: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/adop_20180408_084847.log

                Phase: prepare

                 

                 

                [STATEMENT] [START 2018/04/08 08:48:47] Performing verification of parameters

                [STATEMENT] [END   2018/04/08 08:49:21] Performing verification of parameters

                [STATEMENT] Sourcing the Run Edition environment: /d01/oracle/CBSPROD/fs1/EBSapps/appl/APPSCBSPROD_ebsprd.env

                [STATEMENT] [START 2018/04/08 08:49:21] Checking for the required ENV setup

                [STATEMENT] [END   2018/04/08 08:49:22] Checking for the required ENV setup

                [STATEMENT] [START 2018/04/08 08:49:22] Determining admin node

                [STATEMENT] [END   2018/04/08 08:49:23] Determining admin node

                [STATEMENT] [START 2018/04/08 08:49:24] Acquiring lock on sessions table

                [STATEMENT] SQL stmt: <       begin

                          AD_ZD_ADOP.LOCK_SESSIONS_TABLE('ebsprd',60,2);

                       end;

                >

                 

                 

                [STATEMENT] [END   2018/04/08 08:49:25] Acquiring lock on sessions table

                [STATEMENT] [START 2018/04/08 08:49:25] Checking for any pending sessions

                [STATEMENT] inside checkAciveHotPatchSession

                [STATEMENT] Statement: <    select count(1) from ad_adop_sessions

                     where status <> 'C' and prepare_status='X' and cutover_status='X' and

                     abort_status='X' and apply_status in ('N','P') and cleanup_status='N'

                     and appltop_id=196 and node_name='ebsprd'

                >.

                [STATEMENT] value of incomplete_session: <0>

                [STATEMENT] leaving checkAciveHotPatchSession

                [STATEMENT] Master Session Id: <>

                [STATEMENT] [START 2018/04/08 08:49:27] Staging the current session

                  [STATEMENT] statement: <select ad_adop_session_id_seq.nextval from dual>

                  [STATEMENT] [START 2018/04/08 08:49:30] Checking if node "ebsprd" is abandoned

                    [STATEMENT] statement: <         select abandon_flag from ad_adop_sessions

                         where node_name='ebsprd' and abandon_flag is not null and

                         adop_session_id = (select max(adop_session_id) from ad_adop_sessions where

                                            ((prepare_status='Y' and apply_status='Y' and cutover_status='Y') or (abort_status='Y'))

                                            and node_type='master'

                                           )

                >

                  [STATEMENT] [END   2018/04/08 08:49:31] Checking if node "ebsprd" is abandoned

                  [STATEMENT] SQL stmt: <        insert into ad_adop_sessions

                          (adop_session_id, prepare_status, apply_status, finalize_status, cutover_status,

                           cleanup_status,abort_status,session_input_data,status,appltop_id,node_name,node_type,abandon_flag)

                        values (4,'N','N','N','N','N','N','','N','196','ebsprd','master', 4)

                >

                 

                 

                [STATEMENT] [END   2018/04/08 08:49:32] Staging the current session

                [STATEMENT] input_string: admin_node#ebsprd;abortmode#0;LOG_LEVEL_VALUES#HASH(0x23373b8);num_tries#2;workers#3;max_workers#7;logidentmode#SUBROUTINE;LOG_LEVEL#HASH(0x2337250);hotpatch#0;logfile#adop_20180408_084847.log;shared_fs#0;patchcontextfile#/d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml;recom_workers#3;session_id#4;lock_wait_interval#60;loglevel#statement;patchtop#/d01/oracle/CBSPROD/fs_ne/EBSapps/patch;merge#yes;phase#prepare;adpatch_interactive#yes;non_shared_fs_multi_node#0;multi_node#0;mtrestart#1;is_master#1;nodbaction#0;autoskip#0;runcontextfile#/d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml;

                [STATEMENT] Session ID: 4

                [STATEMENT] statement: <      update ad_adop_sessions

                      set    session_input_data ='admin_node#ebsprd;abortmode#0;LOG_LEVEL_VALUES#HASH(0x23373b8);num_tries#2;workers#3;max_workers#7;logidentmode#SUBROUTINE;LOG_LEVEL#HASH(0x2337250);hotpatch#0;logfile#adop_20180408_084847.log;shared_fs#0;patchcontextfile#/d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml;recom_workers#3;session_id#4;lock_wait_interval#60;loglevel#statement;patchtop#/d01/oracle/CBSPROD/fs_ne/EBSapps/patch;merge#yes;phase#prepare;adpatch_interactive#yes;non_shared_fs_multi_node#0;multi_node#0;mtrestart#1;is_master#1;nodbaction#0;autoskip#0;runcontextfile#/d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml;'

                      where  adop_session_id =4

                        and node_name='ebsprd'

                >

                [STATEMENT] [START 2018/04/08 08:49:34] Unlocking sessions table

                  [STATEMENT] SQL stmt: <       begin

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

                       end;

                >

                 

                 

                [STATEMENT] [END   2018/04/08 08:49:34] Unlocking sessions table

                [STATEMENT] [START 2018/04/08 08:49:34] adzdoptl.pl run

                  [STATEMENT] Session ID: 4

                  [STATEMENT] Phase: prepare

                  [STATEMENT] Log file: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/adop_20180408_084847.log

                  [STATEMENT] SQL Statement: <    select count(1)

                      from  ad_adop_sessions

                      where  adop_session_id=4 and (prepare_status in ('N','R'))

                >.

                  [STATEMENT] SQL Output: <1>.

                  [STATEMENT] SQL Statement:       update ad_adop_sessions

                        set status='R'

                         where adop_session_id = 4 and appltop_id = 196 and node_name='ebsprd'

                 

                 

                  [STATEMENT] [START 2018/04/08 08:49:40] prepare phase

                    [STATEMENT] SQL Statement:         update ad_adop_sessions

                        set prepare_start_date=to_date('08-04-2018 08:49:40','DD-MM-YYYY HH24:MI:SS')

                        where  adop_session_id=4

                 

                 

                    [STATEMENT] PREPARE Phase START TIME: 08-04-2018 08:49:40

                    [STATEMENT] SQL Statement:       update ad_adop_sessions

                        set prepare_status='R'

                        where adop_session_id=4 and appltop_id=196  and node_name='ebsprd'

                 

                 

                    [STATEMENT] [START 2018/04/08 08:49:43] Validating Configuration

                      [STATEMENT] Calling: /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSanityCheck.pl

                      [STATEMENT] Output directory: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd

                    [STATEMENT] [END   2018/04/08 08:49:46] Validating Configuration

                    [STATEMENT] [START 2018/04/08 08:49:47] Detecting config changes in FS

                      [STATEMENT] Calling task: <Executing adConfigChangeDetector on ebsprd>; script: </d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adConfigChangeDetector.pl>; args: < -detectConfigChanges contextfile=/d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml promptmsg=hide log=/d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd/adConfigChanges.log hostname=ebsprd>

                      [STATEMENT] [START 2018/04/08 08:49:48] Executing adConfigChangeDetector on ebsprd

                        [STATEMENT] Calling: /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adConfigChangeDetector.pl

                        [STATEMENT] Output directory: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd/adConfigChanges.log

                      [STATEMENT] [END   2018/04/08 08:49:52] Executing adConfigChangeDetector on ebsprd

                      [STATEMENT] Config changes detected in ebsprd

                      [STATEMENT] [START 2018/04/08 08:49:52] Insert Config Clone tracking row for NODE: ebsprd

                      [STATEMENT] [END   2018/04/08 08:49:55] Insert Config Clone tracking row for NODE: ebsprd

                    [STATEMENT] [END   2018/04/08 08:49:56] Detecting config changes in FS

                    [STATEMENT] [START 2018/04/08 08:49:56] Performing check to see if pending cleanup actions exist

                      [STATEMENT] Checking if pending cleanup actions

                      [STATEMENT] [START 2018/04/08 08:49:59] Performing steps for cleanup

                        [STATEMENT] Calling cleanup since cleanup was not ran in previous patching session.

                        [STATEMENT] [START 2018/04/08 08:50:00] Performing Cleanup steps

                          [STATEMENT] [START 2018/04/08 08:50:01] Running CLEANUP ddls in ddl handler table

                            [STATEMENT] [Start 2018/04/08 08:50:02] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop

                              [STATEMENT] Reading defaults file /d01/oracle/CBSPROD/fs1/EBSapps/appl/admin/CBSPROD/adalldefaults.txt

                              [STATEMENT] Substituting tokens ...

                              [STATEMENT] Regenerating defaults file ...

                            [STATEMENT] [End   2018/04/08 08:50:02] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop

                            [STATEMENT] Log file: adop_20180408_084847.log

                            [STATEMENT] Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=3 restart=no abandon=yes defaultsfile=/d01/oracle/CBSPROD/fs1/EBSapps/appl/admin/CBSPROD/adalldefaults.txt patchtop=/d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv

                            [STATEMENT] ADPATCH Log directory: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd/log

                            [STATEMENT] Running: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=3 restart=no abandon=yes defaultsfile=/d01/oracle/CBSPROD/fs1/EBSapps/appl/admin/CBSPROD/adalldefaults.txt patchtop=/d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv stdin=yes

                          [STATEMENT] [END   2018/04/08 08:50:34] Running CLEANUP ddls in ddl handler table

                          [STATEMENT] [START 2018/04/08 08:50:35] Generating All DDL Report

                            [STATEMENT] [START 2018/04/08 08:50:35] Generating Report to display all the DDLs from ad_zd_ddl_handler

                              [STATEMENT] Report: /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql

                 

                 

                              [STATEMENT] Output: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd/adzdallddls.out

                 

                 

                            [STATEMENT] [END   2018/04/08 08:50:37] Generating Report to display all the DDLs from ad_zd_ddl_handler

                          [STATEMENT] [END   2018/04/08 08:50:37] Generating All DDL Report

                          [STATEMENT] Calling cleanup in STANDARD mode

                          [STATEMENT] [WARN] Cleanup may take a while. Please wait.

                        [STATEMENT] [END   2018/04/08 08:50:44] Performing Cleanup steps

                        [STATEMENT] [START 2018/04/08 08:50:44] Generating Post Cleanup Reports

                          [STATEMENT] [START 2018/04/08 08:50:45] Generating Report to display the cleanup status

                            [STATEMENT] Report: /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDCLEANUPRP.sql

                 

                 

                            [STATEMENT] Output: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd/adzdcleanuprp.out

                 

                 

                            [ERROR]     Error occurred while executing <sqlplus -s APPS/apps  /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDCLEANUPRP.sql /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd/*****>

                          [STATEMENT] [END   2018/04/08 08:53:40] Performing steps for cleanup

                          [STATEMENT] No pending cleanup actions, proceeding with other steps

                        [STATEMENT] [END   2018/04/08 08:53:41] Performing check to see if pending cleanup actions exist

                        [STATEMENT] [START 2018/04/08 08:53:42] Deleting rows from ad_patches_tables table

                        [STATEMENT] [END   2018/04/08 08:53:43] Deleting rows from ad_patches_tables table

                        [STATEMENT] [START 2018/04/08 08:53:44] Performing DB Sanity checks

                          [STATEMENT] [START 2018/04/08 08:53:44] Checking if edition enabled users exist

                          [STATEMENT] [END   2018/04/08 08:53:45] Checking if edition enabled users exist

                          [STATEMENT] [START 2018/04/08 08:53:46] Performing Check for patch service existance

                          [STATEMENT] [END   2018/04/08 08:53:47] Performing Check for patch service existance

                          [STATEMENT] [START 2018/04/08 08:53:48] Performing Check for Logon Trigger existence and enablement

                            [STATEMENT] Logon Trigger check failed

                            [STATEMENT] Trying to create the Logon Trigger

                            [STATEMENT] [START 2018/04/08 08:53:51] Performing steps to fix Sanity Errors

                              [STATEMENT] [START 2018/04/08 08:53:51] Creating Logon Trigger

                              [STATEMENT] [END   2018/04/08 08:53:52] Creating Logon Trigger

                            [STATEMENT] [END   2018/04/08 08:53:53] Performing steps to fix Sanity Errors

                          [STATEMENT] [END   2018/04/08 08:53:54] Performing Check for Logon Trigger existence and enablement

                        [STATEMENT] [END   2018/04/08 08:53:54] Performing DB Sanity checks

                        [STATEMENT] [START 2018/04/08 08:53:55] Generating Tablespace Report

                          [STATEMENT] [START 2018/04/08 08:53:56] Generating report to display the status of important tablespaces. (ie. free space)

                            [STATEMENT] Report: /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWTS.sql

                 

                 

                            [STATEMENT] Output: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd/adzdshowts.out

                 

                 

                          [STATEMENT] [END   2018/04/08 08:53:58] Generating report to display the status of important tablespaces. (ie. free space)

                        [STATEMENT] [END   2018/04/08 08:53:59] Generating Tablespace Report

                        [STATEMENT] [START 2018/04/08 08:53:59] Run the ADZDPATCH concurrent program

                          [STATEMENT] reqid_statement: <select AD_ZD_ADOP.GET_ACTIVE_CP_REQUEST_ID() from dual>.

                          [STATEMENT] sr_statement: <    declare

                      result varchar2(20);

                    begin

                      result:=ad_zd_adop.submit_request();

                    exception

                            when others then

                            update ad_adop_sessions set status='F'

                            where adop_session_id=4;

                    commit;

                    raise_application_error(-20001,'Error while calling ad_zd_adop.submit_request().' || sqlerrm);

                    end;

                >.

                          [STATEMENT] [START 2018/04/08 08:54:02] Checking status of the ADZDPATCH concurrent program

                            [STATEMENT] sr_statement: <select ad_zd_adop.get_adzdpatch_status(468275) from dual>.

                            [STATEMENT] Status of ADZDPATCH:

                            [STATEMENT] The next available concurrent manager will process this request.  This

                request will process as soon as the concurrent manager finishes its

                current processing and the processing of other requests ahead of this

                request. User SYSADMIN submitted this request on 08-APR-2018 08:54:01.  No

                action required. This is a normal condition. You may expedite the start of

                the processing of this request by reducing its priority value. Only the

                System Administrator responsibility may update request priority values.

                          [STATEMENT] [END   2018/04/08 08:54:04] Checking status of the ADZDPATCH concurrent program

                          [STATEMENT] Concurrent Request Number: 468275

                        [STATEMENT] [END   2018/04/08 08:54:36] Run the ADZDPATCH concurrent program

                        [STATEMENT] [START 2018/04/08 08:54:37] Generating All DDL Report

                          [STATEMENT] [START 2018/04/08 08:54:37] Generating Report to display all the DDLs from ad_zd_ddl_handler

                            [STATEMENT] Report: /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql

                 

                 

                            [STATEMENT] Output: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd/adzdallddls.out

                 

                 

                          [STATEMENT] [END   2018/04/08 08:54:39] Generating Report to display all the DDLs from ad_zd_ddl_handler

                        [STATEMENT] [END   2018/04/08 08:54:40] Generating All DDL Report

                        [STATEMENT] [START 2018/04/08 08:54:40] Check and create Patch Edition (if required)

                          [STATEMENT] [START 2018/04/08 08:54:40] Checking if Patch Edition already exists

                            [STATEMENT] Patch Edition does not exist

                            [STATEMENT] [START 2018/04/08 08:54:42] Creating Patch Edition

                            [STATEMENT] [END   2018/04/08 08:57:27] Creating Patch Edition

                          [STATEMENT] [END   2018/04/08 08:57:28] Checking if Patch Edition already exists

                        [STATEMENT] [END   2018/04/08 08:57:28] Check and create Patch Edition (if required)

                        [STATEMENT] [START 2018/04/08 08:57:29] Performing steps to synchronise the FS

                          [STATEMENT] [START 2018/04/08 08:57:29] Performing steps to CLONE FS of RUN and PATCH appltops

                          [STATEMENT] [END   2018/04/08 08:57:32] Performing steps to CLONE FS of RUN and PATCH appltops

                          [STATEMENT] [START 2018/04/08 08:57:33] Performing steps to syncup FS of RUN and PATCH appltops

                            [STATEMENT] [START 2018/04/08 08:57:34] Sync FS of RUN and PATCH

                              [STATEMENT] Calling: /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl

                              [STATEMENT] Output directory: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd

                            [STATEMENT] [END   2018/04/08 08:57:41] Sync FS of RUN and PATCH

                          [STATEMENT] [END   2018/04/08 08:57:41] Performing steps to syncup FS of RUN and PATCH appltops

                          [STATEMENT] [START 2018/04/08 08:57:42] Performing steps to CONFIG_CLONE FS of RUN and PATCH appltops

                            [STATEMENT] There is a pending clone session for /d01/oracle/CBSPROD/fs2 file system

                            [STATEMENT] [START 2018/04/08 08:57:45] Performing FS CONFIG_CLONE Steps

                              [STATEMENT] [START 2018/04/08 08:57:46] CONFIG_CLONE PATCH FS with RUN FS

                                [STATEMENT] Calling: /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl

                                [STATEMENT] Output directory: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd

                                [ERROR]     Error occurred while executing <perl /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -patchcontextfile=/d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -promptmsg=hide -console=off -mode=migrate -sessionid=4 -timestamp=20180408_084847 -outdir=/d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd>

                                [ERROR]     Error occurred while CONFIG_CLONE PATCH FS with RUN FS using command: <perl /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -patchcontextfile=/d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -promptmsg=hide -console=off -mode=migrate -sessionid=4 -timestamp=20180408_084847 -outdir=/d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/prepare_20180408_084847/CBSPROD_ebsprd>.

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

                                [ERROR]     Error while runPendingConfigClone sub-routine is called

                                [STATEMENT] [START 2018/04/08 09:09:32] Check and Stop Patch Admin Server

                                  [STATEMENT]         select count(1) from ad_adop_session_patches

                        where applied_file_system_base='/d01/oracle/CBSPROD/fs1' and

                        patch_file_system_base='/d01/oracle/CBSPROD/fs2' and

                        bug_number IN ('CLONE','CONFIG_CLONE') and

                        status IN ('N','F')

                 

                 

                                  [STATEMENT] There is a pending clone session for /d01/oracle/CBSPROD/fs2.

                                  [STATEMENT] Skipping Check and Stop Patch Admin Server Step.

                                [STATEMENT] [END   2018/04/08 09:09:35] Check and Stop Patch Admin Server

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

                                [STATEMENT] SQL Statement:       update ad_adop_sessions

                        set status='F'

                         where adop_session_id = 4 and appltop_id = 196 and node_name='ebsprd'

                 

                 

                                [STATEMENT] SQL Statement:         update ad_adop_sessions

                        set prepare_end_date=to_date('08-04-2018 09:09:38','DD-MM-YYYY HH24:MI:SS')

                        where  adop_session_id=4

                 

                 

                                [STATEMENT] PREPARE Phase END TIME: 08-04-2018 09:09:38

                                [STATEMENT] [START 2018/04/08 09:09:39] Unlocking sessions table

                                  [STATEMENT] SQL stmt: <       begin

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

                       end;

                >

                 

                 

                                [STATEMENT] [END   2018/04/08 09:09:40] Unlocking sessions table

                                [STATEMENT] SQL Statement:       update ad_adop_sessions

                        set status='F'

                         where adop_session_id = 4 and appltop_id = 196 and node_name='ebsprd'

                 

                 

                                [STATEMENT] Log file: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/4/adop_20180408_084847.log

                • 5. Re: 12.2 Adop Fails at Prepare Phase
                  Eric Z-Oracle

                  Hi,

                   

                  It would be better if you can zip and upload the entire directory of session 4 under $ADOP_LOG_HOME, I am expecting something more.

                   

                  Cheers!

                  Eric

                  • 6. Re: 12.2 Adop Fails at Prepare Phase
                    VishnuVinnakota

                    Hi,

                     

                      Its clear. There is a pending fs_clone session.

                     

                      Follow the below steps and it will be resolved:

                    1. Provide me adop -status output
                    2. Abort any patch cycle using adop phase=abort
                    3. Run fs_clone: adop phase=fs_clone or if needed adop phase=fs_clone force=yes
                    4. Then run adop phase=prepare

                     

                    Thanks,

                    Vishnu

                    • 7. Re: 12.2 Adop Fails at Prepare Phase
                      Shafi Yusuf

                      Hi

                      I run the adop phase=abort and then run the phase=fs_clone but the fs_clone is failing with the following error

                       

                      Enabling EBS_LOGON trigger

                      Error while execution /d01/oracle/CBSPROD/fs2/EBSapps/10.1.2/bin/sqlplus -s APPS/apps @ /d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appltmp/alter_ebs_logon_trigger.sql > /d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appltmp/ebs_logon_proc_res.log 2>&1

                      *******FATAL ERROR*******

                      PROGRAM : (/d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)

                      TIME    : Sun Apr  8 23:22:00 2018

                      FUNCTION: main::runFSCloneApply [ Level 1 ]

                      ERRORMSG: /d01/oracle/CBSPROD/fs1/EBSapps/comn/clone/bin/adclone.pl did not go through successfully.

                       

                              [ERROR]     Error occurred while executing <perl /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -patchcontextfile=/d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -promptmsg=hide -console=off -mode=create -sessionid=5 -timestamp=20180408_221221 -outdir=/d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/5/fs_clone_20180408_221221/CBSPROD_ebsprd>

                              [ERROR]     Error occurred while CLONE PATCH FS with RUN FS using command: <perl /d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/d01/oracle/CBSPROD/fs1/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -patchcontextfile=/d01/oracle/CBSPROD/fs2/inst/apps/CBSPROD_ebsprd/appl/admin/CBSPROD_ebsprd.xml -promptmsg=hide -console=off -mode=create -sessionid=5 -timestamp=20180408_221221 -outdir=/d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/5/fs_clone_20180408_221221/CBSPROD_ebsprd>.

                              [ERROR]     fs_clone phase completed with errors/warnings. Please check logfiles

                              [STATEMENT] [START 2018/04/08 23:22:02] Unlocking sessions table

                              [STATEMENT] [END   2018/04/08 23:22:03] Unlocking sessions table

                              [STATEMENT] Log file: /d01/oracle/CBSPROD/fs_ne/EBSapps/log/adop/5/adop_20180408_221221.log

                       

                      adop exiting with status = 2 (Fail)

                      • 8. Re: 12.2 Adop Fails at Prepare Phase
                        Eric Z-Oracle

                        Hi,

                         

                        Once again, please upload the logs for this session, this time it is under directory 5 in $ADOP_LOG_HOME.

                        There are logs for validation, T2P apply, etc. and you need to review the details to determine the root cause.

                        For online patching issues, usually you cannot determine it via the adop.log

                         

                        Cheers!

                        Eric

                        • 9. Re: 12.2 Adop Fails at Prepare Phase
                          VishnuVinnakota

                          Run fs_clone force.

                           

                          adop phase=fs_clone force=yes

                           

                          If fs_clone is failing you have an issue..

                           

                          Thanks,

                          Vishnu

                          • 10. Re: 12.2 Adop Fails at Prepare Phase
                            Shafi Yusuf

                            [oracle@ebsprd ~]$ adop phase=fs_clone force=yes

                            *******FATAL ERROR*******

                            PROGRAM : (/d01/oracle/CBSPROD/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)

                            TIME    : Mon Apr  9 11:57:16 2018

                            FUNCTION: ADOP::GlobalVars::_ValidateArgs [ Level 1 ]

                            ERRORMSG: Invalid Args: force=yes  .

                            For usage, enter adop -? or adop -help.

                             

                            adop exiting with status = 255 (Fail)

                            • 11. Re: 12.2 Adop Fails at Prepare Phase
                              VishnuVinnakota

                              What is your exact EBS version?

                               

                              Without copy paste, type it.. Just wondering how syntax is not working..

                               

                              adop phase=fs_clone force=yes

                               

                              Thanks,

                              Vishnu

                              • 13. Re: 12.2 Adop Fails at Prepare Phase
                                Eric Z-Oracle

                                Why wouldn’t you just focus on the logs for a while?

                                fs_clone failure is a serious issue already.

                                Do below and upload the entire logs, or create an SR and let us dig into it.

                                 

                                adop phase=fs_clone loglevel=statement printdebug=yes

                                 

                                What is your AD&TXK version anyway?

                                Are you saying you’re on 12.2.0?

                                If so, the you’re in big trouble because on 12.2.0 you are only allowed to apply patches on RunFS in hotpatch mode.

                                 

                                Cheers!

                                Eric

                                • 14. Re: 12.2 Adop Fails at Prepare Phase
                                  VishnuVinnakota

                                  Please provide proper version.

                                   

                                  12.2.5 etc.

                                   

                                  Thanks,

                                  Vishnu

                                  1 2 Previous Next