Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Tuesday, 11 December 2012

Oracle DBA Certification

The Oracle DBA Certification Program is a professional certification program offered by the Oracle Corporation. When I start my career as an Oracle DBA first thought click in my mind is Oracle DBA Certification. Here I am going to provide some basic Information about certification.
Oracle DBA Certification Program is administered by Oracle Corporation and for an oracle DBA there are three levels of Oracle Certification in several disciplines: They are
§         Oracle Certified Associate (OCA)
§         Oracle Certified Professional (OCP)
§         Oracle Certified Master (OCM)
If you are already a working Oracle professional as an Oracle DBA then your first question to yourself “what is the need of certification or why should go for certification?
If you are certified as a Database Administrator (DBA) you are having solid job growth outlook over the next several years.
If you get certified in one area such as Oracle or SQL Server, you are most unlikely to switch products and also most unlikely to recommend any other database products other than your certification category.
You may find Certification Useful in the below Case:
§         If you are starting a new career as Oracle DBA (Database Administrator)
§         If you lack or have very limited hands-on product experience.
§         If you’re switching from one job function to another certification will ensure you broader career opportunity.
§         Possibly if you are re-entering the workforce after long time.
§         Solid growth opportunity incase of job change.
Unless the market demands it has a “job” requirement, if you are already an experienced DBA and already have good credentials, certification may offer little career benefit.
Another way to assess the certification requirement would be, basically employers need a quick and easy way to decide whether a candidate is worthy of their time. It is a simple yardstick by which they can “qualify” or shortlist their job candidates, but not necessarily finding a suitable match for the Job.
Apart from above reasons, if you are a Senior Oracle DBA you may consider certification useful to Increase you’re earning Potential especially if you want to work as a consultant or an Oracle DBA Contractor.
Where to get Certified?
Oracle Certification Program is administered by Oracle Corporation. Oracle offers various tracks in this certification program including, Database Administration, Application Developer. Apart from Oracle vendor there are quite a number of third party firms offering Oracle certification. One of the advantage of taking up certification with oracle is they have centers all over the world. Because certification has different level‘s (OCA, OCP and OCM) and also specific oracle DBA certification for specific products such as Oracle Real Application Cluster certification , whatever your preference might be make sure you feel comfortable with the direction of the vendors’ product and certification program before committing to it. You can find these paths for Oracle 9i/10g/11g version at: How to Become Oracle Certified
Note: Please do not forget to check current or updated information on oracle site.
Oracle offers verity of certifications but for the beginning of career as an Oracle DBA following are options:
Oracle Certified Associate (OCA)
If you are wondering what’s been covered in OCA certification subject, It covers the knowledge required to install and maintain Oracle Database. As an oracle database Administrator (DBA) you gain a strong foundation and expertise in the industry’s most advanced database management system. You can find complete list of topics covered for this exam: Exam Web page
Depending on the oracle version you could choose different tracks
Oracle Certified Professional (OCP)
This an entry level certificate for a DBA. If you consider taking up this exam, you would be required to be prepared in Oracle database installation, maintenance, Fine-tuning and troubleshooting aspects of oracle databases. Depending on the oracle version you could choose different tracks.
To take up this OCP exam of oracle DBA Certification, You need:
§         Become an Oracle 11g Database Certified Associate.
§         Must complete one of the approved instructor-led online or in-class courses and pass the Oracle Database 11g: Administration II exam
§         Last but not the least you must submit the Hands on Course Requirement Form which would enable you to become an Oracle Database 11g Administrator Certified Professional
Oracle Certified Master (OCM)
If you are looking for Oracle Certified Master (OCM) certification, it would be the most advanced Certification for an Oracle DBA. This is the highest level Oracle certification for oracle DBA. You can choose between Oracle 10g and 11g database and any latest version. For updated details check the .
It requires at lease 3-4 years of professional enterprise-level oracle experience. The requirement to become an Oracle Certified Master you must OCA/OCP both.
Complete two advanced-level DBA coursework, instructor –led online or in-class courses
Pass an Oracle Certified Master exam.
Finally you are expected to demonstrate your skills through an intensive two-day hands-on practical examination.
The Oracle Database 10g and 11g Oracle certified Master or any latest oracle version (OCM) credential of oracle DBA certification is for the most advanced Oracle database administrator. Once you complete this you are expected to have comprehensive and extensive knowledge on a wide variety of topics including installation, backup and recovery, tuning and troubleshooting.
Upgrade Certification:
Oracle requires that you follow upgrade paths to continue your certification. If you are an OCP DBA in older version you can take single exam to upgrade your certification.
Candidate must wait 14 days before retaking a failed OCA exam. Candidates cannot retake a passed exam or a beta exam at any time.
DBA certification can cost from a few hundred dollars. As an Oracle Professional you must weight the costs and benefits differently to come to this conclusion. Perform your own “cost / benefit” analysis before deciding whether you certify or not.
The exams can be taken at any Oracle Testing Center worldwide. Candidates can find their local testing center by registering through the Oracle website but make sure to check with your local testing center for up-to-date price information. Keep a look out for promotional exam discounts from Oracle or for third-party exam voucher specialists to help you save on the cost of the exam. 


  1. Salam and Happy Republic Ray!!

    Sir, please tell me the roles and responsibility of junior(2 yr exp) DBA in production environment..


    1. ٍسشةث فخ غخع
      Generally, It depends on the company and your department. Come in the early morning before the most users of ‎database is coming and check whether all databases are up and Monitor the alert log file and take actions if any ‎errors found, Check the growth of database, You should aware of Database backup and Recovery concept especially ‎RMAN most of the industry using, In some of the concept verbal explanation is also one of the quality to attend the ‎users, Make the habit of reading oracle forum and DBA book to keep updating your self.‎

    2. hmm.. thanks!!! Sir, could u please tell me the most common type of error found in alert log file and its solution??

    3. All internal Errors: ORA-00600, Block Corruption Errors: ORA-01578 and deadlock errors ORA-00060 that occur recorded in alert Log file.
      Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements are recorded in alert Log file.
      for more details follow the link:

    4. Thanks a lot sir!!.

  2. Source:

  3. Dear,

    For more details about current situation of oracle certification
    Visit at

  4. Path Infotech is in the field of oracle training program from past several years.

    For more info : Oracle Certifications

  5. Hi,

    You Have Provided Valuable Information on Oracle DBA Online Training .Oracle DBA Means Oracle Data Base Administration.Data base administration is the main to every company.each database requires at least one DB Admins.becoz data base system will be larger it have many users.DB Admins Responsibilities are installing & Upgrading oracle server,system storage requirement and modifying for database system,structure,maintaining system sercurity.

  6. Thanks for sharing useful information. We also providing best SAS Online Training

  7. Nice information. Our institute Is the Leading online institute in

    Hyderabad, India to provide OBIEE online trainings with the real

    time experts and certified professionals. alot

    Obiee Online Training.

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

  9. Learn how to win a Free Retake Oracle Certification. In this site (Click in "SKIP THIS AD", and lock information in topic R​EGIONAL P​ROMOTIONS).

    Good Luck!!

  10. This is one of the awesome and Important post.I like your blog description.
    oracle certification

  11. Great Post, I really appreciate your effort here.
    Oracle DBA Certification Training in Gurgaon

  12. Really this post is awesome ,i am glad see this post ,,,,,,,,,,,,,,,.

    Oracle training institute in gurgaon

  13. I have read your blog its very attractive and impressive. I like it your blog.

    Angularjs Online Training | Javascript Online Training

  14. I have read your blog its very attractive and impressive. I like it your blog.

    Java Online Training Java EE Online Training Java EE Online Training Java 8 online training Core Java 8 online training

    Java Online Training from India Java Online Training from India Java Online Training

  15. Here I got a complete information about Oracle certification. It is very beneficial for people who acquire this certification in terms of better job support and high salary.

    Crish Watson
    Pass Microsoft Certification Without Taking Exam

  16. Oracle Database comes handy and as an effective solution for the management of data. I appreciate you spending some time and effort to put this information together on Oracle training in Delhi | Oracle dba Training institute in Delhi .it was still worthwhile!

  17. Thanks for sharing this blog. This very important and informative blog for theose who want to know
    Content related oracle technology
    Best Oracle training in Gurgaon

    Learned a lot of new things from your post! Good creation and HATS OFF to the creativity of your mind.
    Very interesting and useful blog!

    Looking forward to your response!

    Thanks & Regards
    Mahesh Chandan

  18. Thanks Learned a lot of new things from your post! Good creation and HATS OFF to the creativity of your mind.
    Very interesting and useful blog!

    Oracle Training in Gurgaon

  19. Usually I never comment on blogs but your article is so convincing that I never stop myself to say something about it. This paragraph gives clear idea for the new viewers of blogging, Thanks you. You’re doing a great job Man, Keep it up.
    Oracle Training in Noida

  20. Nice Blog post. Thanks for sharing great information. keep posting..

    SAP S/4 HANA training online

  21. Nice information well said. If you want more details please visit our website.
    SQL DBA Training in Hyderabad


  22. Nice blog..! I really loved reading through this article. Thanks for sharing such
    a amazing post with us and keep blogging...

    oracle dba online coaching in ammerpet