10G-OCM考试简介--考试环境-考试大纲-考试安排-转自还不算晕的专栏

zhltom

首先是10G OCM考试环境：
数据库：Oracle Database 10g Enterprise Edition Release 10.2.0.2.0     Oracle Enterprise Manager 10g Grid Control Release 10.2.0.1.1
操作系统：oel 5.4
数据库软件及操作系统安装包如需要可以留言。
ORALCE官网关于考试环境要求详见：  http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:10GOCM        

关于考试的其它要求及建议：http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:10GOCM&p_org_id=&lang=#tabs-1

Notes about the exam  注意需要使用命令行完成至少40%，用命令或OEM完成40%，其它工具20%。

• Exam participants work through eight skillsets that are based on exam objectives.
  
• Approximately 40% of the tasks must be performed using CLI.
  
• Approximately 40% of the tasks can be performed using either CLI or OEM
  
• The remaining tasks need to be performed using various other tools like Oracle Universal Installer and Database Configuration Assistant.
  

考试大纲：http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:10GOCM&p_org_id=&lang=#tabs-1


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
  

考试安排及要求：  --来自网络

机器内存大概为4G，大多数都是在奇数机上运行。
1、时间安排
第一天：
section 0:创建一个数据库 45分钟
section 1:数据库和网络配置 120分钟
section 2:Gridcontrol安装配置 120分钟
section 3:数据库备份恢复 60分钟
section 4:数据仓库管理 90分钟

第二天：
section 5:数据库管理 120分钟
section 6:数据库性能管理 120分钟
section 7:部署Oracle RAC数据库 105分钟
sectoin 8:部署Dataguard数据库 60分钟