Oracle RAC Interview Questions and Answers for Experienced - 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.
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.
Give the steps to install and configure RAC.
Following are the steps to install and configure RAC.
Install operating system drivers
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
Perform sanity checks
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.
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.
- Oracle DBA RAC Interview Questions and Answers
- Oracle RAC Interview Questions and Answers for Experienced
- Oracle Database 11g Architecture Interview Questions and Answers Pdf
- Oracle DBA Scenario Based Interview Questions and Answers
- Senior Oracle DBA Interview Questions and Answers for Experienced
- Oracle Developer Interview Questions and Answers for Experienced
7000+ TNPSC Group 1, 2, 4, VAO Indian Economy Study Materials Pdf More
7000+ Gate Computer Science Engineering Previous Year Questions More
7000+ Fill in the Blanks with Suitable Homonyms More
7000+ Fill in the Blanks with Suitable Homophones More
Power Semiconductor Device and Integrated Circuits MCQ Questions Pdf More
TNPSC Zoology Online Test in Tamil and English 2019-2020 More
PG TRB Model Question Paper for Physics with Answer More
1000+ ECE Viva Questions and Answers Pdf More
Vedic Age Objective Questions and Answers More
1000+ TNPSC Aptitude Questions with Solutions More