Interview Questions.

Q1. What Kind Of Storage We Can Use For The Rac Database Storage?

OCFS (Release 1 or 2)

ASM

raw devices

0.33 celebration cluster report machine along with GPFS or Veritas

Q2. What Is Cache Fusion?

In a RAC surroundings, it is the combining of facts blocks, which might be shipped throughout the interconnect from far flung database caches (SGA) to the local node, on the way to satisfy the necessities for a traction (DML, Query of Data Dictionary).

Q3. What Is The Main Purpose Of Oracle Real Application Clusters (rac)?

Oracle Real Application (RAC) provides the interplay of executable report with the Oracle database.

It permits the going for walks of any packaged or custom built software with the Oracle database that is running on a server pool.

It gives very high degree of availability, flexibility and scalability to run the utility and save 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 weight may be allotted.

It makes it easier for the administrator to hold many servers on the identical time by load-balancing techniques and offering provision to feature increasingly more servers whilst the weight will increase.

Q4. What Are The Types Of Connection Load-balancing?

There are  kinds of connection load-balancing: server-side load balancing and patron-aspect load balancing.

Q5. Explain The Hardware Architecture Used In Oracle Rac?

The Hardware Architecture of the Oracle RAC clusters offers a shared architecture with the server pools and allows all the storage gadgets to be shared.

Hardware Architecture helps different types of storage networks like Network attached garage (NAS), Storage Area Network (SAN) and SCSI disks.

Hardware architecture is such that it provides appropriate picks for the storage swimming pools and system that gives scalability and flexibility to the general device.

The structure need to contain the input and output for the software that want to be developed and then the device can have extra scalability.

Hardware structure helps more application to be brought within the server pool and lets in better integration of services.

Q6. Where Are The Cluster Ware Files Stored On A Rac Environment?

The Clusterware is established on every node (on an Oracle Home) and on the shared disks (the voting disks and the CSR file).

Q7. What Is Global Services Daemon (gsd)?

GSD runs on each node and isn't an Oracle background system.

This system performs administrative responsibilities, which includes startup and shutdown, based totally at the requests from exceptional customers, together with DBCA and employer manager.

Q8. What Is A Vip In Rac Use For?

The VIP is an change Virtual IP cope with 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 long past down. Without VIP, the application will watch for TCP timeout after which discover that the consultation is not stay due to the failure.

Q9. What Is A Crs Resource?

Oracle Clusterware is used to manipulate excessive-availability operations in a cluster. Anything that Oracle Clusterware manages is referred to as a CRS resource. Some examples of CRS assets are database, an instance, a carrier, a listener, a VIP deal with, an application process and many others.

Q10. What Is Required By Oracle Rac Database To Connect To A Network?

Oracle RAC calls for an active connection of the community to the LAN (Local Area Network) so that the database server can be determined and connected.

The database server is similarly having connections with application servers that store the applications and allow person to trfer their information.

The connection is required with the server pool in order that the trfer of services and applications can be done on demand basis.

The interconnection among the networks is actually vital as it has to hold the overall waft of the swimming pools and the sources.

Oracle RAC offers aid to redundant interconnects notably and it affords an universal infrastructure solution.

The load balancing and inter-node messaging can be dealt with more cautiously whilst the networks or the servers are interconnected to every other.

Q11. What Is Oclumon Used For In A Cluster Environment?

The Cluster Health Monitor (CHM) stores running device metrics within the CHM repository for all nodes in a RAC cluster. It stores information on CPU, memory, procedure, community and other OS data, This facts can later be retrieved and used to troubleshoot and become aware of any cluster associated troubles. It is a default issue of the 11gr2 grid install. The facts is saved within the master repository and replicated to a standby repository on a specific node.

Q12. What Is Rac Cluster?

RAC cluster is a database with a shared cache architecture that overcomes the constraints of conventional shared not anything and shared disk approaches.

It is a key aspect of Oracle's non-public cloud structure.

Q13. What Is The Use Of Atomic Control File Memory Service (acms)?

ACMS guarantees international updates to System Global Area (SGA) in a RAC installation.

Q14. What Is Rolling Upgrade?

Rolling improve refers back to the software upgrading whilst database continues to be purposeful without bringing the database down for upgrade.

This is the new characteristic of Oracle 11g.

Q15. Mention How Oracle Flex Asm Works?

Oracle Flex ASM instance whilst fails on a selected node, then the Oracle Flex ASM example is surpassed over to any other node inside the cluster.

Q16. What Are The File Systems And Volume Management Techniques Used In Oracle Rac?

The document device and volume management in Oracle RAC must realize approximately the structure this is being used and it should be aware of the clusters which might be concerned in it. 

Oracle helps automated storage control that automates the storing of documents and setup the conversation in between the databases storage swimming pools. 

Oracle supports the excessive overall performance of the input and output of the garage subsystem by providing smooth tools to apply to maximise it.

They offer a way to stability the burden across the available assets that lets in the right optimization of the report device and volume management. 

Oracle RAC provides dynamic quantity manager and it has a document gadget that carries the statistics of the cluster report device as well. 

The cluster file system in oracle is referred to as as (OCFS) and it has the connection with the databases that offer raw devices and command line features.

Q17. What Is Acfs?

ACFS presents an Oracle Home shared record system or a fashionable cause clustered record device on ASM garage.

It desires ASM Dynamic Volume Manager (ADVM) to talk to the operating device.

Q18. List The Background Processes Required For Rac?

The background techniques 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

Q19. Where Are The Database Software Files Stored On A Rac Environment?

The base software program is installed on each node of the cluster and the database storage at the shared disks.