Oracle Apps Patch Basics

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_PF. Few example of falilies are SCM ( 11i.SCM_PF.G ), ATG ( 11i.ATG_PF.H ) _PF indicate Product Family Pack
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

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:

71 comments
Anonymous says August 10, 2006

I have heard people taking about drives….? what exactly is that ?

Reply
Anonymous says August 10, 2006

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

Reply
Anonymous says August 11, 2006

Would appreciate if you could pay a bit more attention to the grammar..

Reply
Atul Kumar says August 11, 2006

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.

Reply
Anonymous says August 11, 2006

Good Work Atul, Keep going.. Thank you very much.

Varaha

Reply
Anonymous says August 29, 2006

Hi Atul ..What is this F-CUPS ?…Family Consolidated Upgrade Patches

Reply
Atul Kumar says August 29, 2006

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

Reply
Anonymous says September 11, 2006

Great job Man.
Thanks
Hanmant

Reply
Atul Kumar says September 11, 2006

Thanks a lot hanmant.

Atul

Reply
Baskar says September 19, 2006

continue doing this goodwork atul.it is very useful and i am also aware that u spend ur precious time in publishing.well done.

Reply
Anonymous says October 2, 2006

What is the differnece between rollup patches and stand alone patches??

Reply
Atul Kumar says October 2, 2006

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 .

Reply
Anonymous says October 30, 2006

Good work atul, keep it up.
Arizuddin

Reply
Atul Kumar says October 30, 2006

Arizuddin
Thanks a lot !!
Atul

Reply
Atul Kumar says November 22, 2006

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

Reply
Anonymous says December 12, 2006

Could u please help explain what is 11., 5., 10.,2 in Oracle Apps ?
Thanks & regards
p_d_ahuja@indiatimes.com

Reply
Atul Kumar says December 12, 2006

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

Reply
Anonymous says December 20, 2006

How to check when the Apache is bounced and please let me know is there any log file i can check

Thanks
Shiva

Reply
Atul Kumar says December 20, 2006

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

Reply
Anonymous says January 11, 2007

Thanx for the usefull stuff

regards
kumar

Reply
Anonymous says January 12, 2007

Can we talk about ad utilities here? I wanted to know about adadmin. what is the step “copy files to destination”???

Reply
Atul Kumar says January 12, 2007

Thanks a lot for your request. I’ll discuss this in a day or two in new post

Reply
fouadbandarkar says January 21, 2007

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.

Reply
Atul Kumar says January 22, 2007

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

Reply
Anonymous says February 2, 2007

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 :)

Reply
Anonymous says February 7, 2007

i am still waiting for the posts on adutilities

Reply
Atul Kumar says February 7, 2007

Hi Anonymous

AD Utilities are listed at http://becomeappsdba.blogspot.com/2006/08/ad-utilities-for-apps-dba.html

Reply
Anonymous says February 21, 2007

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

Reply
Atul Kumar says February 22, 2007

Hi Abinas,
For training check http://www.teachmeoracle.com/training02.html

Reply
Anonymous says March 6, 2007

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?

Reply
Atul Kumar says March 6, 2007

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

Reply
Anonymous says March 6, 2007

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?

Reply
Atul Kumar says March 6, 2007

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

Reply
Anonymous says March 14, 2007

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 ..

Reply
Atul Kumar says March 14, 2007

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

Reply
Anonymous says March 28, 2007

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

Reply
Atul Kumar says March 28, 2007

Steve download them from http://metalink.oracle.com

Reply
Naveen says April 2, 2007

Hi Atul,
How to find if a particular Oracle Patch is applied or not?
(DB Patch)

Thanks
Naveen

Reply
Atul Kumar says April 2, 2007

Naveen,
Use “opath lsinventory” to find database patch on db node

Reply
Anonymous says August 3, 2007

Can u tel something abt patches like , wat type of patches wil we apply in realtime ?

Regards
Jagadeesh

Reply
Anonymous says August 3, 2007

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

Reply
Nishu says September 5, 2007

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.

Reply
shankar says September 20, 2007

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

Reply
Atul says October 16, 2007

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 .

Reply
bilal says January 9, 2008

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

Reply
Paul says June 28, 2008

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.

Reply
amit says June 29, 2008

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

Reply
mann says June 30, 2008

hi atul,

where the OPatch log file store.

Thanking you
mann

Reply
amit says June 30, 2008

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

Reply
Atul says June 30, 2008

As amit explained they are under $OH/.patch_storage (note its dot before patch_storage and its hidden file)

Reply
aggmx1@gmail.com says November 13, 2008

what is the query for check all applied patches in 20008 year?

Reply
Atul Kumar says November 13, 2008

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;

Reply
aggmx1@gmail.com says November 13, 2008

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?

Reply
aggmx1@gmail.com says November 13, 2008

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.

Reply
Atul Kumar says November 13, 2008

Check APPLIED_PATCH_ID column, it should be different .

Follow ad_bugs

Reply
Siva says June 16, 2009

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

Reply
Atul Kumar says June 16, 2009

@ 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)

Reply
anilkumar.srd says August 19, 2010

how to know O.S process of failed worker in adctrl if worker is failed?

Reply
Narendra says June 1, 2011

Hi Atul,

I am integrating EBS Demantra with OID/SSO.. here after registring demantra as partner application i need to generate an osso.conf and it should include in mod_osso.conf.

I am in confusion on which server i had to do the above either on EBS server or OID server ?

and how to generate osso.conf and how to include it in mod_osso.conf
can you provide an example.

Thanks and Regards
Narendra Challa

Reply
Narendra says June 1, 2011

Please give me a solution…

Reply
Atul Kumar says June 1, 2011

@ Narendra,
Check this and ask me question in case of further doubts.

http://download.oracle.com/docs/cd/B28196_01/idmanage.1014/b15988/part_apps.htm#SSOAG161

Share your OID & SSO version .

Reply
sani says July 25, 2011

Hi Atul,

I try to apply Developer 6i patch 16 on my linux installation; Installation goes fine; but when try to relink Procedure Builder, Forms, Graphics and Reports:

during relinking of Graphics I face error

e4 -lnlsrtl3 -lclient -lvsn -lcommon -lgeneric -lnlsrtl3 -lcore4 -lnlsrtl3 -lcore4 -lnlsrtl3 `cat /d01/oracle/visora/8.0.6/lib/sysliblist` -ldl -lpthread -lm \
-L/usr/X11R6/lib -lXm -L/usr/X11R6/lib/ -L/usr/X11R6/lib/ -lXt -lX11 -lm -lix60 -lixd60 -lX11 -lnlsrtl3 -lXp -lXext
/d01/oracle/visora/8.0.6/lib//libgeneric.a(skgfr.o): In function `skgfrcre':
skgfr.c:(.text+0x56a): warning: the `llseek’ function may be dangerous; use `lseek64′ instead.
skgfr.c:(.text+0x56a): warning: the `llseek’ function may be dangerous; use `lseek64′ instead.
/usr/bin/ld: cannot find -lXt
collect2: ld returned 1 exit status
make: *** [g60runm] Error 1

can you please advice what kind of mistake I am doing here ?

my Linux version is OEL5.4

SQL> select release_name from fnd_product_groups ;

RELEASE_NAME
11.5.10

Question#2:How to apply APPLICATIONS INTEROPERABILITY PATCH FOR DEVELOPER 6I PATCH 16

like there is file c3392966.drv
did not find syntax or method to apply it ?

hope to listen from you soon

Thanks and Regards

Ehsan

Reply
Atul Kumar says July 26, 2011

@ Sani,
It looks like you are missing some RPM on your linux related to EBS version

Google on /usr/bin/ld: cannot find -lXt

Reply
Guminasay says October 3, 2012

Wou, I though the different is about how to install it. Nice post.

Reply
zaid says September 27, 2013

Hi Atul ,
I did patching with just a simple one-off patch but it showed me error that one of the report file of prduct ax is not generated , I did r&d on that .rdf file and now its no longer present in the report directory.
what should I do to recover it back ?

Reply
zaid says September 27, 2013

Hi Atul,
plz reply me fast I need ur help ,
I am waiting .

Reply
Atul Kumar says September 27, 2013

@ zaid

You can use adadmin to generate failed report that will give you rdf back .

Reply
zaid says September 27, 2013

Thanks Atul but I tried using adadmin and it did not work and after that in doing r&d on that file(axxgracc.rdf) that file is missing from the product ax I tried adadmin many times but the file didn’t generate so plz suggest me some other way.

Reply
zaid says September 30, 2013

Hi Atul,
when I run the adadmin it shows no error but the file is not generated.
Its generating the form files but not generating the rdf files

Reply
Add Your Reply