10g OCM 大师认证全面解析及经验分享 挑战自我, 提升价值! 崔旭 @dbstyle
个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述 考试技巧 心得及考场经验分享
个人介绍 姓名 : 崔旭 网络 ID:dbstyle 获 Oracle OCM 认证 OCM 联盟核心成员 个人技术 Blog:http://www.dbstyle.net 微博 :http://weibo.com/ryandbstyle 电话 :13811106886
所获认证
所获认证
个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述 考试技巧 心得及考场经验分享
Oracle DBA 成功之路 将会得到的 享受 阳光与咖啡 高薪水 受尊敬 需要承受的 挫折 心酸 压力 随时待命 从容应对第一份 DBA 工作 融入到 DBA 圈子中 ; 寻找一位良师 初级 DBA 晋级为中级 DBA 创建 自己的 资料库 ; 参与技术讨论 中级 DBA 晋级为高级 DBA 阅读官方文档 ; 成为某一领域专家 ; 撰写技术文章 DBA 四条守则 1. 备份重于一切 ;2. 三思后行 ;3.rm 是危险的 ;4. 指定规范
个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述 考试技巧 心得及考场经验分享
Oracle 认证体系介绍 OCM 含金量最高 业界公认专家 身份的象征 OCP 值得信赖 知识完备 OCA 低级别认证 具备基本技能
个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述 考试技巧 心得及考场经验分享
OCM 考试条件及其要求 获得 OCP 认证 参加云和恩墨的培训 ( 可选三门 ) 或参加 1 门 OU 培训课程 通过三门笔试 ( 选择题 ) DBA 经验积累 要求至少 5 年一线 DBA 工作经验 能够熟练处理数据库故障 经验重于一切 获得 OCM 认证 参加云和恩墨 OCM 培训或参加 2 门 OU 的 OCM 培训课程 参加 OU 为期两天的 OCM 实战上机考试
10g OCM 认证获取路径方法 直接考取路径 10g OCP( 三门选择题笔试 ) 10g OCM( 两天上机直接考试 ) 升级路径 9i OCP 10g OCP( 一门升级选择题笔试 ) 10g OCM( 两天上机直接考试 ) 10g OCP 10g OCM( 两天上机考试 ) 11g OCP 10g OCM( 两天上机考试 )
个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述 考试技巧 心得及考场经验分享
10g OCM 考场环境介绍 熟悉考场环境 Check: 电源 网络 键盘 鼠标 主机配置信息 设备环境 每位考生 2 套环境 奇数机 偶数机 RAC 的两个节点 RAC 环境通过 vncview 方式访问 考生不能互相访问对方数据 考试期间不可提前离开考场 ( 提前交卷除外 ) 每个场景结束后由考官采集成绩交评分组审批 审评制度 出成绩周期较长,4 到 6 周, 历史最快 3 天!
10g OCM 考试形式及考试范围概述 10g OCM 直接考试 : 两天上机考试 10g OCM 直接考试大纲 http://education.oracle.com/pls/web_prodplq-dad/db_pages.getpage? page_id=5001&get_params=p_exam_id: 10GOCM
10g OCM 考试介绍 Platform Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 Oracle Enterprise Manager 10g Grid Control Release 10.2.0.1.1 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.
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
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
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
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
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
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
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
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
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
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
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
个人介绍 Oracle DBA 成功之路 Oracle 认证体系介绍 OCM 考试条件及其要求 OCM 考点解析及考试范围概述 考试技巧 心得及考场经验分享
OCM 考试技巧与心得 OCM 考试技巧 知识点烂熟于胸, 做到 下意识 操作 熟练使用官方文档 不参考任何文档 充分利用所有时间, 熟练使用 vi 和 SQL*Plus 工具 OCM 考试心得 只有平时多流汗, 才能战时少流血! -OCM 备考箴言 对 Oracle 原理通透理解 故障处理思路要清晰 做好充分有效的备份 确保每场分数可采集
考试现场经验分享 10g OCM 考试难度大, 需要大量上机训练! 对操作熟练度要求极高 : 时间短, 任务重 考试范围广 你必须对每一个知识点都有非常丰富的实际操作经验! 设备故障 极有可能遭遇环境问题, 有 备 无患! 考试过程是结交 Oracle 界高手的绝好机会 Good luck!
Oracle 授权实训基地 云和恩墨 OCM OCP http://www.enmoedu.com ENMO-OCM西点军校 战队宣言 追求卓越 共创价值! ENMO_OCM交流QQ群 279496979
百名 OCM 大师合影留念 温暖的大家庭
ENMO_OCM 西点军校 欢迎您
完整版视频课程获取方法 : 方法一 : 加入恩墨学院 QQ 交流群 (279496979) 方法二 : 直接联系 ENMO 学院君 QQ:1478525441 恩墨学院官网 :http://edu.enmotech.com/ 恩墨学院邮箱 :training@enmotech.com 恩墨学院 QQ 交流群 :279496979 联系方式 :400-660-8755( 转 2)