Top Oracle RAC Interview Questions (2024)
What is Oracle RAC?
What advantages does Oracle RAC provide?
What are the requirements for installing Oracle RAC?
How do distributed transactions get handled by Oracle RAC?
What does the Oracle Grid Infrastructure do?
What distinguishes Oracle RAC from Oracle Clusterware?
How is load balancing handled by Oracle RAC?
What does the Oracle Cluster Registry (OCR) do?
What is the difference between Oracle RAC active-active and Oracle RAC active-passive configurations?
What is the Cluster Verification Utility's (CVU) primary use?
What role does the Oracle RAC SCAN listener provide?
How is backup and recovery handled by Oracle RAC?
What does the Oracle Clusterware voting disk do?
How is automatic failover handled by Oracle RAC?
Q: What is Oracle RAC?
Ans:
Oracle Real Application Clusters is referred to as Oracle RAC. It is a database clustering solution that offers high availability and scalability by enabling several instances to access a single database concurrently.
Q: What advantages does Oracle RAC provide?
Ans:
Oracle RAC enables many instances to access a single database, resulting in high availability and scalability. Additionally, it offers failover, load balancing, and automatic node recovery.
Q: What are the requirements for installing Oracle RAC?
Ans:
A shared storage system, like a storage area network (SAN), network file system (NFS), or clustered file system, is required prior to implementing Oracle RAC. In order to connect the nodes, a private network is also required.
Q: How do distributed transactions get handled by Oracle RAC?
Ans:
To manage distributed transactions, Oracle RAC utilizes a distributed locking system. The locks are managed independently by each instance and are coordinated via the interconnect.
Checkout our related posts :
Q: What does the Oracle Grid Infrastructure do?
Ans:
For the implementation of Oracle RAC, a number of services are provided by the Oracle Grid Infrastructure. It consists of the Oracle Automatic Storage Management (ASM) and Oracle Clusterware software.
Q: What distinguishes Oracle RAC from Oracle Clusterware?
Ans:
The infrastructure for Oracle RAC is provided by clustering software of Oracle Clusterware. In addition Oracle Clusterware provide high availability services like automated failover, it maintains the cluster resources. Where as Oracle RAC uses database clustering technique which enables multiple instances to access a single database.
Q: How is load balancing handled by Oracle RAC?
Ans:
Load balancing is provided by Oracle RAC by dividing the workload among all of the available instances. The workload is distributed according to load balancing mechanism set up in the cluster.
Q: What does the Oracle Cluster Registry (OCR) do?
Ans:
Information about cluster configuration is kept in the Oracle Cluster Registry (OCR). It is a shared file that is used to keep data on the cluster's resources and services.
Q: What is the difference between Oracle RAC active-active and RAC active-passive
configurations?
Ans:
All instances are actively handling user requests in an active-active arrangement. One instance is active and handling user requests in an active-passive setup, while the other instances are passive and prepared to take over in the event of a failure.
Q: What is the Cluster Verification Utility's (CVU) primary use?
Ans:
Before and after installing Oracle RAC, the cluster's readiness is checked using the Cluster Verification Utility (CVU). It looks for configuration errors or possible difficulties and makes suggestions for fixing them.
Q: What role does the Oracle RAC SCAN listener provide?
Ans:
Clients can connect to the database using a single name provided by the SCAN listener. Clients can connect to the SCAN listener, which will route the connection to the proper node, as rather than connecting to each individual node listener.
Q: How is backup and recovery handled by Oracle RAC?
Ans:
The Oracle Recovery Manager (RMAN) and the Oracle Data Guard are just two of the backup and recovery options offered by Oracle RAC. The entire database can be backed up using RMAN, and a standby database for disaster recovery can be built using Data Guard.
Q: What does the Oracle Clusterware voting disk do?
Ans:
Data about cluster membership is kept on the Oracle Clusterware voting disk. It is a shared disk which is used to keep track of the cluster's state.
Q: How is automatic failover handled by Oracle RAC?
Ans:
By using Oracle Clusterware to keep monitoring on the nodes and resources in the cluster, Oracle RAC offers automatic failover. Oracle Clusterware automatically switches to another node in the event that a node or resource fails.