While Applying Patch 26834480 (R12.AD.C.Delta.11) Adop Fails With Error ORA-03114: not connected to ORACLE (Doc ID 2613090.1)

Last updated on MAY 19, 2024

Applies to:

Symptoms

On : 12.2.7 version, Patch Application Issues: ORA-03114: not connected to ORACLE when attempting to apply AD Delta 11 patch for file ADZDMVB.pls


ERROR
-----------------------
See the following error:

Filename =u_ad_1172629585.log

Time is: Tue Oct 22 2019 10:06:57

FAILED: file ADZDMVB.pls on worker 1 for product ad username APPLSYS.

Time is: Tue Oct 22 2019 10:06:57

ATTENTION: All workers either have failed or are waiting:

FAILED: file ADZDMVB.pls on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

FAILED: file ADZDMVB.pls on worker 1.

******adwork001.log *************

sqlplus -s APPS/***** @/data/oracle/ASCPATCH/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/data/oracle/ASCPATCH/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDMVB.pls &un_apps'
Connected.

PL/SQL procedure successfully completed.

CREATE OR REPLACE PACKAGE BODY AD_ZD_MVIEW AS
*
ERROR at line 1:
ORA-12152: TNS:unable to send break message

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

ERROR:
ORA-03114: not connected to ORACLE

...
...
...

ERROR:
ORA-03114: not connected to ORACLE

SP2-0359: memory exhausted

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. adop phase = apply

BUSINESS IMPACT
-----------------------

Due to this issue, users cannot continue with applying AD patch and upgrade to latest AD Delta 11.

Changes

 Customer applying AD delta 11 Patch

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.