http://onlineAppsDBA.com

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

 

hi atul

how to know the patch/115/sql/apwexptb.pls


plz Reply as early as possible

 

Hi Atul Bhai,
Its gr8 yaar to meet a human like u ,very interesting u will get all u r returns from Almighty for these efforts."Can u plz post prepatching n post patching steps so that i can try it by looking at u r blog.
Thanx alot again.

 

We are updating these details in new site at http://onlineAppsDBA.com

 

Hi
I frequently check your site when i face some problem related to apps. is there any document available which comprehensively provides steps for applying patch on windows 2003 operating system, including the path for GNUMAKE, environment variables to be confirmed before starting the patch application and so on.

thanks
sunita

 

hi Atul,

can provide detail about patching step by step

Thanks,
Yusuf

 

hi sir ,

my self ranjeet from India(mumbai) I am oralce 9i certified now I am working in oracle 10g in saraswat bank so tell me what is difference between core DBA and apps DBA.so I am interesting to learn apps DBA in directly apps 11i is it possible to me.and give me the path of certification,books

 

Hi Atul,
Have you used PPM tool to apply Oracle patches? If yes, do you have a step by step document for this?

Thanks
Prush

 

When we apply any application patch on a dual node or multi node server, why do we start applying it from concurrent node and then application nodes?

 

How to confirm if a particular patch was applied before the ESA Patch? Is there any query to check this ?

Thanks
Pramod

 

Atul,

your articles are really useful for all of us.
can you please post CPU patches info for E-Businesss 11i? It would be very helpful.

Thanks
srini

 

Hi, We are running Oracle ERP Rel 12, we have 2 languages one in English and another one is German. I have to apply a patch in this environment. what is the right way?

Do i need to download and apply the patch for English, and then German Language Or only English (ie the dafault) patch is enough? Pls clarify.

Regards,
M. Mydeen

 

Hi Atul,
How to apply adpatch by using OAM, I want know only effected files after running the patch. i.e., it is possible by using adpatch apply=no option. but how come it possible in OAM??

 

hi Atul ,
really you are helpful..
my question is ,if patches realted to application we can use adpatch utiltiy...bt for patches related to database side..i mean where to apply O patch???