We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Apps 11i DBA preparation |
Saturday, August 19, 2006 |
|
As I am getting lots of request for how one should prepare for Oracle Apps 11i DBA in Technical domain including Sysadmin, I am summing up things you should learn / study in order to understand E-Business Suite 11i . The topics mentioned below, which you should read in order to become apps DBA or as part of your Oracle Apps DBA training will include roles & responsibilities of oracle Apps DBA.
1. Apps Architecture This is key topic & you should be very clear about Oracle Applications/E-Business Suite 11i components & Architecture. This is base of your knowledge & if you are not clear about various components & uses it will be quite difficult in learning Apps. Where to find Oracle Applications 11i architecture in Ocean of oracle Application technical documentation. Well I agree with you go straight to http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/11iconcepts.pdf and go through chapter 1 (Page 13 to Page 32 Just 20 Pages)
2. Installing Apps 11i Next point in apps dba training is Oracle Apps 11i Install using Rapid Install preferably on Linux/Unix Where to find Rapid Install 11i Oracle Apps Guide This is guide by Oracle http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/r115102ins.pdf for a start Chapter 1 & 2 are enough page 13 to p 63 is enough to understand Installation) Where to find Discs / software for Oracle Apps 11i E-Business Suite : You can download it via http://edelivery.oracle.com or order it via your Metalink account . Once you got CD , please do install Apps atleast once in order to understand & to familiarize your self with Oracle Applications
3. Apps 11i File System/Software Once you installed applications 11i using above guide on Unix/Windows/Linux software then login as Operating System User & check directories while going through document http://download-uk.oracle.com/docs/cd/B25516_08/current/acrobat/11iconcepts.pdf Chapter 2 Applications File System (P39- 48) very important in understanding Database Server & Application Server Tier & various tops like DATA_TOP, ORA_TOP, APPL_TOP, COMN_TOP, AD_TOP.... If you know your applications 11i File system you know where to find particular component files & logs .
I think this is enough for keep you going for 10-15 days , pay as much attention you can on these basics as these are building blocks of your careers as Apps DBA. For remaining tips on how & from what to prepare next like AD Utility(patching, adsplice,..), Cloning ... I'll update you tomorrow .
Now you can raise your doubts/questions/issue in forum at http://teachmeoracle.com/forum (Dedicated to Apps DBA's)
Atul Kumar http://teachmeoracle.com/interview.html |
We have moved to kindly check onLineAppsDBA.com in future
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 2:28 PM
  |
|
37 Comments: |
-
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
-
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
-
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
-
link for media pack for 11i is edelivery.oracle.com
-
-
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,
I am vasu, working in Chennai, India and have been working with 11i for the past 1 year and now when I tried to install R12 on Solaris environment. The staging went on well and while installation is in progress it threw an eror.
i give below the error displayed.
Database Availability command: su oracle -c "/software/StageR12/startCD/Disk1/rapidwiz/bin/riwTDBup.sh /data/oracle/VSIN/db/tech_st/10.2.0/VISN_sunapps.env APPS/APPS" riwTDBup.sh started at Sat Oct 20 17:59:58 IST 2007
Parameters passed are : /data/oracle/VSIN/db/tech_st/10.2.0/VISN_sunapps.env APPS/APPS Cannot find environment file /data/oracle/VSIN/db/tech_st/10.2.0/VISN_sunapps.env
RW-50011: Error: - Database ORACLE_HOME connection test has returned an error: 1 command: su applmgr -c "/software/StageR12/startCD/Disk1/rapidwiz/bin/riwTDBup.sh /data/oracle/VSIN/inst/apps/VISN_sunapps/ora/10.1.2/VISN_sunapps.env APPS/APPS" riwTDBup.sh started at Sat Oct 20 17:59:59 IST 2007
Parameters passed are : /data/oracle/VSIN/inst/apps/VISN_sunapps/ora/10.1.2/VISN_sunapps.env APPS/APPS
The environment settings are as follows ...
ORACLE_HOME : /application/apps/VSIN/apps/tech_st/10.1.2 ORACLE_SID : TWO_TASK : VISN PATH : /application/apps/VSIN/apps/tech_st/10.1.2/bin:/usr/bin:/usr/ccs/bin:/usr/sbin:/usr/ccs/bin:/software/StageR12/startCD/Disk1/rapidwiz/unzip/Solaris:/usr/ccs/bin:/usr/sbin:/usr/bin:/usr/openwin/bin:/usr/ucb:/usr/ccs/bin:/usr/openwin/bin:/usr/dt/bin:/usr/platform/SUNW,Sun-Fire-280R/sbin:/opt/sun/bin:/opt/SUNWexplo/bin:/opt/SUNWsneep/bin:/opt/rsc/bin LD_LIBRARY_PATH : /application/apps/VSIN/apps/tech_st/10.1.2/lib32:/application/apps/VSIN/apps/tech_st/10.1.2/lib:/usr/dt/lib:/usr/openwin/lib:/application/apps/VSIN/apps/tech_st/10.1.2/jdk/jre/lib/sparc:/application/apps/VSIN/apps/tech_st/10.1.2/jdk/jre/lib/sparc/native_threads
Executable : /application/apps/VSIN/apps/tech_st/10.1.2/bin/sqlplus
riwTDBup.sh exiting with status 2
RW-50011: Error: - Apps ORACLE_HOME connection test has returned an error: 2
could you kindly let me know what is the problem ?
-
-
Hi Everybody ,
This is Girish ... Am an oracle DBA . I want to switch towards Apps DBA ... Please suggest some good institutes in Hyderabad & Bangalore
-
Hi
I am unable to install Oracle Apps 11i. Could anyone please send me a Installation Document on Windows 2003 Platform to gopinath.chenji@gmail.com
Thanks Gopinath
-
Hi
I am unable to install Oracle Apps 11i. Could anyone please send me a Installation Document on Windows 2003 Platform to gopinath.chenji@gmail.com
Thanks Gopinath
-
Hi
I am unable to install Oracle Apps 11i. Could anyone please send me a Installation Document on Windows 2003 Platform to gopinath.chenji@gmail.com
Thanks Gopinath
-
Hi atul this is kalyan working as core DBA and wanted to update myself with applications.Jus gone through your site and started the architecture part.Please guide me in this matter.
-
Hi atul this is pavan working as a core dba and wanted to upgrade myself with appications jus gone through ur site.Started architecture part.please guide me in this matter
-
-
hey ur doing really great yaar atul
-
hai, i want to install oracle 11i apps dba on fedora 7. please tell me how to procede installation on fedora 7
|
|
<< Home |
|
|
|
awe some work..thank you so much, Its a wondeful guide for all dba's.