驾照考完了，接下来的一段时间，是该静下来学习一下ocm的相关知识，为ocm考试准备了。在这里，我会记录下准备ocm考试的相关知识，和大家一起分享。
考试科目：10G OCM（其他各个科目如9i，11g的oca，ocp，ocm等考试计划，可参见这里）
考试价格：RMB:7720/人
考试时间：2天，早上9点开始，下午18点结束。一旦考试开始，在每个考试测试部分（skillset）不允许离开。如果考试没通过，再次考试的时间需要间隔14天。
考试相关：考试需要完成8个部分（8 skillsets）的测试内容，大约40%的考试内容需要通过命令行，大约40%左右的内容可以使用命令行或者OEM界面，其他百分比的内容需要通过Universal Installer或者dbca来完成。
获得证书途径：完成2门现场或者在线的高级课程培训+提交完成高级课程的表格+OCM考试+提交完成完成表格的表格（HAND-ON），你真正需要挑战的，就是这里面的OCM考试。
OCM考试需要完成2门高级培训，你可以在以下的课程中选择2门：
Advanced or Specialty courses：
* Oracle Database 10g: OCM Exam Preparation (Not available in all regions.)
* Oracle Database 10g: Performance Tuning
* Oracle Database 10g: Performance Tuning Ed 1.1 LVC
* Oracle Database 10g: Backup and Recovery
* Oracle Database 10g: Backup and Recovery LVC
* Oracle Database 10g: Real Application Clusters
* Oracle Database 10g: RAC for Administrators Release 2
* Oracle Database 10g: RAC for Administrators LVC
* Oracle 10g Database: RAC Deployment Workshop
* Oracle Database 11g: RAC Administration
* Oracle Database 10g: Data Guard Administration
* Oracle Enterprise Manager 10g Grid Control
* Oracle Enterprise Manager 10g Grid Control Release 2
* Oracle Database 10g: Implement Streams
* Oracle Database 10g: Implement Streams Ed 2 LVC
* Oracle Database 10g: Security
* Oracle Database 10g: Security Ed 2 LVC
* Oracle Database 10g: Security Release 2
* Migrate from SQL Server to Oracle Database 10g
* Migrate from Sybase to Oracle Database 10g
* Oracle Database 10g: SQL Tuning Workshop
* Oracle Database 10g: Program with PL/SQL
* Oracle Database 10g: Advanced PL/SQL
* Oracle Database 10g: Using XML for SQL and PL/SQL Developers
* Oracle Database 10g: Implement and Administer Data Warehouse
* Oracle Database 10g:Using OLAP
* Oracle Database 10g: Develop Applications Using HTML DB (Database)
* Oracle Spatial 10g: Advanced
* Oracle Database 11g: New Features for Administrators
* Oracle Database 11g: New Features for 9i DBAs
或者你也可以从以下的科目选择2门（很奇怪，10g的ocm却是9i的课程）：
Additional Approved Courses：
* Oracle9i: Program with PL/SQL
* Oracle9i: Advanced PL/SQL
* Oracle9i: Implement Advanced Queing
* Oracle9i: SQL Tuning Workshop
* Oracle9i Database: SQL Tuning Workshop R2
* Oracle 9i: Advanced Instance Tuning
* Oracle Net Services: Advanced Administration
* Oracle9i Database: Advanced Replication
* Oracle Enterprise Manager 9i
* Oracle9i Database: Security
* Oracle9i Database: Implementing Oracle Streams
* Oracle 9i: Data Guard Administration
* Oracle9i Release 2: Real Application Clusters
* Oracle9i Database: Advanced Backup and Recovery using RMAN
* Oracle9i: Data Warehouse Administration
* Oracle9i Database: Implement Partitioning
* Administering the Oracle Internet Directory
在选择课程的时候，你不能选择那些你在考ocp时候念的课程。说白了，就是oracle一定要收你的钱，才允许你考试。
参加考试的技能条件：
参加ocm考试，你至少要会以下技能：
有3～4年的oracle企业级应用管理经验。
能完成备份、恢复、还原。（这个条件必备，因为在考试中数据库会故障，要求你还原）
精通sql
OS方面：
会基本的linux os命令
创建目录和进入目录
拷贝、删除、移动文件
会使用文本编辑器。
会设置环境变量
另外，你还需要熟悉oracle方面的知识：
rman
net manager
netca
oem
listener管理工具
oms
orapwd
dbca
另外你要非常熟悉online document的查询。
注查询的时候，提供的浏览器是Mozilla 1.6。
考试使用的Oracle版本：
* Oracle Database 10g Rel. 2 (10.2.0.2)
* Oracle Enterprise Manager Rel. 2 (10.2.0.2)
* Oracle Database 10g Rel. 2 (10.2.0.1) - For RAC Only
考试使用的OS平台：
* For Candidate machines (both ODD and Even): Red Hat Enterprise Linux AS release 4 (Nahant Update 2)
* For RAC Cluster nodes: Red Hat Enterprise Linux AS release 3 (Taroon Update 7)
注意：每个参加ocm考试的人，需提供一个9位的Testing ID（请至少在参加考试1个星期前，获得你的Testing ID）
考试的大纲：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 |
Server Configuration [ ] Create the database [ ] Determine and set sizing parameters for database structures [ ] Create and manage temporary, permanent, and undo tablespaces [ ] Stripe data files across multiple physical devices and locations [ ] Configure the database environment to support optimal data access performance [ ] Create and manage database configuration files [ ] Create and manage bigfile tablespaces [ ] Create and manage multiple network configuration files [ ] Create and configure a listener [ ] Configure the database instance to support shared server connections [ ] Set up network tracing [ ] Manage Oracle network processes (the Listener Control utility) [ ] Configure the network environment to allow connections to multiple databases [ ] Use configurationless connections Enterprise Manager Grid Control [ ] Install the Enterprise Manager Grid Control software [ ] Configure the Enterprise Manager repository [ ] Create Enterprise Manager Grid Control users [ ] Use Enterprise Manager to modify a database configuration [ ] Configure Enterprise Manager to modify a database availability [ ] Create and manage jobs [ ] Create and monitor alerts [ ] Create notifications [ ] Implement Grid Control and Database Control [ ] Choose the appropriate tablespace type for the intended use [ ] Create Scheduler jobs [ ] Create schedules [ ] Assign jobs to windows [ ] Create programs [ ] Create job classes [ ] Install the Enterprise Manager Grid Control infrastructure [ ] Deploy Enterprise Manager Grid Control agents [ ] Configure Grid Control for business requirements Managing Database Availability [ ] Create a recovery catalog database [ ] Configure Recovery Manager [ ] Use Recovery Manager to perform database backups [ ] Use Recover Manager to perform complete database restore and recovery operations [ ] Set Flashback Database parameters [ ] Monitor Flashback Database logs and statistics [ ] Perform a Flashback Database operation [ ] Configure a flash recovery area Data Management [ ] Implement fine-grained auditing [ ] Create a secure application role [ ] Grant specific privileges for a Flashback Query [ ] Set parameters for retaining undo [ ] Implement fine-grained access control [ ] Create and manage contexts [ ] Use SQL*Loader [ ] Implement transportable tablespaces between homogeneous and heterogeneous systems (using different methods of moving files) [ ] Choose the appropriate partition method (range, hash, list, and composite) [ ] Choose the appropriate partition key [ ] Choose appropriate indexing methods (local, global, prefixed, and nonprefixed) [ ] Perform partition maintenance operations [ ] Maintain indexes on a partitioned table [ ] Create and manage LOB segments [ ] Apply parallelism appropriately [ ] Tune memory for parallel operations [ ] Set parallel parameters Data Warehouse Management [ ] Create external tables (Data Loader and Data Pump drivers) [ ] Implement Data Pump export and import jobs for data transfer [ ] Implement Data Pump to and from remote databases [ ] Implement Replication/Streams [ ] Configure and manage master replication [ ] Configure and manage distributed materialized views [ ] Configure and manage Streams for replication Performance Management [ ] Install Statspack [ ] Adjust the default interval for statistics collection [ ] Customize the events that are monitored [ ] Use ADDM to analyze statistics and to identify performance bottlenecks and fix them [ ] Implement automatic shared memory management [ ] Tune memory using manual memory management [ ] Monitor and tune SGA areas that are not automatically tuned [ ] Implement automatic SQL execution memory management [ ] Tune the PGA using work area size parameters [ ] Use the PGA Advisor [ ] Create a Database Resource Manager plan with directives (active session count, max execution time) [ ] Create consumer groups [ ] Configure consumer group mappings [ ] Manage Services [ ] Create and manage objects to accommodate different data access methods (schema tuning) [ ] Use the SQL Tuning Advisor [ ] Use the SQL Access Advisor [ ] Gather Optimizer statistics [ ] Interpret execution plan [ ] Use SQL tuning tools and features Real Application Clusters [ ] Install Oracle Clusterware [ ] Install the Oracle Database 10g software [ ] Implement ASM failure groups [ ] Create and manage as ASM instance [ ] Create and manage ASM disk groups [ ] Configure ASM for the shared disks, and create a clustered database [ ] Configure archiving [ ] Configure Services with a preferred instance and an available instance Data Guard [ ] Use Data Guard Manager and DGMGRL [ ] Create and utilize a physical standby database [ ] Create and utilize a logical standby database [ ] Set up log transport services for various levels or protection [ ] Configure the network environment to allow communication between the standby database and the primary database [ ] Open the physical standby database in a "ready-only" state [ ] Perform a switchover operation and a failover operation [ ] Implement Data Guard |
另外，如果你希望获得更多的信息，且能上twitter，我建议你follow这个帐号：@OracleCert，会有最新的实时消息。另外，在这里也有目前已经通过OCM的名单，有什么问题和他们Email联系，我想，他们也会乐意帮助你的。
3条评论
1：考试价格不是2000美金，而是大约8000人民币；
2：没记错的话，考试的db和gc应该都是10.2.0.1的版本；
3：考试应该一共是9个sections，其中section 0 ，手工建库为非计分场景；
4：考试开始以后，你可以离开考场，抽烟，喝水，上厕所都可以，但是，这些全部算你的考试时间，也就是从考试开始，到固定的时间结束，中间你想干什么都可以。
5：熟悉的应该不是online document，而是oracle随机光盘中的文档，考试的时候，文档是不能像online document那样做search的，所以要记得内容在那本书的那个地方。
谢谢三少，资料是从otn和education.oracle.com上找的，可能有些和国内的情况不相符，谢谢指正。
btw，你去考过ocm了？
11.2-3我去了，看来你很就没看我的blog了，nnd