Senior Oracle DBA Interview Questions and Answers for Experienced - 1

Question: 1

List the background processes required for RAC?

The background processes required for RAC are given as follows

ACMS – Atomic Controlfile to Memory Service

LMON – Global Enqueue Service Monitor

LMD – Global Enqueue Service Daemon

LMS – Global Cache Service Process

LCK0 – Instance Enqueue Process

RMSn – Oracle RAC Management Processes

RSMN – Remote Slave Monitor

Question: 2

How is RAC different from non RAC clusters?

A non RAC database has a single node while a RAC database has multiple (at least two) nodes.

The nodes in a RAC set up share storage.

RAC offers failover option while a non RAC database does not offer failover option because it is based on a single node.

Question: 3

What is interconnect network?

An interconnect network is a network between nodes of a cluster.

It uses switches to ensure that only nodes can access this network.

Generally, this is a high speed connection.

Question: 4

What is the benefit of using Virtual IP (VIP)?

Whenever an application uses VIP to connect to a database, it can failover to another available node in case of a failure of one node.

You need to use VIP as the host name in the Transparent Network Substrate (TNS) entry to use VIP.

Question: 5

How does RAC ensures data consistency between two nodes?

RAC ensures data consistency between two nodes through cache function.