1 2 Previous Next 20 Replies Latest reply on Jun 1, 2015 3:46 PM by Bashar.

    adop problem: pending session after abort

    Luis Brieva

      Hello. I am trying to use adop to apply a patch. But i have 2 previous session that are in status "N" and i can't do a cleanup. I did already an abort (adop phase=abort) to the actual session.

       

      [applmgr@ebs122 ~]$ adop phase=cleanup cleanup_mode=full

       

       

      Enter the APPS password:

      Enter the SYSTEM password:

      Enter the WLSADMIN password:

       

      Please wait. Validating credentials...

       

      Enter the RUN file system context file name [/d01/oracle/VIS/fs1/inst/apps/VIS_ebs122/appl/admin/VIS_ebs122.xml]:

      Enter the PATCH file system context file name [/d01/oracle/VIS/fs2/inst/apps/VIS_ebs122/appl/admin/VIS_ebs122.xml]:

       

      [STATEMENT] [END   2015/05/21 11:07:24] Performing verification of parameters

      [STATEMENT] [START 2015/05/21 11:07:25] Checking for the required ENV setup

      [STATEMENT] [END   2015/05/21 11:07:25] Checking for the required ENV setup

       

       

      ************* Start of  session *************

      version: 12.2.0

      started at: Thu May 21 2015 11:07:26

       

       

      APPL_TOP is set to /d01/oracle/VIS/fs1/EBSapps/appl

      [STATEMENT] [START 2015/05/21 11:07:27] Determining admin node

      [STATEMENT] [END   2015/05/21 11:07:29] Determining admin node

      [STATEMENT] [START 2015/05/21 11:07:32] Acquiring lock on sessions table

      [STATEMENT] [END   2015/05/21 11:07:33] Acquiring lock on sessions table

      [STATEMENT] [START 2015/05/21 11:07:33] Checking for any pending sessions

      [STATEMENT] Cleanup is not done in earlier session

      [STATEMENT] [START 2015/05/21 11:07:42] Unlocking sessions table

      [STATEMENT] [END   2015/05/21 11:07:43] Unlocking sessions table

      [STATEMENT] [START 2015/05/21 11:07:43] adzdoptl.pl run

        [STATEMENT] Session ID: 5

        [STATEMENT] Phase: cleanup

        [STATEMENT] Log file: /d01/oracle/VIS/fs_ne/EBSapps/log/adop/5/adop_20150521_110642.log

        [ERROR]     Error: Pending session of prepare/apply/cutover exists

        [ERROR]     Hint: Before trying cleanup complete the pending session

        [STATEMENT] [START 2015/05/21 11:07:57] Unlocking sessions table

        [STATEMENT] [END   2015/05/21 11:07:58] Unlocking sessions table

        [STATEMENT] Log file: /d01/oracle/VIS/fs_ne/EBSapps/log/adop/5/adop_20150521_110642.log

       

       

      adop exiting with status = 2 (Fail)

      [applmgr@ebs122 ~]$

       

       

       

       

      This are the previous session:

       

      [applmgr@ebs122 ~]$ sqlplus

       

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Thu May 21 11:04:29 2015

       

       

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

       

       

      Enter user-name: apps

      Enter password:

       

       

      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> set pagesize 200;

      SQL> set linesize 160;

      SQL> column adop_session_id format 999999999999;

      SQL> column bug_number format a15;

      SQL> column status format a15;

      SQL> column applied_file_system_base format a23;

      SQL> column patch_file_system_base format a23;

      SQL> column adpatch_options format a15;

      column node_name format a15;

      SQL> SQL> column end_date format a15;

      SQL> column clone_status format a15;

      SQL>

      SQL> select ADOP_SESSION_ID, BUG_NUMBER, STATUS, APPLIED_FILE_SYSTEM_BASE, PATCH_FILE_SYSTEM_BASE, ADPATCH_OPTIONS, NODE_NAME, END_DATE, CLONE_STATUS

        2  from ad_adop_session_patches

      order by end_date desc;  3

       

       

      ADOP_SESSION_ID BUG_NUMBER      STATUS          APPLIED_FILE_SYSTEM_BAS PATCH_FILE_SYSTEM_BASE  ADPATCH_OPTIONS NODE_NAME       END_DATE        CLONE_STATUS

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

                    2 CONFIG_CLONE    N               /d01/oracle/VIS/fs1     /d01/oracle/VIS/fs2                     ebs122                          NOT-STARTED

                    4 CLONE           N               /d01/oracle/VIS/fs1     /d01/oracle/VIS/fs2                     ebs122                          BACKUP-FMW-HOME

       

       

      How can I perform a cleanup or an abort for a prevoius session??

       

      Thanks!.

        • 1. Re: adop problem: pending session after abort
          Kj - Kiran Jadhav

          Can you post the output of current -

          $ adop -status

          And status of session id - 2 and 4

          $ adop -status <session id>

           

          Regards,

          Kiran

          • 2. Re: adop problem: pending session after abort
            Luis Brieva

            Hi Kj - Kiran Jadhav

             

            [applmgr@ebs122 ~]$ adop -status

             

             

            Enter the APPS username: apps

            Enter the APPS password:

             

            Current Patching Session ID: 5

             

             

            Node Name       Node Type       Phase       Status          Started

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

            ebs122          master          PREPARE     SESSION ABORTED 21-MAY-15 09:40:46 -

                                            APPLY       SESSION ABORTED

                                            CUTOVER     SESSION ABORTED

                                            CLEANUP     SESSION ABORTED

             

            File System Synchronization Used in this Patching Cycle: None

            For more information, see the full ADOP Status Report.

            Generating full ADOP Status Report at location: /d01/oracle/VIS/fs_ne/EBSapps/lo

            Please wait...

            Done...!

            adop exiting with status = 0 (Success)

            [applmgr@ebs122 ~]$

             

             

            [applmgr@ebs122 ~]$ adop -status 2

             

            Enter the APPS username: apps

            Enter the APPS password:

             

            Current Patching Session ID: 2

             

            Node Name       Node Type       Phase       Status          Started                        Finished                       Elapsed

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

            ebs122          master          PREPARE     SESSION ABORTED 19-MAY-15 11:39:33 -05:00      19-MAY-15 11:43:24 -05:00      0:03:51

                                            APPLY       SESSION ABORTED

                                            CUTOVER     SESSION ABORTED

                                            CLEANUP     SESSION ABORTED

             

            File System Synchronization Used in this Patching Cycle: None

             

            For more information, see the full ADOP Status Report.

            Generating full ADOP Status Report at location: /d01/oracle/VIS/fs_ne/EBSapps/log/status_20150521_141025/adzdshowstatus.out

            Please wait...

            Done...!

            adop exiting with status = 0 (Success)

            [applmgr@ebs122 ~]$

             

            [applmgr@ebs122 ~]$ adop -status 4

            Enter the APPS username: apps

            Enter the APPS password:

             

            declare

            *

            ERROR at line 1:

            ORA-20001: No such SESSION_ID found.  Please recheck SESSION_ID.

            ORA-06512: at line 10

            adop exiting with status = 1 (Fail)

            [applmgr@ebs122 ~]$

             

            I don't know why session # 4 is not found.

             

             

            Thanks for your help.

            • 3. Re: adop problem: pending session after abort
              Luis Brieva

              Hi, somebody, any ideas? Thanks!.

              • 4. Re: adop problem: pending session after abort
                Kj - Kiran Jadhav

                Do you see any more details on the error  in Log file: /d01/oracle/VIS/fs_ne/EBSapps/log/adop/5/adop_20150521_110642.log

                • 5. Re: Re: adop problem: pending session after abort
                  Luis Brieva

                  Hi. I attached two logs:

                   

                  /d01/oracle/VIS/fs_ne/EBSapps/log/adop/5/adop_20150521_110642.log



                  and:


                  /d01/oracle/VIS/fs_ne/EBSapps/log/status_20150521_141025/adzdshowstatus.out


                  Thanks!

                  • 6. Re: adop problem: pending session after abort
                    Kj - Kiran Jadhav

                    I am not sure on the issue but trying to analyze.

                    Can you provide the output of below query as well -

                     

                    SELECT   adop_session_id, prepare_status, apply_status, finalize_status,

                             cutover_status, cleanup_status, abort_status, status, abandon_flag,

                             node_name

                        FROM ad_adop_sessions

                    ORDER BY adop_session_id;

                     

                    Where status:

                      Y denotes that the phase is done

                      N denotes that the phase has not been completed

                      X denotes that the phase is not applicable

                      R denotes that the phase is running (in progress)

                      F denotes that the phase has failed

                      P (is applicable only to APPLY phase) denotes at least one patch is already applied for the session id

                      C denotes that the status of this ADOP session has completed

                    • 7. Re: adop problem: pending session after abort
                      Luis Brieva

                      Hi Kj - Kiran Jadhav

                       

                      This is the output:

                       

                       

                       

                      [applmgr@ebs122 ~]$ sqlplus

                       

                       

                      SQL*Plus: Release 10.1.0.5.0 - Production on Fri May 22 11:16:40 2015

                       

                       

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

                       

                       

                      Enter user-name: apps

                      Enter password:

                       

                       

                      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   adop_session_id, prepare_status, apply_status, finalize_status,

                               cutover_status, cleanup_status, abort_status, status, abandon_flag,

                               node_name

                          FROM ad_adop_sessions

                      ORDER BY adop_session_id;  2    3    4    5

                       

                       

                      ADOP_SESSION_ID P A F C C A S ABANDON_FLAG NODE_NAME

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

                                    2 R N R N Y Y C              ebs122

                                    3 R N N N Y Y C              ebs122

                                    5 R N N N N Y C              ebs122

                       

                       

                      SQL>

                       

                       

                       

                      The thing is that I saw another session that they are aborted but they still have something pending as shown in the initial post.

                      • 8. Re: adop problem: pending session after abort
                        Kj - Kiran Jadhav

                        Luis Brieva wrote:

                         

                        This is the output:

                         

                         

                        SQL> SELECT   adop_session_id, prepare_status, apply_status, finalize_status,

                                 cutover_status, cleanup_status, abort_status, status, abandon_flag,

                                 node_name

                            FROM ad_adop_sessions

                        ORDER BY adop_session_id;  2    3    4    5

                         

                         

                        ADOP_SESSION_ID P A F C C A S ABANDON_FLAG NODE_NAME

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

                                      2 R N R N Y Y C              ebs122

                                      3 R N N N Y Y C              ebs122

                                     5 R N N N N Y C              ebs122

                         

                         

                        SQL>

                         

                        The thing is that I saw another session that they are aborted but they still have something pending as shown in the initial post.

                         

                        I think the problem is with session id : 5 which shows Prepare status "R" (i.e. phase is running).

                        Is your session interrupted during adop ?

                         

                        As per Log - adop_20150521_110642.log:

                        Checking for session id = 5 for prepare_status in (N,R)

                        [STATEMENT] SQL Output: <1>.

                          [STATEMENT] SQL Statement: <    select count(1)

                              from  ad_adop_sessions

                              where  adop_session_id=5 and (prepare_status in ('N','R'))

                        >.

                          [STATEMENT] SQL Output: <1>.

                          [ERROR]     Error: Pending session of prepare/apply/cutover exists

                          [ERROR]     Hint: Before trying cleanup complete the pending session

                          [STATEMENT] [START 2015/05/21 11:07:57] Unlocking sessions table

                         

                        You can give a try by updating the prepare_status to "Y" for session id = 5 then run cleanup phase.

                         

                        Regards,

                        Kiran

                        • 9. Re: adop problem: pending session after abort
                          Luis Brieva

                          Hi Kj - Kiran Jadhav

                           

                          I think the problem is with session id : 5 which shows Prepare status "R" (i.e. phase is running).

                          Is your session interrupted during adop ?

                           

                          Yes It is interrupting, thats why I want to abort all of the session and make a full cleanup to all of that previous session and start again with the prepare fase.

                           

                           

                          You can give a try by updating the prepare_status to "Y" for session id = 5 then run cleanup phase.

                           

                           

                          How can I update the preparing status to "Y" ??

                           

                          Thanks.

                           

                          Luis

                          • 10. Re: adop problem: pending session after abort
                            Kj - Kiran Jadhav

                            Since your adop sessions are interrupted, please try to perform below steps:

                             

                             

                            1. Take backup of ad_adop_sessions table then update as below:

                             

                            For:

                             

                            ADOP_SESSION_ID P A F C C A S ABANDON_FLAG NODE_NAME

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

                                          2 R N R N Y Y C              ebs122

                                          3 R N N N Y Y C              ebs122

                                          5 R N N N N Y C              ebs122

                             

                            Update as below:

                             

                            Connect as APPS:

                             

                            update ad_adop_sessions

                            set PREPARE_STATUS='Y'

                            where PREPARE_STATUS='R'

                            AND ADOP_SESSION_ID in ('2','3','5');

                             

                            update ad_adop_sessions

                            set FINALIZE_STATUS='Y'

                            where FINALIZE_STATUS='R'

                            AND ADOP_SESSION_ID in ('2');

                             

                            Commit;

                             

                            Verify the status with below query:

                             

                            SELECT   adop_session_id, prepare_status, apply_status, finalize_status,

                                     cutover_status, cleanup_status, abort_status, status, abandon_flag,

                                     node_name

                                FROM ad_adop_sessions

                            ORDER BY adop_session_id;

                             

                            2. Perform cleanup :

                             

                            $ adop phase=cleanup cleanup_mode=full

                             

                            3. Source the RUN filesystem and run autoconfig.

                             

                            $ADMIN_SCRIPTS_HOME/adautocfg.sh

                             

                            4. Perform fs_clone phase from RUN filesystem

                             

                            $ adop phase=fs_clone

                             

                            5.Then Start new adop patching cycle by running prepare phase.

                             

                            $ adop phase=prepare

                             

                            Make sure your session not getting interrupted.

                             

                             

                            Regards,

                            Kiran

                            1 person found this helpful
                            • 11. Re: adop problem: pending session after abort
                              Luis Brieva

                              Hi Kj - Kiran Jadhav

                              Finally I made a cleanup... great!.

                               

                              But now when I am performing adop phase=fs_clone I got an error:

                               

                              ERRORMSG: Directory /d01/oracle/VIS/fs2/EBSapps/appl does not exist.

                               

                              I found that this directory does not exists! I don't know why It does not exist any more.

                              This directory It does exists: "/d01/oracle/VIS/fs2/EBSapps/"

                              Under EBSapps only exists two directories: "comn" and "10.1.2", take a look:

                               

                              [applmgr@ebs122 EBSapps]$ pwd

                              /d01/oracle/VIS/fs2/EBSapps

                              [applmgr@ebs122 EBSapps]$ ls

                              10.1.2  comn

                              [applmgr@ebs122 EBSapps]$

                               

                              What could happend with "appl"? maybe the cleanup could erase that folder?

                               

                              Thanks!

                              • 12. Re: adop problem: pending session after abort
                                Bashar.

                                Hi,

                                 

                                How was the patch file system created (fs2)?

                                 

                                Regards,

                                Bashar

                                • 13. Re: adop problem: pending session after abort
                                  Luis Brieva

                                  Yes Bashar. I have under: /d01/oracle/VIS

                                   

                                  fs1 (run edition)

                                  fs2 (patch)

                                  fs_ne

                                   

                                  Thanks.

                                  • 14. Re: adop problem: pending session after abort
                                    Bashar.

                                    Hi,

                                     

                                    I asked how it was created.

                                    Is this a cloned environment?

                                    If yes then did you follow the cloning document?

                                     

                                    Regards,

                                    Bashar

                                    1 2 Previous Next