• Find us:
    +1-669-900-5138   |   +44-203-372-5553
  • Free Newsletter

    Get Latest Updates

  • Make Training Enquiry


  • Categories

  • Archive

  • How 2 become Oracle Apps DBA

    Posted by "" in "11i, basics, Beginners" on 2006-07-29

    Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone

    [Updated broken links on Dec 12, 2011]

    Are you looking for Apps DBA training ? ( Free Ofcourse )
    Are you a DBA and looking for Career or Job in Apps DBA ?
    Are a Oracle DBA and interested in Learning Oracle Apps or want to become Oracle Apps DBA ?

    then you are at right place

    Image taken from Application Architecture Document

    There is lot of Oracle Apps Training material available on net/Oracle Site at the same time lot of training Institutes are providing Oracle Apps DBA, Now its up to you if you want to learn E-Business Suite at your own or want a formal training as Apps DBA. Lets start with what all you should learn as an Oracle Apps DBA.

    First thing is you should be Good in Oracle Database Skills and I assume you are already very good as DBA or don’t need any formal training as DBA. To become Oracle Apps DBA first and important thing is that you should be very well familiar with Oracle Applications/E-Business Suite Architecture . Give as much time as possible Architecture & understand all basic component . Its few , Webserver (Oracle-Apache), Forms, Reports, Concurrent Manager, Discoverer and Database. (Discoverer you can skip & can read later but remaining are building blocks of Oracle Applications. Now where to find basic Architecture and related Architecture ?

    EBS Documentation

    this link contain E-Business Suite but its hell lot of guide & you will not be able to finish it until you die. So from here Open Guide “Oracle Applications Concept” & read chapter 1 only that too just page 1 to 19 ( Only 19 pages & your Basics is done ) I think its not much . If you understand any thing in that put a comment on this Blog & I ‘ll definately Explain or Can even mail you .

    So moving on to next part of your Oracle apps DBA training , you should know Installation. You can try installing oracle E-Business Suite on your test systems for that you can pick guide
    Oracle Applications Installation Guide: Using Rapid Install In documentation location mentioned above . This might sound tough for first time but believe me it pretty simple , Everything GUI ( You can ignore creating Staging for Dump but if you are a oracle DBA you can do it pretty well ) Now if you encounter any Issues in Installation you can create Metalink Tar or if you don’t have metalink Account you can post questions in Oracle E-Business Suite Forum .
    So this conclude Two important aspects of your Oracle Apps DBA Training , I am again focusing on Architecture of Oracle Apps is very critical in APPS DBA Training. If you like above material & still want to read remaining parts of Oracle Apps Training like, AD Utilities for Patching (Very Important for DBA), Cloning, Upgrade wait for my Next Blog I will Update this blog as soon as I create tomorrow or day after , till that time clear your Oracle Apps Concept . Believe me learning Oracle Apps is very simple if you Study carefully & with Interest.
    Plsssssss leave comment.

    Now you can raise your doubts/questions/issue in forum at http://teachmeoracle.com/forum (Dedicated to Apps DBA’s)

    Oracle Apps DBA
    Solution to your free apps 11i DBA training

    222 Responses to “How 2 become Oracle Apps DBA”

    1. Anonymous says:

      Looks Good for Beginner.


    2. Anonymous says:

      good work buddy..keep it goin..pretty much useful to everyone.


    3. Anonymous says:

      Really helpfull.Keep going.


    4. Anonymous says:

      Atul ur first session was great please donot stop continue.ther are very few in this world like you.you are very Good.

    5. Atul Kumar says:

      Thanks a lot, I’ll try to be regular as long as I am not piled up by work . Keep checking what sponsors has to say on right side menu bar.

    6. Anonymous says:

      really you are doing a great job.

    7. Anonymous says:

      Hi Atul,

      This is really a great effort. I was looking for some
      kind of Oracle Apps DBA training for quite sometime.

      I really appreciate your time and efforts. Please keep
      up the good work.

      With best regards,
      Kailash Raman.

    8. Anonymous says:

      Hi Atul,

      It is really nice someone teaching. Thanks a lot for the same. Infact i was looking for someone who can guide me on the same. Keep posting. I found it very useful. I need your help.

      S Govindarajan

    9. Atul Kumar says:

      Hi Govindarajan,
      Thanks a lot, I am just sharing my knowledge with others & learning from others questions & dobts . You can mail me anytime at atul_iiit@yahoo.com


    10. Anonymous says:

      Hi Atul.
      I am already working as an oracle DBA. i have good concept knowledge of oracle database. i participate regular oracle forms Mr. Tom kyte site.. just like Mr. Tom kyte u do some work for student and professional. right now i have no idea about Oracle Apps DBA but i want to learn. i hope u will help me.

      Thanx Dear
      Keep in touch.


    11. Atul Kumar says:

      You can mail me at atul_iiit@yahoo.com whenever you need any info/query.


    12. Anonymous says:

      It seems to be instresting to learn about Apps DBA now.

    13. Anonymous says:

      Hi Atul,
      Very fantastic and impressive information for new bies…..
      How long can it take for an Oracle DBA to become Oracle Apps DBA?

      Abid Malik

    14. Atul Kumar says:

      Thanks a lot for compilment . About time to become apps dba, It depends on individual & how much time He/She is spending + if learning is on Job or at Home .

      I have noticed that learning on Job is much faster.


    15. Anonymous says:

      This work has to be appreciated… definitely.. Atul…, Flowers to you..!!!


    16. Atul Kumar says:

      Prasant & everybody ,
      Thanks a lot for your compliments . Do send me feedback how to improve & what topics you want to hear from me.


    17. Anonymous says:


      The efforts and the work you have done is very good. Thanks for guiding to learn the APPS

    18. Atul Kumar says:

      Thanks a lot for compliment, you can download 11i software from



    19. Ramana says:

      Excellent work Atul. Great. Keep it up. You are infact setting up a good example of “Sharing” and doing good to the society.

      I have problems understanding “Forms Listener Servlet Architecture”. Could you please explain it in your words and also its advantages.


    20. Atul Kumar says:

      Thanks a lot for all those good words. You raised very good point . Forms can run on both socket or servlets by default sockets. I will explain in detail about forms in servlets with Advantage & disadvantages of using forms via servlets and how to configure it in my coming posts.


    21. Ramana says:

      Thanks a lot Atul for your prompt response.

      I would be waiting for your post on “Forms Listener Servlet Architecture” and their advantages.

      I would be following your posts regularly as I have started learning “Oracle Apps DBA” with your help. But if possible could you pls drop me a mail on ramana_orac@yahoo.com when you post info on “Forms listener server architecture”

      Thnx & Regards

    22. Vignesh says:

      Its good for people like me looking for position in APPS DBA from DBA.

      Thanks. Vignesh

    23. Vignesh says:

      This is good for people like me to begin APPS DBA from DBA


    24. sudhir says:


      you are really doing a great job. this is my first day i happen to hit this web-site. i was also looking for something which would give me a start. i am already a DBA, so now i would like to pickup APPS DBA.


    25. sudhir says:

      you are doing great. this is my first hit on such a web-site, in all my browsing years. i was looking for some information on the oracle apps, as i myself am a ORACLE DBA. This would give me a great start.

    26. Atul Kumar says:

      I Wish you could find everything you need as Apps DBA in coming years from thius site & my other site Teache Me Oracle

    27. Anonymous says:

      Hay Atul,

      Its Precise and to the point to starters …. Good work ….


    28. Atul Kumar says:

      Thanks a lot to everyone for every one for making this site huge success.

      Do ket me know if you want to know about any topic in apps & thats not included here .


    29. Anonymous says:

      Hi, Atul

      Your work is very execllent. If i can help u for this work its my pleasure.


    30. Anonymous says:


    31. srikanth says:

      hi Atul,

      this is srikanth already working as Apps DBA this site will be usefull for beginners

      srikanth bolagani

    32. Anonymous says:

      Hi Atul kumar

      Good work, thanks lot

      Realy help full to the beginners
      i am also a beginner for oracle apps dba.

    33. Anonymous says:

      Hi Atul kumar

      Good work, thanks lot

      Realy help full to the beginners
      i am also a beginner for oracle apps dba.

    34. Jagdish says:

      looks very simple…

    35. Atul Kumar says:

      Thanks a lot to all of you for your comments . Could you please suggest how to improve here & Site

      http://teachmeoracle.com (Dedicated for Apps DBA’s)


    36. Anonymous says:

      Thanks alot This site is very useful.


    37. Anonymous says:

      Hi Atul it’s really gr8 to see such a website..i will also coprate with u …

    38. Atul Kumar says:

      Thanks a lot for your support.

      Now you can post your questions/doubts problems in Forum dedicated to Apps DBA’s at


    39. Anonymous says:

      They are really helpful
      keep going
      thanks a lot

    40. kk says:

      hi atul

      this is kumar.am a tech consultant and setups and sysadmin for oralce app’s .really am confusing about my future so am planing to learn app’s dba .
      am in chennai am working for one of the major it company..can any one suggest wich is gud institute for app’s dba or any one teaching who is working .any body know’s let me know
      my e-mail id:sullank@gmail.com

    41. kk says:

      hi atul

      this is kumar.am a tech consultant and setups and sysadmin for oralce app’s .really am confusing about my future so am planing to learn app’s dba .
      am in chennai am working for one of the major it company..can any one suggest wich is gud institute for app’s dba or any one teaching who is working .any body know’s let me know
      my e-mail id:sullank@gmail.com

    42. Atul Kumar says:

      KK few training Institutes are listed at http://teachmeoracle.com/training02.html


    43. Anonymous says:

      Looks pretty good for beginners.its evry uselkfulfor all and most useful for a new career launch IN Apps.KeepGoing ..Your should grow good as you keep good in sharing your knowledge

    44. Atul Kumar says:

      Hi Anonymous,
      Thanks a lot for your wishes, I need some of you to help other Budding Apps DBA in answering their questions/doubts at forum http://teachmeoracle.com/forum dedicated to Apps DBA’s

    45. Anonymous says:

      Hi Atul,
      I would like to publish my documents/experiences in http://blogs.oracle.com/ . How to do that.

    46. Atul Kumar says:

      You can request to put a link of your blog to http://blogs.oracle.com . I don’t know what they look for but if you could share your blog name with readers

      You can have blog space at http://blogs.oracle.com/yourname
      only if you are oracle employee .

      If you are not from oracle then put it on some site like I am doing on blogspot.com

    47. Anonymous says:

      Thanks for the help!

    48. Kevin Krause says:

      good stuff as always!

    49. Alan says:

      This looks a great site for a beginner such as me. kepp up the good work.


    50. Atul Kumar says:

      Hi Alan ,
      Thanks a lot for your compliments ….


    51. Anonymous says:

      hi atul..first of all thanks for sharing ur knowledge ..
      I am NOT a DBA but a java developer who uses oracle a lot for procs, functions,queries etc..basically PL/SQL ..i feel i m okie in all that..i wanna switch to oracle Apps ..and NOT oracle apps DBA …do u have any reference where i can start from? please if u can reply back at letseewatsup@yahoo.com i would be glad. THanks a TONNNNN!

    52. Atul Kumar says:

      You can start with Anil Passi’s site for technical apps development at http://oracle.anilpassi.com


    53. Anonymous says:

      Hi Atul,

      Thanks for what you are doing.

      Keep up the good work

    54. Anonymous says:

      Hi atul
      Iam new to oracle . so plz tell me how to be strong in oracle basics . In which areas i have to be strong ……Wat are all concepts i should be strong

    55. Atul Kumar says:

      In my views most important thing you should understand is Oracle Database & Apps Architecture & to understand various components of Apps.

      Then you can focus on Patching , Cloning …

    56. Anonymous says:

      hello friend atul
      you have done a wonderful job,Its really a nice site.it will help lot for those who can’t pay a huge training fees. I really appreciate your job. I will definitely become a aPps dba.
      thanks and regards;
      sadashiv shinde(oracle 9iocp_dba trainer pune)

    57. Atul Kumar says:

      Thanks Sadashiv


    58. Anonymous says:

      Hi Atul ,

      U r doing a great job ..Its like showing a way to the one who shows has lost guy ..

    59. Anonymous says:

      Great job,Simply classic energetic information i had,Myself Thivagar & beginner in DBA field preparing for OCP 9i,very much useful to fresher like me & Hats of thnaks Atulji, Keep goin on & on …
      Lots of Heartly blessing to u & ur family.

    60. Anonymous says:

      Great job,Simply classic energetic information i had,Myself Thivagar & beginner in DBA field preparing for OCP 9i,very much useful to fresher like me & Hats of thnaks Atulji, Keep goin on & on …with lots of Heartly blessing to u & ur family.

    61. Santosh Kulkarni says:

      Thank you for a great compilation of the Oracle. It really was helpful.

    62. Atul Kumar says:

      Thanks a lot !!!

    63. Sunil says:

      Hi Atul,
      Good work. Impressive. Although, I do not use the site, but I am very much impressed on the amount of work you have put in.



    64. Atul Kumar says:

      Thanks a lot for those good words. Your comments & readers feedback are my inspiration. Do let me know if I can try improving somthing on this blog to make it useful to everyone including you :-)

    65. Anonymous says:

      thanks a lot it is very useful for a beginner like me
      keep going

    66. Atul Kumar says:

      Thanks a lot anonymous

    67. Vinod says:

      Your site seems very interesting! Thank you for your hard work.

    68. Atul Kumar says:

      Thanks a lot Vinod

    69. Anonymous says:

      Hi Gurudev,

      I just started learning Apps DBA.

      Pls bless me.

      Rakesh Reddy

    70. Dilesh says:

      Hi Atul,
      I am really touched the way you put togather facts for Apps DBA. You are in UK but due to your auspicious work, you have reached everywhere.
      I am certified 10g DBA and want to start Apps DBA. Where can I find books/references?


    71. Atul Kumar says:

      Thanks a lot .

      All Apps Guides are updated in above post itself at


    72. Dilesh says:

      Hi Atul,
      It is really nice to have your email so quick. I book marked the link for future reference. As a DBA, I have setup 9i, 10g databases from scratch and applied patches,performed backups and installed 10g Apps server and configured report servers. I have gone through Oracle Financial 10.7sc intensive training in India, will it help me in becoming Apps DBA? I am a really good developer as well and got certification for developer 6i Release 2. Now, looking to my exposure, will you please tell me what step should I follow to start ii1 Apps DBA? Do you think that classroom training is required for Apps DBA?

    73. Atul Kumar says:

      I think its more than enough. I would suggest you instead of class room teaching start with hands on Installation, patching & cloning 11i.

      Good luck for your Journey towards Apps DBA

    74. Dilesh says:

      Hi Atul,
      Thanks for your inspirational email. I will follow your suggested path.

    75. Neeraj Bhatia says:

      Hi Atul,

      This is really a great effort. Keep Doing.


    76. Neeraj Bhatia says:

      Hi Atul,

      This is really a great effort. keep Doing.


    77. Anonymous says:

      Hi Atul ,

      Tis really a great effort , keep it up .

      Prasanta Patnaik

    78. Atul Kumar says:

      Thanks Prasanth & Neeraj

      Atul Kumar

    79. Anonymous says:

      excellent blog

    80. Anonymous says:

      Hey Atul,

      I am a friend of Dennis who works in Oracle Bangalore and He spoke very high of you and also told me about this site. Its a wonderful site. I think this site has become similar to asktom. Hats off to your good work Pal.


    81. Atul Kumar says:

      Hi John,
      Thanks a lot for your wishes .


    82. qAnand says:

      Hi Atul,
      This is really a great site especially for beginners.
      Can you throw some light on Oracle Alerts especially Event Based Alerts?
      Waiting for your update.


    83. Atul Kumar says:

      Anand ,
      Thanks a lot. I am not very good in alerts but will try to cover in future whatso ever I know

    84. qAnand says:

      Thanks for your assurance. I wanted to know one more thing. Is it possible to configure HTTPS only for the login screen, so that the username and password can be pass through internet encrypted instead of clear text? My organization does not want to do any investment in procuring any certificates. Is it possible to accomplish this without making any investment?

      Waiting for your update….


    85. Atul Kumar says:

      Yes you can tweak around using sso. For free you cabn use test certificates comes free with oracle HTTP Certificates

    86. qAnand says:

      Thanks for the update Atul. But can you please elaborate? Probably a URL or a link in your site would help. We are not using SSO here.


    87. Atul Kumar says:

      Anand ,
      To be frank it is bit complicated (not very straight forward) I did some work on 10g AS Integration with Apps for SSO but I don’t to post it on site at this minutes . Here is metalink note which you can refer metalink note

      233436.1 Installing Oracle Application Server 10g with Oracle E-Business Suite Release…

      & then configure SSL for HTTP Server on SSO (Infra tier).

      You have to study a lot for this

    88. qAnand says:

      Thanks Atul for the metalink note.


    89. Anonymous says:

      Many Thanks to you Atul…for offering your genuine help in teaching Oracle!!

      Aditya P

    90. VeeraReddy says:

      Hi Atul, Just now I started this training .It is looking too good. I’ll try to be regular

    91. Atul Kumar says:

      Thanks Veera.
      Pass it on to your friends as well & do let me know if you need any further information

    92. Everett says:

      This site is exactly what I’ve been looking for. Thank you


    93. Anonymous says:

      Hi Atul,

      How are you, My question is how do we configure PCP on 11i Apps.Please give some tech Docs

      Thanks & Regards

    94. Atul Kumar says:

      ASD Follow

      278816.1 How to Setup Parallel Concurrent Processing using Shared APPL_TOP for RAC Environment

      Kindly use forum http://teachMeOracle.com/forum for such doubts in future

    95. Anonymous says:

      You are a decent man. It’s hard to find people who would take up a noble deed like this. Goddess Saraswathi be with you always..

    96. Anonymous says:

      It really Helped me alot but please let me know whats the difference between DBA and Apps DBA??? the operations are same onyl clonning and patching and updation is what apps DBA has to do ………..please correct me if am i wrong ….

    97. Anonymous says:

      I am not an Oracle DBA, But interesed in Apps DBA. Is it possible to learnn it?

    98. Atul Kumar says:

      Yes !!

    99. Anonymous says:

      Hi Atul,

      This is priyanka. I m very much interested in Oracle Apps. I not DBA ya but i have learnt Oracle 9i during Btech. Can i learn Oracle Apps with having much knowledge abt Oracle. If no then pls guide me how to start and wat all i should study.


    100. Anonymous says:

      Hi Atul,

      I m not DBA but want to learn Oracle Apps though i have studied DBMS and Oracle during Engineering. Cud u pls guide me how to start and wat all Topics shud i go through to become Apps DBA

    101. Atul Kumar says:

      Follow section under For Apps DBA Beginner’s in left menu bar for start

    102. Bhushan Kumar says:

      Hi Atul:

      Thanks forsuch a good knowledge giving it free.
      I am a DBA, wana to nbe Apps DBA?
      Will the study at ur site will be enough or I need to go through something else?

      Bhushan Walde

    103. Atul Kumar says:

      For a start this blog should be fine but you have to read more from Oracle books for specific issues

    104. Anonymous says:

      Hi Atul,
      All the Apps DBA Info on same page this is really great effort. Keep it up, its very useful for all.

      Dinesh (Govind)

    105. Anisha says:

      Hello Atul
      Well one can’t stop appreciating all the effort you are putting into building this blog.Thankyou so much.It is overwhelming ….everybody here seems to be a DBA before they considered APPS Dba well, i am not a DBA and what are the other books I need to read along APPS books.Two others asked you the same and u replied saying to start from the beginners section…but it is unnerving to see ” First thing is you should be Good in Oracle Database Skills and I assume you are already very good as DBA or don’t need any formal training as DBA” :( please help

    106. Anonymous says:

      very helpful, thanks

    107. shiva da karthik says:

      Awesome work buddy… Thanks

    108. Sanjeev says:

      I am very thank full to giving such information

    109. Ravi Prakash says:

      Hi Atul,

      Good Work, Started my First Day Class :-) to be a APPS DBA. I am planning to move ahead, with E-Business,

      Cheers & Keep it updated to help people like me

      Ravi Prakash

    110. Elwos says:

      Hi Atul,

      very thanks to u to help pepole
      to their self in road of oracle
      APPL DBA.

      Thanks and


    111. Anonymous says:

      Hi Atul,

      Very thanks to you to help us to
      become oracle app Dba .

      Thanks and


    112. Rajesh says:

      Hi Atul,
      The Documentation will really help a beginner like me. I am a beginner in apps dba and I need to know if Oracle applications can be installed on a home PC ? I mean in one PC with a configuration of 512 MB with 40GB hard drive or do I need to look for a sever in Web, something like webhosting ? If so, which is my best option ?



    113. Atul Kumar says:

      You don’t need server and can be installed on normal computer but you might need more CPU and harddisk.

      Check installation guide with prereq. for installing apps

    114. Anonymous says:

      Hi Atul,

      First of all a very big thanks for the wonderful help that you have been providing for all learners like us.I would like to know if there is any site where we can get more knowledge on core DBA as well.
      If so that would also be a great help again …
      thanks & regards

    115. Atul Kumar says:

      Hi SEha,
      Thanks for these nice words. For core DBA I am not aware of any site which provide free training but my recommendation . Go to oracle documentation and pick oracle dba documentation nd go through them

    116. soiled_cheetah says:

      Really i am surprised why i didnt know this website earlier. Man your Efforts soooo much Appreciated. Thanks a lot.

    117. Samer says:

      Dear Atul,

      is it possible that the client ( desktop tier) connect to forms server without the web server ( apache) and in case the apache server is down what will happen?


      Samer ALJazzar
      Oracle DBA
      NBK – Kuwait

    118. Atul Kumar says:

      No , Initial connection will always be via Apache in standard Oracle Applications 11i

    119. nagesh says:

      Hi Atul,

      I have basic knowledge of oracle 9i database, i am looking my career as ORACLE APPS DBA. Will it possible for me to achieve that.

      I had been with the Oracle application concepts, im not finding any difficulty in understanding them.

      It really sounds good.

      Note: I dont have depth knowledge on database. I am working as UNIX Administrator.


      Nagesh Prabhu

    120. Atul Kumar says:

      Yes Nagesh, you can be good apps dba provided you focus on basics and work hard

    121. suhag says:

      This is a best.
      but give step by step giude.
      This is perfect for every one.

      Suhag Shukla(ORACLE DBA)

    122. Atul Kumar says:

      Thanks Suhaag, Step by Step will take quite a lot time for each post but I’ll try to put as much detail as I can in my future posts..

    123. Anonymous says:

      I have gone through the material you recommended (11iconcepts pg 1-19). It is quite interesting not very complicated and not long just as you had said.

      So basically, the aim was to grasp the architecture of the E-Business suite.

      Now am looking forward to the installation part of it.

    124. Anonymous says:

      Hi Atul,
      Can U plz Suggest a blog or site 2 learn Oracle 10g DBA by Step by Step

    125. Atul Kumar says:

      I am not aware of step by step but few dba blogs are mentioned in blogroll

    126. Anonymous says:

      hi Atul, Ur blog is good but i found ur blog is just overview on all the topics, why dont u go more deeply on all the contents.

    127. Atul Kumar says:

      Thanks for feedback, yes I agree majority of posts are on overview and reason for that is most of guys I met are not clear of concepts even so I thought of dicsussing them first though I have some posted on few things in detail as well . Do let me know on which topic you want me to cover in detail and I’ll try to cover them

    128. shobhit says:

      Hi Atul,

      This is Shobhit. I m very much interested in Oracle Apps. I am 10g Certified Professional but i am a fresher. Can i learn Oracle Apps . If yes then please guide me how to start and what all i should study.And is it good to switch from enterprise to Apps.

      And in last your blog is really having much to learn.

      Shobhit Saxena

    129. Anonymous says:


      Oracle DBA’s life is not a cool one ,try to switch to application development for a peaceful life .

      Vinod (Oracle DBA)

    130. Shakeel says:

      I am a new DBA in Oracle Application 11i. I was worried, how can I learn this. At last I found this site.

      It’s a ggod start for me. Material on thsi site is more helpful to become Oracle Application11i DBA.


    131. Anonymous says:

      Hi Atul,

      I am a beginner for Oracle Apps,I am interested in pursuing a career.I refer the material you provide.I would like to practice the installation and the patching,can u guide me how to go about. I have an external hard disk, can I install the linux and the oracle Apps on the Hard disk, if so how can I or if there is any other alternate way that i can practise.Could you please help me out..


    132. Diwaker says:

      Dearest Atul
      Thanks a ton, this would become an highway for 11i training, great work, splendid……
      Divaker V Vittal
      Oracle DBA

    133. Pankaj Sharma says:

      Dear Atul,

      Keep up the good work. Its amazing to see you give simple solutions to the problems which seemed nearly impossible before getting to your site.

      warm regards,
      Pankaj Sharma

    134. yasser says:

      Hi Atul,

      I believe its an exact web site for Oracle Apps DBA, But can u plz clear my doubt.

      Am an high end Oracle DBA having 3 yrs exp in HP,configured more than 20 Dataguard for banking DB’s and a lot of hard core performance tuning work!!!!!!
      So is it proper way that i can switch to Apps DBA domain….
      Can u plz compare Oracle DBA and Apps DBA in terms of Salary,demand in market,good future.
      Your guidance will be highly appreciable…..


    135. Sajid Khan says:

      Dear Atul;

      Gr8 work, please continue to support us.

      I am a beginner in this field and i need a lot of support from people like you. Please keep on doing the good work.

      I am interested in your training program that you are going to conduct in India, please Email me more info regarding that.

      Thanks again.
      Sajid Khan
      mail4saj@gmail.com ; mcasajid@gmail.com

    136. Sridhar.K says:

      Dear Atul,

      I am an Oracle DBA looking a career in Apps.
      You are doing excellent work buddy.

      It is very helpfull for people like me.

      I am astonished at your patience level.

      Keep it up.

    137. Compupasha says:

      WOW ! it is a great site, unfortunately I didn’t find it earliar, your effort is helpful to the computer professionals particularly who are interested to become Oralce Apps DBA.
      Great Job Atul, keep it up……….

    138. Suhag Shukla says:

      Hi Atul,

      can you give about info.( 1Z0-233 Oracle 11i Install, Patch and Maintain Applications)

      about book.


    139. Santhosh says:


      This is the best information site i have ever seen.

      Keep up the good work dosth.


    140. Jack says:


      Intersting post!…

    141. Lucky says:

      Atul , u have done a gr8 job.

      I have a query for u . Basically iam a Oracle DBA, but got an oppertunity to work as Apps DBA. Here i don’yt have any one to teach me iam learning og f my self and maintaing the Production system.

      If possible can u mail me the procedure for cloning my Production system.

      Thanks in advance.

      Saudi Arabia,

    142. Jehad Khwyter says:

      Good job mate, I am working on Oracle Apps 11i environment.. it is really interesting to keep testing your professional skills :) … can you please send me your email, so we may do some business…

      Thanks body

    143. paulofp says:

      Hi Jehad,

      Do you whant what e-mail? Mine?

      BEst Regards,
      Paulo Portugal.

    144. paulofp says:

      Hi all,

      Just a clue, if you want to really learn it, install it and then practice a lot(install patchs,use everything of adadmin, add languages, crash you database, rollback configuration,etc).

      Best Regards,
      Paulo Portugal.

    145. Atul says:

      Thanks Jehad,
      You can contact me at

      atul @ onlineappsdba.com

    146. Raghu says:

      Hi Atul

      I have been following your site for past couple of months. Its very informative but one suggestion I have is that for people who don’t have access to metalink and oracle support, could you not create a FAQ of sorts where you can put in the frequent problems which have been encountered by you and the solutions for those problems.
      Your site is nice but there’s too much theory in it…Or maybe thats why you have those webinars/Online Training on the site….

    147. krishell says:

      Hi Atul :) u r Cute ;)

      Can you send please 1z0-233 sample questions to

      Thanks a lot,


    148. Arjun says:

      I think it would help a lot for me and others….))))

      thank u buddy

    149. Devendra says:

      Hi Atul ,

      First site I have seen where information provided is consistent , accurate and up-to-date.

    150. Nadjib says:


      very goog site, and the idea is is the greatest


    151. Arshad says:

      Hi Atul,
      God bless you for this good work. I’m very new to Apps DBA responsibility , with just about 2 yrs of experience as Oracle 10g DBA ,I’ve have a long way to go.But I’ve greatest penchant for 11i Apps.I’ll keep in touch with you for any relevant enquiries/discussions.

      Thanks again.


    152. sohail ahmad says:

      Thank very good for anyone who want to start career in oracle apps dba.
      i am new and yet not install oracle apps yet.today i will try to installl..
      but your suggestion are very important for me …
      please guide me because i am new and want to learn oracle apps ..


    153. Muhammad Umer Iqbal says:

      Hi Atul,

      You are doing a fine job. Pls guide me; I am working as a DBA on Oracle 10g Server. My Database knowledge is fair, not so good. I want to switch to APPS DBA. How to step further ? Can APPS DBA study will improve my Database Knowledge ? Little Confused !

      Muhammad Umer Iqbal

    154. murugharaj says:

      hi Atul,

      i worked in a comp for some months,during my training i found that i was most interested in DB field.i have some knowledge in sql,but i dont have any knowledge in oracle,one of friend told me about this oracle 11i apps DBA course.i dont know whether i can do this course,since i dont have any knowledge in oracle.morever i dont have much industry experience.please advice me about this.


    155. Atul says:

      Yes, you can learn/become Oracle Apps DBA but you have to practice a lot. (If you wish to be expert in this domain)

    156. abc says:

      for Umer, you need to work harder to achieve something

    157. inder says:

      Hi Atul ,

      I have a question to ask , can I install Oracle apps on my Home PC for practice??

      Please assist

    158. Atul says:

      Yes inder you can install as long as you have enough memory, disk and right o.s.

    159. faiz Ahmad says:

      Hi Anil,

      I am a Oracle Apps Techno Functional Consultant and wanted to learn Oracle Apps DBA. Can you please suggest from where I can start.


    160. sanbala says:

      hi atul,

      do u know any “oracle apps dba” traing institute in sheffield(uk). or is there any job opportunity for “oracle dba(production)”.
      if i have 3yrs experiance “oracle dba(production)” and if i want to move as “oracle apps dba” which topic i should select during the apps dba course?

    161. Kaushik says:

      Hi Atul,
      Need your expert advise,
      I need to make a major decision in my career.I’m basically into oracle apps functional domain since 2 years and have now been asked to move to Apps DBA . Is it good considering that i have very little idea about DBA .
      Please suggest as to what is the learning curve for picking apps dba skills so as to work in a decent situation without much help.

    162. nswakn says:

      Hi Atul,

      I m Mohammed Ashfaq Hussain from saudi arabia working in a Ministy, i m Core DBA & i know basics of Apps DBA i would like to become very good in Apps 11i / R12 so thanx very much to supporting us..


    163. confusedkid says:

      Hi Atul,
      I work as a performance tuner and am planning to move into Apps DBA as i find it intresting. I hope I can learn much from this site.

      I have a question though- being a DBA, you have to be in shifts. How do you manage your personal life with shifts. Especially if both hus. and wife are working?


    164. Ram says:

      I’m beginner for oracle APPS DBA.I’ve got knowledge in oracle DBA..so could plz advice me how to become a APPS DBA

    165. Atul Kumar says:

      Good Question (how to become apps dba)

      My tips

      1. Go through Oracle Apps Architecture Guide
      2. Go through Oracle apps Installation Guide
      3. Install Oracle Apps
      4. Go through file system (physically on server) and from Oracle Apps concepts guide
      5. Learn Start/Stop of apps
      6. Go through ad utilitites guide
      7. Apply apps patch using adpatch
      8. Check ad controller adctrl to see worker status
      9. Clone apps instance using metalink notes
      10. Finally try backup

      This should cover most of day to day task for apps dba’s

      For next level learn Advanced deployment like
      1. Mulitple Middle tier configuration
      2. Setting load balancer and DMZ
      3. Integrating apps with OID/SSO
      4. Upgrade from 11i to R12
      5. Confihuring SSL
      6. Upgrading tech stack in apps
      7. Upgrading database with apps
      8. Configuring RAC with apps database

      For documentation check http://www.oracle.com/technology/documentation/applications.html

    166. Hitesh Tomar says:

      Hi Atul,

      Undoubtedly you are really doing good job.

      Would you help me out with some information on Oracle Apps 11i Functional as i am planning to do this course and also about the future prospect and scope for this course.

    167. Ash says:

      hi Atul,

      I want a conceptual concept of Oracle Apps like
      — what exactly the six different servers contains.
      — is it same as our database server.
      — what is the archietecture of these six servers.
      — where the actual html forms/ frx files/ report files are stored etc…

      I am new to the Apps.

      Please reply


    168. Atul Kumar says:

      – what exactly the six different servers contains.
      Database Server, Web Server, Forms Server, Concurrent Manager Server, Admin Server, Discoverer Server (This is for 11i)

      – is it same as our database server.
      Database Server for apps is same as standard database server with some additional things like Autoconfig under apputil directory in Oracle Home. Forms & web server are based on Oracle Application Server

      – what is the archietecture of these six servers.
      Check Oracle Apps Architecture Guide

      – where the actual html forms/ frx files/ report files are stored etc…
      On application tier under APPL_TOP under their own product directories (check file system under Architetcure Guide)


    169. Ash says:

      thank you atul for your reply

      is there specific reason for dropping discoverer server in 12i architecture


    170. Ash says:

      Hi Atul,

      for basics i read Ch 1 & 2 of Oracle Application Concept.
      I installed R12 on my test machine.

      but still, not getting clear idea.
      for more basic knowledge which chapters should i read either from concepts or from installation guide.

      please suggest.


    171. pinaki007 says:

      Hi ATUL,
      nice post!

    172. Rohit says:


      I am workin as an ERP Administrator and had plans to switch to Oracle Apps DBA. I am OCA in Oracle 9i (SQL and Fundamentals). I have conceptual knowledge of Oracle DB architecure and it has always been my fav subject. For I get chance to work in real time on Oracle few time like installing Oracle Db, crating table, indexes, altering users, access level etc. My total exp is around 6 yrs. Can you please suggest me if I can swith over to Oracle Apps DBA (as I am ERP Admin, my knowledge of working in ERP will help as understand modules, patches, deployment, etc..). Reading above guidance about learning Oracle apps DBA as given me morl support that yes it is not tough. Can you pls advise me how should I pick it up and can swith over to ully Oracle apps DB profile.?

    173. venky says:

      i am working as oracle core DBA, I would like to switch to apps DBA, so its nice to learn the conecpts here.

      thanks alot

    174. srinivas says:

      thanks for the information,its very useful for me..

    175. narashim says:

      its really good work keep it up Atul

    176. Jishar says:

      Hi Atul,

      Hope you are doing well..First of all i want to say a big thank you for your great efforts in sharing your knowledge..great work..

      Right Now working as an Oracle Dba and would like to know more about Apps. Today i went through your site and start reading about the Apps concept.

      Again Thanks a lot

      With Regards

    177. tummie says:


      i just got the apps concepts material and will be starting on it tonite, a big thank u for such a great job u doing as i want to follow the apps DBA this is a great start for me ,

      Big thank you
      God bless


    178. jaspreet says:

      Hi Atul
      Really great job
      i am not able to find 11i on edilevery site.can you pls tell me which option should i download

    179. Rahul says:

      Hi Atul,

      I read your forums and it is very helpful.

      You are doing really a great job. I need your advice.

      I have 6 years of PL/Sql development experiance and now i am working as Tech Lead in one of the company. It is right decision to become Oracle Apps DBA now.

      I have not worked on form and reports nor more on Oracle Core DBA.

      Please suggest/advie me, Is it correct decision to join Apps DBA in this stage or should i continue with my current profile ?


    180. Lakshmikanthan says:

      hi atul,

      Thanks for giving valuable supporting.
      Am working as a oracle apps dba! still am not done any certification… can i do directly oracle apps dba cerification? is it possible?

    181. Manjunath says:

      Hi Atul,
      Good Going
      may i know what’s the difference between
      Apps Technical
      Apps Functional
      Apps Techno-Functional

    182. Haafiz says:

      hey gr8 work atul.
      its like metalink support from oracle
      i have good knowledge regarding apps but 0 in troubleshooting
      if u forward some doc or ppts regarding d the same if possible

    183. khaja says:

      what is the meaning for vision demo database

    184. Atul Kumar says:

      @ Khaja,
      Vision Demo Database means Oracle Apps will be installed with demo data which functional guys can use to test functional setup. From DBA’s point of view size of database will be much bigger when selecting Vision compared to fresh database.

    185. khaja says:

      hai atul you told me answer for “how to restrict users from loging in to instance even front end is up and running?”

      answer is this,

      Configure Firewall between users and application tier and block web server port on firewall
      please tell me how can we do this?

    186. Atul Kumar says:

      @ khaja,
      Fir decide which Firewall you are going to use (hardare or software) then use appropriate firewall document to block/allow port.

      If your application tier is on Linux you can use pre installed software firewall “iptables”


    187. Vishnu says:

      Hi Atul,

      Is the book Oracle Applications DBA Covers 11i and R12 sufficient enough to prepare for the exams 1z0-235,1z0-236 and 1z0-233 atleast to an extent of 75% to become an Oracle Apps DBA 11i ?
      Please guide me in this.

      Thanks in advance.

    188. Vishnu says:

      Sorry, I have not mentioned the author of the book

      book – Oracle Applications DBA Covers 11i and R12
      author – Joyjeet Banerjee
      Publications – Tata McGraw-Hill Publishing Company Limited

    189. Atul Kumar says:

      @ Vishnu,
      I have not seen book myself. To check if it covers certification topic, simply check index of book with exam topics for 1Z0-233 http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_org_id=1243197&lang=ZHS&p_exam_id=1Z0_233

      1Z0-235 & 1Z0-236 are core DBA topics and I don’t think 235, 236 topics are covered in detail in book you mentioned above.

    190. Vishnu says:

      Thanks for your reply,

      I want to know which path will be more fetching for a fresher to become Oracle Apps DBA 11i, considering the time factors and availablity of study materials.

      1) OCP DBA 11g -> 1z0-233
      2) 1z0-235,1z0-236 -> 1z0-233

      Please suggest me.. Thanks..

    191. Atul Kumar says:

      @ Vishnu,

      My option would be 1st i.e. OCP DBA 11g -> 1z0-233

    192. Vishnu says:


      Thanks a lot.

    193. khaja says:

      hi atul
      can please tell me what is the difference between
      and iam reading that book 11i concepts
      i completed till admin server its good till where i can stop it.
      thanku alot

    194. Atul Kumar says:

      @ Khaja,
      Check metalink note
      243880.1 – Shared APPL_TOP FAQ

    195. jalaja says:

      Hi, Atul

      Thank a lot for helping out the beginner professional.. keep it up.. keep helping


    196. siva says:

      hi atul,

      thanks u very much .can u please elaborate all the concepts.


    197. Aishwarya says:

      Hi Atul,

      It’s really very helpful in getting through the apps architecture….thanks a lot.


    198. piyush says:

      i wanted to switch over the oracle apps DBA.i dont having the DBA background but having the experience in oracle 9i database With strong knowledge in SQL.

      can i choose the field of apps DBA?

      Please suggest me!


    199. Sundar says:


      Im Fresher joined recently and trained as Oracle DBA.

      Is learning Apps now a correct time ??

      I like to be a Apps DBA. Where can i learn Apps ??


    200. Atul Kumar says:

      @ Sundar,
      Yes in my view this is correct time .

      You can learn on your own by picking apps dba documentation from Oracle.

      You can also join one of training institute (join one which provides hands-on practice sessions)

      Check http://focusthread.com/training

    201. abha says:

      link is not working. it is invalid url.

    202. Atul Kumar says:

      @ Abha,
      Are you talking about apps dba training link mentioned above or something else ?


    203. Stab_3216 says:

      Hi, Not everyone would take out so much time to help out people. it really is a great thing you have done,

      I’m a DBA but i also like to learn oracle apps.
      This might sound stupid but I am somehow unable to locate the guide “oracle applications concepts” in the EBS link you have posted.

      are you referring to Oracle Applications Online Documentation Library? Please help me out as i want to start off as soon as i can

    204. Stab_3216 says:

      got it, Thanks i will go through and let you know if i have doubts

    205. Karthik says:

      We are having oracle 9i database running in a different server machine and oracle 11i forms running in a different server machine. I like to know how these two servers are linked to each other and where the respective settings are in. We use a solaris sparc server. i used to start the database startup script first and then the startup script for forms server in the different machine. what are the settings that link the database to the forms server

      • Atul Kumar says:

        @ Karthik,
        Depending on mode in which forms is configured (Socket or Servlet) it uses TNS or think jdbc to connect from forms server to database. (connect details are in $TNS_ADMIN of Forms/Report ORACLE_HOME or in dbc file under $FND_SECURE)

    206. Karthik says:

      Thanks Atul,
      Kindly suggest me an Open source linux OS which i can install in virtual box and test all the softwares. I am well trained in unix platform. I felt ubuntu was a bit easy to use but i am not able to install any oracle software for testing as all ends up with an error

    207. Karthik says:

      Thanks atul,

      It seems my server is connected in a socket mode.
      I checked the listener.ora and tnsnames.ora. I found the following lines . are they the configuration settings that connect each other


      (SID_LIST =
      (SID_DESC =
      (SID_NAME = TEST)
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (PROGRAM = extproc)


      # Intermedia
      extproc_connection_data =
      ) )

      Is the ExtProc connecting both the servers. If not why are they used.

    208. Udit says:

      Hello Atul Sir,

      May I please have your email id(The one you use often).
      Mine is uditappsdba@gmail.com
      I shall be highly obliged.

      Udit Kulshrestha

    209. Vara says:

      Hi Atul,

      Could you please let me know how to find the below info from instance.

      1. Total no of application users that exist module wise

      2. No of users logged in module wise

      3. No of users logged in last ‘n’ days

      Thanks in advance


    210. Kusuma says:


      Thanks for the blog.
      Your blog is very helpful. As I wanted to learn apps dba concepts, but no clue where to start. Your blog shows the path where to start.

      Thanks Once gain.


    211. Junaid says:

      Dear Kumar,
      I have executed adpatch to apply a patch 10627713. While patching, I have received the following error, kindly guide what should I do to rectify the below error ??

      error message while patching

      Parsing and loading patch driver file…
      212 lines processed.

      Not checking patch integrity as integrity checking flag is turned off.

      Successfully read patch driver file.

      Determining target release…

      Current target release is 12.1.1

      AutoPatch warning:
      None of the NLS languages listed in the patch driver file are
      installed in the database instance.

      Patch 10627713:IS is a NLS patch.

      You must first apply the corresponding US patch
      for the NLS patch(es) listed above.

      AutoPatch error:
      A fatal error related to codelines or codelevels has occurred.

      See messages above for details.
      You should check the file
      for errors.
      Kind Regards,


    212. asma fatima says:

      Trying to configure SSO for OAM components used are db11g,weblogic,OID,http server webgate.I’m
      totally confused,browsed all the related topics on google ,but no use ,got even
      more confused.Dont know how to use the identity ,policy & credential
      store.totally lost pls help.

    213. asma fatima says:

      Trying to configure SSO for OAM components used are db11g,weblogic,OID,http server webgate.I’m
      totally confused,browsed all the related topics on google ,but no use ,got even
      more confused.Dont know how to use the identity ,policy & credential
      store.totally lost pls help.

      • Atul Kumar says:

        - Install OAM as per installation guide
        – Install OID and integrate OID with OAM
        – Install OHS
        – Configure OHS as proxy (mod_wl_ohs) to forward requests to OAM
        – Install WebGate on OHS

        For time being forget about identity, policy and credential and ask query specific to installation & integration document .

    214. Zao_man says:

      Please do you have a free class that explains difference betwwn
      APPS DBA and 11i/R12 DBA
      the place of Web Logic, OC4J, SOA suite, and Oracle Fusion in studying AppDBA

    Leave a Reply

  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.

    K21 Technologies
    8 Magnolia Place, Harrow,
    London, HA2 6DS

    UK: +44(0)7476444481
    USA: +1-888-414-1821

  • 2014, K21 Technologies. All rights reserved DMCA.com
  • TOP