设为首页 收藏本站
查看: 1485|回复: 0

[经验分享] 10G-OCM考试简介--考试环境-考试大纲-考试安排-转自还不算晕的专栏

[复制链接]

尚未签到

发表于 2015-11-9 13:16:34 | 显示全部楼层 |阅读模式
首先是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分钟


运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.yunweiku.com/thread-137071-1-1.html 上篇帖子: OCM_Session7_12_安装listener监听 下篇帖子: OCM考试中Outline的配置
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表