Windows RAC Delete failed node, adding node instance operations document

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.