1 2 Previous Next 20 Replies Latest reply on Nov 9, 2017 9:48 AM by Beauty_and_dBest

    Apply Patch for EBS R12.2.6

    Beauty_and_dBest

      EBS R12.2.6

      12c

      OL6

       

       

      Hi ALL,

       

      I am starting to apply a patch.

      First step is  adop phase=prepare

       

      [appcrp1@orar12 PATCH]$ adop phase=prepare

       

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

       

      Validating credentials.

       

      Initializing.

          Run Edition context  : /u01/appcrp1/CRP1/fs1/inst/apps/CRP1_orar12/appl/admin/CRP1_orar12.xml

          Patch edition context: /u01/appcrp1/CRP1/fs2/inst/apps/CRP1_orar12/appl/admin/CRP1_orar12.xml

          Patch file system free space: 41.06 GB

       

      Validating system setup.

          Node registry is valid.

          [WARNING]   MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.

       

      Checking for existing adop sessions.

          No pending session exists.

          Starting new adop session.

       

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

      ADOP (C.Delta.8)

      Session ID: 19

      Node: orar12

      Phase: prepare

      Log: /u01/appcrp1/CRP1/fs_ne/EBSapps/log/adop/19/20171108_015316/adop.log

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

       

      Validating configuration on node: [orar12].

          Log: /u01/appcrp1/CRP1/fs_ne/EBSapps/log/adop/19/20171108_015316/prepare/validate/orar12

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

       

      Verifying data dictionary.

       

      Validating system is ready to prepare.

          Log: /u01/appcrp1/CRP1/fs_ne/EBSapps/log/adop/19/20171108_015316/prepare/orar12

       

      Detecting configuration changes.

          Log: /u01/appcrp1/CRP1/fs_ne/EBSapps/log/adop/19/20171108_015316/prepare/orar12/adConfigChanges.log

      The log file is /u01/appcrp1/CRP1/fs_ne/EBSapps/log/adop/19/20171108_015316/prepare/orar12/adConfigChanges.log

       

      /u01/appcrp1/CRP1/fs1/inst/apps/CRP1_orar12/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.

          File system configuration changes were detected.

       

      Checking for pending cleanup actions.

          Running cleanup as it was not run in previous patching cycle.

       

      Processing cleanup actions in parallel.

          Log: /u01/appcrp1/CRP1/fs_ne/EBSapps/log/adop/19/20171108_015316/prepare/orar12/log/cleanup.log

       

      Generating report of queued DDL actions.

          Output: /u01/appcrp1/CRP1/fs_ne/EBSapps/log/adop/19/20171108_015316/prepare/orar12/adzdallddls.out

       

      Running cleanup in STANDARD mode.

          Log: @ADZDSHOWLOG.sql "2017/11/08 01:55:35"

       

       

       

      I see above WARNING listed below:

      1.   [WARNING]   MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.

      2.  [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.

      3.   [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.

       

      Is it okay not to  apply patch 17537119 and still my patch will succeed?

      How do I correct item #2?

      What is missing in #2? I can read the /etc/hosts file as appl owner.

      [appcrp1@orar12 ~]$ cat /etc/hosts

      127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

      ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

      192.168.0.185   orar12.abc.com     orar12

      192.168.0.243   frozen.abc.com     frozen

       

      Please help...

       

      Kind regards,

      jc

        • 1. Re: Apply Patch for EBS R12.2.6
          mdtaylor

          Hi jc,

           

          The MTCC/ETCC code checker patch is not one you apply, but download and execute to see what patches you are missing in your environment.  If you have not done this in a while, you will get a list of dozens of FMW, forms, WLS patches to apply.  The official guidance is you should apply these patches in the patch cycle to the patch fs.

           

          Patch 17537119 EBS Technology Codelevel Checker

          https://updates.oracle.com/Orion/PatchDetails/process_form?patch_num=17537119

           

          I see a bigger problem that you only have 41GB free and to have a patching cycle, you need 75GB free.  Please delete some old logfiles or large concurrent request logfiles to free up space.

           

          Regards,

          Michael

          • 2. Re: Apply Patch for EBS R12.2.6
            Beauty_and_dBest

            Hi all,

             

            adop phase=prepare   ...taking soooo lonngg  and not completing

             

            stuck on:

             

            Starting Apps listener.

             

            adalnctl.sh version 120.3.12020000.4

             

            Checking for FNDFS executable.

            Listener APPS_CRP1 has already been started.

             

            adalnctl.sh: exiting with status 2

             

            adalnctl.sh: check the logfile /u01/appcrp1/CRP1/fs1/inst/apps/CRP1_orar12/logs/appl/admin/log/adalnctl.txt for more information ...

             

            Submitting ADZDPATCH concurrent program.

                Waiting for conflicting requests to complete.

             

             

            Capture.GIF

            Capture2.GIF

            Capture3.GIF

             

            Capture5.GIF

             

            Please help...

             

             

            Kind regards,

            • 3. Re: Apply Patch for EBS R12.2.6
              mdtaylor

              12.2 prepare phase can take an hour or more to complete depending on how much cleanup from previous sessions or fs_clone activities it needs to finish. 

               

              You can speed up WebLogic start/stop timings by making sure rngd is running on the Linux server.

               

              Java Programs Are Running Slower In Newer Servers Due To Lack Of Entropy In The System (Doc ID 1615981.1)

               

              cat /proc/sys/kernel/random/entropy_avail

              51

               

              vi /etc/sysconfig/rngd

              # Add extra options here

              EXTRAOPTIONS="-i -o /dev/random -r /dev/urandom -t 10 -W 2048"

               

              service rngd start

              chkconfig rngd on

               

              cat /proc/sys/kernel/random/entropy_avail

              3558

               

              Regards,

              Michael

              • 4. Re: Apply Patch for EBS R12.2.6
                Beauty_and_dBest

                Hi Michael,

                 

                Why no manager for fndload? its pending waiting for nothing?

                 

                Our Stardard Manager actual=15 target=15   pending=2  << this are the patching process, why pending?

                Capture2.GIF

                Capture3.GIF

                Capture5.GIF

                • 5. Re: Apply Patch for EBS R12.2.6
                  Beauty_and_dBest

                  Hi Michael,

                   

                  [root@orar12 ~]# cat /proc/sys/kernel/random/entropy_avail

                  922

                  [root@orar12 ~]# vi /etc/sysconfig/rngd

                  [root@orar12 ~]# service rngd start

                  Starting rngd:                                             [  OK  ]

                  [root@orar12 ~]# chkconfig rngd on

                  [root@orar12 ~]# cat /proc/sys/kernel/random/entropy_avail

                  2179

                  [root@orar12 ~]# cat /etc/sysconfig/rngd

                  # Add extra options here

                  EXTRAOPTIONS="-i -o /dev/random -r /dev/urandom -t 10 -W 2048"

                   

                   

                  I tride to abort adop prepare and rerun again.

                   

                   

                  Kind regards,

                  • 6. Re: Apply Patch for EBS R12.2.6
                    Beauty_and_dBest

                    Hi ALL,

                     

                    I aborted the prepare phase and bounce the apps tier. Then rerun the prepare phase.

                    But still staying long or stuck at:

                     

                    Submitting ADZDPATCH concurrent program.
                        Waiting for conflicting requests to complete.

                     

                    Why is it  waiting for conflicting requests? what is conflicting here?

                     

                    Is this normally long process?

                     

                    select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(541059) from dual;

                    $ FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE

                     

                    1. abort the patch cycle

                    2. run the above command

                    3. stop appn and db

                    and try to run prepare

                     

                     

                    Kind regards,

                    • 7. Re: Apply Patch for EBS R12.2.6
                      mdtaylor

                      Hi jc,

                       

                      If your running Online Patching in Progress request is hours old you may need to cancel that one and let the new one start.

                       

                      Cheers,

                      Michael

                      • 8. Re: Apply Patch for EBS R12.2.6
                        Beauty_and_dBest

                        Hi Michael,

                         

                        I done cancelling 3 times now, but still the issue persist

                         

                         

                        Kind regards,

                        • 9. Re: Apply Patch for EBS R12.2.6
                          mdtaylor

                          Hi jc,

                           

                          I would abandon this prepare phase process, shutdown the concurrent managers, run $FND_TOP/bin/cpadmin.sh, then restart the concurrent managers.

                           

                          Type adop --status to ensure the previous session was completely abandoned.

                           

                          adop phase=prepare again.

                           

                          Regards,

                          Michael

                          • 10. Re: Apply Patch for EBS R12.2.6
                            Beauty_and_dBest

                            Hi Michael,

                             

                            I have done that as well.

                             

                            1. Abort the adop run, (cntrl+c)

                            2.Then adop phase=abort.

                            3. Then adop phase=cleanup

                            4. Bounce apps and db.

                            5. Run again adop phase=prepare.

                             

                            But still its two pending process conflicts?

                            Adop1.GIF

                            Adop2.GIF

                            Adop3.GIF

                            Adop4.GIF

                            Adop5.GIF

                            Adop6.GIF

                             

                             

                            Please help....

                             

                             

                            Kind regards,

                            • 11. Re: Apply Patch for EBS R12.2.6
                              Beauty_and_dBest

                              Hi Michael,

                               

                              How so I attached APPLCSF log here?

                               

                              After long running and waiting the adop prepare expired with error below:

                               

                              Submitting ADZDPATCH concurrent program.

                                  Waiting for conflicting requests to complete.

                               

                                  [ERROR]     Failed to execute sql statement:

                              select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(542079) from dual

                                  [ERROR]     SQLPLUS error: buffer=

                              SQL*Plus: Release 10.1.0.5.0 - Production on Wed Nov 8 05:00:21 2017

                              Copyright (c) 1982, 2005, Oracle.  All rights reserved.

                              SQL> SQL> Connected.

                              SQL> select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(542079) from dual

                                     *

                              ERROR at line 1:

                              ORA-20008: Failed to submit concurrent program ADZDPATCH

                              ORA-06512: at "APPS.AD_ZD_ADOP", line 330

                              Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

                              With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

                               

                                  [UNEXPECTED]Error calling runConcurrentProgram subroutine.

                                  Stopping services on patch file system.

                                  Stopping admin server.

                                  Stopping node manager.

                                  [ERROR]     Prepare phase has failed.

                               

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

                               

                               

                               

                               

                              Kind regards,

                              • 12. Re: Apply Patch for EBS R12.2.6
                                Magnanimous

                                Solution 1 -

                                Shutdown application on all the node.

                                    Kill if any process running

                                    Startup the application – stop the internal manager

                                    All managers will be in Actual and Target shld be 0

                                    Again shutdown the application on all the node.

                                    Startup the application.

                                    Please see if any Patching Application req in running status if any cancel that.

                                  And run prepare again.

                                 

                                Solution 2 -

                                FNDLOAD apps/******* 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE

                                • 13. Re: Apply Patch for EBS R12.2.6
                                  Beauty_and_dBest

                                  Hi Magna,

                                   

                                  I already tried yesterday, both 1 and 2 above but no ano avail

                                   

                                  FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE

                                   

                                  It is strange that this command does not complete as well, or just froze:

                                   

                                  select AD_ZD_ADOP.WAIT_FOR_CP_TO_RUN(541059) from dual;

                                   

                                   

                                  Kind regards,

                                  • 14. Re: Apply Patch for EBS R12.2.6
                                    Magnanimous

                                    Is any other concurrent program getting completed ?

                                    1 2 Previous Next