Oracle Database 12cR2 RAC and Grid Infrastructure Administration
 
 

Oracle Database 12cR2 RAC and Grid Infrastructure Administration

Course Code: O12CRAC

Duration: 5 days

Our training courses can also be delivered at a location of your choice...

S12

Oracle Database 12cR2 RAC and Grid Infrastructure Administration Course Overview

This Oracle Database 12cR2 RAC and Grid Infrastructure Administration course introduces the general features and capabilities of Oracle Real Application Clusters (RAC) within the Oracle Grid Infrastructure environment.

Delegates will learn how to install and configure Oracle Clusterware in a RAC environment. Delegates will learn how to create, configure and administer a database for use with RAC within the Oracle Grid Infrastructure environment. Delegates will learn how to setup and use Automatic Storage Management (ASM).

The delegate will learn and acquire skills as follows:

  • Installing and configuring Oracle Database 12cR2 Grid Infrastructure
  • Installing Oracle Database software
  • Creating a RAC Cluster Database
  • Administering and Monitoring a RAC database
  • Using configuration and management tools for RAC enabled databases
  • Administering ASM using command line and GUI clients
  • Setting up services for workload management and application high availability
  • Backing up, restoring and recovering a RAC database
  • Monitoring and tuning the performance of a RAC database
  • Troubleshooting Oracle Clusterware

Who will the Course Benefit?

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

Versions supported 12cR2, 18c, 19c.

Course Objectives

The objectives of this Oracle Database 12cR2 RAC and Grid Infrastructure Administration course are to provide the skills needed to plan, implement, manage and troubleshoot Oracle Clusterware and RAC database configurations in an Oracle Grid Infrastructure environment.

Requirements

A working knowledge of Oracle Database 12cR2 Administration is required. These skills can be obtained by attendance on the pre-requisite Oracle Database 12cR2 Administration and Oracle Database 12cR2 Backup and Recovery with RMAN 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.

Pre-Requisite Courses

Follow-On Courses

Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.


 

Course Contents

Oracle Database 12cR2 RAC and Grid Infrastructure Administration Training Course

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 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

Session 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

Session 3: CONFIGURE SERVERS FOR INSTALLATION

  • Oracle RAC Pre-installation Tasks
  • Job Role Separation
  • Create Oracle Groups, User Accounts and Directories
  • Validate and Prepare the Hardware and the Operating System
  • Configure RAC Nodes for Remote Access using SSH
  • Configure the Network for RAC
  • Configure the Startup Commands for the Oracle RAC Nodes
  • ASM Storage Management Configuration Methods
  • Configure ASM and the udev Device Manager
  • Udev SCSI Rules
  • Install and Configure ASMLIB
  • ASM Filter Drivers (ASMFD)

Oracle Database 12cR2 RAC and Grid Infrastructure Administration Training Course

Session 4: INSTALL ORACLE GRID INFRASTRUCTURE AND REAL APPLICATION CLUSTERS

  • The Clusterware Role
  • Requirements for Oracle Clusterware
  • Pre-installation Steps
  • The Voting Disk, OCR and GIMR
  • Oracle Clusterware Installation Stages
  • Install the Oracle Grid Infrastructure for a Cluster
  • Use the Cluster Verification Utility
  • Install Oracle Database Software and Create a Cluster Database
  • Verify the Installation
  • Oracle Clusterware Daemons and Log Files
  • Clusterware Interconnect Best Practices
  • Post Installation Tasks
  • Clean Up Failed Installations
  • TNS Configuration
  • Convert a Single Instance Database to a RAC Database
  • Use the DBCA for Single Instance Conversion
  • RAC Specific Background Processes

Session 5: RAC CLUSTER DATABASE AND DATABASE INSTANCE ADMINISTRATION

  • Administer Oracle RAC using Enterprise Manager
  • Policy Managed and Administrator Managed Databases
  • RAC Initialization Parameters
  • Password File Management
  • Manage Undo Tablespaces in a RAC Environmentc
  • Temporary Tablespace Configuration
  • Manage Redo Log Files and Groups in a RAC Environment
  • Oracle Enterprise Manager Cluster Database Pages
  • Manage Sessions on RAC Databases
  • Start and Stop Oracle RAC Databases and Instances
  • Administer Database Storage

Session 6: ADMINISTER ORACLE CLUSTERWARE COMPONENTS

  • CRS Resources and the Cluster Ready Services Stack
  • Cluster Processes
  • USe crsctl Commands to Stop, Start and Administer Clusterware
  • Backup and Recover Voting Disks
  • Add and Remove Voting Disks
  • The ocrcheck Utility
  • The ocrdump Command
  • Administer the Oracle Cluster Registry (OCR)
  • Locate OCR Automatic Backups
  • Backup and Restore OCR
  • Troubleshoot the OCR with ocrcheck

Oracle Database 12cR2 RAC and Grid Infrastructure Administration Training Course

Session 7: ASM INSTANCE ADMINISTRATION

  • ASM Management Overview
  • ASM Storage Components in RAC
  • Oracle Automatic Cluster File System (ACFS)
  • ASM Initialization Parameters
  • Creation an Ownership of an ASM Instance
  • Administer ASM Instances and Disk Groups with EM
  • Administer ASM Instances and Disk Groups with asmca
  • Administer ASM Instances with srvctl
  • Administer ASM with the asmcmd Command Line Tool

Session 8: ASM DISK GROUP ADMINISTRATION

  • Create and Delete ASM Disk Groups
  • Create ASM Data Files
  • ASM Disk Group Attributes
  • Flex ASM
  • ASM Disk Group Maintenance Tasks
  • Preferred Read Failure Groups
  • ASM Disk Statistics
  • ASM Storage Limits
  • Tuning ASM Rebalance Operations
  • ASM Disk Scrubbing
  • ACTive Session History (ASH) fro ASM

Session 9: RAC MANAGEMENT COMMANDS

  • RAC Management Commands
  • RAC Administration with svrctl
  • svrctl Cluster Database Configuration Tasks
  • svrctl Cluster Database Administration Tasks
  • Check the Current Configuration
  • svrctl Command Summary
  • Administer Databases and Instances
  • Administer Services and Node Applications
  • Bring a Cluster Database online and offline
  • Manage Application Resources
  • Introduction to CRS
  • Cluster Services
  • What-if command line evaluation with eval

Session 10: MANAGING THE DATABASE WORKLOAD USING SERVICES

  • Manage the Database Workload using Services
  • Configure Services for High Availability
  • Create and Administer Services
  • Service Administration using EM Cloud Control
  • Service Administration using srvctl
  • Configure Oracle Net to Support Services
  • Connection Failover
  • Transparent Connection Failover
  • Load Balancing
  • Configure Service Level Thresholds
  • Configure Clients for Failover
  • Fast Application Notification (FAN)
  • Fan Callouts
  • Server and Client Side Oracle Notification Services

Session 11: HIGH AVALABILITY OF CONNECTIONS

  • RAC High Availability Framework
  • Database High Availability Best Practices
  • RAID Configuration for High Availability
  • Causes of Planned and Unplanned Down Time
  • Failure Detection with Cluster Services
  • Oracle RAC and Hardware Failover

Oracle Database 12cR2 RAC and Grid Infrastructure Administration Training Course

Session 12: RAC CACHE FUSION AND GLOBAL RESOURCE MANAGEMENT

  • Cache Fusion Overview
  • RAC Locking Mechanism
  • Buffer Cache Fusion Processing
  • Oracle RAC Cache Fusion Accelerator
  • Result Caching
  • Library and Row Cache Management
  • Management Requirements of the Buffer Cache
  • Access Single Blocks in RAC
  • Multi Block Read Considerations in RAC
  • Undo and Read Consistency Issues in RAC

Session 13: BACKUP AND RECOVER A RAC DATABASE

  • Overview of RAC Backup and Recovery
  • Instance Failure and Recovery in RAC
  • The LMON and SMON processes
  • Redo Threads and Archive Log Configurations
  • Configure a Fast Recovery Area for use with RAC
  • Tune Instance Recovery in RAC
  • Parallel Recovery in RAC
  • Initiate Archiving
  • Configure RMAN Backup and Recovery Settings
  • Backup a RAC Database using RMAN
  • Restore and Recover a RAC Database using RMAN
  • Display Backup Reports
  • Best Practices and Tips for Backup and Recovery

Session 14: RAC PERFORMANCE MONITORING AND TUNING

  • Monitoring and Performance Guidelines
  • RAC Monitoring Tools
  • RAC Performance Recommendations
  • Workload Partitioning
  • CPU and Wait Time Latches
  • is there a need to meet before you go on holiday or
  • Session and System Statistics
  • RAC Specific V$ Views
  • Analyze RAC Performance Issues
  • Use OSWatcher
  • Create a Monitoring Plan
  • AWR and Statspack Reports
  • Monitor RAC Cluster Interconnect Performance
  • Cache Coherency Times
  • RAC Wair Events of Interest
  • Undesirable Global Cache Statistics
  • Important RAC Wait Events
  • Global Cache Wait Events
  • Important Cache Fusion Views
  • Monitor the GES Processes
  • Monitor and Tune using Enterprise Manager

Session 15: ORACLE CLUSTERWARE TROUBLESHOOTING

  • Overview of Oracle Clusterware Troubleshooting
  • Hardware, Storage and Network Problems with RAC
  • The Oracle Clusterware Alert Log
  • Trace and Incident Files
  • Other Diagnostic Data
  • Failed, Missing or Offline Cluster Resources
  • Oracle Clusterware Log File Locations
  • The Clusterware Resource Activity Log
  • The Diagnostics Collection Tool
  • Troubleshoot the OCR and Voting Disk
  • Debug Resources
  • Debug a Component Level
  • CRS, CCS and EVM Components
  • Oracle Clusterware Troubleshooting Tools and Utilities

Oracle Database 12cR2 RAC and Grid Infrastructure Administration Training Course

Session 16: ADD AND DELETE NODES AND CLUSTERS

  • Grid Plug and Play (GPnP)
  • Prepare a New Node
  • Extend the Oracle Grid Infrastructure Home to the New Node
  • Extend the Oracle RAC Home Directory
  • Add the New Node to the Cluster
  • Create an Instance on the New Node
  • Delete an Instance from the Cluster Database
  • Remove a Node from the Cluster

Session 17: MANAGE ORACLE SOFTWARE AND APPLY PATCHES

  • Overview of Upgrades and Patching
  • Patches and Patch Sets
  • Obtain Patches
  • Apply Rolling Patches to a RAC System
  • Apply a Patch with the opatch Utility
  • Upgrade the Oracle Software

Session 18: MULTITENANT ARCHITECTURE IN A RAC ENVIRONMENT

  • Overview of Multitenant Architecture
  • Create a RAC CDB and PDB
  • Use the CDB and PDB Default Services
  • Drop a PDB

Session 19: OVERVIEW OF RAC ONE NODE

  • Overview of RAC One Node
  • Online Database Migration
  • Add an Oracle RAC One Node Database to an Existing Cluster
  • Convert a Single Instance Database to a RAC One Node Database
  • Convert an Oracle RAC One Node Database to a Complete RAC Database

Session 20: OVERVIEW OF QUALITY OF SERVICE MANAGEMENT

  • Overview of Quality of Service Management (QOS)
  • QOS Components
  • QOS Functionality

Session 21: OVERVIEW OF APPLICATION CONTINUITY FOR JAVA

  • Overview of Application Continuity (AC)
  • AC Architecture
  • AC Restrictions
  • Application Requirements
 

Oracle Database 12cR2 RAC and Grid Infrastructure Administration

Duration: 5 days

RRP: £2,250.00 exc. VAT 


Upcoming Scheduled Events
Next 6 months

London
Start Date   Spaces Book
25 Nov 2019   Spaces StayAhead - Course Running Book
 
10 Feb 2020   Spaces StayAhead - Course Running Book
 
11 May 2020   Spaces StayAhead - Course Running Book
 
10 Aug 2020   Spaces StayAhead - Course Running Book
 
Virtual Events StayAhead Virtual Courses available You can attend your training virtually using the London dates shown above. Please contact us for more details on our Virtual training options or to discuss specific Virtual course dates to meet your requirements.
 

Course Reviews

Excellent instruction.

Kevin - DBA - Insurance


Well paced with a good mix of theory and workshops.

Brendan - Consultant - IT


The instructor has been very helpful, very intuitive, and the course has been a joy to be on.

Simon - Technical Consultant - IT


 
 
 
Quick Search....
        Home             Let Us Call You
 

 

Course Deliveries

Public Scheduled and Closed
Virtual
UK and Overseas

OUG

Oracle User Group - Membership Benefits

OUG

Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

StayAhead
Flexibility

Cannot see a sutiable date?
Please call us and we will try an accommodateyour needs!




Our Course Curriculum

 
 
 
 
 



Our Ratings

Instructor
Quality
 

97.32%

Course
Practical
 

92.6%

Overall
Courseware
 

94.19%

Overall
Course
 

96.33%

+44 (0)20 7600 6116
Enquiries@StayAhead.com
Copyright © 2019 StayAhead Training Ltd
Cookies   /   Privacy Policy