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 


 

 

 


 

 

 

On-Site Oracle 12c RAC Training

© 2016 by Burleson Corporation

 

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

Click here for on-site RAC course prices

Optional supplemental RAC mentoring

 

   
Key Features

* Presents a complete guide to the installation and configuration of Oracle12c Real Application Clusters.

* Describes secrets for successful design of RAC clusters.

* Supplies expert internals of shared disk technology, including RAID setup and ASM for RAC 12c.

* Exposes the internal concurrency, resource coordination and locking mechanism within RAC.

* Explains configuration of load balancing and failover services.

* Details tips for monitoring and tuning RAC applications.

 

 

 

  

This is an intensive 3-day Oracle RAC 12c training class. This course is a comprehensive overview of Oracle 12c RAC including the installation and configuration of Oracle RAC and Grid.

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 your shop. The course content can be customized according to your specific Oracle RAC configuration.

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

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

This Oracle RAC training was designed by Steve Karam and Donald K. Burleson.  Authors 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 features, and they will share their secrets in this intense Oracle RAC training.



Oracle 12c RAC Training Class
Course Syllabus

Copyright © 2016 by Donald K. Burleson

 

DAY 1
 
Introduction to RAC 12c
 
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
 
RAC 12c High Performance and Highly Available Databases
 
            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
            Oracle12c Basic Processes
            Oracle12c Basic Internal Structures
            Oracle12c RAC Additional Processes
            Oracle12c RAC Additional SGA Areas
RAC Server Components
            GCS Resource Modes and Roles
            Accessing RAC
 
DAY 2
 
RAC Server and Disk Technology
Overview
 
Oracle12c RAC Disk System
Understanding Disks, LUNs, Volumes
           Raw Volumes
           File Systems
Storage Technology and Redundancy
           Disk Systems
           Understanding I/O Path
           Host Bus Adapters (HBA)
           Storage Redundancy Components
           RAID and RAID Administration
           High Availability of Storage
           Logical Volume Managers
Storage Areas
           OCFS/OCFS2
           RAW Volumes
           ASM
           Other CFS Solutions
Redundancy
           Understanding RAID Redundancy
 Capabilities
           Server Redundancy
           Redundancy Types
 

RAC Installation and Configuration

 
Architecture and Components
            Servers and Operating System
            Cluster Interconnect and Public Switch
            Oracle Clusterware
            Shared Storage Subsystem
Overview of Installation Steps
            Installation of Oracle Clusterware
            Installation of Oracle for use with ASM
            Installation of Oracle for production database use
Oracle RAC Tools
            crs_stat
            olsnodes
            srvctl
            dbca
            netca

 
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
 

12c 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
Using SQL*Plus
            Starting the Database in Cluster Mode
Using Oracle DB Control for Clusters
            Configuration of DB control w/RAC
 
RAC  12c 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
ASM and RMAN
            Performing advanced backup/ recovery techniques with ASM
            SWITCH DATABASE TO COPY
            Keeping ASM Clean
 
Failover and Load Balancing
 
Services In-depth
            Failover
            Load Balancing
            Planning and Configuration
Connection Pools and Services
The Load Balancing Advisory
Monitoring Services
 
RAC Performance Monitoring and Tuning
 
Analysis of Performance Issues
            Monitoring RAC Cluster Interconnect
           Using performance views
           Using AWR
           ADDM for RAC
           Using DB Control to Monitor RAC           
 
RAC Design Consideration
 
            Designing equipment for RAC
            Effects of component failure
            Redundancy at every level
            Choosing Service/Nodes for Work
Sequences in RAC
             Tablespace Design Considerations
             Solid State Disk Considerations
             Table Locks and Latch Waits
             Scalability and Unpredictable Loads

 
Migration to RAC Databases
 
Overview
Migration Methodology
            Moving from Single Instance to RAC
            Cloning Overview
            Migrating to Oracle 12c
            Rolling Upgrades

 

Oracle 12c RAC parallel upgrades

Oracle 12c RAC has a rolling upgrade features whereby RAC database can be upgraded without any downtime. 

 

Oracle 12c hot patching

Oracle 12c RAC has a the ability to apply patches on a node-by-node basis without service interruption.

 
Oracle 12c RAC load balancing advisor

Starting in 10gr2 we see a RAC load balancing advisor utility.  Oracle says that the 12c RAC load balancing advisor is only available with clients which use .NET, ODBC, or the Oracle Call Interface (OCI).
 
ADDM for RAC 12c

In Oracle 12c, ADDM has been extended to include RAC, and provides information on the entire cluster including latency issues on the cluster interconnect, global cache hot blocks (blocks with concurrency issues across multiple nodes), and general object usage information across multiple nodes.

12c RAC cache fusion protocols

12c RAC improves the cache fusion layer for faster and more efficient pinging between nodes

12c RAC ASMCA

Oracle 12c offers an ASM configuration assistant allows you to install cluster file systems (ACFS), ASM instances, ASM volumes and disk groups

Optimized 12c RAC cache fusion protocols

Extends the general cache fusion protocols in 10g to deal with specific scenarios where the protocols could be further optimized.
 
Oracle 12c RAC Grid provisioning

The Oracle 12c grid control provisioning pack allows you to "blow-out" a RAC node without the time-consuming install, using a pre-installed "footprint". 

 
 

This is a BC Oracle 12c 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 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.