Oracle Database 12c RAC and Grid Infrastructure Administration

5 Day Course
Hands On
Code O12CRAC

Book Now - 2 Delivery Methods Available:

Scheduled Online Onsite

Overview

This Oracle Database 12c RAC and Grid Infrastructure Administration course provides an introduction to 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).

Objectives

The delegate will learn and acquire skills as follows:

  • Installing and configuring Oracle Database 12c Grid Infrastructure
  • Installing Oracle Database software
  • Creating a RAC Cluster Database
  • Administering and Monitoring a RAC database using Enterprise Manager and command line tools
  • Using configuration and management tools for RAC 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

Target Audience

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

Additional Information

  • 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.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

Oracle Real Application Clusters Overview (5 topics)

  • Oracle RAC Features
  • Oracle RAC Technology Hierarchy
  • Oracle RAC Capabilities
  • Oracle RAC Components
  • Tools for Installing, Configuring and Managing Oracle RAC

Oracle Clusterware Troubleshooting (10 topics)

  • Overview of Oracle Clusterware Troubleshooting
  • Hardware, Storage and Network Problems with RAC
  • The Oracle Clusterware Alert Log
  • Failed, Missing or Offline Cluster Resources
  • Oracle Clusterware Log Files
  • Troubleshoot the OCR and Voting Disk
  • Debug Resources
  • Debug a Component Level
  • CRS, CCS and EVM Components
  • Oracle Clusterware Troubleshooting Tools and Utilities

RAC Performance Monitoring and Tuning (12 topics)

  • Monitoring and Performance Guidelines
  • RAC Monitoring Tools
  • RAC Performance Recommendations
  • Workload Partitioning
  • CPU and Wait Time Latches
  • Session and System Statistics
  • RAC Specific V$ Views
  • Analyze Performance Issues
  • Use the Automatic Workload Repository in RAC
  • Use the Automatic Database Diagnostic Monitor in RAC
  • Statspack with RAC
  • Monitor and Tune the RAC Cluster Environment

Add and Delete Nodes and Clusters (8 topics)

  • 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

Manage Oracle Software and Apply Patches (9 topics)

  • Overview of Upgrades and Patching
  • Release and Patch Set Upgrades
  • PSU, CPU and Patch Set Upgrade
  • Merge Patches
  • Out of Place Database Upgrades
  • Plan and prepare for Upgrade
  • Perform Out of Place Release Install and Upgrade
  • Apply a Patchset with the opatch Utility
  • Post Upgrade Tasks

Oracle Grid Infrastructure Overview (10 topics)

  • Cluster Overview
  • 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
  • ASM Architecture
  • Create and Manage ASM Disk Groups
  • An Overview of RAC Services
  • Network Configuration

RAC Pre-Installation Tasks (4 topics)

  • Oracle RAC Pre-installation Tasks
  • Create Oracle Groups, User Accounts and Directories
  • Validate and Prepare the Hardware and the Operating System
  • Network Configuration

Install Oracle Real Application Clusters (6 topics)

  • Cluster Verification Utility
  • Install Oracle Database Software and Create a Cluster Database
  • Verify the Installation
  • Post Installation Tasks
  • Configure Client Connections with Oracle Net Manager
  • RAC Specific Background Processes

RAC Cluster Database and Database Instance Administration (7 topics)

  • RAC Initialization Parameters
  • Manage Undo Tablespaces in a RAC Environment
  • Manage Redo Log Files and Groups in a RAC Environment
  • Oracle Enterprise Manager Cluster Database Pages
  • Start and Stop Oracle RAC Databases and Instances
  • Administer Database Storage
  • Transparent Data Encryption and Wallets in RAC

Administer Oracle Clusterware Components (9 topics)

  • Manage CRS Commands
  • 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)
  • Backup and Restore OCR
  • Troubleshoot the OCR with ocrcheck

ASM Instance Administration (6 topics)

  • ASM Initialization Parameters
  • Create an ASM Instance using ASMCA
  • Start and Stop an ASM Instance using srvctl
  • Start and Stop an ASM Instance using ASMCMD
  • Start and Stop an ASM Instance Containing Cluster Files
  • Start and Stop the ASM Listener

ASM Disk Group Administration (5 topics)

  • Create and Delete ASM Disk Groups
  • ASM Disk Group Attributes
  • ASM Disk Group Maintenance Tasks
  • Preferred Read Failure Groups
  • ASM Disk Statistics

RAC Management Commands (11 topics)

  • 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
  • Introduction to CRS
  • Cluster Services

Managing the Database Workload Using Services (7 topics)

  • Manage the Database Workload using Services
  • Create and Administer Services in a RAC Environment
  • Services and Client Applications
  • Manage Services with Enterprise Manager and from the Command Line
  • Configure Oracle Net to Support Services
  • Configure Service Level Thresholds
  • Configure Clients for Failover

High Availability of Connections (8 topics)

  • RAC High Availability Framework
  • Failure Detection with Cluster Services
  • Oracle RAC and Hardware Failover
  • Connection Failover
  • Transparent Application Failover (TAF)
  • Server, Client And Runtime Load Balancing
  • Fast Application Notification (FAN)
  • Server and Client Side Oracle Notification Services

RAC Cache Fusion and Global Resource Management (9 topics)

  • Globally Managed Resources
  • Library Cache Management
  • Row Cache Cache Management
  • Buffer Cache Fusion
  • Management Requirements of the Buffer Cache
  • Use Result Caching
  • Access Single Blocks in RAC
  • Multi Block Read Considerations in RAC
  • Undo and Read Consistency Issues in RAC

Backup and Recover a RAC Database (8 topics)

  • 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

Multitenant Architecture in a RAC Environment (4 topics)

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

Overview of RAC One Node (5 topics)

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

Overview of Quality of Service Management (3 topics)

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

Overview of Application Continuity for Java (4 topics)

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

Prerequisites

A working knowledge of Oracle Database 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.

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

Relevant Certifications

Scheduled Dates

Please select from the dates below to make an enquiry or booking.

Pricing

Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Oct Nov Dec Jan Feb Mar
O12CRAC 5 Days $2,250

or call:408-759-5074

Alternatively you can request a callback or schedule a call with a Training Advisor

Course PDF

Print

Share this Course

+1
Share

Recommend this Course

Sections