Patching Commonly asked questions
Where can I find patch log files ? ( Check http://becomeappsdba.blogspot.com/2006/08/oracle-apps-patch-basics-ii.html)
What are different type of patches ?
http://becomeappsdba.blogspot.com/2006/08/oracle-apps-patch-basics.html
How to check if a patch is applied ?
Check table ad_bugs (bug_number ) or ad_applied_patches table .
What two tables adpatch creates when you apply or run adpatch session ?
FND_INSTALL_PROCESSES , AD_DEFERRED_JOBS
Is uninstalling apps patch applied using adpatch supported ?
No (Supported version is to restore from backup )
How to apply a patch when adpatch is running & you come to know that a patch needs to be applied before that patch ?
Broad level steps are Shutdown workers using adctrl, backup above two tables, backup .rf9 files, Drop these two table mentioned above, apply patch which you were suppose to apply , restore .rf9 files , restore two tables which you backed up earlier & restart patch again .
Whats defaults file ?
This is to apply patch non interactively more Coming soon ( i ‘ll post on this soon )
Few methods to reduce patch timing ?
Use defaults file, merge patches & apply as single patch, use high batch size depneding on your system resource, select carefully number of workers while running patching, if upgrade use staged appl_top ( more coming on this in future, please note staged appl_top is different from shared appl_top )
How to control workers ?
using adctrl .
If you encounter any questions related to adpatch and not clear about it, please mail it to me & I will get back to you with in 48 hours . Mail me at atul_iiit@yahoo.com
To know more about Oracle apps 11i Webserver visit my site http://teachmeoracle.com/apc.html
Oracle Apps DBA