Classes
ORACLE COURSES
ORACLE 9i RAC

Duration: 40 Classroom Hours, weekends and weekday evenings.
ORACLE Access: 2 Months ORACLE access for practice and home study from the date of enrollment.

Overview

Learn from the experts how to quickly optimizer your Oracle clustered server environment for optimal
performance and flexibility.

Covering all areas of RAC continuous availability and transparent application failover, this class is
indispensable for any Oracle DBA who is charged with configuring and implementing a RAC clusters
database.

Key Features:

  • Presents a complete guide to the installation and configuration of Oracle9i Real Application
    Clusters.
  • Describes secrets for successful design of RAC clusters
  • Supplies expert internals of shared disk technology, raw devices and RAID with RAC.
  • Exposes the internal concurrency, resource coordination and locking mechanism within RAC
  • Explains configuration of Transparent Application Failover (TAF)
  • Details tips for monitoring and tuning RAC applications
  • Furnishes tricks for using Oracle9i RAC Cluster Guard

Course Description

Introduction to RAC

  • The Dynamic Business Environment
  • The Explosive Growth of Business Data
  • Online and Real-Time Access to Corporate Data
  • Data Warehousing, Packaged Applications, E-Commerce Operations
  • Dependence on Database Management Systems
  • High Performance Systems
  • Introduction to Cluster Technology
  • Benefits of Real Application Clusters (RAC)
  • What is a DB Cluster?
  • Architectures of DB Clusters
  • What is a Cluster Interconnect?
  • Problems with Other Architectures
  • The IBM Shared-Nothing Configuration
  • Microsoft Federated Servers Database
  • Seeing the High Availability Spectrum
  • Real Application Clusters
  • Processing Prior to Cache Fusion
  • Oracle9i Real Application Clusters
  • Attributes of an Oracle RAC Cluster
  • Building an Oracle RAC Cluster
  • RAC Performance and Scalability

High Performance and Highly Available Databases

  • High Performance
  • Growth of Powerful Processors
  • Why Parallel Processing?
  • Opportunities for Parallelism
  • Scaleability
  • Parallel Databases
  • Types of Parallelism
  • High Performance Computing Cluster – HPCC
  • Clusterize Applications
  • How Do You Clusterize Applications?
  • Highly Available Databases
  • Need for Highly Available Data
  • Failure
  • Availability
  • Reliability and Serviceability
  • Fault-tolerant Systems
  • Database Availability
  • Clustered Systems
  • Databases Issues
  • Oracle RAC – High Performance and Highly Available Database

Database Clusters

  • Overview of the Cluster Technology
  • How Clusters Differ from Distributed Systems
  • Clusters are Different from Fault-tolerant Systems
  • Database Clusters
  • Why Clusters?
  • Types of Clusters
  • Fail over Clusters
  • Scalable High Performance Clusters
  • Application Server Clusters
  • Other Types of Clusters
  • Components of a Cluster
  • Cluster Nodes
  • Emerging Server Cluster Architectures
  • Cluster Interconnect
  • Essentials for Parallel Database Clusters
  • Cluster Interconnect Products
  • Infiniband Interconnect
  • ClusterWare
  • Concurrent Database Access
  • Failover Database Clusters
  • Resources, Resource Type
  • Resource Groups
  • The Concept of a Virtual Server
  • Failover Process
  • Examples
  • Failover Cluster Architecture
  • Oracle Database Service in HA Cluster
  • Issues with FO Clusters – Hidden Risks
  • Parallel Database Clusters
  • Shared-Nothing Model
  • Shared-Disk Model
  • Microsoft SQL Server Federated Database
  • IBM Offerings
  • Requirements for Parallel Clusters
  • Oracle’s Instance Membership Recovery
  • Cache Coherency and Lock Management

Real Application Cluster Architecture

  • Overview of Oracle Real Application Clusters
  • RMAN for RAC
  • RAC Workload Management
  • RAC Scalability
  • High Availability
  • Architecture
  • Oracle9i Basic Processes
  • Oracle9i Basic Internal Structures
  • Oracle9i RAC Additional Processes
  • Oracle9i RAC Additional SGA Areas
  • RAC Server Components
  • GCS Resource Modes and Roles
  • Accessing RAC

RAC Server and Disk Technology

  • Overview
  • Oracle9i RAC Disk System
  • RAW Partitions and Cluster File System
  • Raw Partitions
  • Cluster File System
  • Storage Technology and Redundancy
  • Storage Disk System
  • Understanding I/O Path
  • Host Bus Adapter (HBA)
  • Storage Redundancy Components
  • Multiple RAID Controllers and Storage Processors
  • Power Management
  • High Availablity with SAN
  • RAID and RAID Administration
  • Multiple Access Paths to Host
  • Logical Volume Manager
  • Cluster File System
  • Oracle9i RAC and CFS
  • Context Dependent Symbolic Link – CDSL
  • Veritas CFS
  • PolyServe Matrix Server (MxS)
  • HP Tru64 CFS
  • Oracle Cluster File System (OCFS)
  • Other CFS Solutions
  • Oracle Managed Files
  • Oracle Disk Manager
  • Server Redundancy
  • Necessity of Server Redundancy
  • Redundancy Features

RAC Installation and Configuration

  • Architecture and Components
  • Servers and Operating System
  • Interconnect
  • Cluster_interconnect parameter
  • Cluster Software
  • Shared Storage
  • General Steps
  • Communication Stack
  • Shared Storage Configuration
  • Oracle Cluster File System (OCFS)
  • PolyServe Matrix Server
  • Oracle Installation and Creation of Database
  • Oracle Software Installation
  • Database Creation using DBCA
  • Database Creation Manually

Internals of Real Application Clusters

  • Overview of Cache Fusion
  • Evolution of Cache Fusion
  • Nature of Cache Fusion
  • Benefits of Cache Fusion
  • Concurrency and Consistency
  • Cache Coherency
  • Global Cache Service
  • SGA Components and Locking
  • SGA – System Global Area
  • Program Global Area (PGA)
  • Buffer Cache Management
  • What is a Dirty Block?
  • Multi – Version Consistency Model
  • RAC Components
  • Global Cache Service
  • Global Enqueque Service
  • Row-Level Locks
  • Global Resource Directory
  • RAC Processes
  • Resource Coordination
  • Synchronization
  • GCS Resource Modes and Roles
  • Concept of Past Image
  • Lock Modes
  • Block Access Modes and Buffer States
  • Cache Fusion Scenarios
  • Block transfers using Cache Fusion – Examples
  • Block Access, Grants, and Interrupts
  • Cache Fusion and Recovery
  • Recovery Features
  • Recovery Methodology and Steps
  • Recovery Process – Re-mastering Resources

RAC Administration

  • Parameter Management
  • Overview
  • RAC and Initialization Parameters
  • UNDO Management
  • UNDO Management in RAC
  • UNDO Tablespace Features
  • System Rollback Segment
  • Concept of Thread
  • Thread Features
  • Redo Thread Maintenance
  • Segment Space Management
  • Automatic Segment Space Management
  • Manual Space Management
  • Oracle Managed Files
  • Oracle Disk Manager
  • Server Control Utility
  • srvctl add
  • srvctl config
  • srvctl getenv
  • srvctl setenv
  • srvctl start
  • srvctl status
  • srvctl stop
  • GSD daemon
  • GSD Services
  • Using SQL*Plus
  • Starting the Database in Cluster Mode
  • Using Oracle Enterprise Manager
  • Configuration of OEM with RAC

Backup and Recovery

  • Overview of RAC backup and Recovery
  • Export
  • Cold Backup using Scripts
  • Hot Backups using Scripts
  • RMAN (Recovery Manager)
  • Third Party Solutions
  • Backup of RAC Database
  • Using RMAN for Backups
  • Backup Procedures RMAN and RAC
  • Recovery in the RAC Environment
  • Media Recovery in RAC Instances
  • Using RMAN to Recover a RAC Environment
  • Recovery in an OCFS Environment
  • Recovery in a Raw File System Environment
  • Parallel Recovery
  • Standby Databases in RAC Configuration
  • Setting up a Standby Database for a RAC Cluster to a Single-Instance (One Node)
  • Configuration when the Standby Database is a Single Node System
  • Cross-Instance Archival
  • Archive Log Gap Resolution and FAL

Failover with TAF

  • Overview of Transparent Application Failover
  • Load Balancing
  • Example listener.ora
  • Example TAF Configuration
  • TAF with Connect-Time Failover and Client Load Balancing
  • Configuring TAF to Retry a Connection
  • Configuring TAF for Pre-Establishing Connections
  • Verifying TAF Configurations
  • Using Instance Role for Configuring the Primary and Secondary Instance
  • Connection to Instance Role Type
  • Establishing a Connection to a Specific Instance
  • Using BACKUP with TSF Pre-Establishing a Connection
  • Using OCI Driver

Performance Monitoring and Tuning

  • Analysis of Performance Issues
  • Monitoring RAC Cluster Interconnect Performance
  • Use of the cache_transfer Views
  • Monitoring the GES Processes
  • Monitoring and Tuning using OEM
  • Configuring the Oracle Intelligent Agent with RAC

Parallel Execution

  • Overview
  • Types of Parallelism
  • Parallelism in Oracle Relational Database
  • Parallel Execution Mechanism
  • Granules for Parallelism
  • Parallel Execution Servers
  • Degree of Parallelism – DOP
  • Parallel Query: SELECT
  • Parallel DML – Update, Merge, Delete
  • Parallel DML – Insert…Select
  • Parallel DDL Statements
  • Rules for Paralleling “Create Table as Select” (CTAS)
  • SQL*LOADER – Parallel Load
  • Other Parallel Operations
  • Initialization Parameters at a Glance
  • Monitoring and Diagnosing the Parallel Execution

RAC Design Consideration

  • Designing Equipment for Real Application Clusters
  • What are the Effects of Component Failure?
  • Provide Redundancy at Each Level
  • Designing for High Performance
  • Compartmenting Transactions to Specific Nodes
  • Creating Efficient RAC Data Objects
  • Proper Sequence Usage
  • Tablespace Design in Real Application Clusters
  • Extent Management and Locally Managed Tablespaces
  • Minimizing Table Locks to Optimize Performance
  • Performance for Object Creation in Real Application Clusters

Application Deployment

  • Overview
  • Database Consolidation
  • E-business Applications
  • RAC Suitability
  • Advantages of the RAC Database
  • Scalability
  • Unpredictable Loads
  • High Availability
  • Application Deployment Issues
  • OLTP Applications using ‘exclusive’ or Specific Data
  • RAC Suitability for Packaged Applications
  • Oracle eBusiness Suite
  • Middleware Software
  • JDBC Connectivity
  • WebLogic and RAC Database

Migration to RAC Databases

  • Overview
  • Migration Methodology
  • Moving a Single Instance to RAC
  • Upgrading Oracle 8.1.7 to 9.2.0.2
  • Moving HA Cluster to a RAC Cluster
  • Packaged Applications
  • In Case of Oracle eBusiness Suite

Using RAC Cluster Guard

  • Examining the Basics of Cluster Guard Technology
  • Oracle Real Application Clusters Guard Packs
  • The RAC Guard PFSCTL Control Utility
  • The Real Application Clusters Guard Monitors
  • Oracle Real Application Clusters Guard Configuration Templates
  • PFSSETUP Utility
  • Concepts of Oracle Real Application Clusters Guard
  • Primary and Secondary Instance Roles
  • Preferred Primary and Secondary Nodes
  • Definition of the Home and Foreign Nodes
  • Architecture of Oracle Real Application Clusters Guard
  • Oracle Real Application Clusters Guard Packs
  • Resources
  • Using the RAC Cluster Guard Command Line Utility
  • Recovering from an Unplanned Outage on One Node
  • Recovering from Unplanned Outages on Both Nodes
  • Configuring the Call-Home Feature
  • Enhancing Application Failover with Role Change Notification
  • ORATAB File Entries for Oracle RAC Guard
  • Using dbms_libcache to Warm the Secondary Cache
  • Overview of Warming the Library Cache
  • Set Up of DBMS_LIBCACHE
  • Use of the dbms_libcache Package
  • Managing the Oracle Real Application Clusters Guard Log Files
  • What if a Failover Occurs While Datafiles are in Backup Model.
510-440-1200 or via email
info@mtiedge.com