Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Delete and add nodes in 11g rac under windows

2025-01-16 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

The first is to delete:

1 dbca delete node rac1, and delete it as prompted, in which you need to enter the sys password

Crsctl unpin css-n rac1

"after the execution of the grid user to view the resource pool, the rac2 is no longer in the serverpool, then continue to delete the cluster information.

Srvctl config serverpool

Cd / here grid installation directory / bin

# stop the cluster of failed nodes

.\ crsctl stop cluster-n rac1

# View resource status

Crsctl status res-tcrsctl check cluster-all

# deleting the application layer

Crsctl delete node-n rac1crsctl stop resource ora.rac1.vip-fcrsctl delete resource ora.rac1.vip-f

If the vip is still there, you can delete the vip with the following command

Netsh interface ip delete address name= "" addr=xx.xx.xx.xx

Update the post-deletion information:

Cd-d% ORACLE_HOME%\ oui\ bin.\ setup-updateNodeList ORACLE_HOME=d:\ app\ 11.2.0\ grid "CLUSTER_NODES= {rac2}" CRS=TRUEolsnodes-I-t-s

-- perform post-deletion check

Cluvfy stage-post nodedel-n rac1-verbose

Add nodes

Notepad C:\ Windows\ System32\ drivers\ etc\ hosts127.0.0.1 localhost10.10.8.10 RAC-SCAN10.10.8.11 RAC110.10.8.13 RAC210.10.8.12 RAC1-VIP10.10.8.14 RAC2-VIP192.168.1.11 RAC1-PRIV192.168.1.12 RAC2-PRIV

# configure network parameters

Netsh int ipv4 set global dhcpmediasense=disablednetsh int ipv6 set global dhcpmediasense=disablednetsh advfirewall set currentprofile state offnetsh int ipv4 set global dhcpmediasense=disablednetsh int tcp set global chimney=disablednetsh int tcp set global rss=disabled

# check the service

Net stop msdtcnet start RemoteRegistry

# add Node

Cd-d% ORACLE_HOME%\ oui\ binset ignore_preaddnode_checks=Y.\ addnode.bat "CLUSTER_NEW_NODES= {rac1}"CLUSTER_NEW_PRIVATE_NODE_NAMES= {rac1-priv}"CLUSTER_NEW_VIRTUAL_HOSTNAMES= {RAC1-VIP}" D:\ app\ 11.2.0\ grid\ crs\ config\ gridconfig.batset ROOTHASPL=%OH%\ perl\ bin\ perl-I% OH%\ perl\ lib-I% OH%\ crs\ install% OH%\ crs\ Install\ roothas.pl-notermset ROOTCRSPL=%OH%\ perl\ bin\ perl-I% OH%\ perl\ lib-I% OH%\ crs\ install% OH%\ crs\ install\ rootcrs.pl-noterm

# check after adding

Cluvfy stage-post nodeadd-n rac1-verbose

# add db instance

Set ORACLE_HOME=D:\ app\ Administrator\ product\ 11.2.0\ dbhome_1cd% ORACLE_HOME%/oui/bin/.\ addnode.bat "CLUSTER_NEW_NODES= {rac1}"

Reference:

Add crs: https://docs.oracle.com/cd/E11882_01/rac.112/e41959/adddelclusterware.htm#CWADD90997

Add db instance: https://docs.oracle.com/cd/E11882_01/rac.112/e41960/adddelwin.htm#RACAD8200

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report