The SCM0 background process in Oracle RAC (Real Application Clusters) is a component of the Oracle Clusterware and is responsible for managing the shared resources…
Leave a CommentCategory: RAC
Q: What is Oracle RAC and what benefits does it offer? Ans: Oracle RAC (Real Application Clusters) is a cluster database technology that allows multiple…
Leave a CommentSome of the good Real Applications Cluster (RAC) interview questions:
Q 1. How to setup SCAN in 11gr2 and how it works?
SCAN is a single name defined in DNS that resolves to three IP addresses using a round-robin algorithm. The three IP addresses are on the same subnet as RAC’s default public network in the cluster.
4 Comments
After creating 11g R2 RAC database for the EBS R12, we wanted to enable multiplexing for the control files. Oracle recommends multiplexing the control files . We are using ASM for the storage of control files.
At the time of creating the database by dbca we can do multiplexing or we can also do later manually as described below.
Goal:- We have control file in the +DATA disk group and we want to also keep it in another disk group +OCR_VOTE for multiplexing.
Some useful RAC 11G commands are documented below. STOP SEQUENCE COMMAND DESCRIPTION —————————————————————————————— srvctl stop database -d ORCL STOP DATABASE srvctl stop instance -d ORCL…
14 CommentsFigure 1 SCAN is new Oracle Real Application Clusters (RAC) 11gR2 feature. It gives a single name for clients to access oracle database running in…
3 Comments