1 2 Previous Next 19 Replies Latest reply on Aug 29, 2017 7:55 AM by 2836832

    adop phase=prepare is required to apply patches

    2836832

      Hi All,

       

      I am upgrading from EBS 12.2.0 to 12.2.5. I am in the process of applying patch 19676458 in downtime mode.

      Some of the .sql get failed. like jtfDiagLogTD.sql, jtfDiagLogTV.sql.

      I can see the error in the logfile

       

      ORA-20099: E-Business Suite patch does not exist

       

      I checked I am not able to connect using any user except apps. I am getting the same error when I try to connect using any user

      sqlplus jtf/jtf

       

      I am getting the above error.

      When I start the adop session is prepare stage. I am able to connect using all users.

       

      Is it mandatory to start the adop session in prepare stage when to apply the patch in online mode or downtime mode.

       

      Please suggest.

       

      Thanks and Regards,

        • 1. Re: adop phase=prepare is required to apply patches
          #MVivek

          Can you please provide more details regarding the error ?

          Provide error log if possible.

           

          You should follow the path..

           

           

          Step#1: adop phase=fs_clone

           

          *** If multi-node structure then recommended to run fs_clone separately else you can run directly prepare phase. In prepare phase it will automatically call fs_clone.

           

          Step#2: adop phase=prepare

          Step#3: adop phase= apply patches=<patch_number>

          Step#4: adop phase=finalize

          Step#5: adop phase=cutover

          Step#6: adop phase=cleanup

           

          Note:

          Make sure, patch is available on all the nodes and must be unzipped in proper location.

           

           

          Check below discussion also, it may help you..

          ORA-20099: E-Business Suite Patch Edition does not exist

          If any answer is correct or helpful, please mark it. It will help others to identify the correct or helpful answer.

           

           

          Thanks

          Vivek

          • 2. Re: adop phase=prepare is required to apply patches
            2836832

            You did not get me. I am getting the error

            ORA-20099 : E-Business Suite patch does not exist

            ORA-06512: at line 29

             

            I checked I found that the users are not able to connect except apps user. apps user are able to connect.

            I am applying this patch in downtime mode.

             

            When I put the patch session in prepare all the users are able to connect.

             

            Is it mandatory to put the adop session in prepare mode if I am applying the patch in downtime mode.

             

            Thanks and Regards,

            • 3. Re: adop phase=prepare is required to apply patches
              Jibu-Oracle

              Hi,

               

              To apply patches outside a patching cycle used downtime mode.

              apply_mode=downtime applies the specified patches in downtime mode. When using this mode, you only run the apply phase

               

              Hope this helps

               

              Thanks

              Jibu

              • 4. Re: adop phase=prepare is required to apply patches
                2836832

                which means adop apply_mode=downtime does not require adop prepare phase to be run first.

                 

                I am getting an error while I am applying patch in downtime mode.

                 

                Thanks

                • 5. Re: adop phase=prepare is required to apply patches
                  Prashant Umap

                  Hello,

                  Can you upload the details patch error log.

                   

                  Prashant Umap

                  • 6. Re: adop phase=prepare is required to apply patches
                    Jibu-Oracle

                    It is not required unless until it is particularly mentioned in the Oracle document

                    • 7. Re: adop phase=prepare is required to apply patches
                      2836832

                      I checked the adop edtition, It was showing patch.

                      I changed using exec ad_zd.set_edition('RUN')

                      and try to abort the patches,

                       

                      I am getting an abort is not applicable here

                       

                      Output: /erppatches/ebs/12.2.5/fs_ne/EBSapps/log/adop/23/20170821_135147/adzdshowstatus.out
                      ===============================================================
                      Node Name       Node Type  Phase           Status          Started              Finished             Elapsed
                      --------------- ---------- --------------- --------------- -------------------- -------------------- ------------
                      crp             master     PREPARE         ACTIVE     2017/08/20 13:07:12  2017/08/20 13:50:18  0:43:06
                                                 APPLY           NOT STARTED
                                                 FINALIZE        NOT STARTED
                                                 CUTOVER
                                                 CLEANUP         NOT STARTED

                      Please suggest

                      • 8. Re: adop phase=prepare is required to apply patches
                        Prashant Umap

                        Hello,

                        Can you please confirm on the following exec - why you have changed the edition ?

                        It was showing patch. I changed using exec ad_zd.set_edition('RUN')

                         

                        - If you are applying any patch it should be in PATCH edition mode only, using patching cycle.

                         

                        Now - You are getting message - I am getting an abort is not applicable here - Bz edition is in RUN mode.

                        Try to change it to PATCH mode again and abort the patching cycle.

                         

                        Prashant Umap

                        • 9. Re: adop phase=prepare is required to apply patches
                          2836832

                          I am not applying any patch. When i run in patch,it  gives the same.

                          Abort is not applicable.

                           

                          I put it run edition when i starting the application. I have to start adop phase hence i change the edition to run

                          still the same issue.

                           

                          Please help.

                          • 10. Re: adop phase=prepare is required to apply patches
                            Prashant Umap

                            Thanks for the reply. So you mean you are not able to start the patching cycle like - adop pase=prepare.

                            Is there any change or this is first time you have opened the patch cycle.

                             

                            Please confirm.

                             

                            Prashant Umap

                            • 11. Re: adop phase=prepare is required to apply patches
                              Prashant Umap

                              Hello,

                              Can you do the following test on RUN and PATCH env -

                              appltest@test ~]$ . /d01oracle/R122/EBSapps.env run
                              [appltest@test]$ sqlplus apps/<appspwd>
                              SQL*Plus: Release 10.1.0.5.0 - Production on Tue Oct 22 11:28:31 2013
                              Copyright (c) 1982, 2005, Oracle. All rights reserved.

                              Connected to:
                              Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
                              With the Partitioning, OLAP, Data Mining and Real Application Testing options
                              SQL> select ad_zd.get_edition_type from dual;
                              GET_EDITION_TYPE
                              --------------------------------------------------------------------------------
                              RUN

                               

                               

                              appltest@test ~]$ . /d01oracle/R122/EBSapps.env patch
                              [appltest@test]$ sqlplus apps/<appspwd>

                               

                              Also check the following -

                              For more info - https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=qunqalihv_102&_afrLoop=225279656404164

                               

                              Please share the result.

                              • 12. Re: adop phase=prepare is required to apply patches
                                2836832

                                $ . ./EBSapps.env run

                                  E-Business Suite Environment Information
                                  ----------------------------------------
                                  RUN File System           : /erppatches/ebs/12.2.5/fs1/EBSapps/appl
                                  PATCH File System         : /erppatches/ebs/12.2.5/fs2/EBSapps/appl
                                  Non-Editioned File System : /erppatches/ebs/12.2.5/fs_ne

                                DB Host: crp.manafth.local  Service/SID: MANDEV

                                Sourcing the RUN File System ...

                                [appldev@crp 12.2.5]$ sqlplus apps

                                SQL*Plus: Release 10.1.0.5.0 - Production on Tue Aug 22 08:14:04 2017

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

                                Enter password:

                                Connected to:
                                Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
                                With the Partitioning, OLAP, Data Mining and Real Application Testing options

                                SQL> select ad_zd.get_edition_type from dual;

                                GET_EDITION_TYPE
                                --------------------------------------------------------------------------------
                                PATCH

                                SQL> @/erppatches/ebs/12.2.5/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWED.sql
                                =========================================================================
                                =                             Editions
                                =========================================================================

                                Edition Name    Type     Status   Current?
                                --------------- -------- -------- --------
                                ORA$BASE                 ACTIVE
                                V_20170807_1428          ACTIVE
                                V_20170809_0814          ACTIVE
                                V_20170809_1212 OLD      ACTIVE
                                V_20170815_1140 RUN      ACTIVE
                                V_20170820_1348 PATCH    ACTIVE   CURRENT

                                Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
                                With the Partitioning, OLAP, Data Mining and Real Application Testing options
                                [appldev@crp 12.2.5]$ . ./EBSapps.env patch

                                  E-Business Suite Environment Information
                                  ----------------------------------------
                                  RUN File System           : /erppatches/ebs/12.2.5/fs1/EBSapps/appl
                                  PATCH File System         : /erppatches/ebs/12.2.5/fs2/EBSapps/appl
                                  Non-Editioned File System : /erppatches/ebs/12.2.5/fs_ne

                                DB Host: crp.manafth.local  Service/SID: MANDEV

                                Sourcing the PATCH File System ...

                                [appldev@crp 12.2.5]$ sqlplus apps

                                SQL*Plus: Release 10.1.0.5.0 - Production on Tue Aug 22 08:17:12 2017

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

                                Enter password:

                                Connected to:
                                Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
                                With the Partitioning, OLAP, Data Mining and Real Application Testing options

                                SQL> @/erppatches/ebs/12.2.5/fs2/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWED.sql
                                =========================================================================
                                =                             Editions
                                =========================================================================

                                Edition Name    Type     Status   Current?
                                --------------- -------- -------- --------
                                ORA$BASE                 ACTIVE
                                V_20170807_1428          ACTIVE
                                V_20170809_0814          ACTIVE
                                V_20170809_1212 OLD      ACTIVE
                                V_20170815_1140 RUN      ACTIVE
                                V_20170820_1348 PATCH    ACTIVE   CURRENT

                                Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
                                With the Partitioning, OLAP, Data Mining and Real Application Testing options

                                • 13. Re: adop phase=prepare is required to apply patches
                                  Prashant Umap

                                  1. When you run -
                                  . ./EBSapps.env run

                                  It should be
                                  - GET_EDITION_TYPE=RUN
                                  - sqlplus also connected.

                                  2. When you run -
                                  . ./EBSapps.env patch

                                  It should be
                                  - GET_EDITION_TYPE=PATCH
                                  - Sqlplus error -
                                  ERROR:
                                  ORA-00604: error occurred at recursive SQL level 1
                                  ORA-20099: E-Business Suite Patch Edition does not exist.
                                  ORA-06512: at line 29

                                  This is normal behavior.

                                  Now in your scenario - RUN file system showing edition_type=patch and PATCH file system showing edition_type=RUN
                                  Which is wrong and also in both the scenario you are able to connect to sqlplus.

                                   

                                  Please check the following -

                                  1. AD Version.

                                  2. Please check the patch - Patch 21112881: Bug 21112881 - 1OFF:20989525:TXKPREPAREACTABLES.PL TRIES TO CONNECT DB FROM PATCH FS AND FAILS.

                                  3. Also in previous update you have changed the edition manually - if yes - Please revert back.

                                   

                                  Prashant Umap

                                  • 14. Re: adop phase=prepare is required to apply patches
                                    Jibu-Oracle

                                    You could provide adop -status -detail to understand current status

                                    Have you applied a patch in downtime mode, after adop prepare ?

                                    1 2 Previous Next