Oracle 12c OCM(Oracle Certified Master) upgrade exam

12c OCM升级考试(从11g升到12c)

Exam Number(考试代码):12COCMU Duration(持续时间):1 day

Passing Score(通过分数):Overall 60% with acceptable performance on all 4 skillsets* 

This exam has been validated against Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.(12ocm升级考试已在12.1.0.2.0验证通过)

考试环境：
操作系统:OEL 6.5 64bit
集群软件版本:12.1.0.2.0
数据库软件版本: 企业版12.1.0.2.0
企业云管理器:12c Rel 4

从OU上看，考试主题主要分为以下四部分。

一、创建和管理可插拔数据库、用户、角色、权限等。配置网络环境，允许连接多个数据库。备份数据库确保在任何情况下可以恢复，创建和管理数据库相关配置。

二、修改物化视图，可插拔传输表空间特性，创建分区表，闪回技术，配置资源管理器，SQL优化，RAT(Real Application Testing)，创建和管理SQL Plan Baseline
三、创建物理备库，并使备库可用做测试。还原备库到正常工作模式，配置Fast Start Failover。

四、安装GI，配置Flex ASM，创建ASM磁盘组，创建ACFS。管理ASM实例。启动、关闭、配置和管理GI。安装12c数据库软件，创建RAC数据库，并配置服务。

A.General Database and Network Administration, and Backup Strategy

Create and manage pluggable databases
Create and manage users, roles, and privileges
Configure the network environment to allow connections to multiple databases
Protect the database from loss of data due to any kind of failure
Create and manage database configuration files

B.Data and Performance Management

Modify materialized views
Create a plugged-in tablespace by using the transportable tablespace feature
Create partitioned tables
Configure the database to retrieve all previous versions of the table rows
Configure the Resource Manager
Tune SQL statements
Perform real application testing
Create SQL Plan baselines

C.Data Guard

Create a physical standby database
Make the standby database available for testing
Restore the standby database to its normal function
Configure fast start failover

D.Grid Infrastructure and Real Application Clusters

Install Oracle Grid Infrastructure
Configure Oracle Flex ASM
Create ASM disk groups
Create and manage an ASM instance
Create ACFS
Start, stop, configure, and administer Oracle Grid Infrastructure
Install the Oracle Database 12c software
Create RAC databases
Configure services

Oracle推荐的培训

Oracle Database 12c: New Features for Administrators
Oracle Database 12c: Data Guard Administration
Oracle Database 12c: High Availability New Features
Oracle Database 12c: ASM Administration
Oracle Database 12c: Clusterware Administration
Oracle Database 12c: RAC Administration

每个场景通过可接受的得分:

Skillset 1 - 56%
Skillset 2 - 32%

Skillset 3 - 43%

Skillset 4 - 44%

考试环境

Oracle Linux Release 6.5 64 bit（OEL 6.5 64bit）
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

考生注意事项

Exam participants work through four skillsets that are based on the exam objectives.
Tasks can be performed using CLI or GUI environment and tools when available

技能和经验的最低要求:

3-4 years of professional enterprise-level Oracle experience

Experience with backup, restore and recovery operations

Proficient with SQL

Working knowledge of LINUX command language that includes:

Executing basic OS commands

Creating and navigating through directory structures

File management using copy, move, and delete

Linux environment text editors

Setting environment variables

The ability to locate and/or  use Oracle executables that include but not limited to:

RMAN utility

Oracle Net Manager

Oracle Net Configuration Assistant

Oracle Enterprise Manager Database Express

Listener Utility

OMS

Oracle Password Utility

Database Creation Assistant (DBCA)

DGMGRL

Proficient with OEM Cloud Control

Familiarity navigating through online Oracle documentation

Proficient with using Mozilla browser software

准备阶段

Refer to the Oracle Database12c documentation library available from the Oracle Technology Network

Practice in a representative environment (practice environment does not need to be on the exact OS and database software versions used in the OCM exam - see below). You can download Oracle products from the Oracle Technology Network. Use Oracle Linux operating system.

To prepare for the OCM exam, candidates should focus on mastering the tasks for each Skillset. Software can be downloaded from the Oracle Technology Network (OTN) to build a practice environment.  Use the latest software available from OTN; it is not necessary to build a practice environment on the exact OS and database software versions used in the OCM exam.  Later releases of Oracle server support nearly all features and functions of earlier ones; for any software version, relevant parameter values, naming differences and obsolete features may be found in the product documentation, which is available from OTN.

It is also recommended that candidates practice on the type of keyboard that they expect to find in OCM Test Center. All countries, except those listed will use country-specific keyboards:

United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.

更多详情请查看下面链接

https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:12COCMU