OCM 12c Preparation

Today (1st SEP 2018) I will finally start my Oracle OCM 12c study project.

My target is to take the exam by FEB 2019.

Oracle Database 12c Certified Master Exam | 12cOCM

Exam Environment
  • 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 12Release 1 (12.1.0.2)
  • Oracle Enterprise Manager Cloud Control 12c Rel 4
Notes about t he exam
  • Exam participants work through eight skillsets that are based on the exam objectives.
  • Tasks can be performed using CLI or GUI environment and tools when available

Minimum Skill-set wise Passing Scores:

Skillset1: Create Database and Network Configurations : 60.29%

Skillset2: Managing Database Availability : 46.93%

Skillset3: Data Warehouse Management : 34.14%

Skillset4: Data Management : 33.92%

Skillset5: Performance Management : 39.13%

Skillset6: Data Guard : 43.39%

Skillset7: Grid Infrastructure : 53.84%

Skillset8: Real Application Cluster Database : 37.83%

https://education.oracle.com/oracle-database-12c-certified-master-exam/pexam_12cOCM

General Database and Network Administration
  • Create and manage pluggable databases
  • Administer users, roles, and privileges
  • Configure the network environment to allow connections to multiple databases
  • Administer database configuration files
  • Configure shared server
  • Manage network file directories

Manage Database Availability

  • Install the EM Cloud Control agent?Configure recovery catalog
  • Configure RMAN
  • Perform a full database backup
  • Configure and monitor Flashback Database

Data Management

  • Manage additional buffer cache
  • Optimize space usage for the LOB data
  • Manage an encrypted tablespace
  • Manage schema data
  • Manage partitioned tables
  • Set up Fine-Grained Auditing
  • Configure the database to retrieve all previous versions of the table rows

Data Warehouse Management

  • Manage database links
  • Manage a fast refreshable materialized view
  • Create a plug-in tablespace by using the transportable tablespace feature
  • Optimize star queries
  • Configure parallel execution
  • Apply a Patch
  • Configure Automatic Data Optimization, In-Row Archiving, and Temporal Validity
  • Manage external tables

Performance Management

  • Configure the Resource Manager
  • Tune SQL statements
  • Use real application testing
  • Manage SQL Plan baselines
  • Capture performance statistics
  • Tune an instance
  • Configure and manage result cache
  • Manage extended statistics
  • Create and manage partitioned indexes
  • Control CPU use for Oracle Instances
  • Configure and manage “In Memory” features

Data Guard

  • Administer a Data Guard environment
  • Create a physical standby database
  • Configure a standby database for testing
  • Configure a standby database to apply redo
  • Configure a standby database to use for reporting
  • Configure fast start failover
  • Manage DDL in a Data Guard environment

Grid Infrastructure

  • Install Oracle Grid Infrastructure
  • Create ASM Disk Groups
  • Create and manage ASM instances
  • Configure ASM Cloud File System (ACFS)
  • Administer Oracle Clusterware
  • Manage Flex Clusters and Flex ASM

Real Application Cluster Database

  • Install Oracle Database software
  • Create a Real Application Clusters (RAC) database
  • Configure Database Services
  • Administer Oracle RAC databases on one or more cluster nodes

One thought on “OCM 12c Preparation

  1. Pingback: General Database and Network Administration  | ORACLE -LEARN

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.