March 5, 2023

Top 60 Oracle RAC Interview Questions Part3 [2023]

Oracle RAC DBA Interview Questions/FAQs Part3

41. What is HAS (High Availability Service) and the commands?
Answer:
HAS includes ASM & database instances and listeners.
crsctl check has
crsctl config has
crsctl disable has
crsctl enable has
crsctl query has releaseversion
crsctl query has softwareversion
crsctl start has
crsctl stop has [-f]

42. How many nodes are supported in a RAC Database?

Answer:
Oracle RAC 10g Release 2 onwards, support 100 nodes in a cluster using Oracle Clusterware, and 100 instances in a RAC database.

43. What is IO fencing?

Answer:
I/O fencing prevents updates by failed instances, and detecting failure and preventing split brain in the cluster. When a cluster node fails, the failed node needs to be fenced off from all the shared disk devices or diskgroups. This methodology is called I/O Fencing, sometimes called Disk Fencing or failure fencing.

44. Why is Clusterware installed in the root user (why not in the oracle user)?

Answer:

45. What are the wait events in RAC?

Answer:
http://satya-racdba.blogspot.com/2012/10/wait-events-in-oracle-rac-wait-events.html

gc buffer busy
gc buffer busy acquire
gc current request 
gc cr request
gc cr failure 
gc current block lost
gc cr block lost
gc current block corrupt
gc cr block corrupt
gc current block busy
gc cr block busy
gc current block congested
gc cr block congested.
gc current block 2-way
gc cr block 2-way
gc current block 3-way
gc cr block 3-way
(even if we have n number of nodes, there can be only 3-way wait event)
gc current grant 2-way
gc cr grant 2-way
gc current grant busy
gc current grant congested
gc cr grant congested
gc cr multi block read
gc current multi block request
gc cr multi block request
gc cr block build time
gc current block flush time
gc cr block flush time
gc current block send time
gc cr block send time
gc current block pin time
gc domain validation 
gc current retry
ges inquiry response
gcs log flush sync

46. What is the difference between cr block and cur (current) block?

Answer:

47. What are the initialization parameters that must have the same value for every instance in an Oracle RAC database?

Answer:
http://satya-racdba.blogspot.com/2012/09/init-parameters-in-oracle-rac.html

ACTIVE_INSTANCE_COUNT
ARCHIVE_LAG_TARGET
COMPATIBLE
CLUSTER_DATABASE
CLUSTER_DATABASE_INSTANCE
CONTROL_FILES
DB_BLOCK_SIZE
DB_DOMAIN
DB_FILES
DB_NAME
DB_RECOVERY_FILE_DEST
DB_RECOVERY_FILE_DEST_SIZE
DB_UNIQUE_NAME
INSTANCE_TYPE
PARALLEL_MAX_SERVERS
REMOTE_LOGIN_PASSWORD_FILE
UNDO_MANAGEMENT

48. What were the new features in Oracle RAC 12c?

Answer:
http://satya-racdba.blogspot.com/2012/10/new-features-in-oracle-rac-12c.html

49. How is the Cluster Health Monitor is different from OSWatcher?
Answer:

50. Why do we need user equivalency? What happens if we remove it between nodes 3,5 in a production of 6 node RAC cluster?
Answer:

51. What is the purpose of OLR?
Answer:
With the OCR files being placed in ASM and accessible only when the cluster processes have started up and ASM instance is up and running. However, without the OCR file the Clusterware processes cannot startup.

To resolve this, a copy of the Oracle Local Registry(OLR) registry is now created on each node during the initial installation which stores node-specific information and allows us to get around the problem.

Oracle Local Registry (OLR) 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.

OLR stores the information on the Clusterware configuration, version information, and GpnP wallets.
OHASD process mostly manages this file.

52. What is the difference is between relocating the SCAN using srvctl relocate scan and SCAN_LISTENER by using srvctl relocate scan_listener command?
Answer:

53. What is the difference between Crash recovery and Instance recovery?
Answer:
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.

54. Why is the interconnect used for?
Answer:
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.

55. How do you determine what protocol is being used for Interconnect traffic?
Answer:
One of the ways is to look at the database alert log for the time period when the database was started up.

56. What files components in RAC must reside on shared storage?
Answer:
Spfiles, ControlFiles, Datafiles and Redolog files should be created on shared storage.

57. What is the difference between SRVCTL and CRSCTL utilities?
Answer:
Differences between srvctl and crsctl in Oracle RAC

58. What is the difference between locks, latches, enqueues and semaphores in Oracle?
Answer:

59. What is the use of RACcheck utility?
Answer:

Related Oracle RAC Articles: Oracle RAC Interview Questions Part1 Oracle GoldenGate Interview Questions/FAQs   Oracle RMAN Interview Questions/FAQs


1 comment: