Sr.Oracle DBA RAC/Datagaurd Interview Questions

What is cache fusion in RAC ?
What is the significance of freelists table setting in RAC ?
What is cluster_interconnect init parameter ? What value needs to be setup here ?
Why do you need a seperate network switch for the RAC nodes interconnect configuration?
What is the interconnect bandwidth you recommend for private connect network switch ?
How many NICS you used in the RAC Install ?
What is local_listener setting ? Where do you set this parameter ? What is the value should be ?
What is remote_listener setting ? Where do you set this parameter ? What is the value should be ?
What is rconfig ? When do you use this ? Can you use this with raw devices ? Where do you find this tool ?
What is ocrconfig ? When do you use this ?
Do we need $ORACLE_HOME on all RAC nodes ?
What is OCFS ? Did you used it before ? What is cluvfy ? When do you use this ?
What is ASM ?
What is runcluvfy.sh ? cluvfy ? When do you use ?
What is racdiag.sql and RDA.sh ? What information it will provide ?
Did you ever noticed ORA-29740 ? When do you encounter this error ? How do you solve this ?
what is cmcfg.ora ? What is ocmstart.sh ?
What is CRS ? Do you need clusterware when you use CRS ?
What are the various clusterwares available in the market ? Does 9iRAC requires clusterware ?
What are the three different load balancing techniques you can use with RAC ? Where do you set this up ?
What is gsdctl ? When do you use this ?
What is ORION tool ?
What is LPAR ? Did you ever worked with those ?
Which os requires hangcheck process ? What does it do ?
What is OCR/voting file ?
What is crsctl ? When do you use this tool ?
What is srvconfig_loc setting ? Where do you set this value ?
How do you initialize the raw volume where your SRVM configuration file is located ? When do u use srvmconfig -init command ?
How do you start the global services daemon ? when do you use gsdctl start command?
What is srvctl command ?
How do you list the number of instances running in a RAC environment ?
How do you start or stop RAC db ?
When do you use DBCA_RAW_CONFIG setting ? Where do you set this setting ?
What is fal_server and fal_client ? Where do you need to set this ? What the values would be ?
How do you setup physical standby and logical stand by ? Give me the steps in detail ? What are the differences ?
What is oracle streams ? How do you enable the replication with streams ? Give me the steps ?
How do you resolve/skip the data errors which comes with logical standby ?
How do you skip or exclude specific tables from replication in the logical standby configuration ?
How do you identify the latency and issues with logical standby ?
How do you bypass the database guard and allow modifications to the tables ?
Give me the Top 5 init parameters which needs to be setup in the source db in the physical standby config ?
Give me the Top 5 init parameters which needs to be setup in the target db in the physical standby config ?
How do you handle the nologging issues, If force logging is not enabled in the physical standby environment ?
How do you ensure the 0% data loss in physical standby configuration ?
How do you perform the switch over from primary to standby and standby to primary ?
What is the lock_name_space setting ? When do you need to use this ?
Give me the syntax to create a standby controlfile using RMAN ?
How do you identify the list of stand alone patches applied ?
How do you rollback a stand alone patches ?
Give me the list of steps, approach you take for patch set upgrade ?
Give me the list of steps, approach you take for database release upgrades(9i-10g) ?
How do you apply the standby alone patches ?
How do you figure out the pre-req os patches/packages required for a specific database release ?
How do you compile the steps for a database upgrade ?
How do you perform the cross platform migrations ?
How do you raise a service request with oracle when you can't resolve certain upgrade issues