选择博学的八大理由:Oracle专业培训中心• 全球统一技术教案• 经验丰富讲师授课• 公允实在培训价格• 滚动开课随到随学• 1年内免费重读• 普尔文、VUE、Redhat考试中心• 100余家大型企事业单位*培训供应商。咨询热线
Oracle 10g OCM认证培训
Oracle*推出的全球认证计划 OCM(Oracle Certified Manager)，是由Oracle公司颁布并实施的一项权威的专业技术标准，行业分析师和IT技术专家认为Oracle认证是IT市场最有价值的全球认可的资格认证之一。从认证专员、认证专家到认证大师，每个Oracle 级别都标志着一种业界认可的经验和专业标准。
Oracle 认证专家(OCM)
资深专家级Oracle 技能考试，通过后将成为企业内的资深专家。OCM 不但有能力处理关键业务数据库系统和应用，还能帮助客户利用Oracle 技术获得成功。要想获得OCM 证书，必须先通过OCP考试，再学习两门高级技术课程，并通过预考，然后在Oracle 实验室环境内成功地通过实习考试。实习考试的目的是培养动手能力，学员必须实际完成职业需要的真正任务。
10g OCM认证培训课程及时间：
* Oracle Enterprise Manager 10g Grid Control （5天）
* Oracle Database 10g: Real Application Clusters （5天）
* Oracle Database 10g: Data Guard Administration （3天）
* Oracle Database 10g: Performance Tuning （4天）
* Oracle Database 10g: Implement and Administer Data Warehouse （4天）
* Oracle Database 10g: Backup and Recovery （3天）
* Oracle Database 10g: OCM Exam Preparation (2天)
培训前提：具有OCP证书或同层次技术能力。
课程长度：26天/156小时
开班类型 日期 时间
脱产班 周一至周五 上午 09：00—12：00
下午 13：30—16：30
培训地点: 杭州市文三路252号伟星大厦19楼博学国际教育培训中心
ORACLE 认证大师 (OCM) 课程介绍：
Oracle Enterprise Manager 10g Grid Control (5天)
Oracle Enterprise Manager 10g Grid Control delivers centralized management functionality for the complete Oracle IT infrastructure, including systems running Oracle and non-Oracle technologies. With a broad set of administration, configuration management, provisioning, end-to-end monitoring, and security capabilities, Oracle Grid Control reduces the cost and complexity of managing grid computing environments. Robust service level management functionality within Oracle Grid Control dramatically improves service levels through rich transaction and end-user performance monitoring and deep diagnostics for multi-tier Internet applications. Oracle Grid Control also offers a comprehensive extensibility framework for management of custom applications and integration with other management tools. These capabilities allow companies to deliver superior performance for their systems and applications, while continually reducing management complexity and costs.
The participants gain knowledge on the installation and configuration of the Grid Control framework. The out-of-box capability to manage Oracle targets as well as the ability to extend Grid Control to manage non-Oracle targets is presented. Hands-on practices help students learn how use the robust features of Grid Control to manage, monitor, and administer their data center.
培训内容： * Introduction
* Grid Control Architecture
* Deploying Grid Control
* Deploying the Oracle Management Agent
* Securing Grid Control
* Monitoring Grid Control
* Configuring Grid Control
* Common Managed Targets - Host
* Common Managed Targets – Oracle Database
* Common Managed Targets - Oracle Application Servers * Monitoring your Data Center
* Groups
* Systems and Services
* Job System
* Configuration Management
* Provisioning
* Information Publisher
* Monitoring Oracle Collaboration Suite
* Management Plug-ins
* Upgrade to Grid Control 10.2
Oracle Database 10g: Real Application Clusters (5天)
This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 1 for Oracle Real Application Clusters (RAC).Students learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration
课程目标:
* Identify Real Application Clusters components
* Install, create, administer, and monitor a Real Application Clusters database
* Use configuration and management tools for Real Application Clusters databases
* Migrate your database storage to Automatic Storage Management
* Setup services for workloads management, and applications high availability
* Develop a backup and recovery strategy for Real Application Clusters databases
* Review high availability best practices
课程内容： * Introduction
* Architecture and Concepts
* RAC Installation and Configuration Part I
* RAC Installation and Configuration Part II
* RAC Database Instances Administration
* Administering Storage in RAC Part I * Administering Storage in RAC Part II
* Services
* High Availability of Connections
* Managing Backup and Recovery in RAC
* RAC Performance Tuning
* Design for High Availability
Oracle Database 10g: Data Guard Administration (3天)
Minimize the downtime associated with any outage and prevent data loss by learning how to use Oracle Data Guard. The course details Data Guard architecture as well as the creation of physical and logical standby databases. In addition, it examines the performance implications of using various Data Guard features and offers some troubleshooting tips.
Learn to use Enterprise Manager Grid Control to create and manage your Data Guard configuration. A workshop that gives students the opportunity to apply what they have learned to meet stated business requirements reinforces skills
课程目标:
* Use Data Guard to achieve a highly available Oracle Database
* Describe the Data Guard architecture
* Modify the Data Guard services
* Use the Data Guard broker
* Implement physical and logical standby databases
* Perform failover and switchover operations
* Enable fast-start failover
培训内容：
* Oracle Data Guard: Overview
* Understanding the Oracle Data Guard Architecture
* Using Oracle Data Guard Broker and Enterprise Manager
* Creating a Configuration and Physical Standby Database by Using Enterprise Manager
* Creating a Physical Standby Database by Using SQL
* Configuring Data Protection Modes and Log Transport Services
* Creating a Logical Standby Database by Using Enterprise Manager
* Creating a Logical Standby Database by Using SQL
* Performing Switchover and Failover
* Enabling Fast-Start Failover
* Using Data Guard in a Real Application Clusters Configuration
* Other Considerations for Oracle Data Guard
* Workshop
Oracle Database 10g：性能优化（4天）
通过学习一些能够*限度地提高数据库效用的性能优化方法，发挥 10g 数据库的*功效。学员将学习如何通过 Oracle Database 10g 自动优化功能受益，还将通过使用 statspack 工具练习一些人工优化方法。明确地定义了各种方法后，学员可以使用这些方法对 Oracle 数据库进行优化。本课程将介绍 Oracle 数据库的各种可调组件。在整个课程中，将通过一系列的课堂练习，让学员亲手体验 Oracle 数据库的优化操作。
课程目标:
* 使用适用于可用工具的 Oracle 数据库优化方法
* 利用数据库 Advisor 主动地对 Oracle 数据库进行优化
* 使用基于自动工作量信息库的工具对数据库进行优化
* 使用 Statspack 报表对数据库进行优化
* 诊断并优化常见的数据库性能问题
* 使用 Enterprise Manager 中与性能有关的页监控 Oracle 数据库。
培训内容：
* 性能优化概览
* 统计数据和等待事件
* 指标、预警和基准
* 使用 Statspack
* 使用 AWR
* 被动式优化
* 优化共享池 * 优化缓冲区高速缓存
* 自动共享内存
* 检查点和重做优化
* 优化 I/O
* 优化 PGA 和临时空间
* 优化块空间的使用量
* 初始配置
Oracle Database 10g：实施和管理数据仓库（4天）
本课程是为数据库管理员、系统管理员以及设计、维护和使用数据仓库的数据库应用程序开发员设计的。参加本课程之前，您应该熟悉关系数据库的概念、数据仓库基本原理、包括应用程序和服务器优化在内的 Oracle 服务器概念，以及运行 Oracle Database Server 的操作系统环境。
课程目标:
* 了解和描述 Oracle 10g Data Warehouse 的内在功能
* 演示如何实施并行操作
* 演示数据提取、转换和加载流程
* 描述和演示如何有效使用数据仓库中的物化图 * 描述星形方案、雪花方案和 3NF 方案
* 为数据仓库表实施有效的分区方案
* 制定有效的备份和恢复策略
* 描述数据仓库面临的安全性挑战
培训内容：
* 数据仓库设计
* 数据仓储方案
* 分区基本概念
* 提取、传输和加载（提取和传输）
* ETL 加载
* ETL 转换
* 并行概念 * 数据仓库中的并行操作
* 物化图
* 维
* 物化图刷新
* 查询重写功能
* SQL Access Advisor
* 数据仓库系统管理
Oracle Database 10g: Backup and Recovery（4天）
After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. They learn how to use RMAN and Enterprise Manager to perform backup and recovery operations. Flashback features are described as an additional way to recover from human error.
This Course includes Oracle Secure Backup, which supplies reliable tape backup of the database through direct integration with RMAN and also provides general file system backup to tape capabilities. Students install Oracle Secure Backup and use it to back up Oracle Database files and file system files.
课程目标:
* Plan effective backup and recovery procedures
* Use Recovery Manager to create backups and perform recovery operations
* Use Oracle Flashback technologies to recover from human error
* Install Oracle Secure Backup
* Perform an Oracle-suggested backup to tape
* Use Oracle Secure Backup to perform a file system backup
* Use Oracle Secure Backup to perform a file system restoration
* Perform an encrypted database backup and restore
* Manage the Oracle Secure Backup environment
* Monitor and tune Recovery Manager
* Perform tablespace point-in-time recovery
* Create a duplicate database
* Create and manage a recovery catalog database
培训内容：
* Introduction
* Configuring for Recoverability
* Using RMAN to Create Backups
* Using RMAN to Perform Recovery
* Using Oracle Flashback Technologies
* Using RMAN to Create a Duplicate Database
* Performing Tablespace Point-in-Time Recovery
* Using the RMAN Recovery Catalog * Monitoring and Tuning RMAN
* Oracle Secure Backup Overview
* Install Oracle Secure Backup
* Use RMAN and Oracle Secure Backup
* Back Up File System Files With Oracle Secure Backup
* Restore File System Backups with Oracle Secure Backup
* Manage Oracle Secure Backup Security
* Manage the Administrative Domain
Oracle Database 10g Administrator Certified Master Exam（2天）
Exam Number: 10g OCM
Associated Certifications:
Oracle 10g DBA OCM
Exam Price:
18000
Duration:
2 days
考试内容:
（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
（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
(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
(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
(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
(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
* 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
(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
(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
为什么选择在博学国际教育培训中心参加Oracle培训
1、培训师资：博学教育中心Oracle讲师队伍由2名OCT，15名OCP组成。全部为Oracle数据库管理专家，有多年数据库维护经验全部有多年的授课经历，理论联系实际。
2、培训环境：
每人专用一台电脑，联网环境；实验环境24小时开放，由Sun和IBM小型机、Cisco路由器交换机、Oracle数据库、Solaris操作系统、IBM AIX操作系统、Red Hat Linux操作系统组成的高端IT实验室；实行公司化管理，空调机 房，真切体验 IT 公司氛围。
4、培训价格：
博学教育中心实行滚动开课，提供优质培训的同时，降低了培训费用
5、交通便利：
杭州市文三路252号伟星大厦19楼A座（地处文教区，电子信息一条街，*信息产业园）（点击查看详细交通线路）
6、教学模式：
博学教育中心采用全新教学模式，理论授课与实验操作相结合，实现滚动开课，学员1年内无条件免费重听、免费实验。
7、认证考试：
博学国际教育培训中心为Prometric、VUE授权国际认证考试中心，由于设备，师资，教学模式的全面优势，确保了 教学质量，加上考试内容资料和辅导，学员全部通过Oracle OCA，OCP考试。
8、Oracle培训客户：
TOSHIBA（杭州）、UTstarcom（*）、浙江电信、浙江移动、浙江联通、宁波移动、杭州网通、山西电信、江 苏电信、武汉电信、浙江省报刊发行局、东方通信、中程科技、恒生电子、浙大快威、浙大网新、用友软件、重 庆电信、国航浙江、信雅达、杭州朗新、南方航空、朝华科技等等。
咨询热线
