Newsletters Archive - All

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


  Removing a Node from an Oracle RAC 10g Release 2 Cluster on Linux - (CentOS 4.5 / iSCSI) — (04-March-2008)

Although not as exciting as building an Oracle RAC or adding a new node and 
instance to a clustered database; removing a node from a clustered environment 
is just as important to understand for a DBA managing Oracle RAC 10g. While it 
is true that most of the attention in a clustered 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 RAC environment. It may be that a server is being 
underutilized in the database cluster and could be better served in another 
business unit. Another scenario is a node failure. In this case, a node can be 
removed from the cluster while the remaining nodes continue to service ongoing 
requests.

I recently published an extension to two of my articles:

"Building an Inexpensive Oracle RAC 10g Release 2 on Linux - (CentOS 4.5 / iSCSI)"

and

"Adding a Node to an Oracle RAC 10g Release 2 Cluster on Linux - (CentOS 4.5 / iSCSI)"

Contained in this new article are the steps required to remove a single node 
from an already running and configured three-node Oracle RAC 10g Release 2 
environment on the CentOS 32-bit (x86) platform. The node being removed is the 
third node I added in the second article. Although this article was written and 
tested on CentOS 4.5 Linux, it should work unchanged with Red Hat Enterprise 
Linux 4 Update 5.

The new article can be accessed using the following link:

Removing a Node from an Oracle RAC 10g Release 2 Cluster on Linux - (CentOS 4.5 / iSCSI)

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