We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Reduce Patch timing in apps , defaults file, nocompilejsp , nocompiledb , merge patch |
| Monday, September 25, 2006 |
|
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 .
More on how to reduce patch time in coming posts ...Labels: patching |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 2:50 PM
  |
|
| 9 Comments: |
-
impressed.
How to specify the work number in the command line when apply patch
-
Thanks a lot (I would love to see name of my readers but you have full right not to disclose it at same time)
Do you mean by number of workers or any other thing ?
-
how to register.jsp pages in oracle apps in reg to frame work.i developed a application in jdeveloper and how to convert .xml into .jsp
bye
sunny
-
Sunny,
Apologies but I don't think I will be able to answer this .
Check in some developer forum
-
Great web site. Is there any way to move the app into maintenace mode non-interactively too? SO that I could use the crontab to shut the app down, stick the app into maint mode then use adpatch with the defaults file to apply the patches...all ovwernight?? Thanks
-
Here it comes
$AD_TOP/patch/115/sql/ adsetmmd.sql
-
We first apply patches to the test menvironment. The test environment has a different APPL_TOP, apps password, system password, ORACLE_HOME...etc. I apply a patch to the test environment, do I just copy the default file to th production environment to appl it noninteractively? Looks to me the only way you can apply a patch non interactivley is if you have already applied it same machine, or if you applied it in another machine which has exact passowrd, ORACLE_HOME...etc. Am I right?
-
hi atul!!
what is this maintenance patch!! and how can we determine taht we need a maintenance patchand more over how can we get it
-
Hi,
You can refer the metalink document(375130.1) for
How to apply patch without enabling Maintenance Mode
Regards
Ash
|
| |
| << Home |
| |
|
|
impressed.
How to specify the work number in the command line when apply patch