1 2 Previous Next 16 Replies Latest reply on Apr 11, 2019 8:42 AM by Shaik

    Merge Patch Drivers

    Beauty_and_dBest

      Upgrading EBS 12.0.6 to 12.2.7  using CUP9

       

      EBS 12.0.6  to  12.2.7

      Database is already 12.1.0.2

      OL6

       

      Hi ALL,

       

      I have completed step 14.

       

       

      I am on step 15 of step above.

      Please confirm if below process I will run is correct.

       

       

      $ unzip p26924710_12.2.0_R12_LINUX.zip

      $ cd 26924710?

      $ adpatch preinstall=y

       

       

      $ cd $AU_TOP/patch/115/driver

      $ admrgpch -d . -preinstall -master u10124646.drv

       

       

      Kind regards,

      jc

        • 1. Re: Merge Patch Drivers
          Beauty_and_dBest

          Hi ALL,

           

          I run below commands, but it says I have no defined APPL_TOP?

           

          Please help....

           

          Kind regards,

          • 2. Re: Merge Patch Drivers
            VishnuVinnakota

            Hi,

             

              Regarding the original question,

             

               Make sure you install all the applicable ones from MOS DOC ID in pre-install mode.

             

               Then apply the merged Upgrade Driver along with the preinstall patches. The command you gave above is correct but ensure all pre-install patches are installed in pre-install mode.

             

               Regarding APPL_TOP Question: It is strange, I don't remember seeing such messages .. Let me check and revert.

             

               Which patch are trying to apply here? English driver? Can you give me pwd, ls of current directory.

             

            Thanks,

            Vishnu

            • 3. Re: Merge Patch Drivers
              Beauty_and_dBest

              Hi Dearest,

               

              The patch I am applying is merge patch step 15, after CUP9 patch in step 14.

              It is the one I followed in note > R12.1 and 12.2 Oracle E-Business Suite Preinstall Patches Report [Video] (Doc ID 1448102.2)

              Here is the pwd.

               

              This is the command that does is asking APPL_TOP?

               

              adpatch options=nocopyportion,nogenerateportion

               

              Please help...

               

              Kind regards,

              • 4. Re: Merge Patch Drivers
                VishnuVinnakota

                Hi

                 

                  Open a new terminal. Set only EBS 12.2.7 Environment using (Just to ensure previous env variables are not used any where)

                 

                   /mnt/data/u01/oracle/PPAPROD/fs1/EBSapp/appl/APPS<SID>_hostname.env

                 

                   Then run adpatch options=nocopyportion,nogenerateportion

                 

                   Choose all default options like any other adpatch, then give driver name "u10124646.drv"

                 

                   Let me know.

                 

                Thanks,

                Vishnu

                • 5. Re: Merge Patch Drivers
                  Beauty_and_dBest

                  Thanks dearest,

                   

                  I am confused with steps 14 and 15 below:

                   

                   

                  I understand 26924710 is CUP9 patch?

                   

                  Why is patch 10117518 also named in step 14 as  10117518_CUP9? are there two CUP9?

                   

                   

                  Please help...

                  • 6. Re: Merge Patch Drivers
                    Beauty_and_dBest

                    Hi Vishnu and ALL,

                     

                    I run > adpatch options=nocopyportion,nogenerateportion

                     

                    and it is now running....too many jobs to run

                     

                     

                    Kind regards,

                    • 7. Re: Merge Patch Drivers
                      Beauty_and_dBest

                      Hi Vishnu and ALL,

                       

                      The program took very long time

                      Please help how to speedup this process.

                      Am I doing the right process?

                       

                       

                      It has been almost 24 hrs runnong but still it is in 53,000+ jobs remaining

                       

                      I see also some failed jobs , but others are still running?

                       

                       

                      I did try to look in it, but there are no error, the logs are outdated, meaning they are not on the right location 

                      Today is April 8 here, but the logs are April 6, I already find other SID/log but nowhere to be found.

                       

                      Ok, I found it in another defined location:

                       

                      adworker01:

                       

                      sqlplus -s APPS/***** @/mnt/data/u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/mnt/data/u01/oracle/PPAPROD/fs1/EBSapps/appl/ap/12.0.0/patch/115/sql/apwhstsc.sql '

                       

                      Connected.

                      PL/SQL procedure successfully completed.

                      DECLARE

                      *

                      ERROR at line 1:

                      ORA-06502: PL/SQL: numeric or value error: character string buffer too small

                      ORA-06512: at line 2

                      Time when worker failed: Mon Apr 08 2019 09:38:01

                       

                      adworker011: 

                       

                      sqlplus -s APPS/***** @/mnt/data/u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/mnt/data/u01/oracle/PPAPROD/fs1/EBSapps/appl/iby/12.0.0/patch/115/sql/ibyhistg.sql '

                       

                      Connected.

                      PL/SQL procedure successfully completed.

                      DECLARE

                      *

                      ERROR at line 1:

                      ORA-06502: PL/SQL: numeric or value error: character string buffer too small

                      ORA-06512: at line 3

                      Time when worker failed: Mon Apr 08 2019 09:38:03

                       

                      adworker015:   

                       

                      sqlplus -s APPS/***** @/mnt/data/u01/oracle/PPAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/mnt/data/u01/oracle/PPAPROD/fs1/EBSapps/appl/ap/12.0.0/patch/115/sql/aphstrvn.sql '

                       

                      Connected.

                      PL/SQL procedure successfully completed.

                      DECLARE

                      *

                      ERROR at line 1:

                      ORA-06502: PL/SQL: numeric or value error: character string buffer too small

                      ORA-06512: at line 2

                      Time when worker failed: Mon Apr 08 2019 09:38:01

                       

                       

                       

                       

                      Please help...

                       

                       

                      Kind regards,

                      • 8. Re: Merge Patch Drivers
                        lmu

                        To make the patch apply faster:

                        Login into the database and check the parameters

                         

                        show parameter cpu

                        show parameter job

                        show parameter parallel

                        show parameter process

                         

                        How much memory does the box have?

                         

                        set the job_queue_processes=NumberofCPU

                        set parallel_max_servers=NumberofCPU

                         

                        Make sure enough processes are set to handle the jobs and parallel.

                         

                        If nothing is happening and it hangs, then bounce the database and increase the number of processes.

                        If you have the option to chose the number of workers = NumberOFCPU-2

                         

                        If you have a lot of memory and processors, you can unset both job_queue_processes and parallel_max_servers to let them take the default.  You will really need to increase the number of processes if you do this.  This is an experiment and you will have to try till you find the ideal number of processes.  If you hit it right, you will not be able to read the jobs as they fly by because it is going so fast. It is trial and error.

                        • 9. Re: Merge Patch Drivers
                          Beauty_and_dBest

                          Thanks Imu,

                           

                          Please help with my error:

                           

                          ERROR at line 1:

                          ORA-06502: PL/SQL: numeric or value error: character string buffer too small

                          ORA-06512: at line 2

                          Time when worker failed: Mon Apr 08 2019 09:38:01

                           

                           

                          Kind regards,

                          • 10. Re: Merge Patch Drivers
                            VishnuVinnakota

                            Hi,

                             

                              Whats the specific SQL or object its referring to. Attach the full worker logfile ASAP. It might need a small to change to the object to proceed if supported/recommended by Oracle.

                             

                            Thanks,

                            Vishnu

                            • 11. Re: Merge Patch Drivers
                              Beauty_and_dBest

                              Thanks Vishnu,

                               

                              How do I attach log file here in forum?

                               

                               

                              Kind regards,

                              • 12. Re: Merge Patch Drivers
                                mdtaylor

                                Hi jc,

                                 

                                It appears a lock issue may have hung up your upgrade.

                                 

                                R12.2 Upgrade Driver Patch Hangs (Doc ID 2397870.1)

                                 

                                Regards,

                                Michael

                                • 13. Re: Merge Patch Drivers
                                  Beauty_and_dBest

                                  Thanks Michael, Vishnu.

                                   

                                  My issue is closer to this note > Upgrading To 12.2.0, Driver 10124646.drv, Failed Job On Apwhstsc.sql And Aphstrvn.sql (Doc ID 2360151.1)

                                   

                                  SYMPTOMS

                                  Patch 10124646 fails on apwhstsc.sql

                                   

                                  ".. FAILED: file apwhstsc.sql on worker 12 for product ap username AP.
                                  Start time for file is: Thu Feb 01 2018 14:19:19
                                  sqlplus -s APPS/***** @/u01/oracle/app/prod/R12.2/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/oracle/app/prod/R12.2/fs1/EBSapps/appl/ap/12.0.0/patch/115/sql/apwhstsc.sql '
                                  Connected.
                                  PL/SQL procedure successfully completed.
                                  DECLARE
                                  *
                                  ERROR at line 1:
                                  ORA-06502: PL/SQL: numeric or value error: character string buffer too small
                                  ORA-06512: at line 2
                                  Time is: Thu Feb 01 2018 14:19:37
                                  FAILED: file aphstrvn.sql on worker 3 for product ap username AP.
                                  ..."

                                   

                                   

                                  CAUSE

                                  no formal cause of issue was confirmed

                                  SOLUTION

                                  Client was able to successfully run the job by manually passing the application short name 'AP'

                                   

                                  But there is no solution

                                   

                                   

                                  Or is it also a locking issue?

                                   

                                   

                                  Please help....

                                   

                                   

                                  Kind regards,

                                  • 14. Re: Merge Patch Drivers
                                    Shaik

                                    Hi JC

                                     

                                    increase the SGA size and retest the issue

                                     

                                    Regards

                                    Shaik

                                    1 2 Previous Next