http://onlineAppsDBA.com

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

 

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

 

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

 

Atish,
We have moved to new site at http://onlineappsdba.com/index.php/2006/08/10/oracle-apps-patch-basics so I'll respond to your query at above link kindly in future keep your comment at above site

 

Hi atul have a nice day ,

I have applied maintenance pack 3480000 patch. while applying i got one worker failed if i see the log file the error code is 1. what is the reason the worker failed ? how to resume the patch .. can you give sugesstion for this as soon as possible

advance thanks & regards
yaseen.a.r

 

Please raise it in forum http://teachMeOracle.com/forum dedicated to Apps DBA's

 

Hi Atual,

I want small help. i want to apply the Arabic Language on 11.5.10 version.can you please tell me the what is the patch number and steps.

Thanks
Venkat.

 

Hey Hi buddy,this is Pawan
Ur articles and updates for Apps
Architecture are of Gr8 help.
Gr8 goin Buddy!

 

can you please explain what is rollup patch and how to apply the rollup patch.

 

How i may apply a Patch on R12.0.4 in Windows Server 2003 Environment.....?

Zeeshan

 

Do I need to run adautocfg after applying a CPU patch on 11i EBS?

 

hiiii

 

Great job, I can now work smoothly with my Oracle apps.