Linux-based Oracle RAC 10g cluster Tutorial: steps required to delete a node

In this article, I will discuss the steps required to delete a node from an existing Oracle RAC 10g second cluster.

For demonstration purposes, the environment here is a two-node RedHat Linux cluster.

Database Name	Node number	Database Version	Instance id	Operating system kernel version	File System	Cluster Manager
RACDB	Two nodes -- Rac10g01 and Rac10g03	10.2.0.1	Four instances --RACDB1, RACDB2	Red Hat Enterprise Linux AS 4 2.6.9-42. ELsmp	OCFS2AndASM	Oracle Cluster

This process is implemented in the following three steps:

1. delete a database instance
2. Delete the ASM instance
3. delete a node

Step 1: delete a database instance from RAC

This step is completed as follows:

Unregister the selected instance in the associated Oracle Net Services listener
Delete the selected instance from the instance configuration Node
Delete Oracle Network Configuration
Delete the OFA directory structure from the instance configuration Node

You can delete a database instance from an existing RAC using the following two methods:

1. Use the EM Console

Log on to the EM console and select "manage ".
Select Change Database Section to delete an instance
Enter the cluster ID (if ASM is used, enter the host ID and asm id), select the node to delete the instance, and submit the task.
The task execution information is displayed on the summary page.

2. Use the DBCA command

Run the command on the reserved node.

Interactive Mode)

Instance management-> Delete instance-> enter a user with SYSDBA permissions-> select the instance to be deleted

Silent Mode (Reserved nodes)

Dbca-silent-deleteInstance [-nodeList node]-gdbName gdbname-instanceName instname-sysDBAUserName sysdba-sysDBAPassword password

Step 2: delete the ASM instance from the node (if ASM is used)

Delete a node
1. Stop using all databases of the deleted ASM instance
2. Delete the ASM instance srvctl stop asm-n node_name srvctl remove asm-n node_name
3. Delete the ASM Oracle directory

1 2 Next Page