Oracle Database 12c: RAC Administration Training

Download Course Brochure

Instructor-Led Training Parameters

Course Highlights

  • Instructor-led Online Training
  • Project Based Learning
  • Certified & Experienced Trainers
  • Course Completion Certificate
  • Lifetime e-Learning Access
  • 24x7 After Training Support

Instructor-led Training Live Online Classes

Suitable batches for you

Mar, 2024 Weekdays Mon-Fri Enquire Now
Weekend Sat-Sun Enquire Now
Apr, 2024 Weekdays Mon-Fri Enquire Now
Weekend Sat-Sun Enquire Now

Share details to upskills your team



Build Your Own Customize Schedule



Oracle Database 12c: RAC Administration Training Course Overview

Oracle Database 12c: RAC Administration training explains the Oracle RAC database concepts in details. The training covers the concepts and practical approach to explain the Oracle RAC database architecture, its installation, configuration, and administration. The participants will learn how to take the backup and provide recovery. How to manage high availability of connections and continuity in the applications is also explained during the training sessions.

At the end of the Oracle Database 12c: RAC Administration training course, you will inculcate the following skills:

  • Understand the characteristics of Clusterware  and Flex cluster
  • Define Oracle RAC, its storage solutions, architecture and other details
  • Install, configure, administer, upgrade, and patch Oracle RAC
  • Maintain backup and recovery in RAC at the time of failure  and later on restore
  • Describe how Grid Plug and Play affects Clusterware
  • Explain the necessity of global resources and work on Globally Managed Resources, Library Cache Mangement, Row Cache Management, Buffer Cache management and other associated tasks
  • Work on the high availability of the services in RAC environment
  • Illustrate the monitoring and tuning of RAC
  • Explain the concept of Application Continuity (AC) along with its architecture and working
  • Describe Quality of Service (QoS) management
  • Work on RAC One Node
Target audience
  • Database Administrator
  • Administrator
Prerequisites
  • Oracle Database 12c: Oracle ASM Administration
  • Oracle Database 12c: Clusterware Administration
  • Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2

Oracle Database 12c: RAC Administration Training Course Content

1. Grid Infrastructure Overview and Review

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

2. RAC Databases Overview & Architecture

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

3. Installing and Configuring Oracle RAC

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

4. Oracle RAC Administration

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

5. Upgrading and Patching RAC

  • Overview of Upgrades and Patching
  • Release and Patch Set Upgrades
  • PSU, CPU and Interim Patches
  • Merge Patches
  • Performing Out Of Place Database Upgrades
  • Planning and Preparing for Upgrade
  • Performing Out of Place Release Install or Upgrade
  • Post Upgrade Tasks

6. RAC Backup and Recovery

  • Instance Failure And Recovery In RAC - LMON and SMON
  • Redo Threads and Archive Log 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 Distribution
  • RMAN Restore And Recovery RAC Considerations

7. RAC Global Resource Management and Cache Fusion

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

8. RAC Monitoring and Tuning

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

9. Managing High Availability of Services in a RAC Environment

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

10. Managing High Availability of Connections

  • Types of Workload Distribution
  • Client-Side Load Balancing
  • Server-Side Load Balancing
  • Runtime Connection Load Balancing and Connection Pools
  • Fast Application Notification
  • The Load Balancing Advisory FAN Event
  • Server-Side Callouts
  • Configuring the Server-Side ONS

11. Application Continuity

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

12. Quality of Service Management

  • QOS Management concepts
  • Describe the benefits of using QoS Management
  • QoS Management components
  • QoS Management functionality

13. RAC One Node

  • RAC One Node Concepts
  • Online database migration
  • Adding Oracle RAC One Node Database to an Existing Cluster
  • Convert an Oracle RAC One Node database to a RAC database
  • Convert an Oracle RAC database to a RAC One Node database
  • Use DBCA to convert a single instance database to a RAC One Node database

video-img

Request for Enquiry

assessment_img

Free Oracle Database RAC Training Assessment

This assessment tests understanding of course content through MCQ and short answers, analytical thinking, problem-solving abilities, and effective communication of ideas. Some Multisoft Assessment Features :

  • User-friendly interface for easy navigation
  • Secure login and authentication measures to protect data
  • Automated scoring and grading to save time
  • Time limits and countdown timers to manage duration.
Try It Now

Oracle Database RAC Corporate Training

Employee training and development programs are essential to the success of businesses worldwide. With our best-in-class corporate trainings you can enhance employee productivity and increase efficiency of your organization. Created by global subject matter experts, we offer highest quality content that are tailored to match your company’s learning goals and budget.


500+
Global Clients
4.5 Client Satisfaction
Explore More

Customized Training

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Expert
Mentors

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

360º Learning Solution

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Learning Assessment

Be it schedule, duration or course material, you can entirely customize the trainings depending on the learning requirements

Certification Training Achievements: Recognizing Professional Expertise

Multisoft Systems is the “one-top learning platform” for everyone. Get trained with certified industry experts and receive a globally-recognized training certificate. Some Multisoft Training Certificate Features :

  • Globally recognized certificate
  • Course ID & Course Name
  • Certificate with Date of Issuance
  • Name and Digital Signature of the Awardee
Request for Certificate

What Attendees are Saying

Our clients love working with us! They appreciate our expertise, excellent communication, and exceptional results. Trustworthy partners for business success.

Share Feedback
  Chat On WhatsApp

+91-9810-306-956

Available 24x7 for your queries