个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

Size: px

Start display at page:

Download "个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享"

载链祖
7 years ago
Views:

1 10g OCM 大师认证全面解析及经验分享挑战自我, 提升价值!

2 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

3 个人介绍姓名 : 崔旭网络 ID:dbstyle 获 Oracle OCM 认证 OCM 联盟核心成员个人技术 Blog: 微博 : 电话 :

4 所获认证

5 所获认证

6 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

7 Oracle DBA 成功之路将会得到的享受阳光与咖啡高薪水受尊敬需要承受的挫折心酸压力随时待命从容应对第一份 DBA 工作融入到 DBA 圈子中 ; 寻找一位良师初级 DBA 晋级为中级 DBA 创建自己的资料库 ; 参与技术讨论中级 DBA 晋级为高级 DBA 阅读官方文档 ; 成为某一领域专家 ; 撰写技术文章 DBA 四条守则 1. 备份重于一切 ;2. 三思后行 ;3.rm 是危险的 ;4. 指定规范

8 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

9 Oracle 认证体系介绍 OCM 含金量最高业界公认专家身份的象征 OCP 值得信赖知识完备 OCA 低级别认证具备基本技能

10 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

11 OCM 考试条件及其要求获得 OCP 认证参加云和恩墨的培训 ( 可选三门 ) 或参加 1 门 OU 培训课程通过三门笔试 ( 选择题 ) DBA 经验积累要求至少 5 年一线 DBA 工作经验能够熟练处理数据库故障经验重于一切获得 OCM 认证参加云和恩墨 OCM 培训或参加 2 门 OU 的 OCM 培训课程参加 OU 为期两天的 OCM 实战上机考试

12 10g OCM 认证获取路径方法直接考取路径 10g OCP( 三门选择题笔试 ) 10g OCM( 两天上机直接考试 ) 升级路径 9i OCP 10g OCP( 一门升级选择题笔试 ) 10g OCM( 两天上机直接考试 ) 10g OCP 10g OCM( 两天上机考试 ) 11g OCP 10g OCM( 两天上机考试 )

13 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

14 10g OCM 考场环境介绍熟悉考场环境 Check: 电源网络键盘鼠标主机配置信息设备环境每位考生 2 套环境奇数机偶数机 RAC 的两个节点 RAC 环境通过 vncview 方式访问考生不能互相访问对方数据考试期间不可提前离开考场 ( 提前交卷除外 ) 每个场景结束后由考官采集成绩交评分组审批审评制度出成绩周期较长,4 到 6 周, 历史最快 3 天!

15 10g OCM 考试形式及考试范围概述 10g OCM 直接考试 : 两天上机考试 10g OCM 直接考试大纲 page_id=5001&get_params=p_exam_id: 10GOCM

16 10g OCM 考试介绍 Platform Oracle Database 10g Enterprise Edition Release Oracle Enterprise Manager 10g Grid Control Release Operating System: Oracle Enterprise Linux 5 Update 4 (OEL 5 Update 4) Notes about the exam 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.

17 10g OCM 考试大纲解析 1.Server Configuration 2.Enterprise Manager Grid Control 3.Managing Database Availability 4.Data Management 5.Data Warehouse Management 6.Performance Management 7.Real Application Clusters 8.Data Guard

18 10g OCM 考试大纲解析 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

19 10g OCM 考试大纲解析 2.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

20 10g OCM 考试大纲解析 3.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

21 10g OCM 考试大纲解析 4.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

22 10g OCM 考试大纲解析 5.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

23 10g OCM 考试大纲解析 6.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

24 10g OCM 考试大纲解析 6.Performance Management 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

25 10g OCM 考试大纲解析 7.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

26 10g OCM 考试大纲解析 8.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

27 10g OCM 收益 OCMs continue to enjoy the OCP member benefits and also receive these additional benefits: Distiguished industry-recognized credential, backed by Oracle s brand equity OCM professional profile Exclusive use of the OCM logo for business cards, literature, etc. Complimentary Database OCM Logo embroidered apparel items

28 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享

29 OCM 考试技巧与心得 OCM 考试技巧知识点烂熟于胸, 做到下意识操作熟练使用官方文档不参考任何文档充分利用所有时间, 熟练使用 vi 和 SQL*Plus 工具 OCM 考试心得只有平时多流汗, 才能战时少流血! -OCM 备考箴言对 Oracle 原理通透理解故障处理思路要清晰做好充分有效的备份确保每场分数可采集

30 考试现场经验分享 10g OCM 考试难度大, 需要大量上机训练! 对操作熟练度要求极高 : 时间短, 任务重考试范围广你必须对每一个知识点都有非常丰富的实际操作经验! 设备故障极有可能遭遇环境问题, 有备无患! 考试过程是结交 Oracle 界高手的绝好机会 Good luck!

31 Oracle 授权实训基地云和恩墨 OCM OCP ENMO-OCM西点军校战队宣言追求卓越共创价值! ENMO_OCM交流QQ群

32 百名 OCM 大师合影留念温暖的大家庭

33 ENMO_OCM 西点军校欢迎您

34 完整版视频课程获取方法 : 方法一 : 加入恩墨学院 QQ 交流群 ( ) 方法二 : 直接联系 ENMO 学院君 QQ: 恩墨学院官网 : 恩墨学院邮箱 :training@enmotech.com 恩墨学院 QQ 交流群 : 联系方式 : ( 转 2)

OCM大师认证全面解析及经验分享 - 侯圣文（secooler）

OCM大师认证全面解析及经验分享 - 侯圣文（secooler） 11g OCM 大师认证全面解析及经验分享挑战自我, 提升价值! 侯圣文 @secooler 个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享个人介绍姓名 : 侯圣文网络 ID:Secooler 北京大学理学硕士 Oracle ACE 总监获 Oracle OCM 认证 OCM 联盟

个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述 考试技巧 心得及考场经验分享

个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述考试技巧心得及考场经验分享