How to Become Oracle Apps DBA
Posted by Navdeep Saini on December 7, 2006
“How do I become an Oracle apps DBA” I have been asked this question lots of time. Well my answer is always, “To start with, you should be an Oracle DBA”. Oracle DBA skills are must to learn anything about apps dba. You can also be a good apps developer and still become an Oracle Apps DBA (There are developer there who asked me this question !!), but route is same, learn Oracle DBA.
There are many ways to learn Oracle DBA, however for newbie’s I would suggest to start with OCP DBA(Oracle Certified Professional) learning. To learn more about OCP see:
OCP Link (Under Job Role look for Database Administrator certifications.)
Once you are good at Oracle DBA you can start learning apps stuff. Good place to start is to read Oracle Applications Concepts manual. You can find Oracle apps documentation at:
11i (11.5.10.2+ virtual) Documentation Library
You should devote time to understand oracle applications architecture. Understanding oracle apps architecture is as important as learning to walk before you run. You can read more about Oracle Applications Architecture in my Blog entry under Categories > Beginner’s Guide > 4 Apps Architecture, or simply click on:
Rest of the stuff in concepts manual (apart from chapter 1, apps archi) will be OHT (Over-head Transmission) for the beginners 
. Dont worry and just keep on reading (If you find it interesting). Believe me, I could comprehend just 20% of the manual when I first read it.
As you move on everything will start falling into its place and you will understand the concepts.
Next thing will be to learn installation. Its pretty simple and most of it is java GUI based. Installation manual is the first one in the Apps Document Doc link that I mentioned above. I will also discuss installation in my blog entry here :
At this point you would have learned two important topics in apps dba. Other things that you will have to learn as apps DBA e.g. AD Utilities like Patching and Cloning etc, Upgrade and more. (For complete list of topics please see my blog post:Main Topics)
These are covered under different Blog categories that I have created. I will keep on posting in them in future… so keep on checking my blogs……….and happy learning.
kadiyala said
hi this is kadiyala
site is excellent like atuls blog…really gud site for like us…i have one dought…am basically apps techi guy..am planing to shift..in apps dba…and how much core dba will help me…to become a apps dba…please suggest am confusing…
Navdeep Saini said
Hi Kadiyala
Thanks for reading my blog. Core DBA is really important for an APPS DBA. Although I have seen working without much core DBA experience and still surviving. Also different people have different opinion but if you ask me, at any client site you go you will be labeled at “DBA” and that will include core dba stuff also. I would say dont take chance and learn some basic core dba stuff before shifting your focus to Apps DBA. It is likea foundation on which you will build your Apps DBA competencies.
Good luck.
Nav
asha said
Hi,
This asha,i am working one of m.n.c company as a pl/sql developer.
i need some guidline in Installation Process steps of orcale9i database exited hole objects in one machine to anther machine.
Scott Birkhead said
Thanks for the site…I’m a recruiter looking for my first Apps DBA and I know a lot more now about what one is and how it’s different than a production-side or even development-side DBA.
Cheers,
Scott Birkhead
Denver
Navdeep Saini said
Hi Scott
I am gald my blog was helpful to you.
regards
Nav
WJ said
Hi Navdeep
Is there any way we can get the detail of all the routine tasks of an apps dba ?
best regards.
WJ
Vicky said
Hi Navdeep,
I’m basically an Oracle Apps functional consultant for the past couple of years. I have been asked to move to Apps DBA testing now. What do you think about the transition and your comments whether it is easy to switch . Please comment at the earliest .
Jack Nicholson said
Hi Navdeep,
Yes.You are exactly right. To become Oracle APPS DBA we should need to learn first Oracle DBA. Because after clearing concept of Oracle DBA it becomes easy to learn and understand Oracle APPS architecture and concept.
Very good tip has been provided. Appreciate working. Kindly keep it up.
Navdeep Saini said
Thanks.
hi said
hi i am did my mca and oracle OCP and now i am looking for a job but here they are asking only 2+ and 3+ so how can i get a job if u know just tell me for my grate job looking for ur mail
Navdeep Saini said
Not sure where you are located. I would suggest look at some of the jobs sites local to you.
Gud luck!
vijay said
what is the daily responsibily of apps dba. Please email me in detail. if interviwer ask apps dba responsibitity. Once you enter in company till u leave the company please share it my email id vijaydba31@gmail.com thanks for ur time
Mallikarjun said
Hi Navdeep,
I am looking for consultant who can process my resume for Oracle APPS DBA. Actually I am not in IT field but recently moved from chemical fileld. I have masters in chemistry. I worked many years in USA in chemical filed. Now I am Oraclcal DBA courses. I have finished Sql, Linux, Oracle DBA and Oracle APPS DBA. PLease let me know if you anybody who can process my CV for oracle APPS DBA. I have green card.
I appreciate your kind suggestion.
Thnaks,
Mallikarjun
Nishant Patel said
Hi Navdeep Saini,
I am Fresher at Oracle Apps R12 DBA at corporate level. though i have completed OCP in 10g. Its very difficult to understand Apps r12. And right now nobody is teaching me that how to work in oracle apps so i prefer to read your blogs daily.. and it gives me god knowledge about oracle apps DBA.
So i heartly request you to send me some documents which are very useful for beginners for oracle apps r12 DBA.
Thanking You,
NISHANt PATEL
Rajesh said
Hello sir,
I have one doubt,thai i finished my course with sql server dba. and finaly i got job in dba team but till now i m not in projec, so i want to learn oracle dba….please tell me what to do……
prithviraj chavan said
hi Navdeep,
Very nice and informative blog. I am really impressed with some light statement you made while writting the blog.
Important thing i want to ask is i am OCA certifed guy(basic knowledge of SQL and PL-SQL and worked on oracle prod support project) but somehow landed in tesing field now a days (functional and system testing). Now want to change to Oracle Apps functional (as i am not comfortable with coding). Can you please provide me some inputs like how to start and is there any chances for jobs for freshers. I have already started reading and watching tutorial videos but still not able to figure out where to start….as everything looking strange.
Thanks,
Prithviraj.
syed faraz said
Hi Navdeep,
I am into oracle development (SQL/PlSQL) having 3 years of experience. I am very much interested in becoming Oracle DBA/Apps DBA. How do I start with it. I want to know that do DBA’s has to perform night shifts also. Let me know on this.
Thanks
Syed Faraz
India
vamsi said
i am looking for job in apps dba i want some stuff in r12