My Oracle Support Banner

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 NOVEMBER 26, 2019

Applies to:

Oracle Applications DBA - Version 12.2.7 and later
Information in this document applies to any platform.
Palo Alto Firewall implemented on the instance.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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