{"id":923,"date":"2014-10-22T09:20:39","date_gmt":"2014-10-22T12:20:39","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?page_id=923"},"modified":"2017-09-13T08:30:47","modified_gmt":"2017-09-13T11:30:47","slug":"ocm-11g-preparation","status":"publish","type":"page","link":"https:\/\/www.dbarj.com.br\/en\/ocm-11g-preparation\/","title":{"rendered":"OCM 11g Preparation"},"content":{"rendered":"

Today (22nd October 2014) I will start my Oracle OCM 11g<\/strong> study project. I will list here the topics and some study guides for each of them, so I can exchange with you who is also applying, interested or have any\u00a0skills. Please comment in the post related to each topic if you find out any more valuable information to add.<\/p>\n

My target is\u00a0to\u00a0take the exam by October\/2015<\/strong>.<\/span><\/p>\n

UPDATE 1: I did it on\u00a014th AND 15th October IN Bucharest, Romania. Now I’m waiting for the results! (More information in sections 4 and 5).<\/strong><\/span><\/p>\n

UPDATE 2: After 35 long days, the result finally came on November 20th and now I’m officially and OCM! (More information in section 6).<\/strong><\/span><\/p>\n

Every\u00a0topic will have a link to a post where I will cover some test cases, what is needed to study and the link to the official Oracle Doc related. Remember, the Oracle Official Doc is all you will have on the day of the exam, so being fast and getting to the item in the DOC is a necessity.<\/p>\n

Let’s start:<\/p>\n

1 – Before you begin<\/h2>\n

– Recommended Hardware for Study<\/a>
\n– Download the Exam Environment<\/a>
\n– Prepare your Environment<\/a>
\n– Course Requirements<\/a>
\n– Where to take the exam<\/a><\/p>\n

2 – Topics<\/h2>\n

Those topics were get from the official Oracle OCM website<\/a>\u00a0on Oct\/2014. I will update if I notice any modification.<\/p>\n

I recommend you to print this list in a front\/back page (you can get the pdf here<\/a>\u00a0and print it) and “check” each completed item with a pen! It’s a good way to control your progression. Thanks to Kamran<\/a> for this tip.<\/p>\n

 <\/p>\n

Server Configuration<\/strong>
\n\u2022 Create the database<\/a>
\n\u2022 Determine and set sizing parameters for database structures<\/a>
\n\u2022 Create and manage temporary, permanent, and undo tablespaces<\/a>
\n\u2022 Stripe data files across multiple physical devices and locations<\/a>
\n\u2022 Configure the database environment to support optimal data access performance<\/a>
\n\u2022 Create and manage database configuration files<\/a>
\n\u2022 Create and manage bigfile tablespaces<\/a>
\n\u2022 Create and Manage a tablespace that uses NFS mounted file system file<\/a>
\n\u2022 Create and manage multiple network configuration files<\/a>
\n\u2022 Create and configure a listener<\/a>
\n\u2022 Configure the database instance to support shared server connections<\/a>
\n\u2022 Set up network tracing<\/a>
\n\u2022 Manage Oracle network processes<\/a>
\n\u2022 Configure the network environment to allow connections to multiple databases<\/a>
\n\u2022 Use configurationless connections<\/a>
\n\u2022 Use OPatch to install a patch<\/a>
\n\u2022 Use Grid Infrastructure to manage oracle databases and other resources<\/a>
\n\u2022 Use Enterprise Manager Configuration Assistant(EMCA) utility<\/a><\/p>\n

Enterprise Manager Grid Control<\/strong>
\n\u2022 Install and Patch Enterprise Manager Grid Control software<\/a>
\n\u2022 Configure the Enterprise Manager repository<\/a>
\n\u2022 Create Enterprise Manager Grid Control users<\/a>
\n\u2022 Use Enterprise Manager to modify a database configuration<\/a>
\n\u2022 Configure Enterprise Manager to modify database availability<\/a>
\n\u2022 Create and manage jobs<\/a>
\n\u2022 Create and monitor alerts<\/a>
\n\u2022 Create notifications<\/a>
\n\u2022 Implement Grid Control and Database Control<\/a>
\n\u2022 Choose the appropriate tablespace type for the intended use<\/a>
\n\u2022 Create Scheduler jobs<\/a>
\n\u2022 Create schedules<\/a>
\n\u2022 Assign jobs to windows<\/a>
\n\u2022 Create programs<\/a>
\n\u2022 Create job classes<\/a>
\n\u2022 Install the Enterprise Manager Grid Control infrastructure<\/a>
\n\u2022 Deploy Enterprise Manager Grid Control agents<\/a>
\n\u2022 Configure Grid Control for business requirements<\/a><\/p>\n

Managing Database Availability<\/strong>
\n\u2022 Mantain recovery catalogs<\/a>
\n\u2022 Configure Recovery Manager<\/a>
\n\u2022 Use Recovery Manager to perform database backups<\/a>
\n\u2022 Use Recover Manager to perform complete database restore and recovery operations<\/a>
\n\u2022 Configure RMAN<\/a>
\n\u2022 Create different types of RMAN backups to cater for different performance and retention requirements<\/a>
\n\u2022 Set Flashback Database parameters<\/a>
\n\u2022 Configure a Fast Recovery Area<\/a>
\n\u2022 Perform various recovery operations using Flashback technology<\/a><\/p>\n

Data Management<\/strong>
\n\u2022 Manage Materialized Views to improve rewrite and refresh performance<\/a>
\n\u2022 Configure and manage distributed materialized views<\/a>
\n\u2022 Create and Manage encrypted tablespaces<\/a>
\n\u2022 Manage Transport of tablespaces across platforms<\/a>
\n\u2022 Configure a schema to support a star transformation query<\/a>
\n\u2022 Administer external tables<\/a>
\n\u2022 Implement Data Pump export and import jobs for data transfer<\/a>
\n\u2022 Implement Data Pump to and from remote databases<\/a>
\n\u2022 Configure and use parallel execution for queries<\/a>
\n\u2022 Use SQL*Loader<\/a>
\n\u2022 Administer, manage and tune parallel execution<\/a><\/p>\n

Data Warehouse Management<\/strong>
\n\u2022 Administer partitioned tables and indexes using appropriate methods and keys<\/a>
\n\u2022 Perform partition maintenance operations<\/a>
\n\u2022 Maintain indexes on a partitioned table<\/a>
\n\u2022 Implement securefile LOB<\/a>
\n\u2022 Create and manage LOB segments<\/a>
\n\u2022 Implement fine-grained access control<\/a>
\n\u2022 Create and manage contexts<\/a>
\n\u2022 Administer flashback data archive and schema evolution<\/a><\/p>\n

Performance Management<\/strong>
\n\u2022 Administer Resource Manager<\/a>
\n\u2022 Use Result Cache<\/a>
\n\u2022 Use multi column statistics<\/a>
\n\u2022 Gather statistics on a specific table without invalidating cursors<\/a>
\n\u2022 Use partitioned indexes<\/a>
\n\u2022 Administer and tune schema object to support various access methods<\/a>
\n\u2022 Interpret execution plan<\/a>
\n\u2022 Use SQL tuning tools and features<\/a>
\n\u2022 Use SQL Tuning Advisor<\/a>
\n\u2022 Use SQL Access Advisor<\/a>
\n\u2022 Use SQL Performance Analyzer<\/a>
\n\u2022 Configure baseline templates<\/a>
\n\u2022 Use SQL Plan Management feature<\/a>
\n\u2022 Implement instance caging<\/a><\/p>\n

Grid Infrastructure and ASM<\/strong>
\n\u2022 Install Oracle Grid Infrastructure<\/a>
\n\u2022 Create ASM Disk Groups<\/a>
\n\u2022 Create and manage an ASM instance<\/a>
\n\u2022 Implement ASM failure groups<\/a>
\n\u2022 Creating ACFS File System<\/a>
\n\u2022 Start, stop, configure and administer Oracle Grid Infrastructure<\/a><\/p>\n

Real Application Clusters<\/strong>
\n\u2022 Install the Oracle Database 11gR2 software<\/a>
\n\u2022 Configure ASM for the shared disks and create a clustered database<\/a>
\n\u2022 Configure archiving<\/a>
\n\u2022 Configure services using both Manual and Policy Managed methods<\/a><\/p>\n

Data Guard<\/strong>
\n\u2022 Create Physical Standby Database with real-time apply.<\/a>
\n\u2022 Configure the data guard environment to reduce overheads of fast incremental backups on the primary database<\/a>
\n\u2022 Configure the Observer<\/a>
\n\u2022 Switchover and switch back<\/a>
\n\u2022 Configure connect time failover<\/a>
\n\u2022 Convert the standby to a snapshot standby<\/a>
\n\u2022 Configure archivelog deletion policy for the Dataguard configuration<\/a><\/p>\n

3 – Others Certifications as study\u00a0strategy<\/h2>\n

One very good path\u00a0to study for the OCM<\/strong> is taking other Oracle Certifications as a way to cover a topic. This is the way I’m doing and I recommend it.\u00a0The work & study required to prepare for certification exams broadens your knowledge by exposing you to a wide variety of essential functions, features & tasks.<\/p>\n

Getting certified also adds a lot of benefits for you and your career, as Oracle listed\u00a0here<\/a>.<\/p>\n

So, what extra certifications do I recommend you to take as you study and for what topics do they prepare you?<\/p>\n