Newsletters Archive - All

If you would like to know more about the iDevelopment.info Newsletter, please email me.


  Remove a Node from an Existing Oracle RAC 11g R2 Cluster on Linux - (RHEL 5) — (07-May-2012)

Although not as exciting as building an Oracle RAC or adding a new node and 
instance to a cluster database; removing a node from a clustered environment is 
just as important to understand for a DBA managing Oracle RAC. While it is true 
that most of the attention in a cluster database environment is focused on 
extending the database tier to support increased demand, the exact opposite is 
just as likely to be encountered where the DBA needs to remove a node from an 
existing Oracle RAC. One scenario may be a node failure or that an 
underutilized server in the database cluster could be better served in another 
business unit. In either case, a node can be removed from the cluster while the 
remaining nodes continue to service ongoing requests.

The following guide is an extension to two of my articles: "Building an 
Inexpensive Oracle RAC 11g R2 on Linux - (RHEL 5)" and "Add a Node to an 
Existing Oracle RAC 11g R2 Cluster on Linux - (RHEL 5)".

Remove a Node from an Existing Oracle RAC 11g R2 Cluster on Linux - (RHEL 5)

The original articles that describe the existing Oracle RAC and adding a new 
node can be found at:

Building an Inexpensive Oracle RAC 11g R2 on Linux - (RHEL 5)

Add a Node to an Existing Oracle RAC 11g R2 Cluster on Linux - (RHEL 5)

Contained in this new article are the steps required to remove a single node 
from an existing three-node Oracle RAC 11g Release 2 (11.2.0.3.0) environment 
on the CentOS 5 Linux platform. The node being removed is the third node I 
added in the second article. Although this article was written and tested on 
CentOS 5 Linux, it should work unchanged with Red Hat Enterprise Linux 5 or 
Oracle Linux 5.

----------------------------
Jeffrey M. Hunter, OCP
Sr. Database Administrator
jhunter@idevelopment.info
http://www.idevelopment.info
----------------------------