• Home
  • Oracle
  • Oracle 11g: RAC and Grid Infrastructure Administration Accelerated training

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated training

Download Course Brochure Interview Questions

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

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated training Course Overview

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated training has been designed to insight the candidates on the Oracle Grid Infrastructure products, including Oracle Automatic Storage Manager (ASM), ASM Cluster File System and Oracle Clusterware. Here they will get the chance to  learn to administer the Oracle Clusterware and storage products using both command line utilities and graphical tools using both command line and graphical user interface clients.

After attending Oracle 11g RAC and grid infrastructure administration accelerated release 2 training the candidates would be able to:

  • Describe the Oracle Database 11g Grid Infrastructure
  • Define and implement the intelligence on Administer both Policy and Administrator managed RAC databases
  • Manage RAC databases
  • Implement Grid Infrastructure installation and create RAC database intelligence
  • Understand what Troubleshoot Oracle Clusterware is?
  • Describe Clusterware management proficiency
  • Install Oracle Database 11gR2 software and create RAC database efficiently
  • Manage the backup and recovery for RAC, etc.
Target audience
  • Database Administrators
  • Database Designers
  • Database Administrators
  • Database Designers
  • Technical Administrator
Prerequisites
  • Oracle Database Administration experience
  • Oracle Database 11g: Administration Workshop

Instructor-led Training Live Online Classes

Suitable batches for you

Nov, 2024 Weekdays Mon-Fri Enquire Now
Weekend Sat-Sun Enquire Now
Dec, 2024 Weekdays Mon-Fri Enquire Now
Weekend Sat-Sun Enquire Now

Share details to upskills your team


Build Your Own Customize Schedule


Oracle 11g: RAC and Grid Infrastructure Administration Accelerated training Course Content

1. Oracle Grid Infrastructure Concepts

  • Oracle Grid Infrastructure
  • Oracle Clusterware Architecture and Services
  • Goals for Oracle Clusterware
  • Oracle Clusterware Networking
  • Grid Naming Service, Single-Client Access Name
  • Grid Plug and Play
  • GPnP Domain, Components, Profile
  • Oracle Automatic Storage Management (ASM) and Grid Infrastructure

2. Oracle Clusterware Architecture

  • Oracle Grid Infrastructure for a Cluster
  • Oracle Cluster Registry (OCR)
  • CSS Voting Disk Function
  • Oracle Local Registry and High Availability
  • Oracle Clusterware Initialization, Controlling Oracle Clusterware
  • Verifying the Status of Oracle Clusterware, Viewing the High Availability Services Stack
  • GPnP Architecture: Overview
  • Automatic Storage Management

3. Grid Infrastructure Pre-installation Tasks

  • Pre-installation Planning
  • Shared Storage Planning for Grid Infrastructure
  • Sizing Shared Storage for Oracle Clusterware
  • Storing the OCR in ASM
  • Managing Voting Disks in ASM
  • Installing & Preparing ASMLib
  • Grid Infrastructure Pre-installation Tasks
  • Oracle Grid Infrastructure 11g

4. Grid Infrastructure Installation

  • Choosing an Installation Type
  • Grid Plug and Play Support
  • Cluster Node Information
  • Specify Network Interface Usage
  • Storage Option Information
  • Specify Cluster Configuration: Typical Installation
  • Verifying the Grid Infrastructure Installation
  • Modifying Oracle Clusterware Binaries after Installation

5. Adding and Removing Cluster Nodes

  • Adding Oracle Clusterware
  • Prerequisite Steps for Running addNode.sh
  • Adding a Node with addNode.sh
  • Completing OUI Node Addition
  • Removing a Node from the Cluster
  • Deleting a Node from the Cluster
  • Deleting a Node from a Cluster (GNS in Use
  • Deleting a Node from the Cluster

6. Administering Oracle Clusterware

  • Managing Oracle Clusterware
  • Managing Clusterware with Enterprise Manager
  • Controlling Oracle High Availability Services
  • Determining the Location of Oracle Clusterware Configuration Files g
  • Checking the Integrity of Oracle Clusterware Configuration Files
  • Backing Up and Recovering the Voting Disk
  • Adding, Deleting, or Migrating Voting Disks
  • Locating the OCR Automatic Backups

7. Upgrading and Patching Grid Infrastructure

  • Out-of-Place Oracle Clusterware Upgrade
  • Oracle Clusterware Upgrade
  • Types of Patches, Patch Properties
  • Configuring the Software Library
  • Setting Up Patching, Starting the Provisioning Daemon
  • Obtaining Oracle Clusterware Patches
  • Rolling Patches, Checking Software Versions
  • Installing a Rolling Patchset with OUI, Installing a Rolling Patch with OPatch

8. Troubleshooting Oracle Clusterware

  • Golden Rule in Debugging Oracle Clusterware
  • Monitoring Oracle Clusterware
  • Cluster Health Monitor (CHM)
  • oclumon Utility
  • oclumon debug Command
  • clumon dumpnodeview Command
  • oclumon dumpnodeview Command
  • oclumon manage Command

9. Making Applications Highly Available with Oracle Clusterware

  • Oracle Clusterware High Availability (HA)
  • Resource Management Options
  • Server Pools
  • GENERIC and FREE Server Pools
  • Assignment of Servers to Server Pools ew
  • Server Attributes and States
  • Creating Server Pools with srvctl and crsctl
  • Managing Server Pools with srvctl and crsctl

10. ASM: Overview

  • ASM and ASM Cluster File System
  • ASM Key Features and Benefits
  • ASM Instance Designs: Nonclustered ASM and Oracle Databases
  • ASM Instance Designs: Clustered ASM for Clustered Databases
  • ASM Instance Designs: Clustered ASM for Mixed Databases
  • ASM System Privileges
  • ASM OS Groups with Role Separation
  • Authentication for Accessing ASM Instances

11. Administering ASM

  • Managing ASM with ASMCA
  • Starting and Stopping ASM Instances by Using ASMCA and ASMCMD
  • Starting and Stopping ASM Instances by Using srvctl
  • Starting and Stopping ASM Instances by Using SQL*Plus
  • Starting and Stopping ASM Instances Containing Cluster Files
  • ASM Initialization Parameters
  • AASM_DISKGROUPS
  • Disk Groups Mounted at Startup

12. Administering ASM Disk Groups

  • Disk Group: Overview
  • Creating a New Disk Group
  • Creating a New Disk Group with ASMCMD
  • Creating an ASM Disk Group with ASMCA
  • Creating an ASM Disk Group: Advanced Options
  • Creating a Disk Group with Enterprise Manager
  • Disk Group Attributes
  • V$ASM_ATTRIBUTE

13. Administering ASM Files, Directories, and Templates

  • ASM Clients
  • Interaction between Database Instances and ASM
  • Accessing ASM Files by Using RMAN
  • Accessing ASM Files by Using XML DB
  • Accessing ASM Files by Using DBMS_FILE_TRANSFER
  • Accessing ASM Files by Using ASMCMD
  • Fully Qualified ASM File Names
  • Other ASM File Names

14. Administering ASM Cluster File Systems

  • ASM Files and Volumes
  • ACFS and ADVM Architecture: Overview
  • ASM Cluster File System
  • Striping Inside the Volume
  • Creating an ACFS Volume
  • Creating an ASM Dynamic Volume with Enterprise Manager
  • Managing ADVM Dynamic Volumes
  • Creating an ASM Cluster File System with Enterprise Manager

15. RAC Concepts

  • Overview of Oracle RAC
  • RAC One Node Single-Instance High Availability
  • Oracle RAC One Node and Oracle Clusterware
  • Cluster-Aware Storage Solutions
  • Oracle Cluster File System
  • Benefits of Using RAC
  • Clusters and Scalability
  • Levels of Scalability

16. Installing and Configuring Oracle RAC

  • Installing the Oracle Database Software, Creating the Cluster Database
  • Database Type Selection, Database Identification
  • Cluster Database Management Options
  • Database File Locations, Recovery Configuration, Database Content
  • Create the Database
  • Background Processes Specific to Oracle RAC
  • Considerations for Converting Single-Instance Databases to Oracle RAC
  • Single-Instance Conversion Using the DBCA and rconfig

17. Oracle RAC Administration

  • Configuration Section, Topology Viewer
  • Enterprise Manager Alerts and RAC, Metrics and RAC
  • Enterprise Manager Alert History and RAC, Enterprise Manager Blackouts and RAC
  • Redo Log Files and RAC, Automatic Undo Management and RAC
  • Starting and Stopping RAC Instances
  • Switch Between Automatic and Manual Policies
  • RAC Initialization Parameter Files

18. Managing Backup and Recovery for RAC

  • RAC and Instance Recovery
  • Instance Recovery and Database Availability
  • Instance Recovery and RAC
  • Protecting Against Media Failure
  • Media Recovery in Oracle RAC
  • Parallel Recovery in RAC
  • Archived Log File Configurations
  • RAC and the Fast Recovery Area, RAC Backup and Recovery Using EM

19. RAC Database Monitoring and Tuning

  • CPU and Wait Time Tuning Dimensions, RAC-Specific Tuning
  • Analyzing Cache Fusion Impact in RAC
  • Typical Latencies for RAC Operations
  • Wait Events for RAC, Wait Event Views
  • Global Cache Wait Events: Overview, Global Enqueue Waits
  • Session and System Statistics
  • Most Common RAC Tuning Tips
  • AWR Reports and RAC: Overview

20. Oracle RAC One Node

  • Verifying an Existing RAC One Node Database
  • Oracle RAC One Node Online Migration, Online Migration Considerations
  • Performing an Online Migration
  • Online Migration Illustration, Online Maintenance: Rolling Patches
  • Adding an Oracle RAC One Node Database to an Existing Cluster
  • Converting a RAC One Node Database to RAC
  • Converting a Single Instance Database to RAC One Node
  • Converting a RAC Database to RAC One Node

21. Quality of Service Management

  • QoS Management Overview
  • QoS Management and Exadata Database Machine
  • QoS Management Focus, Benefits, Functional Overview and Policy Sets
  • Server Pools, Performance Classes
  • Classification and Tagging
  • Performance Policies, Performance Class Ranks, Performance Objectives
  • Server Pool Directive Overrides, Overview of Metrics
  • QoS Management Architecture

22. Design for High Availability

  • Causes of Unplanned Down Time, Causes of Planned Down Time
  • Oracle’s Solution to Down Time
  • RAC and Data Guard Complementarily
  • Maximum Availability Architecture
  • RAC and Data Guard Topologies, RAC and Data Guard Architecture
  • Data Guard Broker (DGB) and Oracle Clusterware (OC) Integration
  • Hardware RAID–Striped LUNs, Hardware RAID–Striped LUNs HA
  • Extended RAC: Overview, Connectivity and Disk Mirroring

video-img

Request for Enquiry

assessment_img

Oracle RAC Training (MCQ) 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 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

zoom-in Zoom-in

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
  WhatsApp Chat

+91-9810-306-956

Available 24x7 for your queries

For Career Assistance : contact +91-9810306956