Title of the Course: Oracle RAC
Brief Description: This course provides in-depth knowledge of Oracle Real Application Clusters (RAC), focusing on high availability, scalability, and clustering of Oracle databases. Learners will explore RAC architecture, installation, configuration, administration, and troubleshooting in multi-node environments, ensuring business continuity through failover and load balancing.
Skill Level: Novice->Intermediate->Proficient->Advanced->Expert
Duration: 3 to 4 Weeks
Format: Self-paced / Live Online / In-person / Hybrid
Estimated Time: 3 to 4 weeks
Target Role: Advanced DBA / Production DBA
Goal: Be able to install, configure, and manage Oracle RAC
Environment: Oracle 19c or 21c, VirtualBox or OCI (Oracle Cloud)
| Topic | What to Learn |
|---|---|
| What is Oracle RAC? | RAC vs single instance DB |
| RAC Architecture | Cache Fusion, SCAN, VIP, CRS |
| Oracle Grid Infrastructure | Clusterware + ASM |
| Components of RAC | OCR, Voting Disk, GNS, networks (Private/Public) |
| Licensing & RAC Versions | RAC on SE2 (2-node), EE |
| Task | How to Practice |
|---|---|
| Setup 2 VMs with Linux (OL7/OL8) | Use VirtualBox or VMware |
| Configure network interfaces | Public, private, and virtual |
| Setup shared storage (via ASM or iSCSI) | Simulate shared disks |
| Install Oracle Grid Infrastructure | Cluster-ready nodes |
| Use clufy, runcluvfy.sh | Cluster verification utility |
cluvfy, oifcfg, srvctl, crsctl, asmca, netca
| Task | What to Do |
|---|---|
| Install Oracle RAC Database Software | Run on shared Grid home |
| Create RAC Database with DBCA | Use multi-node wizard |
| Configure SCAN, VIP, GNS | Test with ping and listeners |
| Validate Interconnect & Load Balancing | Use srvctl, lsnrctl |
| Practice RAC startup/shutdown | srvctl stop/start database |
| Topic | Tasks to Perform |
|---|---|
| Add/Remove nodes (theory + lab) | Practice addNode.sh, root.sh |
| Workload Management | Configure services with srvctl |
| SCAN Listener Tuning | Use srvctl, test failover |
| RAC Performance Monitoring | Use GV$ views, AWR, ADDM |
| Troubleshooting RAC | Log files, alert.log, crsd.log, diag |
| Patch RAC environment (OPatch) | Apply patch in rolling mode |
| Certification | Code | Focus |
|---|---|---|
| Oracle RAC and Grid Infrastructure | 1Z0-068 | RAC, ASM, Clusterware |
| Project | Skills Practiced |
|---|---|
| Build 2-node RAC in VirtualBox | Installation, config |
| Create 2 services for RAC DB | Load balancing |
| Simulate node failure | Observe failover |
| Patch one node (rolling patch) | Rolling upgrade |
| Setup Oracle RAC with ASM | Shared disk practice |
What will the learner be able to do after this course?
After completing the Oracle RAC course, the learner will be able to deploy and manage Oracle Real Application Clusters to provide high availability and scalability for enterprise applications. For example, in an e-commerce application experiencing heavy user traffic, they can configure a 2-node RAC database to distribute the load across multiple servers. If one node fails, the application continues to run seamlessly on the remaining node, ensuring zero downtime and optimal performance.
The instructor is a seasoned Oracle Database Administrator with over 12 years of hands-on experience specializing in Oracle SQL, Administration I & II, ASM, RAC, Data Guard, GoldenGate, and Exadata technologies. He holds multiple Oracle certifications, including OCA, OCP, Oracle RAC and Grid Infrastructure Administrator, Oracle Data Guard Expert, Oracle GoldenGate 12c/19c Implementation Specialist, and Oracle Exadata X9M/X10M Implementation Specialist.
He has successfully designed and managed large-scale, mission-critical database environments for several Fortune 500 companies, including TCS, IBM, Accenture, Capgemini, and Cognizant. His real-world expertise in high availability, disaster recovery, performance tuning, and database migration ensures that learners gain industry-relevant, project-based skills that align with current enterprise demands.
Take control of your data with industry-leading database technologies. Whether you're starting with SQL or diving into advanced tools like Oracle RAC, Goldengate, or Exadata our hands-on training will help you build a rock-solid foundation in database management and optimization.