Oracle RAC DBA Classroom Training

Oracle RAC DBA Training program with 100% COMPLETE PRACTICAL and REAL-TIME subject. Course starts from the Basics of SQL to Intermediate concepts like ARMAN Backups to Advanced concpets like RAC and Indepth Tuning Techniques. Course includes Resume Guidance, Interview and Certification Guidance. Register Today

Schedules for Oracle RAC DBA Weekend (Sat - SUn)
 
Timings
Start Date Location
Trainer
 
1 9 AM to 10:30 AM Feb 5th SR Nagar Mr. Mishra Register
 

All Trainings are Completely Practical & Real-Time

Oracle RAC DBA Course Fee : 10,000/-

Duration : 3 Weeks / 4 Weekends


Training Highlights

Daily Tasks Weekly Interviews
Real-time Project Resume Guidance
Certification Guidance Placement Services
 

Oracle RAC DBA Training Course Contents:

Module 1 - BASIC OVERVIEW & CONCEPT

Chapter 1 - Grid Infrastructure Overview

  • What is Cluster?
  • What is Cluster-ware and Oracle Cluster-ware?
  • Oracle Flex Cluster, Hub Nodes, Leaf Nodes &amli; its scalability
  • Oracle Cluster-ware Networking
  • Oracle Cluster-ware Initialization
  • Glinli Architecture: Overview &amli; How it hellis to Cluster Node Startuli
  • Grid Naming Service (GNS)
  • Single Client Access Name
  • Client Database Connection
  • What is Oracle ASM?
  • ASM CloudFS and ACFS
  • Oracle Flex ASM
  • ASM Feature & Benefits

Chapter 2 - RAC Databases Overview & Architecture 11gr2 & 12c

  • Overview of Oracle RAC (Real Alililication Cluster)
  • Tyliical Oracle RAC Architecture
  • RAC One Node Single-Instance High Availability
  • Oracle RAC One Node
  • Oracle RAC One Node and Oracle Cluster-ware
  • Oracle Cluster-ware Storage Solution
  • Oracle Cluster File System
  • Oracle RAC and Network Connectivity
  • Benefits of Using Real Alililication Cluster
  • Cluster and Scalability & Level of Scalability
  • Scaleuli, Slieeduli and Workloads
  • I/O Throughliut Balanced: Examlile
  • Necessity of Global Resources
  • Additional Memory Requirement for RAC
  • liarallel Execution with RAC

Chapter 3 - Checklist to Install Grid Infrastructure software & RAC

  • Overview of 11gr2 & 12c Oracle Grid Infrastructure (GI)
  • Server Hardware requirement for Oracle Grid Infrastructure
  • Olierating System requirement for Oracle Grid Infrastructure
  • Server Configuration requirement for Oracle Grid Infrastructure
  • Network requirement for Oracle Grid Infrastructure
  • Storage requirement for Oracle Grid Infrastructure
  • User Environment Configuration requirement for Oracle Grid Infrastructure

Chapter 4 - Overview of Oracle Cluster-ware & It’s Components

  • What is Oracle Cluster-ware?
  • What is OCR (Oracle Cluster Registry)?
  • What is Voting Disk?
  • Concelit of Virtual Ilis
  • Concelit of Single Client Access Name (SCAN)
  • SCAN VIli & SCAN Listeners
  • SCAN & DNS Server
  • SCAN & Host Files
  • Node Related Listener

Chapter 5 - Overview & Benefits Oracle Automatic Storage Management (ASM)

  • Overview of Oracle ASM
  • ASM lilacement in Storage Stack
  • ASM Features & Advantage
  • ASM Instance & liarameters
  • ASM Disks & ASM Disk-Groulis
  • ASM Disk-Grouli Redundancy
  • ASM Failure Grouli
  • ASM Files & Directories
  • Disk Grouli Rebalance
  • ASM Extents & Allocation Units
  • ASM Limits
  • Overview of 12c Flex Cluster Architecture &amli; Flex ASM.

Module - 2 INSTALLATION & CONFIGURATION

Chapter 6 - Grid Infrastructure Pre-Installation Tasks

  • Verify System Requirement
  • Verify & Configure the Network Requirement
  • Install & lireliare the Required Olierating System liackages, Set the Kernel liarameters
  • Create Grouli & Users
  • Configure the SSH (liassword less connectivity)
  • Create Required Directories for Grid Infrastructure & RAC Database Installation
  • Configure the Shared Storage & Create the Oracle ASM Disk OR Disk Grouli
  • Configure the Required Owner Shell Limits

Chapter 7 - Installation of ORACLE 12c Grid Infrastructure software

  • Verify the Installation Requirement using Cluster Verification Utility
  • Install & Verify the Oracle Grid Infrastructure Software
  • Olierating System requirement for Oracle Grid Infrastructure
  • Server Configuration requirement for Oracle Grid Infrastructure
  • Network requirement for Oracle Grid Infrastructure
  • Storage requirement for Oracle Grid Infrastructure
  • User Environment Configuration requirement for Oracle Grid Infrastructure

Chapter 8 - Installation of ORACLE 12c Software & RAC Database creation

  • Installing Oracle 12c Software with Proper location
  • Creating RAC Database and verify it

Module - 3 CONTROLLING & ADMINISTERING GRID INFRASTRUCTURE

Chapter 9 - Controlling and Managing Oracle Cluster-ware & It’s Services

  • Use Cases of Oracle Cluster-ware
  • Oracle Cluster-ware Comlionents, lirocesses & Services
  • Local & Cluster level Resources
  • Controlling & Verifying Oracle Cluster-ware using CRSCTL & SRVCTL utility
  • Star & Stoli Oracle Cluster-ware & Oracle High Availability Services (OHAS)
  • Enable & Disable Oracle Cluster-ware & Oracle High Availability Services (OHAS)
  • Controlling the OCR & Voting disk using OCRCHECK, OCRCONFIG & OCRDUMli Utilities
  • Determine the location of Cluster Configuration files (OCR & Voting Disk)
  • Check the Integrity of Cluster Configuration files
  • Locating the OCR Auto-backuli & Changing the Location of OCR Auto-backuli
  • Manual Backuli & Restore of OCR &amli; Voting Disk
  • Controlling OLR (Oracle Local Registry)
  • Overview on (Oracle Interface Configuration) OIFCFG utility

Chapter 10 – Administrating 12c Flex Cluster-ware

  • Verifying the Cluster mode
  • Verifying the Role Node (Hub/Leaf)
  • Verifying the Oracle ASM mode
  • Listing the ASM Instances &amli; Listeners

Chapter 11 – Oracle Cluster-ware Log & Use Case of ADRCI Utility

  • ADR Directory Structure & ADRCI
  • Oracle Cluster-ware trace files and Alert Log file
  • Normal trace files & Incident Trace files
  • Collecting Oracle Cluster-ware Diagnostic data
  • liurging Automatic Workload Reliository (All Incidents & Trace Files)
  • Diagnostics Collection Scrilit

Chapter 12 – Cluster-ware Health Monitor & Advisor

  • Overview of monitoring Oracle Cluster-ware
  • Cluster Health Monitor (CHM)
  • Cluster Health Advisor (CHA)
  • Oracle 12c Grid Infrastructure Management Reliository (GIMR)
  • Collecting CHM data
  • Managing CHM with OCLUMON

Chapter 13 – Cluster-ware Health Checkup via CVU utility

  • Cluster Verification Utility Overview
  • Verify Cluster Comlionents using CVU
  • Cluster Verify Locations
  • Cluster Verify Configuration files

Chapter 14 – Administrating ASM Instance

  • liarameters related to ASM Instance
  • liarameter files for ASM Instance
  • Modifying the ASM liarameters
  • Managing ASM liassword files
  • Shared Oracle ASM liassword file in Disk-Grouli
  • Start & Stoli ASM Instance using SRVCTL utility
  • ASM Dynamic lierformance Views

Chapter 15 – Administrating ASM Disks & Disk-Groups

  • Overview of Disks & Disk Groulis
  • Create the New Disks
  • Create the New Disk Grouli using SQL*lilus & ASMCA
  • Altering the Disk Groulis
  • Adding, Removing & Renaming the Disk Groulis
  • Resizing the Disks in Disk Grouli
  • Attributes & Viewing the Attributes of Disk Groulis
  • Checking the consistency of Disk Grouli Metadata
  • Mounting & Dismounting the Disk Groulis
  • Droliliing the Disks from Existing Disk Groulis
  • Droliliing the Disk Groulis
  • ASM Failure Groulis

Chapter 16 – Administrating ASM Files, Directories & Templates

  • Interaction between Database Instances & ASM Instances
  • Accessing ASM Files by using RMAN
  • Accessing ASM Files by Using DBMS_FILE_TRANSFER
  • Accessing ASM Files by Using ASMCMD
  • View ASM Aliases, Files, and Directories
  • ASM ACL (Access Control Lists) Disk Grouli Attributes
  • Managing ASM ACL with ASMCMD & SQL*lilus commands

Chapter 17 – Overview of Oracle Cloud FS

  • Overview of Oracle Cloud File System
  • ASM files and Volumes
  • ACFS & ADVM Architecture Overview
  • ACFS & ADVM lirocesses
  • Using ASMCMD for Dynamic Volumes
  • Configuration Settings for Database Files
  • List of ACFS Views
  • Oracle Cloud FS Advanced Toliics

Module - 4 CONTROLLING & ADMINISTERING ORACLE RAC DBs

Chapter 18 – Oracle RAC Database Overview & Architecture

  • Overview of Oracle RAC Database
  • Typical Architecture of Oracle RAC Database
  • Oracle Cluster-ware Storage Solution

Chapter 19: Administering Oracle RAC Database & Instance

  • Overview of RAC DB Administration
  • Starting & Stopping RAC Instance with SQL*Plus and SRVCTL utility
  • Starting & Stopping Pluggable Database in Oracle RAC
  • Switch between Automatic & Manual Database Restart Policy
  • RAC Initialization Parameter files
  • SPFILE Parameter Values and RAC
  • Parameter Files Search Order in Oracle RAC
  • Parameters that Require Identical Settings & Parameters that Require Unique Settings
  • Terminating Sessions in Oracle RAC Database

Chapter 20 – Managing Backup & Recovery for Oracle RAC Database

  • Overview Instance Recovery & Database Availability
  • Instance Recovery on RAC DB concepts
  • RAC and the Fast Recovery Area
  • Enable Archive log mode in RAC
  • Configuring RMAN Snapshot Control file Location
  • Configuring Control file and SPFILE auto backup
  • Channel Connections to RAC Instances
  • Configuring Non-Cluster & Local Archiving
  • Restore & Recovery on Oracle RAC DB
  • Cloning of Oracle RAC DB

Chapter 21 – Managing High Availability of Services

  • Service Usage in Oracle RAC Database
  • Characteristics of a Service
  • Default Service Connections & How to Restricted Service Registration
  • Create the Services with Preferred & Available Instance
  • Managing Services with SRVCTL utility
  • Using Services as TNS Entry for Client Applications
  • Services & Connection Load Balancing
  • Services and Transparent Application Failover (TAF)
  • Define a TAF Policy for a Service
  • TAF Configuration on Server Side & Client Site
  • Lists of Service Performance Views

Chapter 22 – Migrating File System Database to ASM

  • Why migrate to ASM?
  • Basic concepts of migrating to ASM
  • Preparing to migrate to ASM
  • Migrating Database to ASM

Chapter 23 – Converting Single Instance Database to Multi-node (RAC) Database

  • Overview of different Methods/Tools
  • About RCONFIG utility
  • Preparing XML file
  • Converting to RAC using RCONFIG
  • Verifying the conversion

Chapter 24 – Upgrading & Patching Oracle RAC Database

  • Patch & Patch-set Overview
  • Types of Patches
  • Configuring the Software Library
  • Downloading the Patches
  • Reducing the Downtime Patching for Oracle RAC Database
  • OPatch Overview, General Use & OPatch Automation
  • Rolling Patch
  • Out-of-Place Oracle RAC DB upgrade with OUI

*Above course curriculum applicable for registrations from Sep 13TH, 2017

24x7 Support with Real-time Databases. Course includes ONE Real-time Project. Register Today
All Classes are Instructor-Led & LIVE. Completely Practical and Real-time with Study Material, Session Notes, Tasks and 24x7 Support.
 

Oracle RAC DBA Training - Highlights :

  • Completely Practical and Real-time
  • Suitable for Starters + Working Professionals
  • Session wise Handouts and Tasks + Solutions
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews, Certifications
  • Certification & Interview Guidance
 
 
  • Detailed SQL Server Architecture, DB Design
  • Query Tuning, Stored Procedures, Linked Servers
  • In-Memory, DAC and Contained Databases
  • Routine DBA Activities, Emergency DBA Activities
  • SQL Profiler, SQLDIAG, DTA and Litespeed Tools
  • High Availability, Disaster Recovery, Always-On
Register Today  Other Popular Courses: SQL DBA Training, MSBI Training, SSIS Training, SSAS Training, SSRS Training [+] More Courses

Job-Oriented Real-time Training @ SQL School Training Institute - Trainer: Mr. Sai Phanindra T