FS_CLONE Is Failed with Sync Error Running txkADOPValidation In Multi Node Environment (Doc ID 2305466.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

Oracle Applications DBA - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Online Patching - OP

When attempting to do fs_clone on multi nodes the following error occurs.

Running "txkADOPValidation" actions on node(s): xxxxxx4
Remote execution results xml output file: /u01/oracle/ERPPRD/fs_ne/EBSapps/log/adop/29/20170903_225956/fs_clone/validate/remote_execution_result_level3.xml
[ERROR] Node: "xxxxxx4" Status: "failed"
[ERROR] txkADOPValidation failed on Node: "xxxxxx4"
[STATEMENT] SQL Statment : " update ad_adop_session_patches
set status='F' ,end_date=to_date('','DD-MM-YYYY HH24:MI:SS')
where applied_file_system_base='/u01/oracle/ERPPRD/fs2'
and patch_file_system_base='/u01/oracle/ERPPRD/fs1'
and bug_number IN ('CLONE','CONFIG_CLONE')
and status NOT IN ('Y','X')
and appltop_id=1195
and node_name IN ('xxxxxx4')
"
[PROCEDURE] [START 2017/09/03 23:08:55] Checking if adop can continue with available nodes
[PROCEDURE] Calling: /u01/oracle/ERPPRD/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPEvalSrvStatus.pl
[EVENT] Log: /u01/oracle/ERPPRD/fs_ne/EBSapps/log/adop/29/20170903_225956/fs_clone/xxxxxx2
[PROCEDURE] [END 2017/09/03 23:09:14] Checking if adop can continue with available nodes
Continuing with processing on node(s): xxxxxx1,xxxxxx2

The issue can be reproduced at will with the following steps:
1. Log on to application tier
2. Source environment file
3. run adop phase=fs_clone

adop phase was failed, hence unable to complete patching cycle.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms