| Patching Commonly asked questions |
| Tuesday, August 15, 2006 |
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Where can I find patch log files ? ( Check http://becomeappsdba.blogspot.com/2006/08/oracle-apps-patch-basics-ii.html)
What are different type of patches ?
http://becomeappsdba.blogspot.com/2006/08/oracle-apps-patch-basics.html
How to check if a patch is applied ?
Check table ad_bugs (bug_number ) or ad_applied_patches table .
What two tables adpatch creates when you apply or run adpatch session ?
FND_INSTALL_PROCESSES , AD_DEFERRED_JOBS
Is uninstalling apps patch applied using adpatch supported ?
No (Supported version is to restore from backup )
How to apply a patch when adpatch is running & you come to know that a patch needs to be applied before that patch ?
Broad level steps are Shutdown workers using adctrl, backup above two tables, backup .rf9 files, Drop these two table mentioned above, apply patch which you were suppose to apply , restore .rf9 files , restore two tables which you backed up earlier & restart patch again .
Whats defaults file ?
This is to apply patch non interactively more Coming soon ( i 'll post on this soon )
Few methods to reduce patch timing ?
Use defaults file, merge patches & apply as single patch, use high batch size depneding on your system resource, select carefully number of workers while running patching, if upgrade use staged appl_top ( more coming on this in future, please note staged appl_top is different from shared appl_top )
How to control workers ?
using adctrl .
If you encounter any questions related to adpatch and not clear about it, please mail it to me & I will get back to you with in 48 hours . Mail me at atul_iiit@yahoo.com
To know more about Oracle apps 11i Webserver visit my site http://teachmeoracle.com/apc.html
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 @ 9:51 PM
  |
|
| 11 Comments: |
-
-
The blog is good,but your web site is better.Waiting to see the updates there.
Sam
http://appstech-sam.blogspot.com
-
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
-
KK,
Thats very valid question . No you should never skip setting Environment Variables. Since mostly env. variable files are called from user profile so as soon as you login to applications from o.s. user it automatically sets environment variables thats why ur seniors might not be seeting env. variables.
Enable maintenance mode was introduced in I suppose Ad.I.2 you can skip that by option=hotpatch so like adpach options=hotpatch
There is no need to stop services but if your patch changes any executable which your services might be using you see unexpected behaviour during patch applications.
Oracle is recommending to stop but its not necessary so for a starter its better to stop services & as you grow in apps dba you can decide to stop or not
Atul
http://teachmeoracle.com
-
This is my first post/comment on ur blog..I must say Hats-Off to u...Keep up the good work..Coming to the query part?? can u put some light on .lgi files which are created along with .log files during patch application...
Thankz and Regards
Kabz
-
Kabz,
Thanks a lot for your compliments. Coming to your query about lgi file while patch , I can never forget this question because I was not aware of this five years ago when someone asked me this question during Apps Interview :)
lgi stands for log information ( lgi ) this stores informative message while patching which can be helpful to understand what patch is actually doing. Though I never came across anyone till now who ever opened this file.
Atul
-
Hi Atul,
Is there a way we can login when maintence mode is on??
-
Hi Atul,
Is there a way we can login when maintence mode is on??
-
Yes you can login but application will behave strangely like responsibility missing or functions/menus not available
-
Where to find that lgi file in R12??
-
I am newbie to Apps DBA...These blogs are helpful to me....thanks
|
| |
| << Home |
| |
|
|
Good work...keep going