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 […]

Read More

Troubleshooting Apps Patch

Now as Apps DBA or Sysadmin you know how to apply apps patch in oracle E-Business Suite 11i (If not read my notes below ) What if you encounter any problem while applying patches ? Where to look for any error messages ? How to control patch workers and how to restart a failed patch […]

Read More

How to apply apps patch using adpatch

Now you know basics of apps patch like type of patches & options available with patching, lets see how to apply patches in oracle applications 11i . Two broad ways to apply patch interactive & noninteractive(You will supply required parameters on commnad line & patch will apply without asking you any questions as you have […]

Read More

ADPATCH Options

Now since you know basics of patch (If not read my previous posts, its quite important to know patch basics before starting to apply patch ) By now you might know that you use utility adpatch to apply oracle apps patch and adadmin, admrgpch, adctrl to manage/control your patch . Depending on you AD version […]

Read More

Oracle Apps PATCH Basics II

As Oracle Apps DBA patching is quite basic thing you do regularly so lets continue with basics . If you have not gone through my previous posts please do so now as its quite important to through basics . Apps patches are buldled somthing like p123456_11i_Unix.zip where p menas patch next few digit are patch […]

Read More

Oracle Apps Patch Basics

Lot of you asked me about patch basics & even I myself was confused with Apps Patches terminology initially as I used to hear family pack, mink pack, maintenance pack, patchset, security patch and lot many other type of patches so I thought of introducing you with patching terminology & all these buzz words oracle […]

Read More

AD Utilities for Apps DBA

From now to next few sessions I will be discussuing very important product from DBA’s prespective i.e. AD also called as Application DBA ( 😉 I think its named AD after Application DBA ) AD_TOP is product in Aplication which is under directory APPL_TOP/ad/11.5.0 ( If you are not familiar with TOP please read my […]

Read More

Apps Architecture

This Topic is quite important and I recommend you to go through this thoroughly. First I want to discuss terminology which you will encounter here & in most of Oracle Documentation. Server – is a process or group of processes and provides a particular functionality/service For example, Database Server listen and process database requests, similarly […]

Read More

Install Oracle Apps

This Post will Contain broad level steps of Oarcle apps Installation , this is just for Overview or High level step for Installing Apps. For details & exact commands refer to Oracle Installation Guide mentioned at bottom of this post . Pre Instalaltion Steps Check System requirement: Software Requirenet : like ar, ld, make, gcc, […]

Read More

Free Apps DBA Training

Training is quite important in all walks of life and same applies to Oracle Apps DBA life, There is no alternative to Formal Oracle Apps training but looking at price of each training it becomes nightmare for individuals to go through them. (Ofcourese if this training is sponsored by your company than you are really […]

Read More