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 already provided answers)

You being new to apps patching will prefer to interactive way f patching , let adpatch throw series of questions & you answer each of these .
If you want to use any option with adpatch enter adpatch with options= seprated by comma (If you don’t supply any options it will take defaukt value set for that particular option like compiledb & compilejsp)
You have to issue adpatch from application user (User you entered as applications/middle tier user usually applmgr if you insatlled using oracle standard documentation like )

adpatch options=nocompiledb,nocompilejsp
Based on you AD verison it will ask you questions like with some suggested value

‘/u01/applmgr/VIS11I/appl’
Is this the correct APPL_TOP [Yes] Log file name & location
….

Once patch is applied you might be interested in checking log files

If patch fails then you have to use utility adctrl to check for which worker it failed & check corresponding worker log file to see error message.

For more information on patches & patch basics follow metalink note # 181665.1
I’ll cover adctrl to see error message & how to reduce patch timing using defaults file day after tomorrow.

Oracle Apps DBA

About the Author Atul Kumar

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

follow me on:

Leave a Comment:

22 comments
Anonymous says November 1, 2006

hi

Is there any list of patches(single node) to be applied for Pre&post installation. Steps to be taken while applying the patches(i.e like shutdown DB or Listener).

thanks
kishore

Reply
Atul Kumar says November 1, 2006

Kishore,
For pre & post steps while patching , these should be mentioned in Patch Read Me so do them if they are mentioned in readme .

For Services these days you have to shut down application tier & enable maintenance mode via adadmin.

DB & DB listener should be up during apps patching

Reply
Firas says March 18, 2007

Hi Atul,

Actually sometimes it is very confusing to know what patches to use. For example i have just installed a fresh oracle TEST apps. Now i have many choices. I will use PATCH WIZARD/OAM to install latest recommended patches. I have also ATG_PF Rollup 4 to install .. am i on the right track? In general what is the right policy and strategy for patching systems? Also how to know the family pack amd mini-packs version you currently have?

Thanks a lot,
Firas

Reply
Atul Kumar says March 18, 2007

Firas,
You can use patchsets.sh script to find mni pack version on your apps instance .
There are various ways of applying patch & autopatch (adpatch) and OAM are few. OAM inturn uses adpatch only . You can use any supported tool to apply patch

Reply
Firas says March 19, 2007

Where could i find this scrip? I did a “find” op and i couldn’t find it. Please advise.

Thanks anyway,
Firas

Reply
Atul Kumar says March 19, 2007

Check at

http://www.teachmeoracle.com/patch02.html

Reply
Anonymous says March 21, 2007

Atul,
u r very helpful.
I have 3 questions for you:
1. How can I know which new patches should I apply by a simple query for the application. I know we can query it from ad_applied_patches, but it only tells the patches, the # tell you nothing. I just want know the answer regardless the version, since the system login on should automatically pick up info without inputing anything.

2. What kind of logs that I can purge within the application, and how?

3. How can backup the application and keep them many days and db files, since they are hundreds gbs, not only database datafiles incremental, but also the application files (top and common folders).

I appreciate your help.

Steve

Reply
Atul Kumar says March 21, 2007

Steve,
For latest mini pack available and one on your system use patchsets.sh this will give list of patch you should apply.

For purging logs you can use
purge concurrent request data &
Purge obsolete workflow data

concurrent request

Reply
Anonymous says March 21, 2007

Atul,

I search the file for the patch set, cannot find it. where is it located? Thank you again.

Steve

Reply
Atul Kumar says March 21, 2007

Check http://www.teachmeoracle.com/patch02.html

Reply
Anonymous says March 24, 2007

when i’m trying apply a patch, the error occure FAILED: file GMFFIN.odf on worker 1 for product gmf username GMF.How can i handle it?

Reply
Anonymous says March 24, 2007

when i’m trying to apply a patch, i’ve got error message :
FAILED: file GMFFIN.odf on worker 1 for product gmf username GMF. How can i handle the error?

Reply
Atul Kumar says March 24, 2007

Whats patch No ? Do you see any reason for failure of this in worker log file ?

Reply
Muhammed says March 26, 2007

hi
i m first time upgrading 11.5.10 to 11.5.10.2 but i dont know how to use adpatch utility , when i run adptach then show a appl_top is not set, plz tell me how to apply this utility on W2003.

Regard’s
Ramzan
Muhammed.ramzan@gmail.com

Reply
Muhammed says March 26, 2007

hi
im first time upgrading 11.5.10 to 11.5.10.2 on vision server now plz tell me how to use adpach utility on w2003.
when i run only adpatch ulility then show appl_top is not set.

i downloded a patches.

soonly reply
regrad’s
Ramzan

Reply
Atul Kumar says March 27, 2007

Set environment varioable by running env file

For any apps quesries/questions / doubts raise them in forum at http://teachMeOracle.com/forum

Reply
Anonymous says March 29, 2007

Hi Atul,

How do we find whether the Language patches(NLS) have been applied from the database level other than using OAM? Can you me suggest a query for that?

Reply
Atul Kumar says March 29, 2007

Check

http://teachmeoracle.com/scriptspatch.html

You might have to correct syntax or typo mistake

Reply
Anonymous says March 30, 2007

Hi Atul,

Sorry that was a typo. What i actually meant was that, Can we find out what all language specific patches are applied to Apps from database level using a query other than using OAM? Is there any query for that? B’cos the Ad_bugs and Ad_applied_patches list only the Base patches(US) applied.

Thanks,
Karthik

Reply
Anonymous says April 4, 2007

Atul,

I have problem to download the patchsets.sh from oracle metalink, and search from application OAM.

can anybody pls send me the file latest downloaded to webfinancial@yahoo.com

and anybody pls give me the list of patches need to be applied for 11.5.10.2 installed on Intel Linux on June 2006.

Thanks.

Fish

Reply
ravi says June 1, 2007

Hi Atul,
how ca i know on which RUP the instance or the application is on …is there any query or any table to know this .

regards,
Ravi Kishore

Reply
» opatch, adpatch and now “smart update” (BSU) to apply weblogic patches Online Apps DBA: One Stop Shop for Apps DBA’s says February 23, 2010

[…] Oracle Apps DBA its mandatory to know about opatch (utility to apply database patch) and adpatch (utility to apply apps patch) but if you are planning to upgrade your skills to Oracle Fusion […]

Reply
Add Your Reply