If there are now three nodes in the RAC cluster C1, C2, C3:
If you want to uninstall the C3 node.
1. Delete the C3 instance on C1 or C2
Run DBCA
Then select Oracle Real application Clusters Database
Select Instance Management
Select Delete an instance
Select an instance, fill in the user name password, Next
Select C3:instance3,next
Execution complete
2. Remove R3 ASM instance (if any)
On C1 or C2, under Oracle users:
Srvctl Stop Asm-n C3
Srvctl Remove Asm-n C3
3, with NETCA uninstall delete monitoring
On C1 or C2, NETCA
Select cluster Configuration,
Select the C3 node,
Select Listener Configuration,
Select Delete,
Select Listener
4. Update Orainventory
On C1 or C2.
In the $oracle_home/oui/bin
Performed:./runinstaller-updatenodelist oracle_home= $ORACLE _home "CLUSTER_NODES=C1,C2"
On the C3.
In the $oracle_home/oui/bin
Performed:./runinstaller-updatenodelist oracle_home= $ORACLE _home "CLUSTER_NODES=C1,C2"
./runinstaller-updatenodelist oracle_home= $ORACLE _home "CLUSTER_NODES=C3"-local
5. Delete Oracle Software in C3
In the $oracle_home/bin
./runinstaller-deinstall
Delete only the database software (do not remove the cluster software)
6. Delete the remaining resources
On C1 or C2.
Under Oracle Users:
/u01/crs_1/bin/srvctl Stop Nodeapps-n C3
Under the root User:
/u01/crs_1/bin/srvctl Remove Nodeapps-n C3
7. Delete C3 Cluster
On the C3.
cd/u01/crs_1/install/
./rootdelete.sh
8, delete the C3 on C1
Under the root user
Cd/u01/crs_1/install
./rootdeletenodesh C3 3
9, in C1 delete C3 Clusterware record information
Cd/u01/crs_1/oui/bin
./runinstaller-updatenodelist oracle_home=/u01/crs_1 "CLUSTER_NODES=C1,C2" crs=true
10, update the Orainventory on C3
Cd/u01/crs_1/oui/bin
./runinstaller-updatenodelist oracle_home=/u01/crs_1 "CLUSTER_NODES=C3" crs=true-local
11, delete the Clusterware software on the C3
Cd/u01/crs_1/oui/bin
./runinstaller-deinstall
Attention:
In the middle you can use Crs_stat-t to view resource status
You can stop a resource with Srvctl stop xxx-n C3
You can remove a resource with Srvctl remove Xxx-n C3
Oracle 10G RAC Deletes existing nodes