RE: Deleting Nodes From Oracle Clusters on Windows-Based Platforms.

Admin — Fri, 16 Jan 2009 23:48:58 GMT

ASM Instance Cleanup Procedures after Node Deletion on Windows-Based Platforms

The delete node procedure requires the following additional steps on Windows-based systems to remove the ASM instances:

If this is the Oracle home from which the node-specific listener named LISTENER_nodename runs, then use NetCA to remove this listener and its CRS resources. If necessary, re-create this listener in another home.
If this is the Oracle home from which the ASM instance runs, then remove the ASM configuration by running the following command for all nodes on which this Oracle home exists:
```
srvctl stop asm -n node
```
Then run the following command for the nodes that you are removing:
```
srvctl remove asm -n node
```
If you are using a cluster file system for your ASM Oracle home, then run the following commands on the local node:

rd -s -q %ORACLE_BASE%\admin\+ASMdelete %ORACLE_HOME%\database\*ASM*

If you are not using a cluster file system for your ASM Oracle home, then run the delete command mentioned in the previous step on each node on which the Oracle home exists.

Run the following command on each node that has an ASM instance:

oradim -delete -asmsid +ASMnode_numberNote:

Oracle recommends that you back up your voting disk and OCR files after you complete the node deletion process.

Deleting Nodes From Oracle Clusters on Windows-Based Platforms.

Admin — Fri, 16 Jan 2009 23:45:04 GMT

Execute the following procedures to delete nodes from Oracle clusters on Windows-based platforms.

Perform the following steps on a node other than the node you want to delete:

Use the Database Configuration Assistant (DBCA) to delete the instance.
Use the Net Configuration Assistant (NetCA) to delete the listener.
If the node that you are deleting has an ASM instance, then delete the ASM instance using the srvctl stop asm and srvctl remove asm commands.
Run the command srvctl stop nodeapps -n nodename of the node to be deleted to stop the node applications.
Run the command srvctl remove nodeapps -n nodename of the node to be deleted to remove the node applications.
Stop isqlplus if it is running.
Run the command setup.exe -updateNodeList ORACLE_HOME=Oracle_home ORACLE_HOME_NAME=Oracle_home_name CLUSTER_NODES=remaining nodes where remaining nodes is a list of the nodes that are to remain part of the cluster.

Perform the following steps on the deleted RAC node:

Run the command setup.exe -updateNodeList -local -noClusterEnabled ORACLE_HOME=Oracle_home ORACLE_HOME_NAME=Oracle_home_name CLUSTER_NODES="". Note that you do not need a value for "" after the CLUSTER_NODES= entry in this command. If you delete more than one node, then you must run this command on every deleted node to remove the Oracle home if you have a non-shared Oracle home (non-cluster file system) installation.
On the same node, delete the Windows Registry entries and ASM services using Oradim.
From the deleted RAC node, run the command Oracle_home\oui\bin\setup.exe to start the Oracle Universal Installer (OUI). Select Deinstall Products and select the Oracle home that you want to de-install.
Then to delete the CRS node, from a remaining node run the command crssetup del -nn node_name of the deleted node, node number
Then run the command setup.exe -updateNodeList ORACLE_HOME=CRS home ORACLE_HOME_NAME=CRS home name CLUSTER_NODES=remaining nodes where remaining nodes is a list of the nodes that are to remain in the cluster.
Then on the deleted CRS node, run the command setup.exe -updateNodeList -local -noClusterEnabled ORACLE_HOME=CRS home ORACLE_HOME_NAME=CRS home name CLUSTER_NODES=""
Remove the Oracle home manually from the new node if the home is not shared and then manually remove the HKLM/software/Oracle registry keys and the Oracle services. 7
After adding or deleting nodes from your Oracle Database 10g with RAC environment, and after you are sure that your system is functioning properly, make a backup of the contents of the voting disk using the dd.exe utility. The dd.exe utility is part of the MKS toolkit.

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / Oracle RAC - Real Application Clusters Forum / Deleting Nodes From Oracle Clusters on Windows-Based Platforms. / Latest Posts

RE: Deleting Nodes From Oracle Clusters on Windows-Based Platforms.

ASM Instance Cleanup Procedures after Node Deletion on Windows-Based Platforms

Deleting Nodes From Oracle Clusters on Windows-Based Platforms.