Adop Prepare fails on DMZ node with cannot connect to database error.

Jul 29, 2019 10:31AM

We have EBS 12.2.4 running on Solaris 11.2. We have 3 application servers and 2 DMZ nodes.

Sometimes prepare fails on DMZ node with below error:

[PROCEDURE] [START 2019/07/29 03:43:53] Performing steps for CLONE from run file system to patch file system

[PROCEDURE] [START 2019/07/29 03:43:54] Preparing seed data tables

[STATEMENT] Sourcing Patch edition environment /u01/oracle/$SID/fs1/EBSapps/appl/APPS$CONTEXT_NAME.env

[PROCEDURE] [START 2019/07/29 03:44:59] Updating adop session status

[STATEMENT] SQL statement : " update ad_adop_sessions

set status='F'

where adop_session_id = 114 and appltop_id = 5217 and node_name='******'

"

[PROCEDURE] [END 2019/07/29 03:45:01] Updating adop session status

[PROCEDURE] [START 2019/07/29 03:45:01] Updating session timestamps

[STATEMENT] PREPARE Phase END TIME: 29-07-2019 03:45:01

Install, Upgrade, Clone, Patch - EBS (MOSC)