Database validation failed while applying EBS R12.2 application patch : Oracle Apps DBA Training : Patches
This post is from our Oracle Apps DBA – R12 Training ( next batch starts on 8th Aug, 2015) where we cover installation, patching, cloning and other maintenance tasks. We also cover upgrade of Oracle E-Business Suite 12.2.0 to 12.2.4 to show how to apply patches and new patch process in Oracle Apps.
One of the trainee from previous batch encountered issue while applying EBS R12.2 application patches 19330775 and 20677045 where command used is highlighted below. The new utility to apply patch is adop (prior to 12.2 you apply patches using adpatch)
adop phase=apply patches=19330775,20677045 hotpatch=yes merge=yes
But patch was failing with error message like:
“adop is not able to detect any valid application tier nodes in ADOP_VALID_NODES table. Ensure autoconfig is run on all nodes.”
So we run autoconfig (there is dedciated topic on Autoconfig in our Oracle Apps/R12 DBA Training) on both Apps Tier & DB Tier by using below commands
- Stop the application tier and Database tier
- Autoconfig on Database tier
a) Source the Oracle Database env
b) cd $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME
c) sh adautocfg.sh
(Check the autoconfig logfiles for any error at $ORACLE_HOME/appsutil/log/$CONTEXT_NAME) - Autoconfig on Apps Tier
a) Please source the APPS environment
b) cd $ADMIN_SCRIPTS_HOME
c) sh adautocfg.sh
After running autoconfig on both the tiers, we again run the command to apply the patch. This time patch failed to execute some SQL statements and showing below error messages:
[Error] Failed to execute SQL statement :
declare
l_msg varchar2(4000);
begin
ad_zd_adop.adop_database_validations(l_msg);
dbms_output.put_line(l_msg);
end;
[Error] Error Message :
[UNEXPECTED] Error occurred while performing database validations
Solution:
To fix this issue, apply database patch 17693770 as per the instructions mentioned in Readme.
After applying 17693770 patch on database tier, issue got resolved and we were able to apply the patches successfully.
You can learn more from our expert team by registering to Oracle Apps DBA Training (next batch starts 8th Aug 2015- register early before 30th July to get 100 USD OFF)
K21 Technologies provide Full Money back Guarantee (If you are not happy after 2 sessions then you can ask for Full Money Back )
For further details and registration check
About the Author Nancy Kamboj
Oracle Consultant at K21 Technologies - Oracle Gold Partner specialising in Design, Implement, and Support.