5 Replies Latest reply on Feb 18, 2016 4:12 AM by Ramaraju

    R12.2 Online help patch Failed

    Ramaraju

      We are upgrading EBS 11i to R12.2.4. and following Oracle document Part No. E48834-15, we are at Chapter - 5, 'Applications Technology Tasks'.

      6.Install online help (recommended), pg no: 107. 

       

      While applying online help patch getting below error.

      $ adop phase=apply patchtop=$AU_TOP/patch/115 patches=driver:u10201000.drv options=nocopyportion,nogenerateportion,forceapply hotpatch=yes

       

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

       

      Validating credentials.

       

      Initializing.

        Run Edition context : /oracle_homes/archr12/fs2/inst/apps/ARCH_archapp1/appl/admin/ARCH_archapp1.xml

        Patch edition context: /oracle_homes/archr12/fs1/inst/apps/ARCH_archapp1/appl/admin/ARCH_archapp1.xml

      Reading driver file (up to 50000000 bytes).

        Patch file system free space: 65.66 GB

       

      Validating system setup.

        Node registry is valid.

       

      Checking for existing adop sessions.

        Continuing with existing session [Session ID: 17]

      [UNEXPECTED]Cannot use hotpatch while an existing patching cycle is still in progress.

        [UNEXPECTED]Unrecoverable error occurred. Exiting current adop session.

       

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

       

      Thanks,

      Ramaraju

        • 1. Re: R12.2 Online help patch Failed
          VishnuVinnakota

          You are trying to apply the patch using hotpatch option when an existing adop cycle is in progress. This is not allowed. Either you apply the online help patch on patch file system (Just use adop phase =apply patches=<patch number>) or You can complete/abort current patch cycle, then apply using hotpatch.

          • 2. Re: R12.2 Online help patch Failed
            Ramaraju

            Hi Vishnu,

            While running cleanup phase we are getting below error. I have already created another question about cleanup phase failed. 

            $ adop phase=cleanup

             

            Enter the APPS password:

            Enter the SYSTEM password:

            Enter the WLSADMIN password:


            Validating credentials.

             

            Initializing.

                Run Edition context  : /oracle_homes/archr12/fs2/inst/apps/ARCH_archapp1/appl/admin/ARCH_archapp1.xml

                Patch edition context: /oracle_homes/archr12/fs1/inst/apps/ARCH_archapp1/appl/admin/ARCH_archapp1.xml

                Patch file system free space: 65.63 GB

             

            Validating system setup.

                Node registry is valid.

             

            Checking for existing adop sessions.

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

            ADOP (C.Delta.7)

            Session ID: 17

            Node: archapp1

            Phase: cleanup

            Log: /oracle_homes/archr12/fs_ne/EBSapps/log/adop/17/adop_20160214_200956.log

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

            [WARNING]   As abort has been detected, a full cleanup will be performed.


            Processing cleanup actions in parallel.

                Log: /oracle_homes/archr12/fs_ne/EBSapps/log/adop/17/cleanup_20160214_200956/ARCH_archapp1/log/cleanup.log

             

            Generating report of queued DDL actions.

                Output: /oracle_homes/archr12/fs_ne/EBSapps/log/adop/17/cleanup_20160214_200956/ARCH_archapp1/adzdallddls.out

             

            Running cleanup in FULL mode.

                Log: @ADZDSHOWLOG.sql "2016/02/14 20:10:45"

                [ERROR]     Failed to execute SQL statement:

                   begin

                    execute immediate 'alter session set DDL_LOCK_TIMEOUT = 600';

                    ad_zd.cleanup('FULL');

                  end;

             

                [ERROR]     Error Message:

                [ERROR]     ORA-00907: missing right parenthesis

                [ERROR]     ORA-06512: at "APPS.AD_ZD", line 64

                [ERROR]     ORA-06512: at "APPS.AD_ZD_TABLE", line 28

                [ERROR]     ORA-06512: at "APPS.AD_ZD_TABLE", line 2460

                [ERROR]     ORA-06512: at "APPS.AD_ZD", line 912

                [ERROR]     ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

                [UNEXPECTED]Error occurred calling cleanup PL/SQL API.

                [UNEXPECTED]Cleanup 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)

             

            Thanks,

            Ramaraju

            • 3. Re: R12.2 Online help patch Failed
              Ramaraju

              adzdshowlog.out

              FileComment

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

              123657662 1:01:44 00:00:00 ad.bin.adop PROCEDURE [END] Generating DDL report

              123657662 1:01:44 00:00:00 ad.bin.adop EVENT Running cleanup in FULL mode.

              123657662 1:01:44 00:00:00 ad.bin.adop EVENT Log: @ADZDSHOWLOG.sql "2016/02/14 11:01:32"

              123657662 1:01:44 00:00:00 ad.plsql.ad_zd.cleanup PROCEDURE begin: FULL

              123657662 1:01:44 00:00:00 ad.plsql.ad_zd.cleanup EVENT Cleanup System

              123657662 1:01:44 00:00:00 ad.plsql.ad_zd.cleanup EVENT Drop Covered Objects

              123657662 1:01:44 00:00:00 ad.plsql.ad_zd.drop_covered_objects PROCEDURE begin

              123657662 1:01:44 00:00:00 ad.plsql.ad_zd.drop_covered_objects EVENT Report: @ADZDSHOWCOBJS

              123657662 1:01:44 00:00:00 ad.plsql.ad_zd.drop_covered_objects STATEMENT Drop covered objects, pass #1

              123657662 1:01:45 00:00:01 ad.plsql.ad_zd.drop_covered_objects EVENT Drop covered objects, pass #1 complete, dropped: 0, errors: 0

              123657662 1:01:45 00:00:00 ad.plsql.ad_zd.drop_covered_objects PROCEDURE end

              123657662 1:01:45 00:00:00 ad.plsql.ad_zd_parallel_exec.execute PROCEDURE [CLEANUP 1:1] begin

              123657662 1:01:45 00:00:00 ad.plsql.ad_zd_parallel_exec.execute PROCEDURE [CLEANUP 1:1] end

              123657662 1:01:45 00:00:00 ad.plsql.ad_zd_table.cleanup PROCEDURE begin: ALL.ALL, FULL

              123657662 1:01:45 00:00:00 ad.plsql.ad_zd_table.cleanup EVENT Cleanup crossedition triggers

              123657662 1:01:45 00:00:00 ad.plsql.ad_zd_table.cleanup EVENT Cleanup unused columns

              123657662 1:02:07 00:00:21 ad.plsql.ad_zd_table.cleanup STATEMENT SQL: alter table "XBSI"."XBSI_EBS_ITEM" set unused (Item Number)

              123657662 1:02:07 00:00:00 ad.plsql.ad_zd_table.cleanup ERROR ERROR: ORA-00907: missing right parenthesis, SQL: alter table "XBSI"."XBSI_EBS_ITEM" set unused (Item Number)

              123657662 1:02:07 00:00:00 ad.bin.adop ERROR Failed to execute SQL statement:

              begin

              execute immediate 'alter session set DDL_LOCK_TIMEOUT = 600';

              ad_zd.cleanup('FULL');

              end;

               

               

              123657662 1:02:07 00:00:00 ad.bin.adop ERROR Error Message:

              123657662 1:02:07 00:00:00 ad.bin.adop ERROR ORA-00907: missing right parenthesis

              123657662 1:02:07 00:00:00 ad.bin.adop ERROR ORA-06512: at "APPS.AD_ZD", line 64

              123657662 1:02:07 00:00:00 ad.bin.adop ERROR ORA-06512: at "APPS.AD_ZD_TABLE", line 28

              123657662 1:02:07 00:00:00 ad.bin.adop ERROR ORA-06512: at "APPS.AD_ZD_TABLE", line 2460

              123657662 1:02:07 00:00:00 ad.bin.adop ERROR ORA-06512: at "APPS.AD_ZD", line 912

              123657662 1:02:07 00:00:00 ad.bin.adop ERROR ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

              123657662 1:02:07 00:00:00 ad.bin.adop UNEXPECTED Error occurred calling cleanup PL/SQL API.

              123657662 1:02:07 00:00:00 ad.bin.adop UNEXPECTED Cleanup phase has failed.

              123657662 1:02:07 00:00:00 ad.bin.adop PROCEDURE [START] Updating session timestamps

              123657662 1:02:07 00:00:00 ad.bin.adop STATEMENT CLEANUP Phase END TIME: 14-02-2016 11:01:55

              123657662 1:02:07 00:00:00 ad.bin.adop PROCEDURE [END] Updating session timestamps

              123657662 1:02:07 00:00:00 ad.bin.adop PROCEDURE [START] Updating adop session status

              123657662 1:02:08 00:00:00 ad.bin.adop STATEMENT SQL statement : " update ad_adop_sessions

              set status='F'

              where adop_session_id = 17 and node_type='master'

               

               

              Dropping the custom object allowed the cleanup phase to complete.

               

               

              As per OSS suggetion, we have taken a backup of the custom object and dropped the object causing the issue.

              Now adop cleanup full mode completed successfully.

               

               

              Thanks,

              Ramaraju

              • 4. Re: R12.2 Online help patch Failed
                Narsi M-Oracle

                Hello Ramaraju,

                 

                Are you able to proceed now ?

                Do you still have issues w.r.t online help patch

                 

                Regards,

                Narsi

                • 5. Re: R12.2 Online help patch Failed
                  Ramaraju

                  Hi Narsi,

                  There is no issues with online help patch and we applied successfully.

                   

                  Thanks,

                  Ramaraju