|
首先是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分钟
|
|
|