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. What Is A Crs Resource?
Oracle Clusterware is used to manage high-availability operations in a cluster. Anything that Oracle Clusterware manages is known as a CRS resource. Some examples of CRS resources are database, an instance, a service, a listener, a VIP address, an application process etc.
Question 3. What Kind Of Storage We Can Use For The Rac Database Storage?
- OCFS (Release 1 or 2)
- raw devices
- third party cluster file system such as GPFS or Veritas
Question 4. What Is Oclumon Used For In A Cluster Environment?
The Cluster Health Monitor (CHM) stores operating system metrics in the CHM repository for all nodes in a RAC cluster. It stores information on CPU, memory, process, network and other OS data, This information can later be retrieved and used to troubleshoot and identify any cluster related issues. It is a default component of the 11gr2 grid install. The data is stored in the master repository and replicated to a standby repository on a different node.
Question 5. What Are The File Systems And Volume Management Techniques Used In Oracle Rac?
- The file system and volume management in Oracle RAC should know about the architecture that is being used and it should be aware of the clusters that are involved in it.
- Oracle supports automatic storage management that automates the storing of files and setup the communication in between the databases storage pools.
- Oracle supports the high performance of the input and output of the storage subsystem by providing easy tools to use to maximize it.
- They provide a way to balance the load across the available resources that allows the correct optimization of the file system and volume management.
- Oracle RAC provides dynamic volume manager and it has a file system that contains the information of the cluster file system as well.
- The cluster file system in oracle is called as (OCFS) and it has the connection with the databases that provide raw devices and command line features.
Question 6. What Is A Vip In Rac Use For?
The VIP is an alternate Virtual IP address assigned to each node in a cluster. During a node failure the VIP of the failed node moves to the surviving node and relays to the application that the node has gone down. Without VIP, the application will wait for TCP timeout and then find out that the session is no longer live due to the failure.
Question 7. What Is The Use Of Atomic Control File Memory Service (acms)?
ACMS ensures global updates to System Global Area (SGA) in a RAC set up.
Question 8. Mention How Oracle Flex Asm Works?
Oracle Flex ASM instance when fails on a particular node, then the Oracle Flex ASM instance is passed over to another node in the cluster.
Question 9. What Are The Provisions And Resources Provided In The Oracle’s Cloud Server?
- Oracle’s cloud server provides scalability by adding more servers to a pool when there is a requirement of any processing power or space.
- Provision to pay per hour/use as per the requirement, to, keep the overall cost low and build the functionality on the high-end systems.
- Oracle RAC provides the platform’s architecture as it provides low-cost hardware platform to deliver high quality service and provide more scalability and availability.
- This reduces the administration cost and provides good management techniques and tools to monitor the services.
- This allows the users to build their own infrastructure on the basis of cloud.
Question 10. Explain The Hardware Architecture Used In Oracle Rac?
- The Hardware Architecture of the Oracle RAC clusters provides a shared architecture with the server pools and allows all the storage devices to be shared.
- Hardware Architecture supports different types of storage networks like Network attached storage (NAS), Storage Area Network (SAN) and SCSI disks.
- Hardware architecture is such that it provides appropriate choices for the storage pools and system that provides scalability and flexibility to the overall system.
- The architecture should contain the input and output for the application that need to be developed and then the system can have more scalability.
- Hardware architecture supports more application to be added in the server pool and allows better integration of services.
Question 11. Where Are The Database Software Files Stored On A Rac Environment?
The base software is installed on each node of the cluster and the database storage on the shared disks.
Question 12. What Is Rolling Upgrade?
- Rolling upgrade refers to the software upgrading while database is still functional without bringing the database down for upgrade.
- This is the new feature of Oracle 11g.
Question 13. What Are The Types Of Connection Load-balancing?
There are two types of connection load-balancing: server-side load balancing and client-side load balancing.
Question 14. What Is Required By Oracle Rac Database To Connect To A Network?
- Oracle RAC requires an active connection of the network to the LAN (Local Area Network) so that the database server can be found and connected.
- The database server is further having connections with application servers that store the applications and allow user to transfer their data.
- The connection is required with the server pool so that the transfer of services and applications can be done on demand basis.
- The interconnection between the networks is really important as it has to maintain the overall flow of the pools and the resources.
- Oracle RAC provides support to redundant interconnects relatively and it provides an overall infrastructure solution.
- The load balancing and inter-node messaging can be handled more carefully when the networks or the servers are interconnected to each other.
Question 15. What Is Acfs?
- ACFS provides an Oracle Home shared file system or a general purpose clustered file system on ASM storage.
- It needs ASM Dynamic Volume Manager (ADVM) to communicate to the operating system.
Question 16. Where Are The Cluster Ware Files Stored On A Rac Environment?
The Clusterware is installed on each node (on an Oracle Home) and on the shared disks (the voting disks and the CSR file).
Question 17. What Is Global Services Daemon (gsd)?
- GSD runs on each node and is not an Oracle background process.
- This process performs administrative tasks, such as startup and shutdown, based on the requests from different clients, such as DBCA and enterprise manager.
Question 18. What Is Cache Fusion?
In a RAC environment, it is the combining of data blocks, which are shipped across the interconnect from remote database caches (SGA) to the local node, in order to fulfill the requirements for a transaction (DML, Query of Data Dictionary).
Question 19. What Is The Main Purpose Of Oracle Real Application Clusters (rac)?
- Oracle Real Application (RAC) provides the interaction of executable file with the Oracle database.
- It allows the running of any packaged or custom built application with the Oracle database that is running on a server pool.
- It provides very high level of availability, flexibility and scalability to run the application and store it to the database.
- It creates the database such that if the pool fails then the database is continued to run from the remaining servers and the load can be distributed.
- It makes it easier for the administrator to maintain many servers at the same time by load-balancing techniques and providing provision to add more and more servers when the load increases.
Question 20. What Is Rac Cluster?
RAC cluster is a database with a shared cache architecture that overcomes the limitations of traditional shared nothing and shared disk approaches.
It is a key component of Oracle’s private cloud architecture.
PL/SQL Interview Questions
Oracle DBA Tutorial
Oracle DBA Interview Questions
DB2 Using SQL Tutorial
DB2 Using SQL Interview Questions
RMAN (Recovery Manager) Interview Questions
Oracle MySQL 5.6 Database Administrator Interview Questions
PL/SQL Interview Questions
Oracle Exadata Database Interview Questions
Oracle GoldenGate Interview Questions
Oracle DBA Interview Questions
Oracle DBA Troubleshooting Interview Questions