Windows RAC Delete failed node, add node instance action document
Platform Introduction :
( os:windows Server 2004, oracle:10.2.0.4.0 )
Implementation steps:
( 1 ) Reinstall Rac2 the operating system
( 2 ) Delete node
( 3 ) to add a new node
( 4 ) To configure a new node
a . installation RAC2 operating System (step slightly).
two . To Delete a node:
2.1 Onrac1, or on any node (deleting), run the following command from Crs_home\bin
crssetup del –nnnode_name,node_number
650) this.width=650; "Width=" 554 "height=" "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ( "/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ( "/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 553 "height=" 351 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650, "width=" 554 "height=", "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ( "/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650, "width=" 554 "height=" "src=", "/e/u261/themes/default/images/spacer.gif" style= "Background:url" ( "/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
2.2 you can discover that RAC3 resources are still registered in the cluster.
. C:\oracle\product\10.2.0\crs\bin>crs_stat-t-V
name typeR/ra f/ftTarget Status Host
----------------------------------------------------------------------
Ora .... B1.inst application 0/5 0/0 online online Rac1
Ora .... B2.inst application 0/5 0/0 ONLINE OFFLINE
Ora .... RLIB.DB application 0/0 0/1 online online Rac1
Ora .... C1.lsnr application 0/5 0/0 online online Rac1
ORA.RAC1.GSD application 0/5 0/0 online online Rac1
Ora.rac1.ons application 0/3 0/0 online online Rac1
ORA.RAC1.VIP application 0/0 0/0 online online Rac1
Ora .... C2.lsnr application 0/5 0/0 OFFLINE OFFLINE
ORA.RAC2.VIP application 0/0 0/0 OFFLINE OFFLINE
To manually cancel All resource registrations for RAC2, you can use Crs_stat to view The RAC2 cluster resource registrations:
C:\oracle\product\10.2.0\crs\bin>crs_unregister.exeora.interlib.interlib2.inst
C:\oracle\product\10.2.0\crs\bin>crs_unregister.exe Ora.rac2.LISTENER_RAC2.lsnr
C:\oracle\product\10.2.0\crs\bin>crs_unregister.exe ORA.RAC2.VIP
Update node Information:
Setup.exe-updatenodelistoracle_home=oracle_home "Cluster_nodes={node_list}"
C:\oracle\product\10.2.0\db_1\oui\bin>setup.exe-updatenodelistoracle_home=c:\oracle\product\10.2.0\db_1\ " CLUSTER_NODES={RAC1} "
650) this.width=650, "width=" 554 "height=" "src=,"/e/u261/themes/default/images/spacer.gif "style=" Background:url ( "/e/u261/themes/default/images/word.gif") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
Setup.exe-updatenodelist oracle_home=crs_home "Cluster_nodes={node_list}"
C:\oracle\product\10.2.0\crs\oui\bin>setup.exe-updatenodelistoracle_home=c:\oracle\product\10.2.0\crs\ " CLUSTER_NODES={RAC1} "Crs=true
650) this.width=650; "Width=" 554 "height=" "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ( "/e/u261/themes/default/images/word.gif") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
2.3 To verify the deletion result:
650) this.width=650; "Width=" 554 "height=" 123 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650, "width=" 554 "height=", "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ( "/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
three . To Add a node:
3.1 Go to Crs_home\oui\bin on Node1 and runthe addnode.bat script
650) this.width=650 "width=" 554 "height=" "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ( "/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 404 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 410 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 413 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
3.2 F ROM Crs_home\install on Node1,run the Crssetup.add.bat script.
650) this.width=650; "Width=" 554 "height=" 267 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
Here are the error, please perform vipca configuration VIP in the new node;
3.3 Check for new nodes all CRS-related services have been started:
650) this.width=650; "Width=" 553 "height=" 131 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
executes on the new node Crs_home/bin/vipca.bat , configure for the new node VIP resources;
( the network card name must be in English or digital )
650) this.width=650; "Width=" 554 "height=" 384 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 389 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 402 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 403 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
Configuration succeeded:
650) this.width=650; "Width=" 554 "height=" 471 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
3.4 Add Oracle_home to the new node: Go to Oracle_home\oui\bin on Node1 andrun the Addnode.bat script
650) this.width=650 "width=" 554 "height=" "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ( "/e/u261/themes/default/images/word.gif") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 553 "height=" 444 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 553 "height=" 318 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
3.5. Run DBCA To add a new instance:
650) this.width=650; "Width=" 554 "height=" "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ( "/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 553 "height=" 398 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 404 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 553 "height=" 435 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 553 "height=" "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 491 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 422 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 553 "height=" 438 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 423 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 467 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
650) this.width=650; "Width=" 554 "height=" 379 "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/images/localimage.png") no-repeat center;border:1px solid #ddd; "alt=" Spacer.gif "/>
Four . to configure a new node:
4.1 add a new node on the surviving node REDO Log solve the above ORA-02174 errors,
ALTER DATABASE ENABLE THREAD 2 Perform the SQL , enable the second node's Redo .
4.2 . start a new node.
========================== the end =========================================
Windows RAC Delete failed node, adding node instance operations document