Windows RAC Delete failed node, adding node instance operations document

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