Latest Updates

Post Top Ad

21 January, 2013

Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch

At start of my career I was applying apps patches with couple of my colleagues ( all freshers), there was huge bunch of patches (I know everybody has to apply lot of patches initially) and we were applying patches individually one by one. Our team lead came & asked us how come you are still applying patches speed up & finish it early (You can't afford this much downtime for patching) . One of my colleague replied look we are not doing anything its Server (Unix Machine) which is applying patches & we can't do much . My TL said give attention what adpatch is doing & try to remove redundant steps which are repeated with each patch.

that's where we really started looking at we realized that
In each patch adpatch is
1. Asking basic questions like , Default APPL_TOP, Log file name, ORACLE_HOME, apps password, system password
2. Compiling database at end of some patches
3. Compiling JSP at end of most of patches
4. Running maintain MRC Multiple reporting Currency in installation where MRC was configured.
5. It was by default taking number of workers as twice the CPU + 1
6. There was some thing called batchsize

Then I looked at metalink to find if there is anyway I can reduce repeated tasks and came across defaults file which I am going to discuss in subsequent pages.
Other thing I came across is merging patched via admrgpch I'll discuss about this after defaults file may be tomorrow
You can also play with batchsize & number of workers to reduce patch timing

Using Defaults file with adpatch (Non Interactive)
How to create defaults file ?
adpatch defaultsfile=$APPL_TOP/admin/$SID/defaults.txt ( You can keep this txt file in any location of your choice)
Now abort autopatch section at point where it asks for patch directory by ctrl +c or ctrl+d
Now check if this file exists
You have to do above steps only once in an environment to create defaults file.


How to apply patches in future ?
Now any future patches you apply non interactive using defaults file like
adpatch defaultsfile=$APPL_TOP/admin/$SID/defaults.txt logfile=654321.log patchtop=/patches/654321 driver=u654321.drv interactive=no

You will see that it will apply patch by itself using defaults file , adpatch will pick APP_TOP, ORACLE_HOME information, system password and apps password from defaults file.

This will save lot of time & you can reduce your patch timing usign defaults file .

28 comments:

Anonymous said...

xanax online xanax pills vs bars - alprazolam 0 5mg ms

Anonymous said...

xanax online 2mg xanax to sleep - buy alprazolam cheap no prescription

Anonymous said...

buy tramadol online tramadol hcl 50 mg for dogs - tramadol online legal

Anonymous said...

cheap xanax online 1mg xanax get high - does xanax show up swab drug test

Anonymous said...

cheap tramadol online order cheap tramadol-overnight - tramadol online shipped to florida

Anonymous said...

generic xanax order xanax pills online - buy xanax pfizer

Anonymous said...

xanax medication xanax dosage 1.5 mg - xanax bars vs xanax

Anonymous said...

buy tramadol online tramadol zydus 50 mg - cheap tramadol buy

Anonymous said...

buy carisoprodol carisoprodol recreational dose - carisoprodol 350 mg tablets information

Anonymous said...

carisoprodol 350 mg carisoprodol 350 mg vs flexeril - drug carisoprodol prescribed

Anonymous said...

order xanax no prescription can really buy xanax online - where can you buy gador xanax

Anonymous said...

buy cialis online cialis webmd - cialis price comparison walmart

Anonymous said...

tramadol without prescription buy tramadol hydrochloride - tramadol for dogs in liquid

Anonymous said...

xanax online alprazolam 0.5 mg tab - xanax drug action

Anonymous said...

xanax online long xanax urine drug test - 3mg xanax dosage

Anonymous said...

buy cialis online buy cialis generic online cheap - price comparison for cialis

Anonymous said...

cialis online cialis moment urban dictionary - buy cialis reviews

Anonymous said...

cialis online how to order cialis online no prescription - cialis user reviews

Anonymous said...

http://buytramadolonlinecool.com/#91646 much tramadol overdose dog - tramadol stada 100mg nebenwirkungen

Anonymous said...

http://buytramadolonlinecool.com/#30807 tramadol 50 mg over counter - tramadol hcl 50 mg side effects

Anonymous said...

http://buytramadolonlinecool.com/#63102 tramadol rash - buy tramadol 180 online

Anonymous said...

learn how to buy tramdadol buying tramadol with mastercard - tramadol hcl coupons

Anonymous said...

buy tramadol tramadol for anxiety - tramadol on drug test

Anonymous said...

http://buytramadolonlinecool.com/#28875 tramadol online bestellen - tramadol hydrochloride 50 mg high

Anonymous said...

ways to buy ativan online novo lorazem 1mg - are ativan and xanax the same

Anonymous said...

ways to buy ativan online ativan withdrawal signs and symptoms - ativan qt interval

Anonymous said...

buy tramadol online what's the tramadol high like - tramadol 50mg for dogs usa

Anonymous said...

http://bayshorechryslerjeep.com/#4038 xanax bars urban - xanax side effects dizziness

Post Top Ad

Your Ad Spot

Pages