1 2 Previous Next 19 Replies Latest reply on Jun 18, 2015 9:28 AM by Bashar.

    ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl

    goj

      Hi All,

       

      EBS 12.2.4 and doing ADOP prepare phase and it just hangs here. I don't see any errors on CLONE logs.

       

      ************

       

       

      ************* Start of  session *************
      version: 12.2.0
      started at: Fri Jun 12 2015 21:37:40

      APPL_TOP is set to /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl
      [STATEMENT] [START 2015/06/12 21:37:40] Determining admin node
      [STATEMENT] [END   2015/06/12 21:37:42] Determining admin node
      [STATEMENT] [START 2015/06/12 21:37:44] Acquiring lock on sessions table
      [STATEMENT] [END   2015/06/12 21:37:45] Acquiring lock on sessions table
      [STATEMENT] [START 2015/06/12 21:37:45] Checking for any pending sessions
      [STATEMENT] [START 2015/06/12 21:37:48] Staging the current session
        [STATEMENT] [START 2015/06/12 21:37:52] Checking if node "ebswl" is abandoned
        [STATEMENT] [END   2015/06/12 21:37:54] Checking if node "ebswl" is abandoned
      [STATEMENT] [END   2015/06/12 21:37:55] Staging the current session
      [STATEMENT] [START 2015/06/12 21:37:58] Unlocking sessions table
      [STATEMENT] [END   2015/06/12 21:37:59] Unlocking sessions table
      [STATEMENT] [START 2015/06/12 21:37:59] adzdoptl.pl run
        [STATEMENT] Session ID: 16
        [STATEMENT] Phase: prepare
        [STATEMENT] Log file: /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/adop_20150612_213726.log
        [STATEMENT] [START 2015/06/12 21:38:06] prepare phase
          [STATEMENT] PREPARE Phase START TIME: 12-06-2015 21:38:07
          [STATEMENT] [START 2015/06/12 21:38:12] Validating Configuration
            [STATEMENT] Calling: /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSanityCheck.pl
            [STATEMENT] Output directory: /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl

      Program :  started @ Fri Jun 12 21:38:15 2015

      *** Log File = /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/TXK_SANITY_filesystemcheck_Fri_Jun_12_21_38_15_2015/txkADOPPreparePhaseSanityCheck_Fri_Jun_12_21_38_15_2015.log


      Program :  completed @ Fri Jun 12 21:38:16 2015

          [STATEMENT] [END   2015/06/12 21:38:16] Validating Configuration
          [STATEMENT] [START 2015/06/12 21:38:17] Detecting config changes in FS
            [STATEMENT] [START 2015/06/12 21:38:18] Executing adConfigChangeDetector on ebswl
              [STATEMENT] Calling: /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adConfigChangeDetector.pl
              [STATEMENT] Output directory: /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/adConfigChanges.log
      The log file is /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/adConfigChanges.log

      /data/nfs_share/d01/oracle/PROD/fs1/inst/apps/PROD_ebswl/appl/admin/cutover directory not found, so configuration changes cannot be detected.
      The directory may have been deleted intentionally or accidentally. Or, if this is the first adop cycle, the directory will only be created after cutover.

      Without this directory, the configuration changes will be propagated to the patch file system forcefully.

      Configuration change detected.
            [STATEMENT] [END   2015/06/12 21:38:23] Executing adConfigChangeDetector on ebswl
            [STATEMENT] Config changes detected in ebswl
            [STATEMENT] [START 2015/06/12 21:38:24] Insert Config Clone tracking row for NODE: ebswl
            [STATEMENT] [END   2015/06/12 21:38:29] Insert Config Clone tracking row for NODE: ebswl
          [STATEMENT] [END   2015/06/12 21:38:30] Detecting config changes in FS
          [STATEMENT] [START 2015/06/12 21:38:31] Performing check to see if pending cleanup actions exist
            [STATEMENT] Checking if pending cleanup actions
            [STATEMENT] [START 2015/06/12 21:38:34] Performing steps for cleanup
              [STATEMENT] Calling cleanup since cleanup was not ran in previous patching session.
              [STATEMENT] [START 2015/06/12 21:38:36] Performing Cleanup steps
                [STATEMENT] [START 2015/06/12 21:38:38] Running CLEANUP ddls in ddl handler table
                  [STATEMENT] [Start 2015/06/12 21:38:39] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
                    [STATEMENT] Reading defaults file /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt
                    [STATEMENT] Substituting tokens ...
                    [STATEMENT] Regenerating defaults file ...
                  [STATEMENT] [End   2015/06/12 21:38:39] ADOP::DefaultsFileUtil::substituteDefaultsFileTokensForPatchApplTop
                  [STATEMENT] Calling: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=24 restart=no abandon=yes defaultsfile=/data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv
                  [STATEMENT] ADPATCH Log directory: /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/log
                  [STATEMENT] Running: adpatch options=hotpatch,nocompiledb interactive=no console=no workers=24 restart=no abandon=yes defaultsfile=/data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/admin/PROD/adalldefaults.txt patchtop=/data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/driver logfile=cleanup.log driver=ucleanup.drv stdin=yes

      Successfully created out directory
                [STATEMENT] [END   2015/06/12 21:39:01] Running CLEANUP ddls in ddl handler table
                  [STATEMENT] [START 2015/06/12 21:39:02] Generating Report to display all the DDLs from ad_zd_ddl_handler
                    [STATEMENT] Report: /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql

                    [STATEMENT] Output: /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/adzdallddls.out

                  [STATEMENT] [END   2015/06/12 21:39:05] Generating Report to display all the DDLs from ad_zd_ddl_handler
                [STATEMENT] Calling cleanup in STANDARD mode
                [STATEMENT] [WARN] Cleanup may take a while. Please wait.
              [STATEMENT] [END   2015/06/12 21:39:09] Performing Cleanup steps
                [STATEMENT] [START 2015/06/12 21:39:10] Generating Report to display the cleanup status
                  [STATEMENT] Report: /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDCLEANUPRP.sql

                  [STATEMENT] Output: /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/adzdcleanuprp.out

                [STATEMENT] [END   2015/06/12 21:39:46] Generating Report to display the cleanup status
            [STATEMENT] [END   2015/06/12 21:39:50] Performing steps for cleanup
            [STATEMENT] No pending cleanup actions, proceeding with other steps
          [STATEMENT] [END   2015/06/12 21:39:52] Performing check to see if pending cleanup actions exist
          [STATEMENT] [START 2015/06/12 21:39:53] Deleting rows from ad_patches_tables table
          [STATEMENT] [END   2015/06/12 21:39:55] Deleting rows from ad_patches_tables table
          [STATEMENT] [START 2015/06/12 21:39:56] Performing DB Sanity checks
            [STATEMENT] [START 2015/06/12 21:39:56] Checking if edition enabled users exist
            [STATEMENT] [END   2015/06/12 21:39:58] Checking if edition enabled users exist
            [STATEMENT] [START 2015/06/12 21:39:59] Performing Check for patch service existance
            [STATEMENT] [END   2015/06/12 21:40:01] Performing Check for patch service existance
            [STATEMENT] [START 2015/06/12 21:40:02] Performing Check for Logon Trigger existence and enablement
            [STATEMENT] [END   2015/06/12 21:40:04] Performing Check for Logon Trigger existence and enablement
          [STATEMENT] [END   2015/06/12 21:40:05] Performing DB Sanity checks
          [STATEMENT] [START 2015/06/12 21:40:05] Generating Tablespace Report
            [STATEMENT] [START 2015/06/12 21:40:07] Generating report to display the status of important tablespaces. (ie. free space)
              [STATEMENT] Report: /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWTS.sql

              [STATEMENT] Output: /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/adzdshowts.out

            [STATEMENT] [END   2015/06/12 21:40:10] Generating report to display the status of important tablespaces. (ie. free space)
          [STATEMENT] [END   2015/06/12 21:40:10] Generating Tablespace Report
          [STATEMENT] [START 2015/06/12 21:40:11] Run the ADZDPATCH concurrent program
            [STATEMENT] [START 2015/06/12 21:40:15] Checking status of the ADZDPATCH concurrent program
              [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 12-JUN-2015 21:40:14.  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   2015/06/12 21:40:19] Checking status of the ADZDPATCH concurrent program
            [STATEMENT] Concurrent Request Number: 474176
          [STATEMENT] [END   2015/06/12 21:40:51] Run the ADZDPATCH concurrent program
            [STATEMENT] [START 2015/06/12 21:40:52] Generating Report to display all the DDLs from ad_zd_ddl_handler
              [STATEMENT] Report: /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDALLDDLS.sql

              [STATEMENT] Output: /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/adzdallddls.out

            [STATEMENT] [END   2015/06/12 21:40:56] Generating Report to display all the DDLs from ad_zd_ddl_handler
          [STATEMENT] [START 2015/06/12 21:40:56] Check and create Patch Edition (if required)
            [STATEMENT] [START 2015/06/12 21:40:57] Checking if Patch Edition already exists
              [STATEMENT] Patch Edition does not exist
              [STATEMENT] [START 2015/06/12 21:41:00] Creating Patch Edition
              [STATEMENT] [END   2015/06/12 21:41:17] Creating Patch Edition
            [STATEMENT] [END   2015/06/12 21:41:18] Checking if Patch Edition already exists
          [STATEMENT] [END   2015/06/12 21:41:18] Check and create Patch Edition (if required)
          [STATEMENT] [START 2015/06/12 21:41:19] Performing steps to synchronise the FS
            [STATEMENT] [START 2015/06/12 21:41:20] Performing steps to CLONE FS of RUN and PATCH appltops
            [STATEMENT] [END   2015/06/12 21:41:25] Performing steps to CLONE FS of RUN and PATCH appltops
            [STATEMENT] [START 2015/06/12 21:41:26] Performing steps to syncup FS of RUN and PATCH appltops
              [STATEMENT] [START 2015/06/12 21:41:28] Sync FS of RUN and PATCH
                [STATEMENT] Calling: /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl
                [STATEMENT] Output directory: /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl

      Program :  started @ Fri Jun 12 21:41:30 2015

      *** Log File = /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/TXK_SYNC_update_Fri_Jun_12_21_41_30_2015/txkADOPPreparePhaseSynchronize_Fri_Jun_12_21_41_30_2015.log

      cmd = /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/comn/util/jdk32/jre/bin/java -classpath /data/nfs_share/d01/oracle/PROD/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/data/nfs_share/d01/oracle/PROD/fs1/EBSapps/comn/java/classes   -mx256m  oracle.apps.ad.tools.configuration.ADOPCustomSyncUp -contextFile /data/nfs_share/d01/oracle/PROD/fs1/inst/apps/PROD_ebswl/appl/admin/PROD_ebswl.xml -custSyncDrv /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/appl/ad/custom/adop_sync.drv -logFile /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/TXK_SYNC_update_Fri_Jun_12_21_41_30_2015/txkADOPCustomSyncUp.log -promptmsg 'hide'
      ADOP Custom Synchorization successfully run

      Program :  completed @ Fri Jun 12 21:41:49 2015

              [STATEMENT] [END   2015/06/12 21:41:49] Sync FS of RUN and PATCH
            [STATEMENT] [END   2015/06/12 21:41:50] Performing steps to syncup FS of RUN and PATCH appltops
            [STATEMENT] [START 2015/06/12 21:41:51] Performing steps to CONFIG_CLONE FS of RUN and PATCH appltops
              [STATEMENT] There is a pending clone session for /data/nfs_share/d01/oracle/PROD/fs2 file system
              [STATEMENT] [START 2015/06/12 21:41:56] Performing FS CONFIG_CLONE Steps
                [STATEMENT] [START 2015/06/12 21:41:57] CONFIG_CLONE PATCH FS with RUN FS
                  [STATEMENT] Calling: /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl
                  [STATEMENT] Output directory: /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl

      Program :  started @ Fri Jun 12 21:42:00 2015

      *** Log File = /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/16/prepare_20150612_213726/PROD_ebswl/TXK_SYNC_migrate_Fri_Jun_12_21_42_00_2015/txkADOPPreparePhaseSynchronize_Fri_Jun_12_21_42_00_2015.log

       

      *************

       

      and then session just stays there and does not move.

       

       

      ADOP STATUS reveals:

       

      Current Patching Session ID: 16

      Node Name       Node Type       Phase       Status          Started                        Finished                       Elapsed
      --------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
      ebswl           master          PREPARE     RUNNING         12-JUN-15 09:38:07 -07:00
                                      APPLY       NOT STARTED
                                      CUTOVER     NOT STARTED
                                      CLEANUP     NOT STARTED

       


      File System Synchronization Used in this Patching Cycle: None

      File System Information:
      ========================

       

      ***********

       

      How long is this supposed  to run?

      I don't see any CHANGES needed or configs on WLS side...

       

      thank you
                                                           

        • 1. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
          Bashar.

          Hi,

           

          It may take an hour or two to finish.

           

          Regards,

          Bashar

          • 2. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
            goj

            its almost 2 hours now....still same....

            • 3. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
              goj

              Job is now been going on for 4 hours....

               

              any ideas?

              • 4. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                yoonas

                Goj,

                 

                Can you share other log files ?

                what is the output of hostname?

                 

                Regards

                Yoonas

                • 5. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                  goj

                  what other log files do you need?

                  and i am not sure what output of hostname is relevant here

                   

                  is there anyone else here that can chime in to this question?
                  I would really appreciate more input from the experts here

                  • 6. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                    yoonas

                    and i am not sure what output of hostname is relevant here

                    R12.2 Adop Hangs And Does Nothing (Doc ID 1590763.1), found this note on MOS so just wanted to make check if you are hitting same

                     

                    12.2 E-Business Suite - Collecting Online Patching and fs_clone Log Files (Doc ID 1542162.1)

                    • 7. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                      goj

                      Hi Yoonas,

                       

                      1), Made changes for host and followed doc and all steps and still , no progress.

                       

                      thanks

                      • 8. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                        goj

                        SELECT codelevel FROM AD_TRACKABLE_ENTITIES WHERE abbreviation in ('txk','ad');

                         

                         

                        CODELEVEL

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

                        C

                        C

                         

                         

                        SQL>

                         

                        also tried adopscan...no luck

                        • 9. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                          goj

                          ADOP_SESSION_ID P A F C C A S ABANDON_FLAG NODE_NAME

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

                                 2 Y N N N Y Y C   ebswl

                                 3 R N N N Y Y C   ebswl

                                 4 R N N N Y Y C   ebswl

                                 5 R N N N Y Y C   ebswl

                                 6 R N N N Y Y C   ebswl

                                 7 R N N N Y Y C   ebswl

                                 8 R N N N Y Y C   ebswl

                                 9 R N N N Y Y C   ebswl

                                10 R N N N Y Y C   ebswl

                                11 R N N N Y Y C   ebswl

                                12 R N N N Y Y C   ebswl

                           

                           

                          ADOP_SESSION_ID P A F C C A S ABANDON_FLAG NODE_NAME

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

                                13 R N N N Y Y C   ebswl

                                14 R N N N Y Y C   ebswl

                                15 R N N N Y Y C   ebswl

                                16 R N N N Y Y C   ebswl

                                17 R N N N Y Y C   ebswl

                                18 R N N N N N R 18 ebswl

                           

                           

                          Do i need to kill some of these?

                          • 10. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                            yoonas

                            Only session 18 is in running status that means only your current session is running.

                            Adop generates a set of log files for each session which can be found under session id at $NE_BASE/EBSapps/log/

                            pleas share log files ( how to collect logfiles is mentioned in note 1542162.1 STEP 1:  Obtain all of the log files within the session ID directory

                            • 11. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                              goj

                              I am attaching log files

                              • 12. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                                goj

                                Program :  started @ Mon Jun 15 21:40:44 2015

                                 

                                 

                                *** Log File = /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/19/prepare_20150615_213754/PROD_ebswl/TXK_SYNC_update_Mon_Jun_15_21_40_44_2015/txkADOPPreparePhaseSynchronize_Mon_Jun_15_21_40_44_2015.log

                                 

                                 

                                Script Name    : txkADOPPreparePhaseSynchronize.pl

                                Started        : Mon Jun 15 21:40:44 PDT 2015

                                 

                                 

                                 

                                 

                                -----------

                                Values used

                                -----------

                                Context File       : /data/nfs_share/d01/oracle/PROD/fs1/inst/apps/PROD_ebswl/appl/admin/PROD_ebswl.xml

                                PATCH Context File : /data/nfs_share/d01/oracle/PROD/fs2/inst/apps/PROD_ebswl/appl/admin/PROD_ebswl.xml

                                OUT Directory      : /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/19/prepare_20150615_213754/PROD_ebswl

                                Patch Top          : /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/patch

                                Mode               : update

                                Console Logging    : off

                                Worker Count       : 24

                                 

                                 

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

                                Updating existing patch appl top...

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

                                 

                                 

                                 

                                 

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

                                Inside updatePatchApplTop()...

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

                                 

                                 

                                 

                                 

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

                                Validating context file...

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

                                 

                                 

                                 

                                 

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

                                Validating PATCH context file...

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

                                 

                                 

                                 

                                 

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

                                Validating APPS schema credentials...

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

                                 

                                 

                                 

                                 

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

                                Validating SYSTEM user credentials...

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

                                 

                                 

                                 

                                 

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

                                Validating mode...

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

                                 

                                 

                                Mode = update

                                 

                                 

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

                                Validating patch top...

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

                                 

                                 

                                 

                                 

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

                                Validating console log key...

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

                                 

                                 

                                Console = off

                                 

                                 

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

                                Validating worker count...

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

                                 

                                 

                                Worker count = 24

                                 

                                 

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

                                Inside checkDBPrepareRequired()...

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

                                 

                                 

                                File Edition Type: patch

                                 

                                 

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

                                Inside getEditionName()...

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

                                 

                                 

                                SQL Command: SELECT NVL(ad_zd.get_edition('PATCH'),'NULL') from dual

                                Edition Name: V_20150615_2140

                                Proceeding to prepare the tables...

                                 

                                 

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

                                Inside prepareDBTables()...

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

                                 

                                 

                                Generating SQL file : /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/19/prepare_20150615_213754/PROD_ebswl/TXK_SYNC_update_Mon_Jun_15_21_40_44_2015/prepare_tables.sql

                                SQL output file     : /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/19/prepare_20150615_213754/PROD_ebswl/TXK_SYNC_update_Mon_Jun_15_21_40_44_2015/prepare_tables.out

                                SQL Command: exec ad_zd_seed.prepare('FND_PROFILE_OPTION_VALUES');

                                SQL Command: exec ad_zd_seed.prepare('WF_RESOURCES');

                                SQL Command: exec ad_zd_seed.prepare('IBY_BEPINFO');

                                 

                                 

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

                                Inside sourcePatchEnv()...

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

                                 

                                 

                                Sourcing the PATCH file system environment: /data/nfs_share/d01/oracle/PROD/fs2/EBSapps/appl/APPSPROD_ebswl.env

                                Execute SYSTEM command : sqlplus ********* @/data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/19/prepare_20150615_213754/PROD_ebswl/TXK_SYNC_update_Mon_Jun_15_21_40_44_2015/prepare_tables.sql

                                 

                                 

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

                                Inside sourceRunEnv()...

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

                                 

                                 

                                Sourcing the RUN file system environment: /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/APPSPROD_ebswl.env

                                EXIT STATUS: 1

                                SQL execution went through successfully.

                                 

                                 

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

                                Inside generateDefaultsFile()...

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

                                 

                                 

                                 

                                 

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

                                Inside loadDefaultsFileIntoGlobalArray()...

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

                                 

                                 

                                 

                                 

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

                                Inside setDefaultsFileParams()...

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

                                 

                                 

                                Updating DBNAME...

                                 

                                 

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

                                Inside tokenStartValueIndex()...

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

                                 

                                 

                                 

                                 

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

                                Inside getIndexOfStringFromArray()...

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

                                 

                                 

                                search_string = DBNAME

                                lower_index = 0

                                upper_index = 1457

                                 

                                 

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

                                Inside getIndexOfStringFromArray()...

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

                                 

                                 

                                search_string = START_OF_VALUE

                                lower_index = 37

                                upper_index = 1457

                                 

                                 

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

                                Inside getIndexOfStringFromArray()...

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

                                 

                                 

                                search_string = END_OF_VALUE

                                lower_index = 37

                                upper_index = 1457

                                No update is required - DBNAME =        PROD_patch

                                 

                                 

                                Updating missing translated version flag...

                                 

                                 

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

                                Inside tokenStartValueIndex()...

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

                                 

                                 

                                 

                                 

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

                                Inside getIndexOfStringFromArray()...

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

                                 

                                 

                                search_string = MISSING_TRANSLATED_VERSION

                                lower_index = 0

                                upper_index = 1457

                                 

                                 

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

                                Inside getIndexOfStringFromArray()...

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

                                 

                                 

                                search_string = START_OF_VALUE

                                lower_index = 625

                                upper_index = 1457

                                 

                                 

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

                                Inside getIndexOfStringFromArray()...

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

                                 

                                 

                                search_string = END_OF_VALUE

                                lower_index = 625

                                upper_index = 1457

                                 

                                 

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

                                Inside updateDefaultsFileFromGlobalArray()...

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

                                 

                                 

                                 

                                 

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

                                Inside getPatchListFromDB()...

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

                                 

                                 

                                SQL Command: SELECT bug_number||',' FROM ad_adop_session_patches WHERE node_name = 'ebswl' AND applied_file_system_base = '/data/nfs_share/d01/oracle/PROD/fs1' and patch_file_system_base IS NULL ORDER BY TO_CHAR(end_date,'YYYY.MM.DD:HH24:MI:SS') DESC

                                 

                                 

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

                                Inside eliminateDuplicates()...

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

                                 

                                 

                                INITIAL LIST:

                                FINAL LIST:

                                 

                                 

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

                                No patches to be applied. Exiting gracefully...

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

                                 

                                 

                                 

                                 

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

                                Inside runADOPCustomSyncUp()...

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

                                 

                                 

                                Executing SYSTEM command: perl /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPCustomSyncUp.pl -contextfile=/data/nfs_share/d01/oracle/PROD/fs1/inst/apps/PROD_ebswl/appl/admin/PROD_ebswl.xml -logfile=/data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/19/prepare_20150615_213754/PROD_ebswl/TXK_SYNC_update_Mon_Jun_15_21_40_44_2015/txkADOPCustomSyncUp.log -promptmsg=hide

                                EXIT STATUS: 0

                                /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPCustomSyncUp.pl went through successfully.

                                 

                                 

                                Program :  completed @ Mon Jun 15 21:41:02 2015

                                 

                                *****************

                                • 13. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                                  goj

                                  Current Patching Session ID: 19

                                   

                                   

                                  Node Name Node Type Phase    Status    Started   Finished  Elapsed

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

                                  ebswl master PREPARE     RUNNING    15-JUN-15 09:38:37 -07:00

                                    APPLY    NOT STARTED

                                    CUTOVER     NOT STARTED

                                    CLEANUP     NOT STARTED

                                   

                                   

                                   

                                   

                                   

                                   

                                   

                                   

                                  File System Synchronization Used in this Patching Cycle: None

                                   

                                   

                                  For more information, see the full ADOP Status Report.

                                  • 14. Re: ADOP Prepare PHASE hangs at txkADOPPreparePhaseSynchronize.pl
                                    goj

                                    Program :  started @ Mon Jun 15 21:41:13 2015

                                     

                                     

                                    *** Log File = /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/19/prepare_20150615_213754/PROD_ebswl/TXK_SYNC_migrate_Mon_Jun_15_21_41_12_2015/txkADOPPreparePhaseSynchronize_Mon_Jun_15_21_41_12_2015.log

                                     

                                     

                                    Script Name    : txkADOPPreparePhaseSynchronize.pl

                                    Started        : Mon Jun 15 21:41:13 PDT 2015

                                     

                                     

                                     

                                     

                                    -----------

                                    Values used

                                    -----------

                                    Context File       : /data/nfs_share/d01/oracle/PROD/fs1/inst/apps/PROD_ebswl/appl/admin/PROD_ebswl.xml

                                    PATCH Context File : /data/nfs_share/d01/oracle/PROD/fs2/inst/apps/PROD_ebswl/appl/admin/PROD_ebswl.xml

                                    OUT Directory      : /data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/19/prepare_20150615_213754/PROD_ebswl

                                    Patch Top          :

                                    Mode               : migrate

                                    Console Logging    : off

                                     

                                     

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

                                    Migrating config changes from run to patch...

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

                                     

                                     

                                     

                                     

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

                                    Inside migrateConfigChanges()...

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

                                     

                                     

                                    ENVIRONMENT is already SET....

                                     

                                     

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

                                    Validating context file...

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

                                     

                                     

                                     

                                     

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

                                    Validating PATCH context file...

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

                                     

                                     

                                     

                                     

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

                                    Validating APPS schema credentials...

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

                                     

                                     

                                     

                                     

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

                                    Validating SYSTEM user credentials...

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

                                     

                                     

                                     

                                     

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

                                    Validating mode...

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

                                     

                                     

                                    Mode = migrate

                                     

                                     

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

                                    Validating console log key...

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

                                     

                                     

                                    Console = off

                                     

                                     

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

                                    Inside checkNodeManagerStatus()...

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

                                     

                                     

                                    Executing SYSTEM command: perl /data/nfs_share/d01/oracle/PROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl -contextfile=/data/nfs_share/d01/oracle/PROD/fs1/inst/apps/PROD_ebswl/appl/admin/PROD_ebswl.xml ebs-get-nmstatus -logfile=/data/nfs_share/d01/oracle/PROD/fs_ne/EBSapps/log/adop/19/prepare_20150615_213754/PROD_ebswl/TXK_SYNC_migrate_Mon_Jun_15_21_41_12_2015/EBSProvisioner_ebs-get-nmstatus.log -promptmsg=hide

                                     

                                     

                                    **********

                                     

                                    still running

                                    1 2 Previous Next