Oracle RAC Interview Questions and Answers for Experienced - 1

Question: 1

Name some Oracle Clusterware tools and their uses?

Following are several tools to manage Oracle Clusterware:

Cluster Verification Utility (CVU): Verifies various cluster components to detect problems in the environment.

Oracle Enterprise Manager (OEM) : Provides graphic user interface to manage database.

Server Control – Refers to the command line utility to manage database.

Cluster Ready Service Control (CRSCTL) – Refers to a command line tool to manually control Clusterware, such as start and stop Clusterware.

Oracle Interface Configuration (OIFCFG) – Refers to a command line tool to allocate and de-allocate network interfaces to components.

OCR Configuration (OCRCONFIG) – Refers to a command line tool that can be used for OCR administration.

Question: 2

What is the use of RSMN?

RSMN stands for Remote Slave Monitor process.

It creates slave processes on remote instance on behalf of master coordinating process running on another instance.

Question: 3

Give the steps to install and configure RAC.

Following are the steps to install and configure RAC.

Install operating system drivers

Configure ASM

Create ASM disks

Install grid infrastructure

Create additional disk groups as needed

Setup automatic reload of ASM Cluster File System (ACFS) drivers on reboot.

Setup ACFS disk group

Install software

Create database

Perform sanity checks

Question: 4

What is cache fusion?

In a RAC setup, each node has its own memory; however, they share physical datafiles.

As we know that data blocks are read into memory for updates or query in a single instance database.

Similarly, in a RAC set up, a node reads a block from datafile when the node needs it.

However, in RAC setting, the required block may be already available in the memory of another node and it is faster to read block from the memory of another block than from a datafile.

Therefore, RAC provides a mechanism to read block from memory of one node to the memory of another node.

This mechanism is called cache fusion.

Oracle uses high speed interconnect to communicate between nodes. GES monitors and the Instance Enqueue process manages the cache fusion.

Question: 5

What is the use of LMD?

LMD stands for Lock Monitor Daemon process.

This process is used for deadlock detection.

It also manages remote resource and enqueue requests.