Oracle OCM 12c Certification Study project.
Completed 2 of the advanced or specialty courses to meet the hands-on course requirements.
My Books Collections
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 12c Release 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
- https://hiteshgondalia.wordpress.com/hol-dataguard/
- 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
Pingback: General Database and Network Administration | ORACLE -LEARN
Pingback: OCM 12c Preparation for General Database and Network Administration | ORACLE -LEARN
Pingback: Manage Database Availability | ORACLE -LEARN
Very interesting blog!!!! Thank you very much
Thank you, Hela for visiting this blog.
Hi Hitesh,
Very informative and concise blog. Are you going to cover up the remaining topics RAC, DG & GI which are left out?
Thank you Jitin for sharing your feedback,
Yes, I will post the remaining topics within the next three months.
HI Hitesh,
I really like your blog, thank you!. Do you know anything about OCM exam? There is no 12c schedule anymore and 19c being LTS version I do not know what will happen.
Hi Hitesh,
It’s a brilliant idea to write such blog. Could you please help to fix the opening of links; the message is “oracle-learn.com domain is expired”. And do you know any details about scheduling OCM exams ?
Thank you
Yes, Please check now.