Lot of you asked me about patch basics & even I myself was confused with Apps Patches terminology initially as I used to hear family pack, mink pack, maintenance pack, patchset, security patch and lot many other type of patches so I thought of introducing you with patching terminology & all these buzz words oracle uses to impress people like you & me.
But before that if you have reached to this post first time & haven’t read all my previous post I’ll recommend you to go through them as they are basics & very important to understand what I am putting here & in future.
So now lets start with patch basics / terminology
Standalone/Oneoff patches : This is used to define patch created to fix single/particular problem.
Mini Pack : This is group of oneoff patches for a particular product like INV, GL, AP and named like 11i.GL.E ( means this group of patches contain fix for 11i GL product (General Ledger till time E is released ) This is cummutative which means it will include 11i.GL.A, 11i.GL.B ….11iGL.D till 11i.GL.E earlier in 10.7 it used to called as patchset.
Family Pack : Group of mini packs in one family buldeled together is called as family pack. they are usually named as 11i
Maintenance Pack : Group of family pack together is called as maintenance pack. So if you say your Verison is 11.5.10 then its maintenance pack 10 ( 3rd digit is maintenance pack ) so
To wind up things you can say
few one off patch make mini pack , few mini pack related to same family bundeled together as family pack & all family pack fixed till that time are bundeled in Maintenance pack .
Oh wait I forgot to tell about NLS Patch ( When you have more than one language , like english & arabic or french .. ) then apart from normal patch you have to apply patch for specific language Installed in your system called as NLS patch ( What is NLS or MLS coming soon ..)
Next I am going to cover patch basics part II
Don’t forget to leave your comment about what else you want to hear about .
Apps Learning
Related Posts for ADPATCH Basics
- Oracle Apps Patch Basics
- Oracle Apps PATCH Basics II
- Good Metalink Notes or Documentation on Apps 11i/R12/12i Patching
Popularity: 15% [?]




Good hands-on exercises (installation, patching, cloning), very experienced trainer worth every penny
59 users commented in " Oracle Apps Patch Basics "
Follow-up comment rss or Leave a TrackbackI have heard people taking about drives….? what exactly is that ?
Thankyou once again for all the stuffs that you are providing.
Please me about configuration of printers in oracle apps and troubleshooting the printer problems
Would appreciate if you could pay a bit more attention to the grammar..
I appreciate your comment about grammer, I’ll try to focus on my grammer as well in future . Please do point out with specific lines whereever you find wrong grammer in future.
Good Work Atul, Keep going.. Thank you very much.
Varaha
Hi Atul ..What is this F-CUPS ?…Family Consolidated Upgrade Patches
Nice Question,
I’ll update Family Consolidation Upgrade patches in my post after database Upgrade . If you don’t see it by next week please remind me again.
I hope you won’t have to remind me .
Atul
Great job Man.
Thanks
Hanmant
Thanks a lot hanmant.
Atul
continue doing this goodwork atul.it is very useful and i am also aware that u spend ur precious time in publishing.well done.
What is the differnece between rollup patches and stand alone patches??
Standalone patch is a patch provided to fix a particular bug/issue. These are usually small in size & limited to only single issue/problem/bug.
Rollup patces are usually fixes of all issues popped up because of a particular minipack/familypack or maintenance pack. Lets assume you applied a family pack & because of that some issue/bug came into picture or all bugs reported soon after family pack or maintenance pack are fixed and released as Roll Up patch . These are usually denoted as roll up 1 rollup 2 or roll up A roll up B.
So you will see maintenance pack 10 (11.5.10) roll up 1 or roll up2
or family pack HJ.J rollup1 .
Roll Up patches are usually cummulative in nature .
Good work atul, keep it up.
Arizuddin
Arizuddin
Thanks a lot !!
Atul
Lakshman,
Unfortunately I won’t be able to post your commnets as they are copy of Metalink Note # 181665.1
Which is against copyright laws.
Regards
Atul Kumar
Could u please help explain what is 11., 5., 10.,2 in Oracle Apps ?
Thanks & regards
p_d_ahuja@indiatimes.com
Hi
11.5.10.2 is version 10 of Oracle Apps 11i with patchset 2.
So 11.5.X is 11i
11.5.10 is version 10 of 11i
11.5.10.2 is patchset 2
How to check when the Apache is bounced and please let me know is there any log file i can check
Thanks
Shiva
Shiva,
You can check $IAS_ORACLE_HOME/Apache/Apache/logs/error_log file
If you see entry like
###
Oracle HTTP Server Powered by Apache/1.3.19 configured — resuming normal operations
###
That means Apache is Just restarted
Thanx for the usefull stuff
regards
kumar
Can we talk about ad utilities here? I wanted to know about adadmin. what is the step “copy files to destination”???
Thanks a lot for your request. I’ll discuss this in a day or two in new post
Hi Atul …
I need to apply a Dicoverer patch on a Windows client … Opatch.
If you couls please provide me with the steps as to how to do it …
I was applying patch 5398173 … It had a pre-requisite patch 2617419.
The steps that I followed were … 1) I unzipped the patch 2617419 in D:\Oracle. I got a directory called OPatch now.
2) I unzipped the other patch too … thats 5398173 in D:\oracle.
3) Went to the location D:\Oracle\5398173 and gave the command opatch apply.
Its not working out.
Please provide me with the detailed steps to set the path and apply the patch … as I dont know the commands too.
This patch is given to us as … the list of application users does not appear when logged in to discoverer.
Thanks and Regards,
Fouad Bandarkar.
If this is database patch “opatch apply” is right way .
What error you are getting ? raise all issues in forum at http://teachMeOracle.com/forum
Though I could n’t find this patch in metalink
Hi Fouad,
There can be 2 issues here…
1. the inventory location may be incorrect
- verify that the global inventory is pointing to the correct instance(oracle-home).
2. opatch is not in the path.
- to verify this, please use ” which opatch”. it it returns the opatch for the desired oracle_home then we need to troubleshoot as per the error msg you are receiving else if its not returning a correct value, then give the absolute path for opatch, say /home/test/10.1.2/OPatch/opatch apply.
You have to run this command from the patch directory where u unzipped ur patch.
Hope this helps
i am still waiting for the posts on adutilities
Hi Anonymous
AD Utilities are listed at http://becomeappsdba.blogspot.com/2006/08/ad-utilities-for-apps-dba.html
Hi atul remember me ur old friend
abinas from LG i want to know about patch from basisc i was out of apps for 4 months.plse suggest for good trainging in south inida as delhi has no facility.
thnaks
abinas
Hi Abinas,
For training check http://www.teachmeoracle.com/training02.html
Hi Atul,
This is very good stuff. Thanks for posting such a good info.
My question is:
My client has changed the default APPLSYS & APPS schema names for some security reasons to APPLSYS_MGR & APPS_MGR while installing Apps.
They have recently created a new user named as “APPLSYS” due to some requirement.
This new “APPLSYS” user is just like any other user in Apps DB, who has synonyms to access 4 tables from APPLSYS_MGR schema.
Would this new user (APPLSYS) create any problem while upgrading/patching OracleApps in future?
Hi Anonymous,
There is fair chances that this might create problem in future upgrades.
I am quite curious to know how user changed default apps & applsys schema names & what all other changes they did after changes schema names ..if you can share .
Regards
Atul Kumar
Thanks Atul for your response. I’ll try to get the details for you based on changes done by client.
Can you also point out to some kind of analysis/oracle docs which would state the potential problems that can be faced while applying patches in scenario mentioned by me?
Hi Anonymous ,
To be frank changing Apps & APPLSYS schema name is not very common (Though clients create their own sutom apps read only schema to give it to functional team) so if you can get more information what all changes were & what all places I can suggest somethign to you .
Atul
Hi Atul ,
The information provided by you is very useful ..Please keep up your good work
I have a generic qs regarding Oracle products..
On what basis does Oracle name its products and the further upgraded versions of it ?
Like –the Database version was Oracle 9i previosuly and it changed Oracle 10g,why not 10i ??
why is the Oracle Apps version 11.5 ??why not 11.4 or 11.3 ?
Similarly for its other products as well like Oracle reports and Forms ..
Hi Anonymous,
i & g is just buzz world where i is internet & g is for grid.
and for version number they follow internal versioning mechanism based on thier own tools
Atul,
I tried the ftp site, ftp://oracle-ftp.oracle.com/apps/patchsets/
as you pointed, it cannot be accessed.
COuld you pls let me know the exact one, thank you so much.
Steve
Steve download them from http://metalink.oracle.com
Hi Atul,
How to find if a particular Oracle Patch is applied or not?
(DB Patch)
Thanks
Naveen
Naveen,
Use “opath lsinventory” to find database patch on db node
Can u tel something abt patches like , wat type of patches wil we apply in realtime ?
Regards
Jagadeesh
I have doubt in patches , regarding ..will we apply patch to add new functionality in realtime ? When we apply that type of patches ?
Regards
Jagadeesh
Hi Atul it was a great learning experience going thru your post..’m in Canda working on Oracle Apps 11.5.8 how can I reach you if I encounter any problem or guidance. I have just a basic knowledge about apps but the good part is that I have access to application so can play around but not confident how can I handle this new responsibility of Analyst to Oracle apps..please send me some tips and guidance how can I if not master but project not a novice on it.
hi atul this is shankar choudary and
here is my request to you plz explain
about 11.5.10 and also some detailed
regarding patches
Atish asked
—————
Hi atul..
i was suppose to apply a patch on an apps Appication 11i using a DB 8i..
wat r the steps to follows?
Should i put the application on maintenance mode? How 2do that..
My problem was, am use to use adadmin on DB 11i an above. but on the DB 8i, the options on adadmin was not the same,am i didn’t know how to put on maintenance mode,etc..
Beside, how to do a patch on a running application..
Thz..
—
If you have to put apps in maintenance mode or not will depend on AD version in your apps (AD.I.2 or higher). Start applying patch using adpatch and if errors out saying apps is not in maintenance mode then enable it using adadmin utility.
You have to put only application from CM in maintenance mode and not ON database .
Hi Atul,
While applying a patch i am getting the below error, i am working on 11.5.10.2 on AIX, i google and metalink but didnt get the suitable solution,
please if u can help
Perl environment not set for Oracle Applications. (TXK libraries not in INCLUDE list)
Ensure that Autoconfig has been run and your environment has been sourced correctly.
at ./txkprepatchcheck.pl line 131.
BEGIN failed–compilation aborted at ./txkprepatchcheck.pl line 141.
Thanks
Bilal
Eric…
What is this ERP all about exactly…
Atul,
While applying patches, if you specify many workers like say 15 or 20, then sometime you see that one worker wait for other or hung up, because it waits for resource to be released.
Question is, where you find which exact resource it is waiting for or what’s happening exactly in terms of resource waiting.
For example, is it waiting for table lock to be released, or some file I/O contension, etc.?
How can we exactly pin point what’s happening? Where we will find this info?
Thanks.
Hi Paul,
With the adctrl utility you can know what worker is doing or in what state it is ?
With the help of some OS utility like top or with v$session table you can know like whether it is running or not.
v$session_longops also help in this and V$lock will give u the lock status.
To know what exactly the script is doing, during the run time just go thru the details of the scripts like what exactly it is looking for.
Hop this all helps.
Amit
hi atul,
where the OPatch log file store.
Thanking you
mann
Hi Mann,
Go to Opatch folder in Oracle Home and run this
opatch lsinventory -detail
This will give all the details inclusing the log file location. Something like
————————————————
Oracle Home = /home/ovis11i/database/prod7db/9.2.0
Location of Oracle Universal Installer components = /home/ovis11i/database/prod7 db/9.2.0/oui
Location of OraInstaller.jar = “/home/ovis11i/database/prod7db/9.2.0/oui/jlib”
Oracle Universal Installer shared library = /home/ovis11i/database/prod7db/9.2.0 /oui/lib/linux/liboraInstaller.so
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Inventory = /home/ovis11i/database/prod7db/9.2.0/inventory
Path to Java = /home/ovis11i/database/prod7db/9.2.0/jre/1.4.2/bin/java
Log file = /home/ovis11i/database/prod7db/9.2.0/.patch_storage//*.log
————————————————
Regards
Amit
As amit explained they are under $OH/.patch_storage (note its dot before patch_storage and its hidden file)
what is the query for check all applied patches in 20008 year?
select bug_number , LAST_UPDATE_DATE from apps.ad_bugs where LAST_UPDATE_DATE >= ‘01-JAN-08′ and LAST_UPDATE_DATE <= ‘13-NOV-08′ order by LAST_UPDATE_DATE;
Thank you Atul,
But I have a question about check applied patches in ebusiness:
The first query display
5715 rows selected
and
The nexy query only 74 rows selected
select APPLIED_PATCH_ID,PATCH_NAME FROM AD_APPLIED_PATCHES where LAST_UPDATE_DATE >= ‘01-JAN-08′ and LAST_UPDATE_DATE <= ‘13-NOV-08′ order by LAST_UPDATE_DATE;
Idon’t understand what is the right?
Thank you very much Atul
but when I execute the next query for check applied patches, display three lines at same patch, do you know what is the problem?
select distinct PATCH_NAME,LAST_UPDATE_DATE FROM AD_APPLIED_PATCHES
where LAST_UPDATE_DATE >= ‘01-JAN-08′ and
LAST_UPDATE_DATE <= ‘13-NOV-08′
order by LAST_UPDATE_DATE;
4381807 12-OCT-08
4381807 12-OCT-08
4381807 12-OCT-08
4444875 12-OCT-08
4444875 12-OCT-08
4444875 12-OCT-08
5974819 31-OCT-08
5974819 31-OCT-08
5974819 31-OCT-08
4551936 31-OCT-08
PATCH_NAME LAST_UPDA
————— ———
4551936 31-OCT-08
4551936 31-OCT-08
6966124 31-OCT-08
6966124 31-OCT-08
6966124 31-OCT-08
5702617 31-OCT-08
5702617 31-OCT-08
5702617 31-OCT-08
74 rows selected.
Check APPLIED_PATCH_ID column, it should be different .
Follow ad_bugs
Hi,
Can I automate the patch applying process? I heard that we can use defaults file kinda option, but I’m new to apps. Please help me
Thanks
@ Siva
For apps patch in non-interactive mode using defaults file -
For 11i check Apps Maintenance Guide
http://download.oracle.com/docs/cd/B25516_18/current/acrobat/11iadproc.pdf (Page 70-74)
For R12 check patching procedure guide
http://download.oracle.com/docs/cd/B53825_02/current/acrobat/121adpp.pdf (Page 115-119)
how to know O.S process of failed worker in adctrl if worker is failed?
Leave A Reply