Suite 3808, Liwa Heights, Cluster W, Jumeirah Lake Towers, Dubai, UAE info@keygains-training.com +971 4 577 6810 +971 52 767 8506 08.00 – 18.00

Sunday – Saturday

E-MAIL : info@keygains-training.com

Follow Us

Oracle 12c R2: RAC Administration

Objectives

This Oracle Database 12c R2: Real Application Cluster (RAC) Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

Target Audience

  • Administrators and Database Administrators

Course Modules

Module 1: Grid Infrastructure: Overview

  • What is a Cluster
  • What is a Flex Cluster
  • Clusterware Characteristics
  • Oracle Clusterware
  • Hardware and Software Concepts (High level)
  • RAC and Flex ASM

Module 2: RAC Databases Overview Architecture

  • Overview of Oracle RAC
  • Oracle RAC One Node (High level)
  • Cluster-Aware Storage Solutions
  • Benefits of Using RAC
  • Scaleup and Speedup
  • I/O Throughput Balanced
  • Global Resources

Module 3: Installing and Configuring Oracle RAC

  • Installing the Oracle Database Software
  • Installation options
  • Creating the Cluster Database
  • Configuring Oracle RAC Reader Nodes
  • Post-installation Tasks
  • Single Instance to RAC Conversion using DBCA and config

Module 4: Oracle RAC Administration

  • Separation of Duty for Administering Oracle RAC
  • Use Enterprise Manager Cluster Database Pages
  • RAC Alerts
  • RAC Metrics
  • Undo Tablespaces
  • Local Temporary Tablespaces
  • Redo Threads
  • Parameters and RAC – SPFILE, Identical and Unique Parameters

Module 5: Upgrading and Patching Oracle RAC

  • Overview of Upgrades and Patching
  • Release and Patch Set Upgrades
  • PSU, CPU, and Interim Patches
  • Merge Patches
  • Performing Out of Place Database Upgrades
  • Planning and Preparing for Upgrade
  • Post Upgrade Tasks

Module 6: Managing Backup and Recovery for RAC

  • Instance Failure And Recovery In RAC – LMON and SMON
  • Redo Threads and Archive Logs Configurations and Admin
  • Parameter Settings Affecting Parallel Recovery and MTTR
  • RAC and the Fast Recovery Area
  • RMAN Configuration
  • RMAN Admin for RAC: Channels, Instances, Backup Considerations

Module 7: RAC Global Resource Management and Cache Fusion

  • Globally Managed Resources and Management
  • Library Cache Management
  • Row cache management
  • Buffer cache fusion
  • Buffer Cache Management Requirements
  • Accessing single blocks in RAC
  • Multi-block read considerations in RAC
  • Undo and read consistency considerations in RAC

Module 8: RAC Database Monitoring and Tuning

  • OCPU and Wait Time Latencies
  • Wait for Events for RAC
  • Common RAC Tuning
  • Session and System Statistics
  • RAC specific V$ Views
  • Automatic Database Diagnostic Monitor for RAC
  • Monitoring RAC with Cluster Health Advisor (CHA)

Module 9: Managing High Availability of Services in a RAC Environment

  • Oracle Services
  • Services for Policy – and Administrator-Managed Databases
  • Service-Oriented Buffer Cache Access
  • Creating Services
  • Managing Services
  • Use Services with Client Applications
  • Services and Connection Load Balancing
  • Services and Transparent Application Failover

Module 10: Managing High Availability of Connections

  • Types of Workload Distribution
  • Client-Side Load Balancing
  • Server-Side Load Balancing
  • Runtime Connection Load Balancing and Connection Pools
  • Fast Application Notification
  • The Load Balancing Advisory FAN Event
  • Server-Side Callouts
  • Configuring the Server-Side ONS

Module 11: Application Continuity

  • What is AC
  • What problem does it solve
  • Benefits of AC
  • How AC works
  • AC Architecture
  • Side Effects
  • Restrictions
  • Application requirements

Module 12: RAC One Node

  • RAC One Node Concepts
  • Online database migration
  • Adding Oracle RAC One Node Database to an Existing Cluster
  • Convert an Oracle RAC One Node database to a RAC database
  • Convert an Oracle RAC database to a RAC One Node database
  • Use DBCA to convert a single instance database to a RAC One Node database

Module 13: Oracle Database In-Memory in RAC

  • The architecture of In-Memory Column Store
  • Implementing In-Memory Column Store in RAC
  • Implementing In-Memory FastStart

Module 14: Multitenant Architecture and RAC

  • Non-CDB Architecture
  • Multitenant Architecture: Benefits
  • CDB in a Non-RAC Environment
  • Containers
  • Terminology and Data Dictionary Views
  • Connection to a Non-RAC CDB
  • Oracle RAC and Multitenant Configuration
  • Oracle RAC and Multitenant Architecture

Module 15: Quality of Service Management

  • QoS Management concepts
  • Describe the benefits of using QoS Management
  • QoS Management components
  • QoS Management functionality

Module 16: Oracle Database Exadata Cloud Service Overview

  • Introducing Exadata Cloud Service
  • Service Configuration Options Service Connection Options
  • Service Architecture Availability
  • Management Responsibilities
  • Storage Configuration Management Details
  • Simple Web-Based Provisioning Management
  • REST APIs
  • Migrating to Exadata Cloud Service

Get Download Brochure





    Program Schedules : Session Starts From

    9th July 2021

    Online Live

    23rd July 2021

    Classroom

    Oracle 12c R2: RAC Administration

    This Oracle Database 12c R2: Real Application Cluster (RAC) Administration training will teach you about Oracle RAC database architecture. Expert Oracle University instructors will deep dive into Global Resources and Cache Fusion. In this course, you will be introduced to Oracle Database Exadata Cloud Service.

    Open chat
    Open chat