Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Oracle RAC Training Class

© 2016 by Burleson Corporation

Also note our advanced Oracle RAC Tuning Training

 

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring

 

   
Key Features

* Learn the installation and configuration of Oracle Real Application Clusters.

* See secrets for successful design of RAC clusters.

* Understand internals of shared disk technology, raw devices and RAID with RAC.

* Understand the use of Oracle Grid Control and learn the command-line RAC commands.

* See how to minimize contention in the cache fusion layer.

* Learn RAC internal concurrency, resource coordination and locking.

* See when to implement Transparent Application Failover (TAF).

* Get detailed tips for monitoring and tuning RAC applications.

* See tricks for using Oracle 10g RAC Cluster Guard.
 

 

 

  

This is an intensive 3-day Oracle RAC features overview. This course is a comprehensive overview of Oracle RAC, customized RAC training for either Oracle 10g RAC or Oracle 11g RAC.

Unlike other Oracle RAC training classes, this RAC course examines all Oracle RAC features with an eye on those features that are the most important to a successful RAC installation. This RAC course content can be customized according to your specific Oracle RAC configuration.

This Oracle RAC training is special because this course is taught by a veteran Oracle Certified DBA with years of full-time RAC experience.

We also guarantee your training success my offering supplemental mentoring by your RAC teacher.
 

  Oracle Grid & Real Application Clusters

Oracle Grid Computing with RAC

Steve Karam, et al

This course is designed for practicing Oracle DBA and system administrator who have basic experience with Oracle. Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.
 

 

This BC Oracle RAC training was designed by Donald K. Burleson.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning. Burleson Corporation instructors offer decades of real world DBA experience in Oracle RAC training classes, and our experienced RAC instructors they will share their hands-on secrets in this pragmatic Oracle RAC training.



Oracle RAC Training Course
Syllabus

Copyright © 2016 by Donald K. Burleson

 

DAY 1
 
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
Oracle 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
            Scalability
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
            Failover 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
            Oracle10g Basic Processes
            Oracle10g Basic Internal Structures
            Oracle10g RAC Additional Processes
            Oracle10g RAC Additional SGA Areas
RAC Server Components
            GCS Resource Modes and Roles
            Accessing RAC
 
DAY 2
 
RAC Server and Disk Technology
Overview
 
Oracle10g 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
            Oracle10g 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
            Phase – 1
            Phase – 2
            Phase – 3
Sun Solaris
            Hardware / System Details
            Creating the Cluster Using Sun Cluster 3.0
            Install the Volume Manager
            Install the Clusterware (OSD) for RAC
            Configure Shared Storage
            Veritas Cluster Volume Management
            UNIX Pre-Installation Steps
Using Veritas DBE / Advanced Cluster
            Communication Stack
            Shared Storage Configuration
            VCS Framework and Service Groups
            Veritas I/O Fencing and SCSI – 3 Persistency
            Install DBE / AC and Configure Service Groups – First Stage
            Install DBE / AC and Configure Service Groups – Second Stage
Using HP Tru64 UNIX
            Hardware / System Details
            Set up Disks
            Creating Installation and Database Creation
Using HP – UX Clusters
            Hardware / System Details
            Creating the Cluster
            Shared Storage Configuration
            Configure HP ServiceGuard Cluster
            UNIX Pre-Installation Tasks
Using IBM AIX
            Hardware / System Details
            What is VSD|?
            Configure using HACMP / ES
            General Parallel File System – GPFS
            Oracle Installation
Using Windows Cluster
            Hardware / System Details
            Creating the Cluster
            Configure Shared Storage
Using Linux
            Hardware / System Details
            Interconnect & Cluster Software
            Shared Storage Volumes
            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

 

 
DAY 3
 
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
 
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
 
RAC 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
            Step-by-Step Setup of the Intelligent Agents on UNIX
            Monitoring RAC using OEM
 
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
 
RAC 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
            SAP and Real Application Clusters
            Siebel and RAC
            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 SAP 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
 
 
 
 

This is a BC Oracle RAC training course (c) 2016

 

   

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational