12C OCM

Based on the Oracle Database 12c Certified Master Upgrade Exam (visited 2018-05-03 - no longer valid). I rate myself as follows (1=poor to 5=good).

The new version (2020-01-07) is here .

Exam Topic My Rating (1-5) Reference
General Database and Network Administration, and Backup Strategy
Create and manage pluggable databases 4 Create 12.1 Container Database No OMF
Create 12c Container Database Using OMF
Create and manage users, roles, and privileges 3
Configure the network environment to allow connections to multiple databases 3
Protect the database from data loss due to failures 3
Create and manage database configuration files 5
Data and Performance Management
Administer Materialized views 3
Create a plugged-in tablespace by using the transportable tablespace feature 4
Create partitioned tables 3
Configure the database to retrieve all previous versions of the table rows 2
Configure Oracle Database Resource Manager 5
Tune SQL statements 3
Perform Real Application Testing 2
Create SQL Plan baselines 5
Data Guard
Administer a Data Guard environment 3
Create a physical standby database 3
Configure a standby database for testing 5
Configure a standby database to apply redo 3
Configure a standby database to use for reporting 3
Configure fast start failover 1
Grid Infrastructure and RAC
Install Oracle Grid Infrastructure 3 Install 12.1.0.2 GI Standalone
Create ASM disk groups 3 Create New ASM Disk Group Using ASMCA
Create and manage ASM instances 3
Configure ASM Cloud File System (ACFS) 1
Administer Oracle Clusterware 2
Install Oracle Database 12c software 4 Install Oracle RDBMS 12.1.0.2 With Grid Infrastructure
Install Oracle RDBMS 12.1.0.2.4 Without Grid Infrastructure
Create a Real Application Clusters (RAC) database 3
Configure Database Services 3

According to Oracle Database 12c Certified Master Upgrade Exam , the exam environment is:

  • Oracle Linux Release 6.5 64 bit
  • Mozilla Browser, Text (emacs, gedit) and vi editors
  • Shell environment: bash, csh
  • Use either CLI or GUI environment and tools when available
  • Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64 bit
  • Oracle Grid Infrastructure 12c Release 1 (12.1.0.2)
  • Oracle Enterprise Manager Cloud Control 12c Rel 4

Build diaries for system used exclusively for OCM 12G can be found at 12C OCM System Builds