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:
Oracle Applications DBA - Version 12.2.7 and laterInformation 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 |