Apps 11i DBA preparation

Hi Atul

Thanks a lot for your time and help. I have completed the 3 parts you have mentioned i.e Architecture, installation and file systems. I have done a single node installation on Solaris SPARC server and is working fine.

Could you pls guide as how to proceed further….Also I would like to create users with access to different modules and so on..Please advise.

Thanks in advance..

Best Regards
Ramana

awe some work..thank you so much, Its a wondeful guide for all dba’s.

Ramana,
Thats good news . I think you have done pretty much for a start , Are you working some where on apps. You can start looking into apps patching & cloning now .

May be upgrade in future .

Atul

By the way what do you means by… I would like to create users with access to different modules and so on..

Authorization in apps is controlled by responsibilities.

Atul

Atul,

Thanks a lot for your response and encouragement. I have not yet started working on prodn system. I have installed Apps(11.5.10.2) on my ODC test server and trying to get hands on. I have plans to take up an Oracle Apps DBA assignment soon. As you suggested, will try my hands on patching and cloning.

When I go through the Apps documentation on responsibiltes I could not find any practical examples. Could you please write an article on “Creating and mananging Users in Apps” as all your articles are very easy to comprehend and are giving a clear understanding, like your various TOPS explanations.

Keep your good work going.

Hats Off..

Ramana

Thanks Ramana,
I’ll try to post on creating users & adding reponsibilities under oracle apps security section oin apps system administration section. I am still at Apps DBA sections & lot way to go like

Discoverer
SSL on apps in Web Server / Forms & database
Parallel Concurrent Processing &
Demystifying Autoconfig

hi Atul,
first of all i want ot congratulate u for providing such a wonderful site.
I am working for satyam computers from the past 2 yrs(i joined as ELTP).I am having exp in java-j2ee, now i came to know that Oracle fusion which is the upcoming series is built on java/j2ee techs. SO i am planning to learn Oracle Apps. What would be best for me Oracle apps or some self server applications in Oracle.

Satya,
Nice to hear from you. Yes oracle is coming with fusion & in next apps release i.e. Rel 12 , you will see Oc4J & 10g iAS

It depends on what you want to learn , if you want to beconme developer then OA Framewrok may be good for start .
If you want to move in Apps DBA soon I am going to cover on Fusion Middle ware , includign SOA ( Service Oriented architecture)

Atul

Hi Ramana,

To create user you have to have system administrator resp and then go to security –>define
—
This is the form now you can create user and add responsibility with them

Amresh

Hi Atul,

I think Fusion is not same as Release 12. Fusion is a release planned after Release 12 which will combine Oracle’s acquired products like JD Edwards and Siebel

– Vikram

Yes Vikram you are right .

Fusion Applications is release after Ver 12.

For Fusion Middleware , which is collection of middleware like 10g AS, Collaboration Suite, SOA Suite , data hub.. its available .

Atul

Here’s an update from Steven Chan: Distinguishing Release 12 from Fusion Applications

http://blogs.oracle.com/schan/2006/12/05#a1018

– Vikram

Hi All,

My name is Bhakti Prasad Dash,
I am a Oracle DBA working in IBM ,India.
I have just started my apps studies with the help of Mr. Vikram Das.

I hope i will get all relevant suggestions from all of you.

Thanks
Bhakti

Guru Gr8 Atul ji,
It is realy a wonderfull help you did for people like me. I’m assigned APPS DBA where the implementation is already going on to way of production and the DBA has done already his installation 3-4 months back and left. I’m newbi to hear this APPS and was having tension “what is apps”. Now i’m lucky, Atul Guruji has given me chance to learn this apps and it realy helping me lot. I’m basically oracle core dba expreinced. Thanks, once again to Guru Atul ji!
Ravi

Hi Atul,

Thanks for all the work and information in this web site. I’ve just migrated an 11.5.9 instance from 9i non RAC to 10g RAC with two RAC DB nodes with concurrent processing tier and PCP enabled. I also added a third node containing the web and forms services. Now I need to add a fourth node containing the forms and web services to provide fault tolerance and load balancing for that tier.
Is it possible without using a hardware load balancer ?

Thanks,

Sergio Chong

Sergio,
You can use DNS server as your load balancer.

Atul

Hello Atul
You are doing great job, i m Oracle 9i certified DBA and want to enter Apps Field,Can u tell me frm where i can get Apps Software, becz its very heavy software n impossible to download (appox 35 GB). I m trying from the past 1 month to download this from net but failed.So suggest me plzzzzzzzzzzz.
Thanks a lot

You can get CD’s from oracle via Metalink

Hi Atul

I am unable to find media pack of oracle 11i on metalink. can you send me a link. I have metalink id. plz its urgent for me.

Thanks

Regards,
Vivek

link for media pack for 11i is edelivery.oracle.com

hi Atul,
I hav a doubt,
Afer Knowing about File System Only, a person can easily install Apps,isn’t it?

Regards,
ShravanDeekonda

Shravan,
For installation you go through installation doc . File system is important in understaning and troubleshooting apps

Hi Atul,

I am a budding DBA, am OCA 9i already and would be DBA within a fortnight. My problem is that I am self studied person, and thus have very little hands on experience. As the job market goes its a catch 22 with me, no job–> no experience and vice versa. How can I get some quality experience with 9i as well as upgrade to application 11 i DBA.

Hi Atul,

I am OCP(DBA) and have just done a course in Oracle Apps DBA.
I am working as a Technical consultant in Oracle Apps.I am finding it hard to get a job as an Apps DBA, what are your suggestions on how to get one.

Thanks and regards,
Aarif

Aarif,
Getting first apps dba job is always tough so keep trying and upload CV to job sites and keep contacting companies . good luck for your job hunt

Hi Atul,
Could you help me?
i am using the oracle application 11.5.10.2 with windows XP.
i am facing the problem, when i run the concurrent program
transfer from AP to Gl.
concurrent program complete with error. while i using the all things correct for this.
could you help me>
thanks in advance

Hi Atul,
i am using the oracle application 11.5.10.2 with Windows XP.
when i run the concurrent program
“Transfer from AP to GL”.
it completed with error. please help me

thanks in advance

Update error log for request failing .

Hi Atul,

Can u suggest me ,which is good institute for doing oracle aaps dba in hyderabad.

Thanks in Advance

Debasis