1 2 Previous Next 17 Replies Latest reply on Mar 23, 2015 11:25 AM by MariaKarpa(MK)

    adop Patching EBS R12.2 Error

      Hi all,

       

      EBS R12.2.4

      RHEL6.6

       

      [appcrp@ip-10-0-0-216 MobileApps]$ adop phase=apply patches=20049473 patchtop=/u01/MobileApps

       

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

       

      Please wait. Validating credentials...

       

      RUN file system context file: /u01/appcrp/CRP/fs1/inst/apps/CRP_ip-10-0-0-216/appl/admin/CRP_ip-10-0-0-216.xml

       

      PATCH file system context file: /u01/appcrp/CRP/fs2/inst/apps/CRP_ip-10-0-0-216/appl/admin/CRP_ip-10-0-0-216.xml

      Execute SYSTEM command : df /u01/appcrp/CRP/fs2

       

      Worker count determination...

       

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

      [EVENT]     [START 2015/03/20 19:29:00] Performing database sanity checks

      [EVENT]     [END   2015/03/20 19:29:00] Finished performing database sanity checks

       

       

        [UNEXPECTED]Apply phase can only be run while in a patching cycle, i.e. after prepare phase.

       

      Log file: /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/adop_20150320_192839.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)

      [appcrp@ip-10-0-0-216 MobileApps]$ adopscanlog -latest=yes

      Scanning /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/adop_20150320_192839.log log file ...

       

       

      /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/adop_20150320_192839.log:

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

       

      Lines #(27-31):

        [PROCEDURE] [START 2015/03/20 19:29:01] Staging the current session

        [PROCEDURE] [END   2015/03/20 19:29:01] Staging the current session

        [UNEXPECTED]Apply phase can only be run while in a patching cycle, i.e. after prepare phase.

        [PROCEDURE] [START 2015/03/20 19:29:01] Unlocking sessions table

          [STATEMENT] Unlocking ad_adop_sessions table for ip-10-0-0-216 with wait interval of 60 seconds and number of tries              2

       

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

      [ec2-user@ip-10-0-0-216 ~]$ vi /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/adop_20150320_192839.log

        Log file: /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/adop_20150320_192839.log

      [START 2015/03/20 19:28:40]Arguments passed to adop

          phase=apply patches=20049473 patchtop=/u01/MobileApps

      [END   2015/03/20 19:28:40]Arguments passed to adop

      [START 2015/03/20 19:28:40] Performing verification of parameters

      [END   2015/03/20 19:28:58] Performing verification of parameters

      [STATEMENT] Sourcing the Run Edition environment: /u01/appcrp/CRP/fs1/EBSapps/appl/APPSCRP_ip-10-0-0-216.env

      [EVENT]     [START 2015/03/20 19:28:59] Checking for the required ENV setup

      [EVENT]     [END   2015/03/20 19:29:00] Checking for the required ENV setup

      [STATEMENT]  Using 4 workers (Default: 4, Recommended maximum limit: 62)

      [PROCEDURE] [START 2015/03/20 19:29:00] Determining admin node

        [STATEMENT] Admin node : "ip-10-0-0-216"

      [PROCEDURE] [END   2015/03/20 19:29:00] Determining admin node

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

      [EVENT]     [START 2015/03/20 19:29:00] Performing database sanity checks

      [EVENT]     [END   2015/03/20 19:29:00] Finished performing database sanity checks

      [PROCEDURE] [START 2015/03/20 19:29:01] Acquiring lock on sessions table

        [STATEMENT] Locking ad_adop_sessions table for ip-10-0-0-216 with wait interval of 60 seconds and number of tries 2

       

      [PROCEDURE] [END   2015/03/20 19:29:01] Acquiring lock on sessions table

      [EVENT]     [START 2015/03/20 19:29:01] Checking for any pending sessions

        [PROCEDURE] [START 2015/03/20 19:29:01] Checking active hotpatch session

          [STATEMENT] Fetching number of incomplete cycles for ip-10-0-0-216 having appltop_id=195.

          [STATEMENT] value of incomplete_session: "0"

        [PROCEDURE] [END   2015/03/20 19:29:01] Checking active hotpatch session

        [STATEMENT] Master Session Id: NOT DEFINED

        [PROCEDURE] [START 2015/03/20 19:29:01] Staging the current session

        [PROCEDURE] [END   2015/03/20 19:29:01] Staging the current session

        [UNEXPECTED]Apply phase can only be run while in a patching cycle, i.e. after prepare phase.

        [PROCEDURE] [START 2015/03/20 19:29:01] Unlocking sessions table

          [STATEMENT] Unlocking ad_adop_sessions table for ip-10-0-0-216 with wait interval of 60 seconds and number of tries 2

       

      [PROCEDURE] [END   2015/03/20 19:29:01] Unlocking sessions table


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


      [appcrp@ip-10-0-0-216 ~]$ adop -status

       

      Enter the APPS password:

       

      Current Patching Session ID: 3

       

      Node Name       Node Type       Phase           Status          Started                        Finished                       Elapsed

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

      crp2            slave           FS_CLONE        COMPLETED       05-NOV-14 03:59:33 -04:00      05-NOV-14 04:54:56 -04:00      0:55:23

                                      PREPARE         NOT APPLICABLE

                                      APPLY           NOT APPLICABLE

                                      CUTOVER         NOT APPLICABLE

                                      CLEANUP         NOT APPLICABLE

       

      File System Synchronization Used in this Patching Cycle: Full

       

      For more information, run ADOP Status Report by using -detail option

       

      Generating ADOP Status Report at location: /u01/appcrp/CRP/fs_ne/EBSapps/log/status_20150320_194359/adzdshowstatus.out

      Please wait...

      Done...!

        • 1. Re: adop Patching EBS R12.2 Error
          Kj - Kiran Jadhav

          You need to follow adop patching cycle. Please run prepare phase before apply phase if not Hotpatch.

           

          -Kj

          1 person found this helpful
          • 2. Re: adop Patching EBS R12.2 Error

            Ohhhh I forgot to add parameter hotpatch, my dumbness

             

            Thank you very much!!!

            • 3. Re: adop Patching EBS R12.2 Error

              Hi Kj and all,

               

              I still  have error

               

              $  adop phase=apply patches=20049477 patchtop=/u01/MobileApps hotpatch=yes

               

              AutoPatch error:

               

              Error running SQL and EXEC commands in parallel

               

              You should check the file

              /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/4/apply_20150321_000452/CRP_ip-10-0-0-216/20049477/log/u20049477.log

               

              for errors.

               

                        [UNEXPECTED]Error occurred while executing "adpatch  workers=4   options=hotpatch     console=no interactive=no  defaultsfile=/u01/appcrp/CRP/fs1/EBSapps/appl/admin/CRP/adalldefaults.txt patchtop=/u01/MobileApps/20049477 driver=u20049477.drv logfile=u20049477.log"

                        [UNEXPECTED]Please check the adpatch log files.

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

                        Log file: /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/4/adop_20150321_000452.log

               

               

              [STATEMENT] Please run adopscanlog utility, using the command

              Starting phase 15 (A15): upg

               

              There are now 2 jobs remaining (current phase=A15):

                  0 running, 1 ready to run and 1 waiting.

               

              Assigned: file EGOSDACI.sql on worker  1 for product ego username EGO.

               

              Time is: Sat Mar 21 2015 00:19:13

               

                 FAILED: file EGOSDACI.sql on worker  1 for product ego username EGO.

               

              ATTENTION: All workers either have failed or are waiting:



              • 4. Re: adop Patching EBS R12.2 Error
                ;) ApPsMasTi ;)

                please see the solution

                ORA-20001: Unable to set edition ORA-06512: at "APPS.AD_ZD" skipped job: egosdaci.sql on appsad_zd build (Doc ID 1989739.1)

                 

                AppsMasti

                Sharing is caring

                1 person found this helpful
                • 5. Re: adop Patching EBS R12.2 Error

                  Thanks dear friend,

                   

                  I will check that notes..brb

                  Where did you see that ora-2001

                   

                   

                  I can only see this log:

                   

                            [STATEMENT] Checking if the patch 20049477_US is already applied...

                            [STATEMENT] Release : 12.0.0

                            [STATEMENT] Appltop Id : 195

                            [STATEMENT] Bug number : 20049477

                            [STATEMENT] Language : US

                            [STATEMENT] Is patch applied : NOT_APPLIED

                            [STATEMENT] 1 Value of actual_command : "adpatch  workers=4   options=hotpatch     console=no interactive=no  defaultsfile=/u01/appcrp/CRP/fs1/EBSapps/appl/admin/CRP/adalldefaults.txt patchtop=/u01/MobileApps/20049477 driver=u20049477.drv"

                            [STATEMENT] 2 Value of actual_command : "adpatch  workers=4   options=hotpatch     console=no interactive=no  defaultsfile=/u01/appcrp/CRP/fs1/EBSapps/appl/admin/CRP/adalldefaults.txt patchtop=/u01/MobileApps/20049477 driver=u20049477.drv logfile=u20049477.log"

                            Calling: adpatch  workers=4   options=hotpatch     console=no interactive=no  defaultsfile=/u01/appcrp/CRP/fs1/EBSapps/appl/admin/CRP/adalldefaults.txt patchtop=/u01/MobileApps/20049477 driver=u20049477.drv logfile=u20049477.log

                            ADPATCH Log directory: /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/4/apply_20150321_000452/CRP_ip-10-0-0-216/20049477/log

                            [PROCEDURE] Running: adpatch  workers=4   options=hotpatch     console=no interactive=no  defaultsfile=/u01/appcrp/CRP/fs1/EBSapps/appl/admin/CRP/adalldefaults.txt patchtop=/u01/MobileApps/20049477 driver=u20049477.drv logfile=u20049477.log acp=yes

                            [UNEXPECTED]Error occurred while executing "adpatch  workers=4   options=hotpatch     console=no interactive=no  defaultsfile=/u01/appcrp/CRP/fs1/EBSapps/appl/admin/CRP/adalldefaults.txt patchtop=/u01/MobileApps/20049477 driver=u20049477.drv logfile=u20049477.log"

                            [UNEXPECTED]Please check the adpatch log files.

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

                       where adop_session_id=4

                       and status='R'

                  >

                            [UNEXPECTED]Autopatch 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 = 195 and node_name='ip-10-0-0-216'

                  "

                            [STATEMENT] APPLY Phase END TIME: 21-03-2015 00:19:19

                            [PROCEDURE] [START 2015/03/21 00:19:21] Unlocking sessions table

                              [STATEMENT] Unlocking ad_adop_sessions table for ip-10-0-0-216 with wait interval of 60 seconds and number of tries 2

                   

                   

                            [PROCEDURE] [END   2015/03/21 00:19:24] Unlocking sessions table

                            [STATEMENT] SQL statement : "  update ad_adop_sessions

                    set status='F'

                     where adop_session_id = 4 and appltop_id = 195 and node_name='ip-10-0-0-216'

                  "

                            Log file: /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/4/adop_20150321_000452.log

                  • 6. Re: adop Patching EBS R12.2 Error

                    Hi ApPs,

                     

                    The note said to apply 20183051:R12.EGO.D

                    But I can not find it in MOS

                     

                    Can you please check if it does exist?

                    Or maybe my search params is wrong?

                     

                    Thanks a lot,

                    • 7. Re: adop Patching EBS R12.2 Error
                      Kj - Kiran Jadhav
                      FAILED: file EGOSDACI.sql on worker  1 for product ego username EGO.

                       

                      Can you please check worker 1 log for the errors.- (Location - <INSTALL BASE>/fs_ne/EBSapps/log/adop)

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

                       

                      -Kj

                      1 person found this helpful
                      • 8. Re: adop Patching EBS R12.2 Error

                        Thanks Kj,

                         

                        How do I attach txt log file here?

                         

                         

                        -rw-r--r--. 1 appcrp dba 188980 Mar 21 00:19 u20049477.log

                        [appcrp@ip-10-0-0-216 log]$ pwd

                        /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/4/apply_20150321_000452/CRP_ip-10-0-0-216/20049477/log



                        The log does not give much hint though


                        It just says: It failed with no reason details.


                        There are now 2 jobs remaining (current phase=A15):

                            0 running, 1 ready to run and 1 waiting.

                         

                        Assigned: file EGOSDACI.sql on worker  1 for product ego username EGO.

                         

                        Time is: Sat Mar 21 2015 00:19:13

                         

                          FAILED: file EGOSDACI.sql on worker  1 for product ego username EGO.

                         

                        Time is: Sat Mar 21 2015 00:19:13

                         

                        Deferred: file EGOSDACI.sql on worker  1 for product ego username EGO.

                         

                        Time is: Sat Mar 21 2015 00:19:13

                                       (Deferment number 1 for this job)

                        Assigned: file EGOSDACI.sql on worker  1 for product ego username EGO.

                         

                        Time is: Sat Mar 21 2015 00:19:13

                         

                           FAILED: file EGOSDACI.sql on worker  1 for product ego username EGO.

                         

                        Time is: Sat Mar 21 2015 00:19:14

                         

                        Deferred: file EGOSDACI.sql on worker  1 for product ego username EGO.

                         

                        Time is: Sat Mar 21 2015 00:19:14

                                       (Deferment number 2 for this job)

                        Assigned: file EGOSDACI.sql on worker  1 for product ego username EGO.

                         

                        Time is: Sat Mar 21 2015 00:19:14

                         

                           FAILED: file EGOSDACI.sql on worker  1 for product ego username EGO.

                         

                        Time is: Sat Mar 21 2015 00:19:14

                         

                        ATTENTION: All workers either have failed or are waiting:

                         

                                   FAILED: file EGOSDACI.sql on worker  1.

                         

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

                         

                        Current time is: Sat Mar 21 2015 00:19:14

                         

                        Telling workers to quit...

                         

                        1 worker has quit.  Waiting for 3 more.

                        • 9. Re: adop Patching EBS R12.2 Error
                          2748727

                          Hi,

                           

                          Check the below note or raise SR i am not this will apply 12.2!

                           

                          Standard Datafix To Remove Duplicate User Defined Attribute (UDA) Records Created In EGO_MTL_SY_ITEMS_EXT_B (Doc ID 953449.1)

                           

                          Regards,

                          AG

                           

                          1 person found this helpful
                          • 10. Re: adop Patching EBS R12.2 Error

                            Thanks dear, I will check on that

                            • 11. Re: adop Patching EBS R12.2 Error
                              ;) ApPsMasTi ;)

                              what does worker 1 log-file says

                              Please upload worker 1 log-file

                               

                              AppsmAsti

                              sharing is Caring

                              1 person found this helpful
                              • 12. Re: adop Patching EBS R12.2 Error

                                Ok wait , im confused with the location of logs it is so hard to find and will mixed up your brain to remember it.

                                 

                                I tried to locate it in:

                                 

                                $ cd /u01/appcrp/CRP/fs_ne/EBSapps/log/adop/4/apply_20150321_000452/

                                $ find . -name adworker*.log


                                But none is found


                                Please assist.


                                Thanks

                                • 13. Re: adop Patching EBS R12.2 Error
                                  ;) ApPsMasTi ;)

                                  please see adop flow chart

                                  http://expertoracle.com/2014/06/12/oracle-applications-r12-2-log-files/

                                  AppsMasti
                                  Sharing is Caring

                                  1 person found this helpful
                                  • 14. Re: adop Patching EBS R12.2 Error

                                    Its  wierd, the previous search can not find it but this one can?

                                     

                                    [appcrp@ip-10-0-0-216 admin]$ cd /u01/appcrp/CRP/fs_ne/EBSapps/log

                                    [appcrp@ip-10-0-0-216 log]$ find . -name adwork*

                                    ./adop/4/apply_20150320_235151/CRP_ip-10-0-0-216/20049475/log/adwork003.log

                                    ./adop/4/apply_20150320_235151/CRP_ip-10-0-0-216/20049475/log/adwork002.log

                                    ./adop/4/apply_20150320_235151/CRP_ip-10-0-0-216/20049475/log/adwork001.log

                                    ./adop/4/apply_20150320_235151/CRP_ip-10-0-0-216/20049475/log/adwork004.log

                                    ./adop/4/apply_20150320_235151/CRP_ip-10-0-0-216/log/adwork003.log

                                    ./adop/4/apply_20150320_235151/CRP_ip-10-0-0-216/log/adwork002.log

                                    ./adop/4/apply_20150320_235151/CRP_ip-10-0-0-216/log/adwork001.log

                                    ./adop/4/apply_20150320_235151/CRP_ip-10-0-0-216/log/adwork004.log

                                    ./adop/4/apply_20150320_234700/CRP_ip-10-0-0-216/log/adwork003.log

                                    ./adop/4/apply_20150320_234700/CRP_ip-10-0-0-216/log/adwork002.log

                                    ./adop/4/apply_20150320_234700/CRP_ip-10-0-0-216/log/adwork001.log

                                    ./adop/4/apply_20150320_234700/CRP_ip-10-0-0-216/log/adwork004.log

                                    ./adop/4/apply_20150320_234700/CRP_ip-10-0-0-216/20049474/log/adwork003.log

                                    ./adop/4/apply_20150320_234700/CRP_ip-10-0-0-216/20049474/log/adwork002.log

                                    ./adop/4/apply_20150320_234700/CRP_ip-10-0-0-216/20049474/log/adwork001.log

                                    ./adop/4/apply_20150320_234700/CRP_ip-10-0-0-216/20049474/log/adwork004.log

                                    ./adop/4/apply_20150320_235832/CRP_ip-10-0-0-216/20049476/log/adwork003.log

                                    ./adop/4/apply_20150320_235832/CRP_ip-10-0-0-216/20049476/log/adwork002.log

                                    ./adop/4/apply_20150320_235832/CRP_ip-10-0-0-216/20049476/log/adwork001.log

                                    ./adop/4/apply_20150320_235832/CRP_ip-10-0-0-216/20049476/log/adwork004.log

                                    ./adop/4/apply_20150320_235832/CRP_ip-10-0-0-216/log/adwork003.log

                                    ./adop/4/apply_20150320_235832/CRP_ip-10-0-0-216/log/adwork002.log

                                    ./adop/4/apply_20150320_235832/CRP_ip-10-0-0-216/log/adwork001.log

                                    ./adop/4/apply_20150320_235832/CRP_ip-10-0-0-216/log/adwork004.log

                                    ./adop/4/apply_20150320_233034/CRP_ip-10-0-0-216/20049473/log/adwork003.log

                                    ./adop/4/apply_20150320_233034/CRP_ip-10-0-0-216/20049473/log/adwork002.log

                                    ./adop/4/apply_20150320_233034/CRP_ip-10-0-0-216/20049473/log/adwork001.log

                                    ./adop/4/apply_20150320_233034/CRP_ip-10-0-0-216/20049473/log/adwork004.log

                                    ./adop/4/apply_20150320_233034/CRP_ip-10-0-0-216/log/adwork003.log

                                    ./adop/4/apply_20150320_233034/CRP_ip-10-0-0-216/log/adwork002.log

                                    ./adop/4/apply_20150320_233034/CRP_ip-10-0-0-216/log/adwork001.log

                                    ./adop/4/apply_20150320_233034/CRP_ip-10-0-0-216/log/adwork004.log

                                    ./adop/4/apply_20150321_000452/CRP_ip-10-0-0-216/20049477/log/adwork003.log

                                    ./adop/4/apply_20150321_000452/CRP_ip-10-0-0-216/20049477/log/adwork002.log

                                    ./adop/4/apply_20150321_000452/CRP_ip-10-0-0-216/20049477/log/adwork001.log

                                    ./adop/4/apply_20150321_000452/CRP_ip-10-0-0-216/20049477/log/adwork004.log

                                    1 2 Previous Next