Product and service reviews are conducted independently by our editorial team, but we sometimes make money when you click on links. Learn more.
 

Oracle Database 12c Administrator

Best Database Certifications
By

Most Oracle DBMS credentials require candidates to attend authorized training classes to qualify for the related exam, but MySQL (and Sun-derived) credentials often do not. Oracle certifications also represent a true ladder, in that it is generally necessary to earn the associate-level credentials first, professional-level credentials second, and master third, finally culminating at the expert level.

Oracle Database 12c R2 is the latest Oracle database version, which includes enhancements to Oracle Database 12c. Currently, Oracle 12c certifications are offered at the associate, professional and master levels. A Foundations Junior Associate certification (novice level) is also available for Oracle Database 12c, as are two specialist designations -- the Implementation Specialist and the Oracle Real Application Clusters 12c Certified Implementation Specialist. Oracle offers two 12c R2 certifications: Oracle Database 12c R2 Administration Certified Associate and Professional. Oracle 11g certifications are still offered as well.

Note: Although premium support for Oracle 11g Database ended on Dec. 31, 2014, extended support will be available until December 2020, so it's probable we'll continue to see Oracle Database 11g in use for the next few years.

In this article, we focus on the requirements for Oracle 12c and 12c R2 Database certifications. One important consideration is that Oracle 11g is forward-compatible with Oracle 12c, but Oracle 12c is not backward- compatible with the prior version. Because Oracle 12c is a newer version, IT professionals possessing Oracle 11g certifications should explore upgrades to their current credentials.

Oracle Database 12c and 12c R2 Administrator Facts & Figures

Certification NameOracle Database 12c Administrator Certified Associate (OCA 12c)

Oracle Database 12c Administrator Certified Professional (OCP 12c)
Oracle Database 12c Administrator Certified Master Certification (OCM 12c)
Oracle Database 12c Maximum Availability Certified Master
Oracle Database 12c R2 Administration Certified Associate (OCA 12c R2)
Oracle Database 12c R2 Administration Certified Professional (OCP 12c R2) upgrade
Prerequisites & Required CoursesOCA 12c: Training recommended but not required

OCP 12c: OCA 12c credential, one training course required

OCM 12c: OCP 12c credential, two advanced training courses (must be different than the course used to achieve the OCP)

Oracle Database 12c Maximum Availability Certified Master: Three credentials:
Oracle Database12c Administrator Certified Master
Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administration
Oracle Certified Expert, Oracle Database 12c: Data Guard Administration

OCA 12c R2: OCA Database SQL, OCA 11g or OCA 12c

OCP 12c R2 upgrade: OCP 11g or OCP 12c credential

Oracle Training: Classes typically two to five days, costs vary between $1,360 to over $5,000
Number of ExamsOCA 12c: Two exams: Choose one exam from the following:
  • Oracle Database 12c SQL (1Z0-071)
  • Oracle Database 12c: SQL Fundamentals (1Z0-061)
  • Oracle Database 11g: SQL Fundamentals I (1Z0-051)
  • Oracle Database SQL Expert (1Z0-047) (retired)
Pass the following exam:
  • Oracle Database 12c: Installation and Administration (1Z0-062)
OCP 12c: One exam: Oracle Database 12c: Advanced Administration (1Z0-063)
OCM 12c: One exam: Oracle Database 12c Certified Master (12COCM), a two-day performance-based exam
Oracle Database 12c Maximum Availability Certified Master: None
OCA 12c R2: One exam: Oracle Database 12cR2 Administration (1Z0-072)
OCP 12c R2 upgrade: One exam: Upgrade Oracle DBA 11g or 12c to 12c R2 (1Z0-074)
Cost per ExamOCA 12c: 1Z0-051 and 1Z0-061 cost $125 each; 1Z0-071 and 1Z0-062 cost $245 each

OCP 12c: 1Z0-063 costs $245

OCM 12c: 12COCM costs $2,584; contact Oracle for pricing/availability of upgrade exam

Oracle Database 12c Maximum Availability Certified Master: None

OCA 12c R2: 1Z0-072 costs $50 (currently in beta)

OCP 12c R2 upgrade: 1Z0-074 costs $245

Note: Prices vary by geography
URLhttps://education.oracle.com/pls/web_prod-plq-dad/ou_product_category.getFamilyPage?p_family_id=32&p_mode=Certification
Self-Study MaterialsEach Oracle certification exam webpage lists exam topics, as well as recommended training courses, seminars and practice tests. A variety of self-study guides are available on Amazon. Oracle Database certification candidates will benefit from student manuals, labs and software provided as part of class offerings.

MORE: Oracle Certifications & Career Paths