We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Oracle Apps PATCH Basics II |
Friday, August 11, 2006 |
|
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 number Unix is platform or OS on which this patch can be applied.
When you unzip a patch you will see some files types which I am explaining here readme.txt - This file contain steps to spply patches, List of Prerequisite patch should be there on apps Instance (If not apply that patch ) cXXXXXXX.drv c stand for copy driver file , this copies patch content to respective patch location , driver is like bus driver which provides instruction on work adpatch need to perform. dXXXXXXX.drv d stand for Database driver & contain content related to database like creating packages, tables, adding column.... gXXXXXXX.drv This contain files related to forms , reports, graphis or messages uXXXXXXX.drv Sometime these three types of files are bundled together into single driver file called Unified driver file
So now you know which type of driver file to apply where ? its common sense if this is d driver you just need to apply once on concurrent manager tier and c & g on all tiers as database is single & if you run it once its enough . If you applied it again by mistake its no harm & will not cause any issues . Similary c & g you need to apply from all tiers , because c will copy your content & g will generate message files. If you are not sure where to apply what just apply it on all tiers & depending on your context file in APPL_TOP/admin/SID_hostname.xml it will apply where to install what by checking xml tag TIER_ADFORMS , TIER_ADWEB , TIER_ADADMIN open your xml file & see these parameters are there or not ( For xml file your system should be Autoconfig enabled ) all system after 11.5.8 by default are autoconfig enabled . For more info on Autoconfig check http://atul-oracle.blogspot.com/2006/07/autoconfig-in-nutshellwhich-is-most.html
Happy Learning Oracle Apps DBA |
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:27 PM
  |
|
23 Comments: |
-
Hi Atul While Patching, As Per documents 1. We have to set the environment variables 2. We should enable Maintenance Mode 3. Stop Services (current Mgr, Forms Server, web server) 4. Apply Patches thru ad Patch (As per Read me file) & review the log files 5. Disable Maintenance Mode (adadmin) My seniors skipped 1 & 3. Please explain why he had skip the above 1 & 3 steps Thanks & Regards KK
-
Hi KK,
your senior is runnng adpatch with options=hotpatch which doesn't require to stop the services and put node in maitaineance mode.
Bob
===========
Hi Atul,
Apart from this reply. I have question for you.
As you discussed about d driver. The way we apply u driver on RAC node with nodatabaseportion. Can we use same option while applying d driver on RAC node.
Waiting for your response on this.
Rgds Bob
-
KK, Apologies as I missed replying to your previous comment.
Bob, I hope you on RAC node , from one database node you are running patch as normal & from second RAC Node you are using nodatabaseportion. Yes for d driver you can use same .
http://teachmeoracle.com/forum
-
KK, Maintenance mode was introduced in AD.I, so if your AD Version is less than I then there was no option to put Apps in Maintenance mode & you could apply patch while Instance was Up or as Bob mentioned ur senior might be using options=hotpatch
Atul
-
Thanks Atul. I have the following questions regarding patch application: 1- How can we know what our patch level is? 2- When can we know we need to apply one patch (only when users complaints about a bug? When there are performance problems? To be on the latest patch level? Why should we apply a patch?) 3- It is not very clear for me: You said: d driver you just need to apply once on concurrent manager tier why not database tier? Can I understand: d on database tier, c &g on all application tiers and on database tier (one time)?
-
-
How to deinstall the patch 4028184
Thanks Shivu
-
Atul How to deinstall the apps patch 4028184
Thanks Shivu
-
How to deinstall the patch 4028184
-
Shivu, Since this is Apps patch applied using adpatch (This is minipack) so you can not uninstall this patch . Only option is to revert back to backup before applying this patch
-
hi Atul i want to know how i applay A Application, 806 or iAS patch in multi-node and shared APPL_TOP i want complite concept ok
-
Hi subhasis , I 'll try to cover them in my coming posts.
-
as u have mentioned here when we unbundle a patch we see a readme file readme.txt, a driver file u(patchno).drv but other than these we also see files like b(patchno).ldt, f(patchno).ldt. could you please let me know what are these files?
-
Check here for ldt or lct file
http://teachmeoracle.com/interview22.html
-
-
thanks but i know what are ldt and lct files. my question is what the ldt files inside a patch_top used for. i m not asking abt the ldt or lct files supplied with a patch to be applied to the instance. i m talking abt the 2 ldt files which are present in a patch_top for all the patches irrespective of the patch type. i wanted to know what are these ldt files and why are they used or how are they used by adpatch?u can try unzipping a patch and find out by urselves.
-
how to apply a patch on a shared APPL_TOP. How to know which is the primary noe.
-
Apply from any node which plays roles of admin server
-
Hi Atul,
Than q for the information. But still I've a doubt. You mentioned that d.drv updates the database. Does this mean that it updates the RDBMS_ORACLE_HOME or anything else?
Than q.
-
plz tell how to migrate oracle apps R12 from linux 64bit OS to 32 bit OS...since mostly people do the reverse migration , but i want 64 bit to 32 bit OS..
-
plz tell how to migrate oracle apps R12 from linux 64bit OS to 32 bit OS...since mostly people do the reverse migration , but i want 64 bit to 32 bit OS..
-
plz tell how to migrate oracle apps R12 from linux 64bit OS to 32 bit OS...since mostly people do the reverse migration , but i want 64 bit to 32 bit OS..
-
Thanks Atul...
Its realy helpful..
Best regards,
Rafi.
|
|
<< Home |
|
|
|
Hi Atul
While Patching, As Per documents
1. We have to set the environment variables
2. We should enable Maintenance Mode
3. Stop Services (current Mgr, Forms Server, web server)
4. Apply Patches thru ad Patch (As per Read me file) & review the log files
5. Disable Maintenance Mode (adadmin)
My seniors skipped 1 & 3.
Please explain why he had skip the above 1 & 3 steps
Thanks & Regards
KK