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 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

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

20 comments
Anonymous says August 26, 2006

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

Reply
Anonymous says October 30, 2006

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

Reply
Atul Kumar says October 30, 2006

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

Reply
Atul Kumar says October 30, 2006

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

Reply
agostino_neto says November 16, 2006

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)?

Reply
Atul Kumar says November 16, 2006

Neto,
For questions/Issues please raise them in forum at http://teachmeoracle.com/forum dedicated to Apps DBA’s

Reply
Anonymous says February 7, 2007

How to deinstall the patch 4028184

Thanks
Shivu

Reply
Anonymous says February 7, 2007

Atul
How to deinstall the apps patch 4028184

Thanks
Shivu

Reply
shivu says February 7, 2007

How to deinstall the patch 4028184

Reply
Atul Kumar says February 7, 2007

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

Reply
subhasis says March 11, 2007

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

Reply
Atul Kumar says March 11, 2007

Hi subhasis ,
I ‘ll try to cover them in my coming posts.

Reply
Anonymous says March 23, 2007

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?

Reply
Atul Kumar says March 23, 2007

Check here
for ldt or lct file

http://teachmeoracle.com/interview22.html

Reply
Atul Kumar says March 23, 2007

Its

http://teachmeoracle.com/interview22.html

Reply
Anonymous says March 23, 2007

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.

Reply
Anonymous says August 26, 2007

how to apply a patch on a shared APPL_TOP. How to know which is the primary noe.

Reply
Atul Kumar says August 27, 2007

Apply from any node which plays roles of admin server

Reply
ananta says August 11, 2012

I want to ask few question regarding patch application.

During patch application we use system password.
In one note i found that it is used for getting system configuration information.
Can you please explain this me in details.

Thanks

Reply
SEYDINA says August 16, 2012

I have never apply a patch in Oracle E-Business Suite.
How can i Apply it step by step

Thanks

Reply
Add Your Reply

Not found