Tag Archives: RAC

Oracle database tutorial:RAC

oracle RAC

In this section of Oracle Database Tutorial:RAC we will talk about RAC(Real application clusters) CONCEPTS AND FUNCTIONAL OVERVIEW RAC is the ability to have two or more instances connect to the same database. These instances reside on separate servers, thereby allowing each instance to make full use of the processing ability of each server. As these instances are accessing the same database they need to … Continue reading Oracle database tutorial:RAC »

How to add any node to Oracle RAC cluster in 10g and 11g

Last updated on July 29th, 2016 at 07:20 am Step 1: Prepare the server to be added a) Shared the Database Storage b) Shared the OCR and voting disk c) Check the new box for ssh connectivity Step 2: Run cluvfy cluvfy stage -post hwos -n XXXX Step 3: Add node to Cluster using the $ORACLE_HOME/oui/bin/addnode.sh from the node existing in cluster And choose SUN12OS … Continue reading How to add any node to Oracle RAC cluster in 10g and 11g »

Cluster command in Oracle clusterware 10g and 11g

Last updated on September 1st, 2016 at 05:21 amOracle clusterware is the clusterware technology from oracle to Manage Oracle RAC database on various platform.Oracle  has provide cluster utilities to manage it. Here are some of the useful Cluster command  in 10g and 11g  CRSCTL Cluster Control utility performs various administrative operation of oracle clusterware. It is located in $ORA_CRS_HOME/bin and must be executed by the … Continue reading Cluster command in Oracle clusterware 10g and 11g »

Interconnect setup in RAC

Last updated on November 23rd, 2015 at 03:42 pmThe interconnect is a very important part of the cluster environment it is on of the aorta’s of a cluster environment. The interconnect is used as physical layer between the cluster nodes to perform heartbeats as well as the cache fusion is using it. The interconnect must be a private connection. Cross over cable is not support. … Continue reading Interconnect setup in RAC »

How Oracle RAC handles instance failure and recovery

Last updated on August 31st, 2016 at 05:37 pmOracle uses a simple mechanism of a heartbeat to detect instance failure of a node in a RAC cluster. The cluster manager software detects if it cannot receive the heartbeat of the other instances and if it does not the recovery process begins. From what I can find, this heartbeat is provided by the udlm package on … Continue reading How Oracle RAC handles instance failure and recovery »