Oracle RAC DBA Interview Questions
Oracle RAC DBA Interview Questions.
Question
Which daemon is used to ensure the time synchronization between RAC nodes?
Answer
ctssd — Oracle Cluster Time Synchronization daemon
Question
On a rac system, how do you start a database in mount state?
Answer
| $srvctl start database -d <db name> -startoption mount |
Question
Which command is used to see nodes and status briefly on a RAC system?
Answer
| srvctl status database -db <dbname> |
Question
What are the different IPs that should reside in nodes ip config files?
Answer
- private IP
- public IP
- Virtual IP
- Scan IP
Question
How to set the parameter in memory scope?
Answer
| alter system set <parameter name>=<parameter_value> scope=memory; |
Question
What are the different types of redundancies?
Answer
- normal
- External redundancy
Question
When installing oracle rac; which type of redundancy would you select in case you want the redundancy held by disk level?
Answer
external redundancy
Question
What is Oracle RAC one node?
Answer
- It is a single instance of Oracle RAC.
- It makes sure a server is always available for failover.
- It allows you update your apps without downgrade time.
Question
How to Convert a database either to or from an Oracle RAC One Node database.
Answer
| srvctl convert database -db db_unique_name -dbtype RACONENODE [-instance instance_name] [-timeout timeout]
srvctl convert database -db db_unique_name -dbtype RAC [-node node_name] |
Question
By using what activity, we achieve server-side load balancing?
options: a) when we create DB using dbca ,b) when we install grid software c) when we start crs system
Answer: when we create DB using dbca
Question
And how do you provide client-side load balancing?
Answer:
Changing connection definition on client side in tnsnames.ora.
See also
- One-off patch on Oracle 19.15 RAC nodes on Linux 7.9
- my oracle support https://support.oracle.com
- https://oracle.com