Oracle RAC interview questions
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?
- Install the same version of operating system in all the nodes.
- Create required no.of groups and oracle user accounts.
- Create required directory structure for CRS_HOME and DB_HOME
- configure kernel parameters as per installation document.
- Set shell limits for oracle user account.
- Edit /etc/hosts and specify public IP, private IP and virtual Ips.
- Configure ssh for user equivalence and trust relationships
- Create required no.of partitions in the shared storage for OCR file,Voting Disks and ASM Diskgroups.
- Download and install additional rpms if required based on OS.
- Install clusterware binaries.
- Install Oracle binaries.
- Invoke NETCA and configure listener.
- Configure ASM and create the required no.of diskgroups.
- Invoke DBCA and create RAC database.
What happenes when root.sh script is executed during RAC clusterware installation?
- Sets the Oracle base and home environments
- Creates the /etc/oratab file
- Verifies the super user privileges
- Creates a trace directory
- Generates OCR keys for the root user
- Adds daemon information to the inittab file
- Starts up the Oracle High Availability Service Daemon (OHASD) process
- Creates and configures an ASM instance and starts up the instance
- Creates required ASM disk groups, if ASM is being used to put OCR and voting files
- Accumulates OCR keys for the root user
- Starts up the Cluster Ready Service Daemon (CRSD) process
- Creates the voting disk file
- Puts the voting disk on the Voting disk, if ASM type is selected
- Displays voting disk details
- Stops and restarts a cluster stack and other cluster resources on the local node
- Backs up the OCR to a default location
- Installs the cvuqdisk-1.0.7-1 package
- Updates the Oracle inventory file
- 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:
- Sets Oracle base and home environmental variables
- The /etc/oratab file will be created
- Performs the super user privileges verification
- Adds trace directories
- Generates OCR keys for the root user
- Adds a daemon to inittab
- Starts the Oracle High Availability Service Daemon (OHASD) process
- Stops/starts a cluster stack and other cluster resources on the local node
- Performs a backup of the OCR file
- Installs the cvuqdisk-1.0.7-1 package
- Updates the Oracle inventory file
- Completes with UpdateNodeList success operation
Name any two post installation steps that you may require to perform after installation of RAC database?
- Backup OCR File.
- Back up the Grid Infrastructure and Oracle DB home