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!

53 comments:

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

    Oracle DBA Training in Chennai

    ReplyDelete

  2. 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
  3. Great effort. Thanks for sharing your valuable knowledge with us.
    Oracle dba training | Oracle dba training syllabus

    ReplyDelete
  4. 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
  5. 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
  6. Learned a lot of new things from your post ,It's amazing article
    Sql server DBA Online Course Hyderabad

    ReplyDelete
  7. 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
  8. 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
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. This comment has been removed by the author.

    ReplyDelete
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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
  28. Thanks For sharing the Information The Information Shared Is Very valuable please Keep Updating Us The InFormation Shared Is Very Valuable Python Online Training Hadoop Online Training <a href="https://nareshit.com/data-science-online-training/>DataScience Online Training</a>

    ReplyDelete
  29. Informative post indeed, I’ve being in and out reading posts regularly and I see a lot of engaging people sharing things and majority of the shared information is very valuable and so, here’s my fine read.

    Big Data Hadoop Training In Chennai | Big Data Hadoop Training In anna nagar | Big Data Hadoop Training In omr | Big Data Hadoop Training In porur | Big Data Hadoop Training In tambaram | Big Data Hadoop Training In velachery

    ReplyDelete
  30. Great post i must say and thanks for the information. Education is definitely a sticky subject.I would really like to read some personal experiences like the way, you've explained through the above article. I'm glad for your achievements and would probably like to see much more in the near future. Thanks for share.

    Data Science Training In Chennai

    Data Science Online Training In Chennai

    Data Science Training In Bangalore

    Data Science Training In Hyderabad

    Data Science Training In Coimbatore

    Data Science Training

    Data Science Online Training

    ReplyDelete
  31. Hi, Thank you for this informative blog, I have just started to learn Oracle DBA & RAC online Training and Certification and this blog is definitely very helpful for me. Thank you for this informative blog.

    ReplyDelete
  32. Hi, I read your whole blog. This is very nice. Good to know about the career in qa automation is broad in future. We are also providing various Oracle DBA & RAC Training, anyone interested can Oracle DBA & RAC Training for making their career in this field .

    ReplyDelete
  33. Explore what the best Data Science training institute is offering you. Learn advanced technologies from the best industry experts and grab lucrative jobs.
    data analytics courses in hyderabad with placements

    ReplyDelete