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
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 :
[Error] Error Message :
[UNEXPECTED] Error occurred while performing database validations
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)
For further details and registration check
Oracle Consultant at K21 Technologies - Oracle Gold Partner specialising in Design, Implement, and Support.
SQLNET.INBOUND_CONNECT_TIMEOUT Parameter has been changed 60 to 0 in sqlnet.ora file.
In my case autonconfig sucessfull and mention patch alreday applied on my DB.Reply