7 Replies Latest reply on Jul 30, 2018 2:12 AM by Beauty_and_dBest

    Patch p25178222_R12.AD.C_R12_LINUX

    Beauty_and_dBest

      EBS 12.2.6

      12c

      OL6

       

      Hi ALL,

       

      I am apply above patch,  but I got error:

      I already run adgrants.sql on dbTier.

       

      AutoPatch error:

      Please apply adgrants.sql file in database tier before applying this patch

       

      You should check the file

      /u03/appv1226/V1226/fs_ne/EBSapps/log/adop/42/20180727_235916/apply/f91163/25178222/log/u25178222.log

       

      for errors.

       

          [UNEXPECTED]Error occurred executing "adpatch  abandon=no restart=yes workers=4      console=no interactive=no  defaultsfile=/u03/appv1226/V1226/fs2/EBSapps/appl/admin/V1226_patch/adalldefaults.txt patchtop=/u01/PATCH/25178222 driver=u25178222.drv logfile=u25178222.log"

          [UNEXPECTED]Refer to the log files for more information.

          [UNEXPECTED]Apply phase has failed.

       

      Please help...

       

      Kind regards,

      jc

        • 1. Re: Patch p25178222_R12.AD.C_R12_LINUX
          mdtaylor

          Hi jc,

           

          Please open the patch readme and review the following section for instructions on running adgrants.sql on the database server which is a mandatory prerequisite action before applying this patch.

           

          Instructions for running AD Grants [required]

           

          You should also be installing AD/TXK Delta 10 for any 12.2 installations.  You are asking about AD.C.Delta 9.

           

          Patchset R12.AD.C.delta.9 R12.AD.C.DELTA.9

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

           

          Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

           

          Regards,

          Michael

          • 2. Re: Patch p25178222_R12.AD.C_R12_LINUX
            Beauty_and_dBest

            Hi Michael,

             

            Yes I read that already, ang had run adgrants.sql

             

            R12.AD.C.DELTA.9  is the pre-requsites of AD/TXK patches.

            So I am applying it first, but it is the one having errors

             

             

            Please help...

             

            Kind regards,

            • 3. Re: Patch p25178222_R12.AD.C_R12_LINUX
              mdtaylor

              Hi jc,

               

              In which document do you find R12.AD.C.DELTA.9 is a prerequisite for R12.AD.C.DELTA.10?  You can directly apply R12.AD.C.DELTA.10 to 12.2.0 as the first AD patch.

               

              Regards,

              Michael

              • 4. Re: Patch p25178222_R12.AD.C_R12_LINUX
                Beauty_and_dBest

                Thanks Michael,

                 

                Ok I will apply R12.AD.C.DELTA.10.

                • 5. Re: Patch p25178222_R12.AD.C_R12_LINUX
                  Beauty_and_dBest

                  Hi Michael,

                   

                   

                  I am applying patch using adop, but I got error in cut-over:

                   

                  Performing database cutover.

                      Log: @ADZDSHOWLOG.sql "2018/07/28 01:00:53"

                   

                  Reference of statement-handler is not-valid.

                   

                  DB-Handle Error Code: 28

                  DB-Handle Error Message: ORA-00028: your session has been killed (DBD ERROR: OCIStmtExecute/Describe)

                  Reference of statement-handler is not valid, attempting database reconnect

                  getConnNExec: Getting db-handler

                  getConnNExec: reattempting sql statement

                  getConnNExec: Returning 0E0

                  Statement Handler Error Code: 20001

                  Statement Handler Error Message: ORA-20001: Error while calling ad_zd_log.message(ad.bin.adop,WARNING,).ORA-01400: cannot insert NULL into ("APPLSYS"."AD_ZD_LOGS"."MESSAGE_TEXT")

                  ORA-06512: at line 6 (DBD ERROR: OCIStmtExecute)

                  Reference of statement-handler is valid, not attempting database reconnect.

                  Failed to execute SQL statement:

                                   declare

                                   begin

                                      ad_zd_log.message('ad.bin.adop','WARNING','','trnsrvr');

                                   exception

                                      when others then

                                         raise_application_error(-20001,'Error while calling ad_zd_log.message(ad.bin.adop,WARNING,).' || sqlerrm);

                                   end;

                   

                  Error Message:

                  ORA-20001: Error while calling ad_zd_log.message(ad.bin.adop,WARNING,).ORA-01400: cannot insert NULL into ("APPLSYS"."AD_ZD_LOGS"."MESSAGE_TEXT")

                  ORA-06512: at line 6 (DBD ERROR: OCIStmtExecute)

                  Error calling ad_zd_log.message to log messages to the database.

                  Please check if database is up

                   

                   

                  I can connect sqlplus apps/apps from appsTier.

                   

                   

                  Please help...

                   

                  Kind regards,

                  • 6. Re: Patch p25178222_R12.AD.C_R12_LINUX
                    mdtaylor

                    Hi jc,

                     

                    Please review the ulimits, especially around nproc.  The ORA-00028 indicates a process starvation issues.

                     

                    Internal Concurrent Manager Startup has Terminated With Status 139 Database Error ORA-28 : opiodr aborting process unknown ospid (Doc ID 1577696.1)

                    Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

                     

                    Regards,

                    Michael

                    • 7. Re: Patch p25178222_R12.AD.C_R12_LINUX
                      Beauty_and_dBest

                      Thanks, 

                       

                      I will check ....brb