Oracle Technical Track

Oracle EBS R12.2: Restarting online patching enablement patch

Vasu Balla
by Vasu Balla
1 min read
Sep 3, 2015

If you are in process of upgrading to Oracle E-Business Suite 12.2.4, you would have went though this critical phase in the upgrade which is to apply the Online Patching Enablement patch: 13543062:R12.AD.C. It's very common to run into errors with this patch in the first try and have to apply it couple of times, in order to get all issues fixed and get online patching enabled. The recommended command to apply this patch is: adpatch options=hotpatch,forceapply When the time comes to re-apply the patch to fix problems, if you use the same command to reapply the patch, you will notice that the patch completed normal with in no time and nothing happens in the back end. This is because of a specific feature from Adpatch. ADPATCH by default skips jobs that are marked as "run successfully" in previous runs or as part of another patch. So we have to force it re-run those jobs. This can be done by using command below: adpatch options=hotpatch,forceapply,nocheckfile Sometimes we run into cases where Online Patching Enablement patch completes as "normal" and the actual online patching feature gets enabled where we see that a schema or two have failed to enable the EBR feature. As soon as APPS schema gets EBR enabled by this patch, even though other custom schemas failed to get enabled, Adpatch gets disabled and we are forced to adop utility from then on. In this scenario, we can still re-apply the Online Patch Enablement using Adpatch after setting the environment variable below: export ENABLE_ADPATCH=YES I see that online patching enablement exercise for every customer is a unique experience. Do post your experiences with this online patching enablement patch in the comments section. I'd love to hear your story!

Discover more about Pythian’s expertise in the world of Oracle.
Previous story
← Amazon RDS migration tool
Next story
Azure cli on Mac →
Slow query to V$ views after DBRU Patching
Oracle

Slow query to V$ views after DBRU Patching

Apr 3, 2023 3 min read
Oracle Database 12c Patching: DBMS_QOPATCH, OPATCH_XML_INV, and datapatch
Oracle

Oracle Database 12c Patching: DBMS_QOPATCH, OPATCH_XML_INV, and datapatch

Jan 20, 2015 12 min read
Make Database Security Patching Consistent
Oracle

Make Database Security Patching Consistent

Mar 4, 2021 4 min read

Get Email Notifications

No Comments Yet

Let us know what you think

Follow us
Love Your Data
Pythian Logo

© 2024 All rights reserved.