1 2 Previous Next 25 Replies Latest reply on Apr 19, 2016 2:26 AM by Beauty_and_dBest

    adop confusion?

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.2.4

       

       

      I run adop prepare, at its says previous session failed, but actually is was completed.

      Why is the message not consistent or not "synced" ?

       

      $ adop phase=prepare

       

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

       

      Please wait. Validating credentials...

       

      RUN file system context file: /u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml

       

      PATCH file system context file: /u01/appprod/PROD/fs1/inst/apps/PROD_uat/appl/admin/PROD_uat.xml

      Execute SYSTEM command : df /u01/appprod/PROD/fs1

       

      Worker count determination...

       

      [UNEXPECTED]Invalid worker Count: 0

      [UNEXPECTED]Error while validating worker count

      Log file: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/adop_20160415_123042.log

      [STATEMENT] Please run adopscanlog utility, using the command

      adop exiting with status = 2 (Fail)

       

      adopscanlog -latest=yes

      Scanning /u01/appprod/PROD/fs_ne/EBSapps/log/adop/adop_20160415_123042.log log file ...

      /u01/appprod/PROD/fs_ne/EBSapps/log/adop/adop_20160415_123042.log:

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

      Lines #(8-11):

      [EVENT]     [START 2016/04/15 12:31:04] Checking for the required ENV setup

      [EVENT]     [END   2016/04/15 12:31:05] Checking for the required ENV setup

      [UNEXPECTED]Invalid worker Count: 0

      [UNEXPECTED]Error while validating worker count

      Lines #(9-11):

      [EVENT]     [END   2016/04/15 12:31:05] Checking for the required ENV setup

      [UNEXPECTED]Invalid worker Count: 0

      [UNEXPECTED]Error while validating worker count

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

       

      Current Patching Session ID: 29

       

      Node Name       Node Type       Phase           Status          Started                        Finished                       Elapsed

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

      uat             master          PREPARE         COMPLETED       05-APR-16 01:25:56 +08:00      05-APR-16 02:32:16 +08:00      1:06:20

                                      APPLY           COMPLETED       05-APR-16 05:39:56 +08:00      06-APR-16 09:49:26 +08:00      28:09:30

                                      FINALIZE        COMPLETED       06-APR-16 12:20:00 +08:00      06-APR-16 12:20:35 +08:00      0:00:35

                                      CUTOVER         COMPLETED       06-APR-16 12:29:31 +08:00      06-APR-16 12:55:47 +08:00      0:26:16

                                      CLEANUP         COMPLETED       06-APR-16 01:02:36 +08:00      06-APR-16 01:03:26 +08:00      0:00:50

       

      File System Synchronization Used in this Patching Cycle: Full

       

      File System Information:

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

      File System: SINGLE NODE INSTANCE

       

       

      Node Name   Node Type   Current Base                   Other Base                     Non Editioned Base             Inst Top

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

      uat         master      /u01/appprod/PROD/fs2          /u01/appprod/PROD/fs1          /u01/appprod/PROD/fs_ne        /u01/appprod/PROD/fs2/inst/app

                                                                                                                           s/PROD_uat

      Custom File System Synchronization script: /u01/appprod/PROD/fs_ne/EBSapps/appl/ad/custom/adop_sync.drv

      Patch Stage Top: /u01/appprod/PROD/fs_ne/EBSapps/patch

      Online Patching Log base: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/29

       

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

      =             Patches Applied in the Current Patching Cycle

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

       

      Node Name    Node Type Patch         Status         Run ID File System Patch Base    File System Applied Base  Adpatch Parameters   Session Type

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

      uat          master    20221271      Y               33354                           /u01/appprod/PROD/fs2                          ONLINE

       

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

      =             ADADMIN actions in the Current Patching Cycle

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

      Node Name    Node Type Adadmin Action  Status      File System Patch Base    File System Applied Base  Adadmin Parameters

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

      uat          master    GEN_FORMS       Y                                     /u01/appprod/PROD/fs2     GFM_USE_CHARSET=Yes,FRM_PLSQL_LIB=Yes,GE

                                                                                                             N_FRM_MENUS=Yes,GEN_FRM_EXE=Yes,GEN_FRM_

                                                                                                             PRD=ap,GFM_SPECIFIC_OBJ=yes,LANG_USED=al

                                                                                                             l,CORRECT_LANG=Yes,SELECTED_LIB_FILES=al

                                                                                                             l,SELECTED_FILES=all

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

      = There is no Online Patching Cycle in progress at this time.

      = Report sections dependent upon Patch Edition will have no output.

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

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

      =                 Summary of the Last 10 ADOP Cycles

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

       

      Session ID Node Name  Node Type Started    Elapsed(Prepare) Elapsed(Cutover) Elapsed(Cleanup) Elapsed(Apply)  Status       Patches Applied      Session Type

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

              29 uat        master    05-APR-16  1:06:20          0:26:16          0:00:50          0:03:24         COMPLETE     20221271             ONLINE

              28 uat        master    05-APR-16  0:00:00          0:00:00          0:00:00          0:00:00         COMPLETE     CLONE                CLONE

              27 uat        master               0:00:00          0:00:00          0:00:50          0:00:00         COMPLETE     --                   --

              26 uat        master    03-APR-16  0:00:00          0:00:00          0:00:00          0:00:00         COMPLETE     CLONE                CLONE

              25 prodapp    master    15-JAN-16  0:00:00          0:00:00          0:00:40          0:14:06         COMPLETE     21068635             HOTPATCH

              24 apps       master    15-OCT-14  0:22:35          0:19:22          12:42:53         0:00:00         COMPLETE     --                   --

              23 apps       master    14-OCT-14  0:35:28          0:28:54          0:01:42          0:05:47         COMPLETE     19445058             ONLINE

                            master                                                                  0:13:09         COMPLETE     19581770             ONLINE

                            master                                                                  0:22:07         COMPLETE     CONFIG_CLONE         CONFIG_CLONE

                            slave                0:00:00          0:00:00          0:00:00          0:00:00         COMPLETE     CONFIG_CLONE         CONFIG_CLONE

              21 apps       master    09-SEP-14  0:11:46          0:22:55          0:01:51          0:00:00         COMPLETE     --                   --

              20 apps       master    09-SEP-14  0:14:20          1:16:06          0:02:55          0:00:00         COMPLETE     --                   --

       

       

       

      Please help...

       

      Kind regards,

      kc

        • 1. Re: adop confusion?
          Narsi M-Oracle

          Hello Jenna,

           

          What is the current version of AD/TXK.

          If your version is AD/TXK Delta 7, try running

          $ adop -validate

           

          If you are not on latest AD/TXK Delta 7, provide

          $ adop -status

           

           

          Regards,

          Narsi

          1 person found this helpful
          • 2. Re: adop confusion?
            Beauty_and_dBest

            Thanks Narsi,

             

            I am not in latest adop hence the last message I posted is adop -status, which show all completed status above.

             

            $ adop -status

            Enter the APPS password:

            Current Patching Session ID: 29

             

            Node Name       Node Type       Phase           Status          Started                        Finished                       Elapsed

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

            uat             master          PREPARE         COMPLETED       05-APR-16 01:25:56 +08:00      05-APR-16 02:32:16 +08:00      1:06:20

                                            APPLY           COMPLETED       05-APR-16 05:39:56 +08:00      06-APR-16 09:49:26 +08:00      28:09:30

                                            FINALIZE        COMPLETED       06-APR-16 12:20:00 +08:00      06-APR-16 12:20:35 +08:00      0:00:35

                                            CUTOVER         COMPLETED       06-APR-16 12:29:31 +08:00      06-APR-16 12:55:47 +08:00      0:26:16

                                            CLEANUP         COMPLETED       06-APR-16 13:02:36 +08:00      06-APR-16 13:03:26 +08:00      0:00:50

             

            File System Synchronization Used in this Patching Cycle: Full



            Kind regards,

            • 3. Re: adop confusion?
              Narsi M-Oracle

              Hello Jenna,

               

               

              Output looks good to me.

              Can you please try running "adop phase=fs_clone" and update the outcome.

               

               

              Regards,

              Narsi

              1 person found this helpful
              • 4. Re: adop confusion?
                Pravin Takpire

                Is it multi-node setup ? If yes looks like your remote node command execution is not happening correctly.

                Please check below note:

                ADOP Fails Because Remote Execution Failed (Doc ID 2053859.1)

                 

                regards

                Pravin

                1 person found this helpful
                • 5. Re: adop confusion?
                  Beauty_and_dBest

                  I do not really understand why after a successful patch, a new one will generate weird error?

                  Yes I have appstierNode and dbTier Node.

                   

                   

                  Adop fs clone also give the same error:

                   

                  $ adop phase=fs_clone

                   

                  Enter the APPS password:

                  Enter the SYSTEM password:

                  Enter the WLSADMIN password:

                   

                  Please wait. Validating credentials...

                   

                  RUN file system context file: /u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml

                   

                  PATCH file system context file: /u01/appprod/PROD/fs1/inst/apps/PROD_uat/appl/admin/PROD_uat.xml

                  Execute SYSTEM command : df /u01/appprod/PROD/fs1

                   

                  Worker count determination...

                   

                  [UNEXPECTED]Invalid worker Count: 0

                  [UNEXPECTED]Error while validating worker count

                  Log file: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/adop_20160415_184920.log

                   

                  [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 = 2 (Fail)

                  • 6. Re: adop confusion?
                    Sachin Thapa

                    can you please try giving no of workers in the same command?

                    does that work for you, give minimal workers

                     

                    ex:

                    adop phase=prepare workers=8 and do let me know the output.

                    I faced similar issue, long back.. is this a newly built instance.. in my case I had some kernel settings related issue..

                    can you run the rda for 12.2 and see if everything is fine there

                    • 7. Re: adop confusion?
                      Bashar.
                      1 person found this helpful
                      • 8. Re: adop confusion?
                        Beauty_and_dBest

                        I do not really understand why after a successful patch, a new one will generate weird error?

                        Yes I have appstierNode and dbTier Node.

                        • 9. Re: adop confusion?
                          Beauty_and_dBest

                          Adding workers still get error

                           

                          $ adop phase=prepare workers=8

                           

                          Enter the APPS password:

                          Enter the SYSTEM password:

                          Enter the WLSADMIN password:

                           

                          Please wait. Validating credentials...

                           

                          RUN file system context file: /u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml

                           

                          PATCH file system context file: /u01/appprod/PROD/fs1/inst/apps/PROD_uat/appl/admin/PROD_uat.xml

                          Execute SYSTEM command : df /u01/appprod/PROD/fs1

                           

                          Worker count determination...

                           

                          [UNEXPECTED]You have specified 8 workers which can not be supported by the database server

                          [UNEXPECTED]Only a maximum of 1 workers can be invoked

                          [UNEXPECTED]Error while validating worker count

                          Log file: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/adop_20160415_191336.log

                           

                          [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 = 2 (Fail)

                          • 10. Re: adop confusion?
                            Beauty_and_dBest

                            I already edited the file, but it still get error and the file reset back to 0.

                             

                             

                            cd $APPL_TOP/admin/$TWO_TASK/log

                            [appprod@uat log]$ ls

                            adpawc.log  adpawc.xml

                            [appprod@uat log]$ vi adpawc.xml

                            [appprod@uat log]$ adop phase=prepare

                             

                            Enter the APPS password:

                            Enter the SYSTEM password:

                            Enter the WLSADMIN password:

                             

                            Please wait. Validating credentials...

                             

                            RUN file system context file: /u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml

                             

                            PATCH file system context file: /u01/appprod/PROD/fs1/inst/apps/PROD_uat/appl/admin/PROD_uat.xml

                            Execute SYSTEM command : df /u01/appprod/PROD/fs1

                             

                            Worker count determination...

                             

                            [UNEXPECTED]Invalid worker Count: 0

                            [UNEXPECTED]Error while validating worker count

                            Log file: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/adop_20160415_192131.log

                             

                            [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 = 2 (Fail)

                            [appprod@uat log]$ cat  $APPL_TOP/admin/$TWO_TASK/log/adpawc.xml

                            <?xml version="1.0"?>

                            <WORKER_COUNT>

                                    <RECOMMENDED>0</RECOMMENDED>

                                    <MAX>1</MAX>

                             

                             

                            Please help...

                            • 11. Re: adop confusion?
                              Sachin Thapa

                              Hi,

                               

                              [UNEXPECTED]You have specified 8 workers which can not be supported by the database server

                              [UNEXPECTED]Only a maximum of 1 workers can be invoked

                               

                              can you try giving workers=1,

                               

                              what is the configuration of the instance that you are using??

                              1 person found this helpful
                              • 12. Re: adop confusion?
                                Beauty_and_dBest

                                Thanks all,

                                Our server is bigger like 8 cores, so it should not be limited to 1

                                Why is that I was able to run adop patching before without issues?

                                • 13. Re: adop confusion?
                                  Beauty_and_dBest

                                  Hi ALL,

                                   

                                  It seems good on workers=1

                                  But I get lots of new wierd errors

                                  Please help...

                                   

                                   

                                   

                                  $ adop phase=prepare workers=1

                                   

                                  Enter the APPS password:

                                  Enter the SYSTEM password:

                                  Enter the WLSADMIN password:

                                   

                                  Please wait. Validating credentials...

                                   

                                   

                                  RUN file system context file: /u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml

                                   

                                  PATCH file system context file: /u01/appprod/PROD/fs1/inst/apps/PROD_uat/appl/admin/PROD_uat.xml

                                  Execute SYSTEM command : df /u01/appprod/PROD/fs1

                                   

                                  Worker count determination...

                                   

                                  Validation successful. All expected nodes are listed in ADOP_VALID_NODES table.

                                  [EVENT]     [START 2016/04/15 22:38:05] Performing database sanity checks

                                  [EVENT]     [END   2016/04/15 22:38:07] Finished performing database sanity checks

                                    [START 2016/04/15 22:38:10] adzdoptl.pl run

                                      ADOP Session ID: 30

                                      Phase: prepare

                                      Log file: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/adop_20160415_223741.log

                                      [EVENT]     [START 2016/04/15 22:38:11] Calling task: "Executing txkADOPValidation script on uat"; script: "/u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl"; args: " -contextfile=/u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml -patchctxfile=/u01/appprod/PROD/fs1/inst/apps/PROD_uat/appl/admin/PROD_uat.xml -phase=prepare -logloc=/u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat -promptmsg=hide"

                                        [EVENT]     [START 2016/04/15 22:38:11] Executing txkADOPValidation script on uat

                                          [EVENT]     Calling: /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPValidations.pl

                                  Oracle E-Business Suite Online Patching

                                  RUN edition environment variables have been set.

                                   

                                  calling: /u01/appprod/PROD/fs2/FMW_Home/webtier/perl/bin/perl /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkValidateSetup.pl -contextfile=/u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml -patchctxfile=/u01/appprod/PROD/fs1/inst/apps/PROD_uat/appl/admin/PROD_uat.xml -logloc=/u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat -phase=prepare -promptmsg=hide

                                   

                                  Program : txkValidateSetup.pl started @ Fri Apr 15 22:38:16 2016

                                   

                                  *** Log File = /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat/ADOPValidations_Fri_Apr_15_22_38_16_2016.log

                                   

                                  SETUP VALIDATION is in progress. This may take few minutes to complete.

                                   

                                  Completed execution of all tests. There are warnings.

                                   

                                  =========================== START OF VALIDATION REPORT ====================

                                   

                                  Validation Results for Node: uat

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

                                  [WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.

                                   

                                  [WARNING]: Either some of the required entries in /etc/hosts file might be missing (e.g. localhost or hostname) OR the file /etc/hosts could not be read.

                                   

                                  There are warnings in tests, please check /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat/ADOPValidations_Fri_Apr_15_22_38_16_2016.log

                                   

                                  =========================== END OF VALIDATION REPORT ======================

                                        [EVENT]     [END   2016/04/15 22:40:51] Executing txkADOPValidation script on uat

                                      [EVENT]     [END   2016/04/15 22:40:51] Executing txkADOPValidation script on uat

                                      [START 2016/04/15 22:41:07] prepare phase

                                        [EVENT]     [START 2016/04/15 22:41:09] Validating Configuration

                                          [EVENT]     Calling: /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSanityCheck.pl

                                   

                                  Program :  started @ Fri Apr 15 22:41:09 2016

                                   

                                  *** Log File = /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat/TXK_SANITY_filesystemcheck_Fri_Apr_15_22_41_09_2016/txkADOPPreparePhaseSanityCheck_Fri_Apr_15_22_41_09_2016.log

                                   

                                  LOG FILE     : /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat/TXK_SANITY_filesystemcheck_Fri_Apr_15_22_41_09_2016/txkADOPPreparePhaseSanityCheck_Fri_Apr_15_22_41_09_2016.log

                                   

                                   

                                  Program :  completed @ Fri Apr 15 22:41:11 2016

                                   

                                        [EVENT]     [END   2016/04/15 22:41:11] Validating Configuration

                                        [EVENT]     [START 2016/04/15 22:41:11] Detecting config changes in FS

                                          [EVENT]     Calling task: "Executing adConfigChangeDetector on uat"; script: "/u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adConfigChangeDetector.pl"; args: " -detectConfigChanges contextfile=/u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml promptmsg=hide log=/u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat/adConfigChanges.log hostname=uat"

                                          [EVENT]     [START 2016/04/15 22:41:12] Executing adConfigChangeDetector on uat

                                            [EVENT]     Calling: /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adConfigChangeDetector.pl

                                  The log file is /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat/adConfigChanges.log

                                          [EVENT]     [END   2016/04/15 22:41:18] Executing adConfigChangeDetector on uat

                                        [EVENT]     [END   2016/04/15 22:41:18] Detecting config changes in FS

                                        [EVENT]     [START 2016/04/15 22:41:18] Performing check to see if pending cleanup actions exist

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

                                        [EVENT]     [END   2016/04/15 22:41:18] Performing check to see if pending cleanup actions exist

                                        [EVENT]     [START 2016/04/15 22:41:18] Performing DB Sanity checks

                                        [EVENT]     [END   2016/04/15 22:41:19] Performing DB Sanity checks

                                        [START 2016/04/15 22:41:19] Generating Tablespace Report

                                            [EVENT]     Report: /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWTS.sql

                                   

                                            [EVENT]     Output: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat/adzdshowts.out

                                   

                                        [END   2016/04/15 22:41:21] Generating Tablespace Report

                                        [EVENT]     [START 2016/04/15 22:41:21] Run the ADZDPATCH concurrent program

                                          [EVENT]     [START 2016/04/15 22:41:26] Checking status of the ADZDPATCH concurrent program

                                            [EVENT]     Status of ADZDPATCH:

                                            [EVENT]     This request is waiting to be processed by the Conflict Resolution

                                  Manager.  This request cannot yet begin execution because other requests

                                  may conflict with it. The Conflict Resolution Manager will determine when

                                  this request may begin execution. User SYSADMIN submitted this request on

                                  15-APR-2016 22:41:24.  No action required. This is a normal condition.

                                          [EVENT]     [END   2016/04/15 22:41:28] Checking status of the ADZDPATCH concurrent program

                                          [EVENT]     [START 2016/04/15 22:41:30] Waiting for ADZDPATCH concurrent program to run

                                          [EVENT]     [END   2016/04/15 22:42:01] Waiting for ADZDPATCH concurrent program to run

                                        [EVENT]     [END   2016/04/15 22:42:01] Run the ADZDPATCH concurrent program

                                        [EVENT]     [START 2016/04/15 22:42:01] Generating ad_zd_logs before truncating

                                            [EVENT]     Report: /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

                                   

                                            [EVENT]     Output: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat/adzdshowlog_cleanup.out

                                   

                                        [EVENT]     [END   2016/04/15 22:42:03] Generating ad_zd_logs before truncating

                                        [EVENT]     [START 2016/04/15 22:42:03] Check and create Patch Edition (if required)

                                          [EVENT]     [START 2016/04/15 22:42:03] Checking if Patch Edition already exists

                                            [EVENT]     Patch Edition does not exist

                                            [START 2016/04/15 22:42:03] Creating Patch Edition

                                            [END   2016/04/15 22:42:41] Creating Patch Edition

                                          [EVENT]     [END   2016/04/15 22:42:41] Checking if Patch Edition already exists

                                        [EVENT]     [END   2016/04/15 22:42:41] Check and create Patch Edition (if required)

                                        [EVENT]     [START 2016/04/15 22:42:41] Performing steps to synchronise the FS

                                            [EVENT]     [START 2016/04/15 22:42:43] Sync FS of RUN and PATCH

                                              [EVENT]     Calling: /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl

                                   

                                  Program :  started @ Fri Apr 15 22:42:43 2016

                                   

                                  *** Log File = /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat/TXK_SYNC_update_Fri_Apr_15_22_42_43_2016/txkADOPPreparePhaseSynchronize_Fri_Apr_15_22_42_43_2016.log

                                   

                                  Oracle E-Business Suite Online Patching

                                  PATCH edition environment variables have been set.

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

                                  PROGRAM : (/u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl)

                                  TIME    : Fri Apr 15 22:42:53 2016

                                  FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]

                                  MESSAGES:

                                  Invalid Connect string - cannot connect to database

                                  ERROR:

                                  ORA-12516: TNS:listener could not find available handler with matching protocol

                                  stack

                                   

                                  STACK TRACE

                                  at /u01/appprod/PROD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168

                                          TXK::Error::abort('TXK::Error', 'HASH(0x1303440)') called at /u01/appprod/PROD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 299

                                          TXK::Common::doError('TXK::SQLPLUS=HASH(0x258aed0)', 'Invalid Connect string - cannot connect to database\x{a}ERROR:\x{a}OR...', undef) called at /u01/appprod/PROD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/Common.pm line 314

                                          TXK::Common::setError('TXK::SQLPLUS=HASH(0x258aed0)', 'Invalid Connect string - cannot connect to database\x{a}ERROR:\x{a}OR...') called at /u01/appprod/PROD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 741

                                          TXK::SQLPLUS::_doExecute('TXK::SQLPLUS=HASH(0x258aed0)', 'true') called at /u01/appprod/PROD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 376

                                          TXK::SQLPLUS::validateConnectInfo('TXK::SQLPLUS=HASH(0x258aed0)') called at /u01/appprod/PROD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 267

                                          TXK::SQLPLUS::setConnectInfo('TXK::SQLPLUS=HASH(0x258aed0)', 'HASH(0x258dab0)') called at /u01/appprod/PROD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 606

                                          TXK::TechstackDB::_getSQLValue('TXK::TechstackDB=HASH(0x2501718)', 'SELECT count(*)||\',\' from dba_source where owner = \'APPS\'...') called at /u01/appprod/PROD/fs2/EBSapps/appl/au/12.0.0/perl/TXK/TechstackDB.pm line 573

                                          TXK::TechstackDB::getSQLValue('TXK::TechstackDB=HASH(0x2501718)', 'SELECT count(*)||\',\' from dba_source where owner = \'APPS\'...') called at /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 4232

                                          main::isTableAlreadyPrepared('IBY_BEPINFO') called at /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 4879

                                          main::prepareDBTables() called at /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 1392

                                          main::checkDBPrepareRequired() called at /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 6255

                                          main::updatePatchApplTop() called at /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl line 647

                                              [UNEXPECTED]Error occurred while executing "perl /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml -patchcontextfile=/u01/appprod/PROD/fs1/inst/apps/PROD_uat/appl/admin/PROD_uat.xml -promptmsg=hide -console=off -patchtop=/u01/appprod/PROD/fs_ne/EBSapps/patch -mode=update -sessionid=30 -timestamp=20160415_223741 -workercount=1 -outdir=/u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat -autoskip=No"

                                              [UNEXPECTED]Error while runSyncFS sub-routine is called

                                                [EVENT]     [START 2016/04/15 22:42:54] Check and Stop Patch FS Admin Server

                                   

                                  You are running adadminsrvctl.sh version 120.10.12020000.9

                                   

                                   

                                  The AdminServer is already shutdown

                                   

                                  adadminsrvctl.sh: exiting with status 2

                                   

                                  adadminsrvctl.sh: check the logfile /u01/appprod/PROD/fs1/inst/apps/PROD_uat/logs/appl/admin/log/adadminsrvctl.txt for more information ...

                                   

                                                [EVENT]     [END   2016/04/15 22:43:08] Check and Stop Patch FS Admin Server

                                                [EVENT]     [START 2016/04/15 22:43:10] Check and Stop Patch Node Manager

                                   

                                  You are running adnodemgrctl.sh version 120.11.12020000.11

                                   

                                   

                                  The Node Manager is already shutdown

                                   

                                  adnodemgrctl.sh: exiting with status 2

                                   

                                  adnodemgrctl.sh: check the logfile /u01/appprod/PROD/fs1/inst/apps/PROD_uat/logs/appl/admin/log/adnodemgrctl.txt for more information ...

                                   

                                                [EVENT]     [END   2016/04/15 22:43:20] Check and Stop Patch Node Manager

                                              [ERROR]     Prepare phase completed with errors or warnings. Please check logfiles.

                                              Log file: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/adop_20160415_223741.log

                                   

                                   

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

                                  [appprod@uat log]$ adopscanlog -latest=yes

                                   

                                  Scanning /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/ directory ...

                                   

                                  /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/adop_20160415_223741.log:

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

                                   

                                  Lines #(139-143):

                                              [EVENT]     Calling: /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl

                                              [STATEMENT] Output directory: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat

                                              [UNEXPECTED]Error occurred while executing "perl /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml -patchcontextfile=/u01/appprod/PROD/fs1/inst/apps/PROD_uat/appl/admin/PROD_uat.xml -promptmsg=hide -console=off -patchtop=/u01/appprod/PROD/fs_ne/EBSapps/patch -mode=update -sessionid=30 -timestamp=20160415_223741 -workercount=1 -outdir=/u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat -autoskip=No"

                                              [UNEXPECTED]Error while runSyncFS sub-routine is called

                                              [PROCEDURE] [START 2016/04/15 22:42:53] Check and Stop Patch Admin Server

                                   

                                  Lines #(140-144):

                                              [STATEMENT] Output directory: /u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat

                                              [UNEXPECTED]Error occurred while executing "perl /u01/appprod/PROD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=/u01/appprod/PROD/fs2/inst/apps/PROD_uat/appl/admin/PROD_uat.xml -patchcontextfile=/u01/appprod/PROD/fs1/inst/apps/PROD_uat/appl/admin/PROD_uat.xml -promptmsg=hide -console=off -patchtop=/u01/appprod/PROD/fs_ne/EBSapps/patch -mode=update -sessionid=30 -timestamp=20160415_223741 -workercount=1 -outdir=/u01/appprod/PROD/fs_ne/EBSapps/log/adop/30/prepare_20160415_223741/PROD_uat -autoskip=No"

                                              [UNEXPECTED]Error while runSyncFS sub-routine is called

                                              [PROCEDURE] [START 2016/04/15 22:42:53] Check and Stop Patch Admin Server

                                                [EVENT]     [START 2016/04/15 22:42:54] Check and Stop Patch FS Admin Server

                                   

                                  Lines #(150-154):

                                                [EVENT]     [END   2016/04/15 22:43:20] Check and Stop Patch Node Manager

                                              [PROCEDURE] [END   2016/04/15 22:43:20] Check and Stop Patch Node Manager

                                              [ERROR]     Prepare phase completed with errors or warnings. Please check logfiles.

                                              [STATEMENT] SQL statement : "  update ad_adop_sessions

                                    set status='F'

                                  • 14. Re: adop confusion?
                                    Bashar.

                                    These are the errors that you pay attention for:

                                     

                                    MESSAGES:

                                    Invalid Connect string - cannot connect to database

                                    ERROR:

                                    ORA-12516: TNS:listener could not find available handler with matching protocol stack

                                     

                                     

                                    Any changes in the database tier recently?

                                     

                                    Please post the output of this command using the database tier owner account:

                                     

                                    lsnrctl status PROD

                                     

                                    Regards,

                                    Bashar

                                    1 person found this helpful
                                    1 2 Previous Next