Adding a voting disk online

Admin — Tue, 08 Sep 2009 16:10:33 GMT

In 10.2 RAC it is now possible to add a voting disk online in addition to specifying more than one voting disk during the ClusterWare install.In 10G R1 there was no software level mirroring of the voting disk.

To add a voting disk:

crsctl add css votedisk path

To remove a voting disk:

crsctl delete css votedisk path

$ORA_CRS_HOME/bin/crsctl add css votedisk /dev/raw/raw4
Cluster is not in a ready state for online disk addition

You have to use the force option in the above command due to
Bug 4898020 ADDING VOTING DISK ONLINE CRASH THE CRS
which is fixed in the 10.2.0.4 patchset.

Before using the force option make sure the CRS stack is not up on any of the nodes.

ps -ef | grep d.bin | grep -v grep
This command should retrun no rows.

$ORA_CRS_HOME/bin/crsctl add css votedisk /dev/raw/raw4 -force
Now formatting voting disk: /dev/raw/raw4
successful addition of votedisk /dev/raw/raw4.

Make sure that the newly added disk can be seen from both nodes.

$ORA_CRS_HOME/bin/crsctl query css votedisk
0. 0 /dev/raw/raw2
1. 0 /dev/raw/raw4

located 2 votedisk(s).

$ORA_CRS_HOME/bin/crsctl query css votedisk
0. 0 /dev/raw/raw2
1. 0 /dev/raw/raw4

located 2 votedisk(s).

When deleting the newly added disks you should get the same error:

./crsctl delete css votedisk /dev/raw/raw4
Cluster is not in a ready state for online disk removal

./crsctl delete css votedisk /dev/raw/raw4 -force
successful deletion of votedisk /dev/raw/raw4.

The force option should be used CAREFULLY only after the CRS stack
is shutdown on all nodes. Failure to do so could result in OCR corruption.

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

Adding a voting disk online

Deleting Nodes From Oracle Clusters on Windows-Based Platforms.