Oracle RAC Training in Hyderabad

Oracle RAC Training in Hyderabad

 
S.NO
TOPIC
Sub Topics
1
Introduction to Clusters
  • Introduction to Clusters
  • Why cluster?
  • Different Clustering Architectures
  • Shared Nothing Clusters
  • Shared Disk Clusters
  • Shared Everything Clusters
2
Introduction to Oracle Real ApplicationClusters (RAC) 12c
  • What is Oracle Real Application
  • Clusters (RAC)?
  • Benefits of Oracle RAC
  • What RAC is NOT?
  • History of RAC
  • Tools & Utilities to manage RAC
3
Overview of Oracle RAC Infrastructure
  • Overview of Infrastructure required to implement RAC
  • Server & OS requirements
  • Network requirements
  • Storage requirements
  • Software requirements
 
4
Overview of Oracle Clusterware
  • What is Oracle Clusterware?
  • About OCR & Voting Disks
  • About Virtual IPs (VIP)
  • Single Client Access Name(SCAN)
  • SCAN VIPs
  • SCAN Listeners
  • SCAN and DNS server
  • SCAN and host file
  • Node Listeners
5
Oracle ASM Concepts
  • Overview of Oracle ASM
  • ASM Features & Advantages
  • ASM Instance
  • ASM Disks & ASM Disk Groups
  • ASM Diskgroup Redundancy
  • ASM Failure groups
  • ASM Files
  • ASM Extents & Allocation Unit
  • Interaction between ASM Instance & RDBMS instance
  • ASM Limits
6
Overview of Oracle 12c Flex Cluster & Flex ASM
  • Oracle 12c Flex Cluster Architecture
  • Hub Nodes & Leaf nodes
  • Standard ASM
  • Overview of Oracle 12c Flex ASM
  • Flex ASM Architecture
  • Oracle Flex ASM Clusters Network
  • Oracle Flex ASM Listener
  • Benefits of Flex ASM
7
Preparing for Oracle 12c Grid Infrastructure Installation
  • Verifying System Requirements
  • Configuring the Network
  • Preparing the Operating System
  • Configuring Users & Groups
  • Configuring SSH
  • Configuring Installation Directories
  • Configuring Shared Storage
  • Creating Oracle ASM Disks
8
Installing Oracle 12c Grid Infrastructure
  • Verifying installation requirements withCluster Verification Utility
  • Installing the Oracle Grid Infrastructure
  • Verifying Oracle Clusterware Installation
9
Installing & Creating Oracle 12c RAC Database
  • Creating required directories
  • Installing Oracle 12c and Creating RACdatabase
  • Verifying RAC Database Creation
10
Administering Oracle Clusterware
  • Purpose of Oracle Clusterware (OCW)
  • OCW Services & Processes
  • OCW Resources
  • Local & Cluster resources
  • Understanding OCW Process Startup
  • Managing Oracle Clusterware using CRSCTL & SRVCTL commands
  • Starting & Stopping OCW
  • Enabling & Disabling OCW
  • Purpose of OCR & Voting Disks
  • Managing OCR & Voting Disks
  • OCRCHECK, OCRCONFIG,OCRDUMP
  • Adding/Removing OCR Locations & Voting Disks
  • Backup of OCR & Voting Disks
  • Oracle Local Registry (OLR)
  • Managing OLR
11
Administering Oracle 12c Flex Clusters
.
  • Verifying Oracle Cluster mode
  • Listing node roles
  • Verifying ASM Cluster mode
  • Listing ASM Instances & Listeners
  • Testing ASM failure in Flex Cluster
12
Oracle Clusterware Diagnostic & AlertLog data
  • ADR Directory Structure &ADRCI
  • Oracle clusterware trace files and AlertLog file
  • Normal trace files & Incident Trace files
  • Collecting Oracle Clusterware
  • Diagnostic data
  • Diagnostics Collection Script
13
Cluster Health Monitor(CHM)
  • Overview of monitoring Oracle Clusterware
  • Cluster Health Monitor (CHM)
  • Oracle 12c Grid Infrastructure Management Repository (GIMR)
  • Collecting CHM data
  • Managing CHM with OCLUMON
14
Using Cluster Verification Utility(CVU)
  • About Cluster Verification Utility
  • CVU command format & usage
  • Using CVU for stage verification
  • Using CVU to check cluster components
15
Administering ASM Instances
  • Initialization Parameters for ASM Instances
  • Parameter Files for ASM Instances
  • Managing ASM Instance parameters
  • Shared Oracle ASM Password File in aDisk group
  • Starting & Stopping ASM Instances
16
 Administering ASM Disk Groups
  • Managing ASM Disk Groups with
  • ASMCA& SQL Commands
  • Creating Disk groups
  • Altering Disk groups
  • Adding & Removing Disks
  • Mounting & Dismounting Disk Groups
  • Dropping Disk Groups
  • ASM Failure Groups
17
Administering ASM Directories & Files
  • ASM Directory structure
  • Managing ASM Directories
  • ASM Files
  • Fully Qualified File Names
  • Alias File Names
  • Incomplete File Names
18
ASM Command-Line Utility (ASMCMD)
  • Types of ASMCMD commands
  • Running ASMCMD in Interactive mode
  • Running ASMCMD in Non-Interactive mode
19
Oracle RAC Architecture
  • Instance in RAC
  • Single Instance DB Vs RAC DB
  • RAC specific Background processes
  • Global Resources in RAC
  • GCS, GES, GRD
  • Cache Fusion in RAC
20
Administering RAC Instances & Database
  • Overview of RAC DB Administration
  • Starting and Stopping RAC Instances and Databases
  • Terminating Sessions in RAC
  • Initialization Parameters in RAC
  • Data Dictionary in RAC
  • Files in RAC
  • Archiving in RAC
  • Client connections in RAC
21
Backup & Recovery in RAC
  • Configuring RMAN Snapshot Control
  • File location
  • Configuring Control File &SPFILE auto backups
  • Configuring Channel connections inRAC
  • Instance Recovery in RAC
  • Media Recovery in RAC
  • Parallel Recovery in RAC
22
Workload Management with Services
  • Introduction to Oracle Services
  • Default Services
  • Creating Services
  • Preferred & Available Instances
  • Administering Services
  • Using Services with Client Applications
  • Transparent Application Failover (TAF)
  • TAF with Client-side configuration
  • TAF with Services
23
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
24
Converting Single Instance Database toRAC Database

 

  • Overview of different Methods/Tools
  • About rconfig utility
  • Preparing XML file
  • Converting to RAC using rconfig
  • Verifying the conversion
25
Patching RAC Environments
  • Patchset, Bundle Patch, One-Off Patch, Patchset Updates
  • Rolling Patches, OPatch Utility
  • Downloading &Analyzing Patches
  • Installing RAC Patches in Rolling fashion
  • Verifying Patch Application