How to apply apps patch using adpatch

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

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

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

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

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

Thanks anyway,
Firas

Check at

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

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

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

Atul,

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

Steve

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

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?

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?

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

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

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

Set environment varioable by running env file

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

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?

Check

http://teachmeoracle.com/scriptspatch.html

You might have to correct syntax or typo mistake

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

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

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

[…] 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 […]