Oracle Database 12c R2: RAC Administration Ed 2/1Z0 - 068

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

The Oracle Database 12c R2: RAC Administration training course will give you a detailed overview of Oracle RAC database architecture. During the training, you will learn Global Resources, Cache Fusion and will be introduced to Oracle Database Exadata Cloud Service.

Who should do Oracle Database 12c R2: RAC Administration Ed 2 training?

  • Administrator
  • Database Administrators
This course prepares you for Exam 1Z0 - 068.

Oracle Database 12c R2: RAC Administration Ed 2 (32 Hours) Download Course Contents

Live Virtual Classroom
Group Training 2850
04 - 07 Oct 09:00 AM - 05:00 PM CST
(8 Hours/Day)

01 - 04 Nov 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 3250
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

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?
Module 2: RAC Databases Overview & Architecture
  • 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
Module 3: Installing and Configuring Oracle RAC
  • 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
Module 4: Oracle RAC Administration
  • 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
Module 5: Upgrading and Patching Oracle RAC
  • 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
Module 6: Managing Backup and Recovery for RAC
  • 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
Module 7: RAC Global Resource Management and Cache Fusion
  • 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
Module 8: RAC Database Monitoring and Tuning
  • 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
Module 9: Managing High Availability of Services in a RAC Environment
  • 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
Module 10: Managing High Availability of Connections
  • 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
Module 11: Application Continuity
  • Side Effects
  • Restrictions
  • What problem does it solve?
  • How AC works
  • Benefits of AC
  • Application requirements
  • What is AC?
  • AC Architecture
Module 12: RAC One Node
  • 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
Module 13: Oracle Database In-Memory in RAC
  • Architecture of In-Memory Column Store
  • Implementing In-Memory FastStart
  • Implementing In-Memory Column Store in RAC
Module 14: Multitenant Architecture and 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
Module 15: Quality of Service Management
  • QOS Management concepts
  • QoS Management components
  • QoS Management functionality
  • Describe the benefits of using QoS Management
Module 16: Oracle Database Exadata Cloud Service Overview
  • Service Configuration Options & Service Connection Options
  • REST APIs
  • Management Responsibilities
  • Introducing Exadata Cloud Service
  • Simple Web-Based Provisioning & Management
  • Migrating to Exadata Cloud Service
  • Storage Configuration & Management Details
  • Service Architecture & Availability
Download Course Contents

Request More Information

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

On completion of this course, you will know:

  • 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