Scribd
Upload
22 views2 pages

Oracle RAC Interview Questions Guide

The document contains a comprehensive list of Oracle RAC interview questions categorized into basic, intermediate, advanced, and difficult scenario-based questions. It covers essential topics such as Oracle RAC components, load balancing, Cache Fusion, and node management. The questions aim to assess knowledge on both fundamental concepts and complex scenarios related to Oracle RAC.

Uploaded by

kiruthikkaraja
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
22 views2 pages

Oracle RAC Interview Questions Guide

The document contains a comprehensive list of Oracle RAC interview questions categorized into basic, intermediate, advanced, and difficult scenario-based questions. It covers essential topics such as Oracle RAC components, load balancing, Cache Fusion, and node management. The questions aim to assess knowledge on both fundamental concepts and complex scenarios related to Oracle RAC.

Uploaded by

kiruthikkaraja
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Oracle RAC Interview Questions (Basic to

Advanced)

Basic Oracle RAC Interview Questions


1 What is Oracle RAC?
2 What are the main components of Oracle RAC?
3 What is Oracle Clusterware?
4 What is SCAN (Single Client Access Name)?
5 What is an Oracle Cluster Registry (OCR)?
6 What is the Voting Disk used for?
7 What are the different types of interconnects used in RAC?
8 What is Cache Fusion?
9 What are the advantages of using Oracle RAC?
10 Can a RAC database have different versions on each node?

Intermediate Oracle RAC Interview Questions


1 Explain the difference between a cluster and a grid.
2 How does load balancing work in RAC? (TAF, FAN, SCAN)
3 What is a split-brain situation? How does Oracle RAC prevent it?
4 What are the key background processes in RAC (LMON, LMD, LMS, LCK0)?
5 What is the function of GCS and GES?
6 What is the role of ASM in RAC?
7 How do you add or remove a node in RAC?
8 How can you check cluster health status?
9 How do you configure services in RAC?
10 What are the network requirements for RAC?

Advanced Oracle RAC Interview Questions


1 Explain the Cache Fusion mechanism in detail.
2 What happens when one node fails in RAC?
3 How does Oracle RAC handle deadlocks across instances?
4 What is the difference between instance recovery and crash recovery in RAC?
5 How is redo synchronization managed in RAC?
6 How do you patch a RAC environment with minimal downtime (rolling patching)?
7 What are common causes of RAC performance issues?
8 What is GC (Global Cache) wait event and how do you troubleshoot it?
9 How do you monitor interconnect usage in RAC?
10 How do you migrate a single-instance database to RAC?

Difficult & Scenario-Based Questions


1 Describe the internal working of Cache Fusion and its impact on performance.
2 How does Oracle RAC detect and resolve split-brain at the kernel level?
3 What are the steps in global enqueue conversion and deadlock resolution across instances?
4 Explain the sequence of events during node eviction in Oracle RAC.
5 How do you diagnose and fix a 'gc buffer busy acquire' issue?
6 What happens during reconfiguration after a node joins or leaves the cluster?
7 How would you troubleshoot slow interconnect performance in a multi-node RAC?
8 Describe the process of RAC instance recovery and redo thread synchronization.
9 How do you perform OCR and voting disk recovery after multiple failures?
10 What methods exist to optimize interconnect throughput and minimize block pinging?

You might also like