Oracle Database 12c R2: RAC Administration Ed 2

Duration : 4 Days (32 Hours)

Oracle Database 12c R2: RAC Administration Ed 2 Course Overview:

The Oracle Database 12c R2: RAC Administration training course provides a comprehensive overview of Oracle RAC database architecture. Throughout the training, participants will gain knowledge about Global Resources and Cache Fusion, essential components of Oracle RAC. Additionally, learners will be introduced to the Oracle Database Exadata Cloud Service, exploring its capabilities and features. The course equips attendees with the necessary skills to effectively administer Oracle RAC databases and utilize Oracle Database Exadata Cloud Service.

Intended Audience:

  • Administrator
  • Database Administrators

Learning Objectives of Oracle Database 12c R2: RAC Administration Ed 2:

  • Configuring Oracle RAC Reader Nodes
  • Defining redo log files & undo tablespaces in a RAC environment
  • Converting a single-instance Oracle Database to RACs
  • Installing the Oracle Database software
  • Creating a cluster database
  • Defining local temporary tablespaces in a RAC environment
  • Modifying initialization parameters in a RAC environment
  • Performing post-database-creation tasks
  • Configuring RMAN for the RAC environment & RAC database to use ARCHIVELOG mode and the fast recovery area
 Module 1: Grid Infrastructure: Overview
  • Clusterware Characteristics
  • RAC and Flex ASM
  • Oracle Clusterware
  • What is a Flex Cluster ?
  • Hardware and Software Concepts (High level)
  • What is a Cluster?
  • Oracle RAC One Node (High level)
  • Benefits of Using RAC
  • Overview of Oracle RAC
  • Global Resources
  • Scaleup and Speedup
  • I/O Throughput Balanced
  • Cluster-Aware Storage Solutions
  • Post-installation Tasks
  • Single Instance to RAC Conversion using DBCA and rconfig
  • Creating the Cluster Database
  • Installation options
  • Configuring Oracle RAC Reader Nodes
  • Installing the Oracle Database Software
  • Parameters and RAC – SPFILE, Identical and Unique Parameters
  • RAC Alerts
  • RAC Metrics
  • Use Enterprise Manager Cluster Database Pages
  • Local Temporary Tablespaces
  • Redo Threads
  • Separation of Duty for Administering Oracle RAC
  • Undo Tablespaces
  • Merge Patches
  • Performing Out of Place Database Upgrades
  • Ovierview of Upgrades and Patching
  • Post Upgrade Tasks
  • Planning and Preparing for Upgrade
  • PSU, CPU and Interim Patches
  • Release and Patch Set Upgrades
  • Redo Threads and Archive Logs Configurations and Admin
  • Parameter Settings Affecting Parallel Recovery and MTTR
  • Instance Failure And Recovery In RAC – LMON and SMON
  • RAC and the Fast Recovery Area
  • RMAN Configuration
  • RMAN Admin for RAC: Channels, Instances, Backup Considerations
  • Row cache management
  • Buffer Cache Management Requirements
  • Undo and read consistency considerations in RAC
  • Multi-block read considerations in RAC
  • Globally Managed Resources and Management
  • Buffer cache fusion
  • Accessing single blocks in RAC
  • Library Cache Management
  • OCPU and Wait Time Latencies
  • Common RAC Tuning
  • RAC specific V$ Views
  • Wait Events for RAC
  • Monitoring RAC with Cluster Health Advisor (CHA)
  • Session and System Statistics
  • Automatic Database Diagnostic Monitor for RAC
  • Oracle Services
  • Managing Services
  • Service-Oriented Buffer Cache Access
  • Services and Connection Load Balancing
  • Creating Services
  • Use Services with Client Applications
  • Services for Policy – and Administrator-Managed Databases
  • Services and Transparent Application Failover
  • Client-Side Load Balancing
  • Server-Side Load Balancing
  • Types of Workload Distribution
  • Configuring the Server-Side ONS
  • The Load Balancing Advisory FAN Event
  • Server-Side Callouts
  • Fast Application Notification
  • Runtime Connection Load Balancing and Connection Pools
  • Side Effects
  • Restrictions
  • What problem does it solve?
  • How AC works
  • Benefits of AC
  • Application requirements
  • What is AC?
  • AC Architecture
  • Use DBCA to convert a single instance database to a RAC One Node database
  • RAC One Node Concepts
  • Adding Oracle RAC One Node Database to an Existing Cluster
  • Convert an Oracle RAC database to a RAC One Node database
  • Online database migration
  • Convert an Oracle RAC One Node database to a RAC database
  • Architecture of In-Memory Column Store
  • Implementing In-Memory FastStart
  • Implementing In-Memory Column Store in RAC
  • Oracle RAC and Multitenant Configuration
  • CDB in a Non-RAC Environment
  • Connection to a Non-RAC CDB
  • Multitenant Architecture: Benefits
  • Non-CDB Architecture
  • Oracle RAC and Multitenant Architecture
  • Containers
  • Terminology and Data Dictionary Views
  • QOS Management concepts
  • QoS Management components
  • QoS Management functionality
  • Describe the benefits of using QoS Management
  • Management Responsibilities
  • Introducing Exadata Cloud Service
  • Simple Web-Based Provisioning & Management
  • Migrating to Exadata Cloud Service
  • Storage Configuration & Management Details
  • Service Architecture & Availability

Oracle Database 12c R2: RAC Administration Ed 2 Course Prerequisites:

  • Oracle Database 12c R2: Clusterware Administration

Suggested but not mandatory

  • Working knowledge of Oracle Database 11g: Release 2, including Clusterware, ASM, and RAC
  • Working knowledge of Oracle Clusterware, ASM & RAC on Linux

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.