Oracle RAC is widely adopted by organizations that require highly available and scalable database solutions. This Oracle Rac interview questions blog is tailored according to the industry's needs and provides you with targeted information on what to expect during the interview process. This can be specifically helpful for Oracle Rac-related roles requiring knowledge of the technology and practices. Also, these questions are useful for both freshers and experienced professionals as well.
If you're looking for Oracle RAC Interview Questions for Experienced or Freshers, you are at the right place. There are a lot of opportunities from many reputed companies in the world. According to research, Oracle RAC has a market share of about 1.0%. So, You still have the opportunity to move ahead in your career in Oracle RAC Development. Mindmajix offers Advanced Oracle RAC Interview Questions 2024 that help you in cracking your interview & acquire a dream career as an Oracle RAC Developer.
Ans:
RAC | GRID |
Single system image available | No single system image |
Proprietary interoperability with VIA | No standards available |
Single ownership | Multiple Ownerships |
Discoverable membership services | Central Index and decentral information to discover |
Moderate throughput | Either too high or too low throughput |
Guarantees capacity | High capacity, varies sometimes |
Most commodity computers | Commodity and High-end computers |
Centralized user management | Distributed user management |
Centralized resource management | Distributed resource management |
Central allocation and scheduling | DecentraliDistributed allocation and scheduling |
Ans: 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).
If you would like to Enrich your career and get certified professional, then enroll in our “Oracle RAC Online Training” - This course will help you to achieve excellence in this domain. |
Ans: When database nodes in a cluster are unable to communicate with each other, they may continue to process and modify the data blocks independently. If the same block is modified by more than one instance, synchronization/locking of the data blocks does not take place and blocks may be overwritten by others in the cluster. This state is called split brain.
Ans: When an instance crashes in a single node database on startup a crash recovery takes place. In a RAC environment, the same recovery for an instance is performed by the surviving nodes called Instance recovery.
Ans: It is a private network that is used to ship data blocks from one instance to another for cache fusion. The physical data blocks, as well as data dictionary blocks, are shared across this interconnect.
Ans: One of the ways is to look at the database alert log for the time period when the database was started.
Related Article: Oracle RAC Tutorial for Beginners |
Ans: Either the Network Time Protocol(NTP) can be configured or in 11gr2, Cluster Time Synchronization Service (CTSS) can be used.
Ans: Spfiles, ControlFiles, Datafiles, and Redolog files should be created on shared storage.
Ans: The network ping failure is written in $CRS_HOME/log
Ans: The OCR config - shows backup can be run to find out the automatic and manually run backups.
Ans: You can use either the logical or the physical OCR backup copy to restore the Repository.
Ans: You can use the dba_hist_seg_stats.
Ans: 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.
Ans: You can query the V$ACTIVE_INSTANCES view to determine the member instances of the RAC cluster.
Ans: 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.
Ans: All processing will show down to the CPU speed of the slowest server.
Ans: Oracle Local repository contains information that allows the cluster processes to be started up with the OCR being in the ASM storage system. Since the ASM file system is unavailable until the Grid processes are started up a local copy of the contents of the OCR is required which is stored in the OLR.
Ans: In 10g the default SGA size is 1G in 11g it is set to 256M and in 12c ASM it is set back to 1G.
Related Article: Overview of Oracle RAC Resource Mastering |
Ans: You can use md_backup to restore the ASM disk group configuration in case of ASM disk group storage loss.
Ans: In 11g the following files can be stored in ASM disk groups.
In 12c the files below can also now be stored in the ASM Diskgroup
Ans: This is the parameter that controls the number of Allocation units the ASM instance will try to rebalance at any given time. In ASM versions less than 11.2.0.3 the default value is 11 however it has been changed to unlimited in later versions.
Ans: A patch is considered rolling if it is can be applied to the cluster binaries without having to shut down the database in a RAC environment. All nodes in the cluster are patched in a rolling manner, one by one, with only the node which is being patched unavailable while all other instances open.
Ans: Some of the RAC parameters are:
Ans: The Grid software is becoming more and more capable of not just supporting HA for Oracle Databases but also other applications including Oracle’s applications. With 12c there are more features and functionality built-in and it is easier to deploy these pre-built solutions, available for common Oracle applications.
Ans: The backups should include OLR, OCR, and ASM Metadata.
Ans: You can run the OPATCH LSINVENTORY -ALL_NODES command from a single node to look at the inventory details for all nodes in the cluster.
Explore Oracle CRM Sample Resumes! Download & Edit, Get Noticed by Top Employers!
Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:
Name | Dates | |
---|---|---|
Oracle RAC Training | Dec 07 to Dec 22 | View Details |
Oracle RAC Training | Dec 10 to Dec 25 | View Details |
Oracle RAC Training | Dec 14 to Dec 29 | View Details |
Oracle RAC Training | Dec 17 to Jan 01 | View Details |
Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.