What You’ll Learn
This course is designed for Oracle Clusterware architecture and General ASM Concept, RAC database
and Basic Data guard ,After completing this course, students will be able to carry out:
Installation of Clusterware and RAC database, Grid Infrastructure pre-installation
tasks, Patching and Upgrading existing Grid Home and Dataguard installation and administration and
General Troubleshooting Concept of Clusterware and RAC database and Basic Performance Tuning
Oracle Database Advance Course Details
Oracle RAC Link
Oracle RAC Oracle RAC Database Oracle DBA certification Path
Oracle Clusterware/RAC
- Introduction of Clusterware and Terminology
- Advantage of RAC database
- RAC Database Configuration
- OCR,Voting Disk,VIP and Interconnect and GPNP Profile
- Oracle Clusterware and Database HOME Installation
- SCAN Concepts,GRD,GCS,GES, Cache Fusion
- Clusterware Startup sequence
- Load Balancing and Failover and TAF
- Node Eviction
- Basic RAC Command
- RAC Performance Tuning, RAC Wait Events
- Space Addition in ASM
- Clusterware/Grid and RAC Database Patching
- Basic Troubleshooting and log files location
- TFA, OSWatcher, ORACHK With Lab Session
- Difference Between 12c & 19c Clusterware/RAC/ASM Features.
DataGuard
- DataGuard Overview
- Types of Standby Databases
- Types of Data Guard Services
- DataGuard Background Processes
- Data Protection Mode
- Standby Setup Overview
- Role Transition: Switchover and Failover
- Detail Active Data Guard
- Basic Command for Monitoring
- DataGuard Broker
Oracle ASM
- ASM Overview
- Asm Disk and Disk Group and redundancy
- Basic Command for ASM
Database Performance Tuning
- Performance Tuning Overview
- Oracle Database Internal
- Oracle Memory Evaluation from 9i to 12c
- Oracle Database Wait Event
- ASH and ADDM Analysis
- Oracle Memory Tuning/Instance Tuning
Understanding SQL Tuning Tools
(Explain Plan ,Trace and TKPROF - AWR Interpretation and Analysis with Real Time Scenarios