Backend interview prep

Start

Oracle RAC Interview Questions

Master Oracle RAC (Real Application Clusters) with interview-focused questions covering RAC Architecture, Clusterware, Cache Fusion, SCAN Listener, Shared Storage, GCS, GES, Load Balancing, Failover, High Availability, Rolling Patching, and enterprise production best practices.

Introduction

Oracle RAC (Real Application Clusters) is Oracle's flagship High Availability (HA) and Scalability solution.

Unlike a traditional Oracle database running on a single server, Oracle RAC allows multiple database servers (nodes) to access the same database simultaneously.

Oracle RAC provides

  • High Availability
  • Horizontal Scalability
  • Fault Tolerance
  • Load Balancing
  • Continuous Availability

It is widely used in

  • Banking
  • Financial Services
  • Telecommunications
  • Government
  • Healthcare
  • ERP Systems

Oracle RAC Architecture

flowchart TD

Application --> ScanListener["SCAN Listener"]

ScanListener["SCAN Listener"] --> Node1

ScanListener["SCAN Listener"] --> Node2

ScanListener["SCAN Listener"] --> Node3

Node1 --> SharedStorage

Node2 --> SharedStorage

Node3 --> SharedStorage

Node1

<--> CacheFusion

Node2

Node2

<--> CacheFusion

Node3

Node1

<--> CacheFusion

Node3

1. What is Oracle RAC?

Answer

Oracle RAC (Real Application Clusters) allows multiple Oracle database instances running on different servers to access a single shared database.

Benefits

  • High Availability
  • Load Balancing
  • Scalability
  • Disaster Tolerance

2. Why is Oracle RAC used?

Without RAC

Server Failure

↓

Application Down

With RAC

One Node Fails

↓

Other Nodes Continue

↓

No Downtime

3. What are the major RAC components?

Oracle RAC consists of

  • Multiple Database Nodes
  • Shared Storage
  • Oracle Clusterware
  • Oracle Instances
  • SCAN Listener
  • Cache Fusion

RAC Components

Oracle RAC

├── Node 1
├── Node 2
├── Node 3
├── Shared Storage
├── Clusterware
└── SCAN Listener

4. What is an Oracle RAC Node?

A Node is an individual server participating in the RAC cluster.

Each node has

  • CPU
  • Memory
  • Oracle Instance

All nodes access the same database.

5. How many instances exist in RAC?

Each node has its own Oracle Instance.

Example

Node1

↓

Instance1

Node2

↓

Instance2

Node3

↓

Instance3

All instances access the same database.

6. What is Shared Storage?

Shared Storage contains

  • Data Files
  • Control Files
  • Redo Logs (or shared storage layout depending on configuration)
  • Archived Logs

Every RAC node accesses the same database files.

Common storage

  • ASM
  • SAN
  • NAS

Shared Storage

flowchart LR

Instance1 --> ASM

Instance2 --> ASM

Instance3 --> ASM

ASM --> DatabaseFiles

7. What is Oracle ASM?

ASM (Automatic Storage Management) is Oracle's storage management layer.

Benefits

  • Disk Striping
  • Mirroring
  • Automatic Rebalancing
  • Simplified Storage Administration

8. What is Oracle Clusterware?

Oracle Clusterware manages

  • Cluster Membership
  • Node Communication
  • Resource Monitoring
  • Failover
  • Node Recovery

Clusterware is mandatory for RAC.

9. What is Cache Fusion?

Cache Fusion allows Oracle RAC instances to share modified database blocks directly through the cluster interconnect without writing them to disk first.

Benefits

  • Lower Disk IO
  • Faster Data Sharing
  • High Performance

Cache Fusion

flowchart LR

Instance1

<--> ClusterInterconnect

<--> Instance2

10. Why is Cache Fusion important?

Without Cache Fusion

Disk

↓

Read

↓

Slow

With Cache Fusion

Memory

↓

Direct Transfer

↓

Fast

11. What is Cluster Interconnect?

A private high-speed network connecting RAC nodes.

Used for

  • Cache Fusion
  • Heartbeats
  • Cluster Communication

Low latency is essential.

12. What is SCAN Listener?

SCAN

Single Client Access Name

provides one hostname for client connections.

Clients connect to SCAN instead of individual nodes.

SCAN Architecture

flowchart LR

Application --> SCAN

SCAN --> Node1

SCAN --> Node2

SCAN --> Node3

13. What are the benefits of SCAN?

  • Simplified Client Configuration
  • Automatic Load Balancing
  • Easier Node Expansion
  • Transparent Failover

14. What is Load Balancing?

Incoming sessions are distributed across RAC nodes.

Benefits

  • Better CPU Utilization
  • Higher Throughput
  • Lower Response Time

15. What is Failover?

If one RAC node fails,

active and new sessions continue on surviving nodes.

Application availability is maintained.

Load Balancing vs Failover

Load Balancing Failover
Distributes Load Handles Failures
Performance Availability

16. What is High Availability?

High Availability minimizes downtime by ensuring services continue despite failures.

Oracle RAC is a High Availability solution.

17. What is GCS?

GCS

Global Cache Service

manages

shared data blocks

between RAC instances.

Works closely with Cache Fusion.

18. What is GES?

GES

Global Enqueue Service

coordinates distributed locking across RAC nodes.

Ensures data consistency.

GCS and GES

flowchart LR

GCS --> CacheManagement

GES --> LockManagement

19. What happens if a node crashes?

Clusterware detects the failure.

Steps

Heartbeat Lost

↓

Node Evicted

↓

Services Relocated

↓

Applications Continue

20. What is Node Eviction?

A failed or unresponsive node is removed from the cluster to protect data consistency.

Remaining nodes continue processing.

21. What is Rolling Patching?

Oracle RAC allows patching one node at a time.

Benefits

  • Minimal Downtime
  • Continuous Service
  • Easier Maintenance

22. Can Oracle RAC scale horizontally?

Yes.

New nodes can be added to increase

  • CPU
  • Memory
  • Processing Capacity

without redesigning the application.

23. Oracle RAC vs Single Instance

Oracle RAC Single Instance
Multiple Nodes One Server
High Availability Single Point of Failure
Load Balancing No
Horizontal Scaling Limited

24. Oracle RAC vs Data Guard

RAC Data Guard
High Availability Disaster Recovery
Active Cluster Standby Database
Same Site or Metro Often Remote Site
Shared Database Separate Database

25. Banking Example

Online Banking

↓

3 RAC Nodes

↓

Shared Database

↓

One node fails

↓

Transactions continue

26. Airline Reservation Example

Thousands of bookings

↓

RAC Load Balancing

↓

High Throughput

↓

No Single Server Bottleneck

27. E-Commerce Example

Black Friday

↓

Millions of Orders

↓

Additional RAC Nodes

↓

Application Remains Responsive

28. Production Failure Example

Node Failure

↓

Clusterware Detects Failure

↓

Connections Redirected

↓

No Database Recovery Required

↓

Users Continue Working

29. Common RAC Interview Questions

  • What is Oracle RAC?
  • RAC vs Single Instance.
  • RAC vs Data Guard.
  • Explain Cache Fusion.
  • What is SCAN?
  • Explain Clusterware.
  • GCS vs GES.
  • What is ASM?
  • What happens when a node fails?
  • Explain Rolling Patching.

Oracle RAC Workflow

flowchart LR

Client --> SCAN --> Clusterware --> AvailableNode --> OracleInstance --> SharedStorage

Enterprise Best Practices

  • Use Oracle ASM for shared storage.
  • Configure redundant Cluster Interconnects.
  • Monitor Cache Fusion performance.
  • Use SCAN for all client connections.
  • Regularly test node failover.
  • Keep Clusterware patched.
  • Monitor GCS and GES wait events.
  • Perform rolling patching whenever possible.
  • Separate public and private network traffic.
  • Continuously monitor cluster health.

Quick Revision

Topic Key Point
Oracle RAC Multi-Instance Oracle
Node RAC Server
Shared Storage Common Database Files
ASM Storage Management
Clusterware Cluster Management
Cache Fusion Memory-to-Memory Block Sharing
SCAN Single Client Access Name
Cluster Interconnect Private RAC Network
GCS Global Cache Service
GES Global Enqueue Service
Load Balancing Distribute Sessions
Failover Continue After Node Failure
Rolling Patching Patch Without Full Downtime

Interview Tips

Interviewers frequently ask

  • What is Oracle RAC?
  • RAC vs Single Instance.
  • RAC vs Data Guard.
  • Explain Cache Fusion.
  • What is SCAN Listener?
  • Explain Oracle Clusterware.
  • What is ASM?
  • GCS vs GES.
  • What happens if a RAC node fails?
  • Why is RAC used in banking systems?

A strong interview explanation is:

"Oracle RAC enables multiple Oracle instances running on different servers to access the same database stored on shared storage. Clusterware manages the cluster, ASM manages storage, SCAN simplifies client connectivity, and Cache Fusion allows database blocks to be shared directly between instances through the cluster interconnect. This architecture provides high availability, load balancing, and horizontal scalability while minimizing downtime."

Summary

Oracle RAC is Oracle's enterprise clustering solution for achieving high availability, fault tolerance, and horizontal scalability. Technologies such as ASM, Clusterware, Cache Fusion, SCAN Listener, GCS, and GES enable multiple database instances to operate on a shared database while maintaining consistency and performance.

Understanding RAC architecture, cluster communication, shared storage, failover mechanisms, and rolling maintenance is essential for Oracle DBAs, Database Engineers, Performance Engineers, and Solution Architects designing mission-critical enterprise systems.