EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

Oracle Database 19c- RAC Administration Workshop

Course outline

5 days

Duration

Oracle Database 19c: RAC Administration Workshop

5 days

Overview

Oracle Real Application Clusters (RAC) allow customers to run a single Oracle Database across multiple servers in order to maximize availability and enable horizontal scalability, while accessing shared storage. User sessions connecting to Oracle RAC instances can failover and safely replay changes during outages, without any changes to end user applications, hiding the impact of the outages from end users.

Learn To:

  • Install and configure RAC
  • Manage RAC Database
  • Upgrade and patch RAC Database
  • Manage backup and recovery for RAC
  • Monitor and tune RAC Database
  • Manage high availability of services
  • Implement High Availability for connections and applications
  • Configure RAC One Node Database
  • Implement In-Memory Column Store in RAC
  • Configure Multitenant Architecture in RAC
  • Manage Quality of Service in RAC

Skills Covered

Upon completion of this course, you should be able to:

  • Install and configure RAC
  • Manage RAC Database
  • Upgrade and patch RAC Database
  • Manage backup and recovery for RAC
  • Monitor and tune RAC Database
  • Manage high availability of services
  • Implement High Availability for connections and applications
  • Configure RAC One Node Database
  • Implement In-Memory Column Store in RAC
  • Configure Multitenant Architecture in RAC

Who Should Attend

This Oracle Database 19c RAC and Grid Infrastructure Administration course is designed for experienced database administrators who are required to plan, implement and administer Oracle 12cR2,18c or 19c Real Application Clusters configurations for Oracle databases.

Prerequisites

  • A good working knowledge of Oracle Database Administration is required. These skills can be obtained by attendance on the pre-requisite Administration and Backup and Recovery courses.
  • This course is run on a Linux operating system, a good working knowledge of UNIX/Linux is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course.

Course Modules

Module 1: ORACLE REAL APPLICATION CLUSTERS OVERVIEW

  • Overview of Oracle RAC
  • Oracle RAC Features
  • Oracle RAC Technology Hierarchy
  • Oracle RAC Capabilities
  • Oracle RAC Components
  • Oracle RAC One Node Overview
  • Benefits of using RAC
  • Tools for Installing,Configuring and Managing Oracle RAC

Module 2: ORACLE GRID INFRASTRUCTURE OVERVIEW

  • Cluster Overview
  • Flex Cluster Overview
  • Grid Foundation Components and Architecture
  • Oracle Clusterware Components and RAC
  • Oracle Clusterware Software and Storage
  • Oracle Storage Subsystems
  • File Types used by a RAC Database
  • Methods used to Share Database Files across a Cluster
  • RAC Multitenant Database
  • ASM Architecture
  • Create and Manage ASM Disks Groups
  • Create and Manage ASM Cluster Filesystems
  • An Overview of RAC Services
  • Network Requirements and Configuration
  • Single Client Access Names
  • Overview of Grid Plug and Play
  • Buffer Cache Fusion Processing

Programme scope, delivery arrangements and suitability are confirmed during enquiry.