NAVEEN

Wednesday, January 13, 2010

Background and Training for DBA

Background and Training for an Oracle DBA

There’s no ideal background for a DBA, but it’s highly desirable that a DBA have a real interest in
the hardware side of databases, and also have a decent knowledge of operating systems, UNIX and
NT servers, and disk and memory issues. It also helps tremendously to have a programming or
development background, because you’ll be working with developers frequently. The most common
operating system for the Oracle database is UNIX, with the Hewlett-Packard (HP) and Sun
Microsystems (Sun) versions being the ones commonly adopted. IBM supplies the AIX variant of
the UNIX operating system, but it has its own proprietary database, the DB2 Universal Database.
If you’re taking classes from Oracle or another provider to become a full-fledged Oracle Database
10g DBA, you need to take two classes:

• Oracle Database 10g: Administration Workshop I
• Oracle Database 10g: Administration Workshop II

Certified Associate (OCA). Workshop II will prepare you for the advanced Oracle Certified Professional
(OCP) certification. As of November 15, 2004, all Oracle9i and Oracle Database 10g DBA
certification candidates are required to take one in-class or online class in order to meet the new
hands-on course requirement. If your firm uses Oracle Real Application Clusters (RAC) or distributed
databases, you need to take additional, specialized courses. If your firm uses the UNIX
operating system and you don’t have experience using it, you may be better off taking a basic class
in UNIX (or Linux) from HP, Sun, Red Hat, or another vendor. You don’t need to take such a course
for Oracle DBA certification purposes, but it sure will help you if you’re new to the UNIX or Linux
environment. Of course, if your databases are going to use the Windows environment, you may get
away without a long and formal course in managing Windows, assuming you are relatively familiar
with the Windows operating system, unless you also happen to be a Windows System Administrator.

Once you get started as an Oracle Database 10g DBA, you will find that the real world of Oracle
databases is much wider and a lot more complex than that shown to you in the various courses you
attend. As each new facet of the database is revealed, you may find that you are digging more and
more into the heart of the software, why it works, and sometimes why it doesn’t work. It is at that
point that you will learn the most about the database and the software used to manage it. If you
really have read everything that Oracle and other private parties have to offer, do not worry—there
are always new versions coming out, with new features and new approaches, practically guaranteeing
an endless supply of interesting new information.
After the first year or two of your DBA journey, you’ll know enough to competently administrate
the databases and troubleshoot typical problems that occur. If you’ve also worked on your
programming skills during this time (mainly UNIX shell scripting and PL/SQL), you should be able
to write sophisticated scripts to monitor and tune your databases. At this stage, if you dig deeper,
you’ll find out a lot more about your database software that can enhance your knowledge and
thereby your contribution to your organization.
Oracle is constantly coming up with new features that you can adopt to improve the performance
of your production databases. Although the developers, testers, and administrators are also
striving mightily in the organization’s cause, it is you, the Oracle DBA, who will ultimately lead the
way to new and efficient uses of the new features of the database.
Certification
In many IT fields, certification by approved authorities is a required credential for advancement
and sometimes even for initial hiring. Oracle has had the Oracle Certification Program (OCP) in
effect for a number of years now. The OCP is divided into three levels: Associate, Professional, and
Master (the Master level requires a lab test in addition to the other requirements). Traditionally, certification
was not a big issue with most organizations, especially in the face of the severe shortages
of certified DBAs in the field for many years. In today’s environment, though, that certification will
help tremendously in underlining your qualifications for the job.
Oracle provides DBA certification at the following levels—Oracle Database 10g Administrator
Certified Associate (OCA), Oracle Database 10g Administrator Certified Professional (OCP), and
Oracle Database 10g Administrator Certified Master (OCM). Oracle provides the following descriptions
of their certification programs:

• OCA: The Oracle Certification Program begins with the Associate level. At this apprentice
skill level, Oracle Associates have a foundation knowledge that will allow them to act as junior
team members working with database administrators or application developers. The
exam ensures knowledge of basic database administration tasks and an understanding of
the Oracle database architecture and how its components work and interact with one
another. The OCA is also a prerequisite to becoming an OCP. You must take the IZ0-042
Oracle Database 10g: Administration exam to get your Oracle Database 10g Administrator Certified Associate (OCA) certificate.

• OCP: The exam ensures that the OCP with the 10g credential can competently address
critical database functions, such as manageability, performance, reliability, security, and
availability using the latest Oracle technology. The OCP is a prerequisite to becoming an
Oracle Certified Master (OCM).

• OCM: The Oracle Database 10g OCM credential is for the Oracle database guru—the senior
database professional with both classroom and on-the-job experience. The prerequisites are
that candidates earn an Oracle Database 10g OCP credential and complete advanced-level
coursework. The final stage requires that candidates prove their skills through an intensive
two-day hands-on practical examination.
My views on certification are really very practical. Preparing for certification will force you to
learn all the little details that you’ve been ignoring for some reason or another, and it will clarify
your thinking regarding many concepts. Also, the need to certify will compel you to learn some
aspects of database administration that you either don’t like for some reason or currently don’t use
in your organization. So if you’re not already certified, by all means start on that path. You can get
all the information you need by going to Oracle’s certification Web site at http://www.oracle.com/
education/certification. Believe me, that certificate does look nice hanging in your cubicle, and it’s
a symbol of the vast amount of knowledge you’ve acquired in the field over time. You can rightfully
take pride in obtaining OCP-certified DBA status!

78 comments:

  1. After coming this blog, I have learned so many things. Thank you friend keep posting like this.
    Oracle DBA Online Training

    ReplyDelete
    Replies
    1. I am technology Enthusiast. Your blog is really awesome, attractive and impressive. I like the way you think. it is very useful for Java SE & Java EE Learners. Your article adds best knowledge to our Java Online Training from India. or learn thru Java Online Training from India Students. or learn thru JavaScript Online Training from India. Appreciating the persistence you put into your blog and detailed information you provide. Kindly keep blogging.

      Delete
  2. I have read your blog and i got a very useful and knowledgeable information from your blog.

    Oracle DBA Training in Chennai

    ReplyDelete
  3. There are lots of information about latest technology and how to get trained in them, like Big Data Training in Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Big Data Training). By the way you are running a great blog. Thanks for sharing this. cloud computing training in chennai

    ReplyDelete
  4. Best iOS Training Institute In Chennai It’s too informative blog and I am getting conglomerations of info’s about Oracle interview questions and answer .Thanks for sharing, I would like to see your updates regularly so keep blogging.

    ReplyDelete
  5. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Android Training in Chennai
    Ios Training in Chennai

    ReplyDelete

  6. If want to do learning from Selenium automation testing to reach us Besant technologies.They Provide at real-time Selenium Automation Testing.Selenium Training in Chennai
    Selenium Training

    ReplyDelete
  7. Great effort. Thanks for sharing your valuable knowledge with us.
    Oracle dba training | Oracle dba training syllabus

    ReplyDelete
  8. I simply wanted to write down a quick word to say thanks to you for those wonderful tips and hints you are showing on this site.
    Hadoop Training Institute In chennai

    ReplyDelete
  9. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here.
    google-cloud-platform-training-in-chennai

    ReplyDelete
  10. I’m experiencing some small security issues with my latest blog, and I’d like to find something safer. Do you have any suggestions?

    DevOps Training in Chennai

    ReplyDelete
  11. Learned a lot of new things from your post ,It's amazing article
    Sql server DBA Online Course Hyderabad

    ReplyDelete
  12. I really like your blog. You make it interesting to read and entertaining at the same time. I cant wait to read more from you.
    Click here:
    angularjs training in marathahalli
    Click here:
    angularjs training in bangalore

    ReplyDelete
  13. Thanks for the good words! Really appreciated. Great post. I’ve been commenting a lot on a few blogs recently, but I hadn’t thought about my approach until you brought it up. 

    Blueprism training in Chennai

    Blueprism training in Bangalore

    Blueprism training in Pune

    Blueprism training in tambaram

    Blueprism training in annanagar

    Blueprism training in velachery

    Blueprism training in marathahalli

    ReplyDelete
  14. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
    DevOps online Training|DevOps Training in USA
    Devops Training in Chennai

    Devops Training in Bangalore

    ReplyDelete
  15. All the points you described so beautiful. Every time i read your i blog and i am so surprised that how you can write so well.
    Blueprism training in Chennai

    Blueprism training in Bangalore

    Blueprism training in Pune

    Blueprism online training

    ReplyDelete
  16. All the points you described so beautiful. Every time i read your i blog and i am so surprised that how you can write so well.
    Blueprism training in Chennai

    Blueprism training in Bangalore

    Blueprism training in Pune

    Blueprism online training

    ReplyDelete
  17. Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision. 
    python training institute in chennai
    python training in velachery
    python training institute in chennai

    ReplyDelete
  18. Thanks you for sharing this unique useful information content with us. Really awesome work. keep on blogging
    Devops training in velachery
    Devops training in annanagar

    ReplyDelete
  19. Nice tutorial. Thanks for sharing the valuable information. it’s really helpful. Who want to learn this blog most helpful. Keep sharing on updated tutorials…
    java training in annanagar | java training in chennai


    java training in marathahalli | java training in btm layout

    ReplyDelete
  20. A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you.

    rpa training in electronic-city | rpa training in btm | rpa training in marathahalli | rpa training in pune

    ReplyDelete
  21. My partner and I stumbled over here different website and thought I might as well check things out. I like what I see so now I’m following you. Look forward to checking out your web page repeatedly.
    safety course in chennai

    ReplyDelete
  22. You’ve written a really great article here. Your writing style makes this material easy to understand.. I agree with some of the many points you have made. Thank you for this is real thought-provoking content

    angularjs online Training

    angularjs Training in marathahalli

    angularjs interview questions and answers

    angularjs Training in bangalore

    angularjs Training in bangalore

    ReplyDelete
  23. When I initially commented, I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Thanks.

    Amazon Web Services Training in Pune | Best AWS Training in Pune


    AWS Training in Pune | Best Amazon Web Services Training in Pune

    ReplyDelete
  24. When I initially commented, I clicked the “Notify me when new comments are added” checkbox and now each time a comment is added I get several emails with the same comment. Is there any way you can remove people from that service? Thanks.

    Amazon Web Services Training in Pune | Best AWS Training in Pune


    AWS Training in Pune | Best Amazon Web Services Training in Pune

    ReplyDelete
  25. My developer is trying to convince me to move to .net from PHP. I have always disliked the idea because of the expenses.
    safety courses in chennai

    ReplyDelete
  26. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.. 

    rpa online training |
    rpa course in bangalore |
    rpa training in bangalore |
    rpa training institute in bangalore

    ReplyDelete
  27. It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
    Python training in bangalore | Python course in pune | Python training in bangalore

    ReplyDelete
  28. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    excel advanced excel training in bangalore | Devops Training in Chennai

    ReplyDelete
  29. I found your blog while searching for the updates, I am happy to be here. Very useful content and also easily understandable providing.. Believe me I did wrote an post about tutorials for beginners with reference of your blog. 
    excel advanced excel training in bangalore | Devops Training in Chennai

    ReplyDelete
  30. I simply want to give you a huge thumbs up for the great info you have got here on this post.
    python training in rajajinagar | Python training in bangalore | Python training in usa

    ReplyDelete
  31. Thank you for allowing me to read it, welcome to the next in a recent article. And thanks for sharing the nice article, keep posting or updating news article.
    Java training in Bangalore | Java training in Btm layout

    Java training in Bangalore |Java training in Rajaji nagar

    Java training in Bangalore | Java training in Kalyan nagar

    ReplyDelete
  32. Does your blog have a contact page? I’m having problems locating it but, I’d like to shoot you an email. I’ve got some recommendations for your blog you might be interested in hearing.


    AWS Training in Pune | Best Amazon Web Services Training in Pune

    AWS Tutorial |Learn Amazon Web Services Tutorials |AWS Tutorial For Beginners

    ReplyDelete
  33. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.
    rpa training in chennai
    rpa training in bangalore
    rpa course in bangalore
    best rpa training in bangalore
    rpa online training

    ReplyDelete
  34. This comment has been removed by the author.

    ReplyDelete
  35. Really great post, Thank you for sharing This knowledge.Excellently written article, if only all bloggers offered the same level of content as you, the internet would be a much better place. Please keep it up!
    aws Training in indira nagar

    selenium Training in indira nagar

    python Training in indira nagar

    datascience Training in indira nagar

    devops Training in indira nagar

    ReplyDelete
  36. Howdy, would you mind letting me know which web host you’re utilizing? I’ve loaded your blog in 3 completely different web browsers, and I must say this blog loads a lot quicker than most. Can you suggest a good internet hosting provider at a reasonable price?


    Best AWS Training Institute in BTM Layout Bangalore ,AWS Coursesin BTM


    Best AWS Training in Marathahalli | AWS Training in Marathahalli

    Amazon Web Services Training in Jaya Nagar | Best AWS Training in Jaya Nagar


    AWS Training in BTM Layout |Best AWS Training in BTM Layout

    ReplyDelete
  37. I’m planning to start my blog soon, but I’m a little lost on everything. Would you suggest starting with a free platform like Word Press or go for a paid option? There are so many choices out there that I’m completely confused. Any suggestions? Thanks a lot.



    AWS Training in NewYork City | Amazon Web Services Training in Newyork City


    AWS Training in London | Amazon Web Services Training in London, UK

    Amazon Web Services Online Training in USA | AWS Online Course in USA

    ReplyDelete
  38. Really you have done great job,There are may person searching about that now they will find enough resources by your post
    excel advanced excel training in bangalore
    Devops Training in Chennai

    ReplyDelete
  39. Greetings. I know this is somewhat off-topic, but I was wondering if you knew where I could get a captcha plugin for my comment form?
    safety course in chennai

    ReplyDelete
  40. Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
    python course institute in bangalore
    python Course in bangalore
    python training institute in bangalore

    ReplyDelete
  41. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
    python interview questions and answers
    python tutorials
    python course institute in electronic city

    ReplyDelete
  42. Thanks for the good words! Really appreciated. Great post. I’ve been commenting a lot on a few blogs recently, but I hadn’t thought about my approach until you brought it up. 

    Online DevOps Certification Course - Gangboard
    Best Devops Training institute in Chennai

    ReplyDelete
  43. Wow it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and i got more information from your blog.

    best rpa training in chennai
    rpa training in chennai
    rpa interview questions and answers
    automation anywhere interview questions and answers
    blueprism interview questions and answers
    uipath interview questions and answers
    rpa training in bangalore

    ReplyDelete
  44. Whoa! I’m enjoying the template/theme of this website. It’s simple, yet effective. A lot of times it’s very hard to get that “perfect balance” between superb usability and visual appeal. I must say you’ve done a very good job with this.
    Best Selenium Training in Chennai | Selenium Training Institute in Chennai | Besant Technologies
    Selenium Training in Bangalore | Best Selenium Training in Bangalore

    ReplyDelete
  45. Amazing Article ! I have bookmarked this article page as i received good information from this. All the best for the upcoming articles. I will be waiting for your new articles. Thank You ! Kindly Visit Us @ Coimbatore Travels | Ooty Travels | Coimbatore Airport Taxi | Coimbatore taxi

    ReplyDelete
  46. I found your blog while searching for the updates, I am happy to be here. Very useful content and also easily understandable providing.. Believe me I did wrote an post about tutorials for beginners with reference of your blog. 
    rpa training in bangalore
    best rpa training in bangalore
    RPA training in bangalore
    rpa course in bangalore
    rpa training in chennai
    rpa online training

    ReplyDelete
  47. It's interesting that many of the bloggers to helped clarify a few things for me as well as giving.Most of ideas can be nice content.The people to give them a good shake to get your point and across the command
    python Training in Pune
    python Training in Chennai
    python Training in Bangalore

    ReplyDelete
  48. Some us know all relating to the compelling medium you present powerful steps on this blog and therefore strongly encourage
    contribution from other ones on this subject while our own child is truly discovering a great deal.
    Have fun with the remaining portion of the year.

    Selenium training in bangalore

    ReplyDelete
  49. Appreciating the persistence you put into your blog and detailed information you provide
    python training in chennai
    python course in chennai
    python training in bangalore

    ReplyDelete
  50. I was recommended this web site by means of my cousin.
    I am now not certain whether this post is written through him as nobody else recognise such precise about my difficulty. You're amazing! Thank you!

    Selenium training in bangalore
    Selenium training in Chennai
    Selenium training in Bangalore
    Selenium training in Pune
    Selenium Online training

    ReplyDelete
  51. Whoa! I’m enjoying the template/theme of this website. It’s simple, yet effective. A lot of times it’s very hard to get that “perfect balance” between superb usability and visual appeal. I must say you’ve done a very good job with this.

    AWS Training in Bangalore | Best AWS Amazon Web Services…
    Amazon Web Services (AWS) Training in Pune India
    AWS Training | AWS Training and Certification | AWS online training
    AWS Training in Bangalore cost| Aws training in Bangalore with placements

    ReplyDelete
  52. This is a nice post in an interesting line of content.Thanks for sharing this article, great way of bring this topic to discussion.
    Best Devops Training in pune
    Devops Training in Bangalore
    Power bi training in Chennai

    ReplyDelete
  53. I’d love to be a part of group where I can get advice from other experienced people that share the same interest. If you have any recommendations, please let me know. Thank you.
    iosh course in chennai

    ReplyDelete
  54. Really great post, I simply unearthed your site and needed to say that I have truly appreciated perusing your blog entries.
    AWS Training in pune
    AWS Online Training

    ReplyDelete
  55. I found your blog while searching for the updates, I am happy to be here. Very useful content and also easily understandable providing.. Believe me I did wrote an post about tutorials for beginners with reference of your blog. 
    Data Science Course in Indira nagar
    Data Science Course in btm layout
    Data Science course in Indira nagar
    Data Science Course in Marathahalli
    Data Science Course in BTM Layout
    Data science course in bangalore

    ReplyDelete