Oracle RAC interview questions

/ Interview Questions / By

In this post we are going to learn Oracle RAC interview questions, This post will be updated constantly, so please do check this post often.

Explain the steps involved in RAC Software and Database creation?

  1. Install the same version of operating system in all the nodes.
  2. Create required no.of groups and oracle user accounts.
  3. Create required directory structure for CRS_HOME and DB_HOME
  4. configure kernel parameters as per installation document.
  5. Set shell limits for oracle user account.
  6. Edit /etc/hosts and specify public IP, private IP and virtual Ips.
  7. Configure ssh for user equivalence and trust relationships
  8. Create required no.of partitions in the shared storage for OCR file,Voting Disks and ASM Diskgroups.
  9. Download and install additional rpms if required based on OS.
  10. Install clusterware binaries.
  11. Install Oracle binaries.
  12. Invoke NETCA and configure listener.
  13. Configure ASM and create the required no.of diskgroups.
  14. Invoke DBCA and create RAC database.

What happenes when root.sh script is executed during RAC clusterware installation?

  1. Sets the Oracle base and home environments
  2. Creates the /etc/oratab file
  3. Verifies the super user privileges
  4. Creates a trace directory
  5. Generates OCR keys for the root user
  6. Adds daemon information to the inittab file
  7. Starts up the Oracle High Availability Service Daemon (OHASD) process
  8. Creates and configures an ASM instance and starts up the instance
  9. Creates required ASM disk groups, if ASM is being used to put OCR and voting files
  10. Accumulates OCR keys for the root user
  11. Starts up the Cluster Ready Service Daemon (CRSD) process
  12. Creates the voting disk file
  13. Puts the voting disk on the Voting disk, if ASM type is selected
  14. Displays voting disk details
  15. Stops and restarts a cluster stack and other cluster resources on the local node
  16. Backs up the OCR to a default location
  17. Installs the cvuqdisk-1.0.7-1 package
  18. Updates the Oracle inventory file
  19. Completes with the UpdateNodeList success operation

When root.sh is executed on the last node of the cluster, the following set of actions is likely to be performed by the script:

  1. Sets Oracle base and home environmental variables
  2. The /etc/oratab file will be created
  3. Performs the super user privileges verification
  4. Adds trace directories
  5. Generates OCR keys for the root user
  6.  Adds a daemon to inittab
  7. Starts the Oracle High Availability Service Daemon (OHASD) process
  8. Stops/starts a cluster stack and other cluster resources on the local node
  9. Performs a backup of the OCR file
  10. Installs the cvuqdisk-1.0.7-1 package
  11. Updates the Oracle inventory file
  12. Completes with UpdateNodeList success operation

Name any two post installation steps that you may require to perform after installation of RAC database?

  1. Backup OCR File.
  2. Back up the Grid Infrastructure and Oracle DB home