Отримати консультацію
Training Center MUKКурсыOracleDatabaseOracle Database 12c R2: Clusterware & RAC Admin Accelerated Ed 2

Oracle Database 12c R2: Clusterware & RAC Admin Accelerated Ed 2

Код курсу
5 Днів, 40 Ак. Годин
Опис курсу
Програма курсу
Опис курсу

Course overview

This Oracle Database 12c R2: Clusterware & RAC Admin Accelerated training covers 8 days worth of content in only 5 days. It starts with the Oracle Database 12c R2: Clusterware Administration course (4 days) and then covers the Oracle Database 12c R2: RAC Administration architecture (4 days); learn how these products work together.


Course objectives

  • Describe the Oracle Clusterware architecture
  • Describe Available Cluster Options
  • Describe the scope and capabilities of what-if command evaluation
  • Implement load-ware resource placement
  • Implement server weight-based node eviction
  • Describe the components and functions of Oracle Autonomous Health Framework
  • Use the Cluster Resource Activity Log
  • Describe and implement Clusterware resource groups
  • Describe the benefits of Oracle RAC
  • Convert a single-instance Oracle Database to RACs
  • Configure Oracle RAC Reader Nodes
  • Define undo tablespaces in a RAC environment
  • Define local temporary tablespaces in a RAC environment
  • Configure RMAN for the RAC environment
  • Describe the benefits of Service-Oriented Buffer Cache Access
  • Explain the goals, benefits, and architecture of the In-Memory Column Store in a RAC environment

Suggested Prerequisite

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

Required Prerequisite

  • Oracle Database 12c R2: ASM Administration Ed 2


  • Technical Administrator
  • Administrator
  • Database Administrators
  • Support Engineer
  • Technical Consultant
Програма курсу

Course Topics

1. Introduction to Grid Infrastructure

  • Clusterware Characteristics
  • What is a Cluster?
  • What is a Flex Cluster?
  • Oracle Clusterware
  • Shared Storage Overview
  • Hardware and Software Concepts (High level)

2. Installing Grid Infrastructure

  • Verifying the Oracle Clusterware Installation
  • Installing Oracle Grid Infrastructure
  • Installing Flex Cluster

3. Policy-Based Cluster Management

  • Server Categorization
  • Policy-Based Cluster Management Overview
  • Policy Set

4. RAC Databases Overview & Architecture

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

5. RAC Backup and Recovery

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

6. Oracle Clusterware Architecture

  • Configuring shared GNS
  • Shared GNS Background and Architecture
  • Clusterware Process Architecture
  • Cluster Storage Requirements
  • Clusterware Initialization and OHASD
  • Moving GNS to Another Cluster
  • Location Independent Names, Addresses and Name Resolution (GNS, SCAN, VIP..)
  • Migrating to shared GNS

7. Managing Cluster Nodes

  • Removing a Node from the Cluster
  • Prerequisites for Running addNode.sh
  • Adding a Node with addNode.sh
  • Adding Oracle Clusterware Homes
  • Configuring the node role

8. Patching Grid Infrastructure

  • Rolling Patches
  • OPatch Overview
  • Types of Patches
  • Obtaining Oracle Clusterware Patches
  • Installing a Rolling Patch with OPatch
  • OPatch Automation
  • Out-of-Place Oracle Clusterware Upgrade
  • Installing a Rolling Patchset with OUI

9. Installing and Configuring Oracle RAC

  • Installing the Oracle Database Software
  • Installation options
  • Single Instance to RAC Conversion
  • Creating the Cluster Database
  • Post-installation Tasks
  • Cleaning Up Unsuccessful Installs

10. RAC Global Resource Management and Cache Fusion

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

11. Application Continuity

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

12. Oracle Database Exadata Cloud Service Overview

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

13. Flex Cluster Architecture

  • Flex Cluster Architecture
  • Configuring Flex Cluster
  • Flex Clusters and Node Failure

14. Grid Infrastructure Pre-Installation Tasks

  • Shared Storage for Oracle Clusterware
  • Groups and Users
  • Shell Settings
  • Redundant Interconnect Usage
  • Kernel Requirements
  • Checking System Requirements
  • Single Client Access Name for the Cluster
  • Oracle Validated Configuration

15. Traditional Clusterware Management

  • Network Administration
  • Administering the Voting Disk file
  • Clusterware Admin Tools Review
  • Administering the Oracle Cluster Registry Disk file
  • Oracle Clusterware startup and shutdown
  • What-If Command Evaluation

16. Troubleshooting Oracle Clusterware

  • Component level checks – cluvfy with -comp
  • Troubleshooting Node Evictions
  • Log files and Diagnostic Collection
  • The oclumon Utility
  • Cluster Health Monitor Enhancements Overview
  • Resource Debugging – Java Tools and Dynamic Debugging
  • Diagnostic Framework Support for CRS

17. Making Applications Highly Available

  • Server Pools
  • ONS and FAN overviews
  • Overview of Using Oracle Clusterware to Enable HA
  • Creating an Application VIP
  • Overall flow diagram of HA lifecycle (crs_profile, crs_register, crs_start….)
  • Resource Management Options
  • Clusterware Resource Modeling
  • Oracle Clusterware HA Components

18. Oracle RAC Administration

  • Undo Tablespaces
  • Use Enterprise Manager Cluster Database Pages
  • RAC Alerts
  • Parameters and RAC – SPFILE, Identical and Unique Parameters
  • Session management on RAC instances
  • Redo Threads
  • Instance Startup, Shutdown and Quiesce
  • RAC Metrics

19. RAC Monitoring and Tuning

  • Common RAC Tuning
  • RAC specific V$ Views
  • Wait Events for RAC
  • OCPU and Wait Time Latencies
  • Session and System Statistics
  • Automatic Database Diagnostic Monitor for RAC

20. Managing High Availability of Services in a RAC Environment

  • Services for Policy – and Administrator-Managed Databases
  • Creating Services
  • Oracle Services
  • Services and Transparent Application Failover
  • Use Services with Client Applications
  • Managing Services
  • Services and Connection Load Balancing
  • Services and the Resource Manager

21. Design for High Availability

  • Database High Availability Best Practices
  • Hardware Assisted Resilient Data
  • RAC and Data Guard
  • Maximum Availability Architecture
  • Oracle’s Solution to Down Time
  • RAID Configuration for High Availability
  • Fast-Start Failover
  • Causes of Planned and Unplanned Down Time
Реєстрація на найближчий курс
Oracle Database 12c R2: Clusterware & RAC Admin Accelerated Ed 2
Код курсу:
5 Днів, 40 Ак. Годин
Отримати консультацію
Свяжитесь со мной
Отримати консультацію
Отправить заявку
Реєстрація на вебінар
Отправить заявку
Ваша заявка отримана!
Ми зв`яжимося з вами найближчим часом.