Home > Default > Remove RAC node on Windows

Remove RAC node on Windows

November 30Hits:0
Advertisement
I have done all the steps to remove one RAC node but got stuck at the step of running rootdelete.sh file from $CRS_HOME/install directory as I don't have this file in windows environment.
What is the equivalent file for rootdelete.sh on windows platform. I want to run this to remove the node info from the clusterware entry.
Is there a good document that explains about removing the node on windows platform.

Answers

Hello,
You need to run the following steps to remove a node from a RAC cluster on Windows platform:
Perform the following steps on a node other than the node you want to delete:
1. Run the Database Configuration Assistant (DBCA) utility to delete the instance.
2. Then run the Net Configuration Assistant (NetCA) to delete the listener.
3. If the node that you are deleting has ASM instance, then delete the ASM instance using the srvctl stop asm and srvctl remove asm commands.
4. Run the command srvctl stop nodeapps -n nodename of the node to be deleted to stop the node applications.
5. Run the command srvctl remove nodeapps -n nodename of the node to be deleted to remove the node applications.
6. Stop isqlplus if it is running.
7. 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:
1. 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.
2. On the same node, delete the Windows Registry entries and ASM services using Oradim.
3. 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.
4. Then to delete the CRS node, from a remaining node run the command crssetup del -nn node_name of the deleted node, node number
5. 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.
6. 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=""
7. 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
8. 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.
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:
1. 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.
2. 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
3. If you are using a cluster file system for your ASM Oracle home, then run the following commands on the local node:
4. rd -s -q %ORACLE_BASE%\admin\+ASM
delete %ORACLE_HOME%\database\*ASM*
5. 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.
6. Run the following command on each node that has an ASM instance:
oradim -delete -asmsid +ASMnode_number
Source:
Oracle® Real Application Clusters Administrator's Guide
10g Release 1 (10.1)
Part Number B10765-02
Chapter 5: Adding and Deleting Nodes and Instances
Hope this helps,
Ben Prusinski, Oracle 10g OCP
http://oracle-magician.blogspot.com

Read other 2 answers

Tags:

Related Articles

  • Remove RAC node on WindowsNovember 30

    I have done all the steps to remove one RAC node but got stuck at the step of running rootdelete.sh file from $CRS_HOME/install directory as I don't have this file in windows environment. What is the equivalent file for rootdelete.sh on windows platf

  • Domain migration of Oracle RAC nodes on windows 2008November 30

    Hello masters, We are planning to migrate servers from old domain to a new domain due to company name change. That is, our DB servers named like db-node-x.old-domain.com will be migrated to db-node-x.new-domain.com. The servers are all on Windows 200

  • Oracle RAC 11g on Windows 2008 64 bit - blue screen error on both nodesOctober 11

    Hi Everyone, I installed Oracle RAC 11g on Windows 2008 64 bit, The installation was successfull and crs_state -t shows all services in two nodes are online. When executed a select query with 100 sessions( For performance evaluation using Transaction

  • Removing one node, re-install and join cluster 3.2/RAC/QFSNovember 30

    Hi all, I have one cluster system with 2 node ( Cluster 3.2, Oracle RAC, QFS). Now one node have been failed and cannot recover. Now I have to reinstall the faulty node. How can it removing all the faulty node from the active node? Can I reinstall an

  • Updgrade from 11.2.0.1 to 11.2.0.3 on 2 node Rac -ASM ON windows 2008 r2November 30

    Hi Guys, We are going to upgrade our 24x7 system (2 node RAC ASM On windows 2008 R2) from 11.2.0.1 to 11.2.0.3. I appreciate if any one let me know the oracle my support document no. or step by step guide. Regards,Hi, You can check the id for upgrade

  • Rac one node in windows 2003?November 30

    Hi, Do RAC one node support windows 2003 64 bit? I could find neither the patch 9004119 nor documentation for windows. All are about RAC one node in linux. Thanks Vincenthi, On 11g R2, yes you can have a one node RAC and the patch you are looking for

  • Rac node failure crs cleanup failingNovember 30

    I have a three node rac database, 10.2.0.4 running on Windows server 2008. I lost a hard drive on one of the servers and it corrupted the mirror disk as well so I am having to rebuild. I am going through these procedures, RAC on Windows: How to Clean

  • How to remove a node from a xmlOctober 11

    Hi All, I want to remove a node from my xml output. Can anyone suggest me how to get that? I want to implement this by using the ASSIGN activity. My sample output is <env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ws

  • Issues while Add / Delete RAC Node in Oracle 10g R2November 30

    Hi, I have an requirement to add a New Node in the existing 2 Node RAC at Production, where 1 Node is Active & other one is passive due to licence issue & cannot keep both the nodes as active. Due to performance issues (Memory , CPU Cores ..etc) w

  • Oracle RAC 11g On Window Server 2003 Installation Step by StepNovember 30

    Hi all I tired searching onlie to get steps of installationg Oracle RAC 11g On Window Server 2003 I have tow nodes EMC storage Any body can help please ... Thanks in Advance. Edited by: MHAIDAR on Jun 15, 2011 1:19 AMI tired searching onlie to get st

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.828 s.