- 从Oracle大学(Oracle University)购买考试券。
- 在PearsonVue预约考试并选择临近的考场。
- 在Oracle测试中心注册考试。
- 仔细回顾OCM考试列出的考点以评估你是否需要额外的加强训练和准备。
- 选择参加Oracle大学中的高级数据库管理员课程来增强你的训练效果。
- 从Oracle Technology Network(OTN)中查阅Oracle数据库11g文档库进行学习。
- 准备一个实验环境(实验环境并不需要和OCM考试中使用的操作系统和软件版本完全一致)。你可以从OTN上直接下载Oracle产品来搭建你的环境。请使用Linux操作系统来搭建。RedHat或其他Linux都可，所需环境应支持KDE。
- 考试环境：除了日本之外，不管你在哪里参见考试，OCM考试环境都将是全英文的。
- 重考政策：一旦考试失败，你需要等待14天才能再次注册。（请注意，即便你换一个新的测试ID来注册考试也是不合规的，这将使得你的考试无效。）
- 考试取消政策：一旦你注册了考试，则考试不可取消，相关费用也是不可退的。
- 基于考试目标，考生将经历9个技术环节方面的作业。
- 任务中可以通过命令行模式(CLI)或图形化模式(GUI)以及当时可用的工具来完成。
- Oracle Linux Release 5.4 (32-bit)
- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 (32-bit)
- Oracle Enterprise Manager 11g Grid Control Release 1 (11.1.0.1.0) (32-bit)
- 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 a tablespace that uses NFS mounted file system file
- 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
- Configure the network environment to allow connections to multiple databases
- Use configurationless connections
- Use OPatch to install a patch
- Use Grid Infrastructure to manage oracle databases and other resources
- Use Enterprise Manager Configuration Assistant(EMCA) utility
- Install and Patch 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 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
- Mantain recovery catalogs
- Configure Recovery Manager
- Use Recovery Manager to perform database backups
- Use Recover Manager to perform complete database restore and recovery operations
- Configure RMAN
- Create different types of RMAN backups to cater for different performance and retention requirements
- Set Flashback Database parameters
- Configure a Fast Recovery Area
- Perform various recovery operations using Flashback technology
- Manage Materialized Views to improve rewrite and refresh performance
- Configure and manage distributed materialized views
- Create and Manage encrypted tablespaces
- Manage Transport of tablespaces across platforms
- Configure a schema to support a star transformation query
- Administer external tables
- Implement Data Pump export and import jobs for data transfer
- Implement Data Pump to and from remote databases
- Configure and use parallel execution for queries
- Use SQL*Loader
- Administer, manage and tune parallel execution
- Administer partitioned tables and indexes using appropriate methods and keys
- Perform partition maintenance operations
- Maintain indexes on a partitioned table
- Implement securefile LOB
- Create and manage LOB segments
- Implement fine-grained access control
- Create and manage contexts
- Administer flashback data archive and schema evolution
- Administer Resource Manager
- Use Result Cache
- Use multi column statistics
- Gather statistics on a specific table without invalidating cursors
- Use partitioned indexes
- Administer and tune schema object to support various access methods
- Interpret execution plan
- Use SQL tuning tools and features
- Use SQL Tuning Advisor
- Use SQL Access Advisor
- Use SQL Performance Analyzer
- Configure baseline templates
- Use SQL Plan Management feature
- Implement instance caging
- Install Oracle Grid Infrastructure
- Create ASM Disk Groups
- Create and manage as ASM instance
- Implement ASM failure groups
- Creating ACFS File System
- Start, stop, configure and administer Oracle Grid Infrastructure
- Install the Oracle Database 11gR2 software
- Configure ASM for the shared disks and create a clustered database
- Configure archiving
- Configure services using both Manual and Policy Managed methods
- Create Physical Standby Database with real-time apply.
- Configure the data guard environment to reduce overheads of fast incremental backups on the primary database
- Configure the Observer
- Switchover and switch back
- Configure connect time failover
- Convert the standby to a snapshot standby
- Configure archivelog deletion policy for the Dataguard configuration
- 拥有最少3-4年Oracle经验。拥有5年以上相关工作经验参与者将更加适合。
- 请确认你在建议的最低技能经验年限下，已拥有所有相关技能。
- 在考试中请准备使用非在线查询文档来帮助你修正你的命令语法错误。
- 即便你知道如何在图形化下完成任务，也请准备一份命令行解决方案，因为并不是每个考试部分都能使用图形界面(GUI)。
- 对于所有的考点，请花时间进行动手练习，特别是那些你不常用到的技能。
- 你必须具备将抽象概念需求变成可执行的特定命令的能力。这里你的实际工作经验及动手实验能力将对你能否成功通过考试非常关键。
- 3-4年企业级Oracle职业经验
- 拥有丰富的备份，恢复及还原操作经验
- 精通SQL
- 熟悉以下Linux命令的使用：
- 格式化命令以及基本操作系统执行命令
- 建立及浏览目录结构
- 拷贝、移动和删除等文件管理命令
- Linux环境文本编辑器
- 环境变量设置
- 能熟练使用以下Oracle可执行工具：
- RMAN工具
- Oracle Net Manager
- Oracle Net Configuration Assistant
- OEM
- Listener工具
- OMS
- Oracle密码工具
- DBCA
- DGMGRL (for 11g OCM)
- 熟练使用Oracle Enterprise Manager
- 熟练使用Oracle Net Manager和Oracle Net Configuration Assistant来配置网络
- 拥有对Oracle企业服务器技术及特性应用到高级知识技能
- 能熟悉浏览Oracle文档
- 熟练使用Mozilla 1.6浏览器软件
- 选择你希望参加的认证考试计划事件
- Oracle Database 10g Administrator Certified Master考试事件
- Oracle Database 11g Certified Master考试事件
- Oracle Database 11g Certified Master升级考试事件
- 按国家及考试时间安排来进行“注册”。
- 结账。
- 如果在当地找不到OCM考试举办事件，请联系当地的Oracle大学代表以获取相关信息。
- 区分认证级别
- 被记录入OCM专家档案
- 可在商业名片，著作等使用OCM logo
- 一件绣有数据库OCM logo的衣服