Sunday, 19 July 2020

Error in adop session

ERROR:
======
    [ERROR]     Error occurred while executing <adpatch  workers=8    options=hotpatch    flags=autoskip   console=no interactive=no  defaultsfile=/mwdb-pl/ebsap/fs1/EBSapps/appl/admin/erpdev/adalldefaults.txt patchtop=/mwdb-pl/ebsap/fs_ne/EBSapps/patch/13543062 driver=u13543062.drv logfile=u13543062.log>
    [ERROR]     Please check the adpatch log files.
    [STATEMENT] Autopatch completed with errors/warnings. Please check logfiles
    [STATEMENT] SQL Statement:       update ad_adop_sessions
        set status='F'
         where adop_session_id = 2 and appltop_id = 2233 and node_name='bbhoeccdbdev'

    [STATEMENT] SQL Statement:         update ad_adop_sessions
        set apply_end_date=to_date('07-07-2020 12:25:38','DD-MM-YYYY HH24:MI:SS')
        where  adop_session_id=2

    [STATEMENT] APPLY Phase END TIME: 07-07-2020 12:25:38
    [STATEMENT] [START 2020/07/07 12:25:42] Unlocking sessions table
      [STATEMENT] SQL stmt: <       begin
          AD_ZD_ADOP.UNLOCK_SESSIONS_TABLE('bbhoeccdbdev',60,2);
       end;
[STATEMENT] Online patching tool cannot proceed when a previous patching session is incomplete
[STATEMENT] Please ensure no pending patching sessions exist before trying a new patch
[ERROR]     Unrecoverable error occured. Exiting the current session.
[STATEMENT] [START 2020/07/07 13:46:35] Unlocking sessions table
[STATEMENT] [END   2020/07/07 13:46:36] Unlocking sessions table
[STATEMENT] Log file: /adop_20200707_134510.log
[STATEMENT] [START 2020/07/07 13:46:41] Unlocking sessions table
[STATEMENT] [END   2020/07/07 13:46:43] Unlocking sessions table

CAUSE:
======
Node Name       Node Type       Phase       Status          Started                        Finished                       Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
bbhoeccdbdev    master          APPLY       FAILED          07-JUL-20 12:24:49 +03:00      07-JUL-20 12:25:38 +03:00      0:00:49
                                PREPARE     NOT APPLICABLE
                                CUTOVER     NOT APPLICABLE
Session was in incomplete in ad_adop_sessions tables.

SOLUTIONS:
==========

>> Check the adop cycle status.

SQL>select adop_session_id,status from ad_adop_sessions where status='F';

Output:
adop_session_id status
2 F

>> Update the status to completed.

SQL>update ad_adop_sessions set status='C' where status='F';

SQL>commit;

$adop -status
Node Name       Node Type       Phase       Status          Started                        Finished                       Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
bbhoeccdbdev    master          APPLY       ACTIVE          07-JUL-20 12:24:49 +03:00      07-JUL-20 12:25:38 +03:00      0:00:49

Now you can start the adop patch.

No comments:

Post a Comment

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...