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 firstname.lastname@example.org http://www.idevelopment.info ----------------------------