Oracle Apps Patch Basics

I 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

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?

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

Please give me a solution…

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

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

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

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

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

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 ?

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

@ zaid

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

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.

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