溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點(diǎn)擊 登錄注冊 即表示同意《億速云用戶服務(wù)條款》

windows下11g rac刪除添加節(jié)點(diǎn)

發(fā)布時間:2020-03-27 08:39:19 來源:網(wǎng)絡(luò) 閱讀:1053 作者:snowhill 欄目:關(guān)系型數(shù)據(jù)庫

首先是刪:
1 dbca刪節(jié)點(diǎn) rac1,按提示刪除即可,其中需要輸入sys密碼
crsctl unpin css -n rac1
2#執(zhí)行完grid用戶查看資源池,此時rac2已經(jīng)不在serverpool里,接下來繼續(xù)刪除cluster信息
srvctl config serverpool
cd /此處grid安裝目錄/bin
#停止故障節(jié)點(diǎn)集群
.\crsctl stop cluster -n rac1
#查看資源狀態(tài)

crsctl status res -t
crsctl check cluster -all

#刪除應(yīng)用層

crsctl delete node -n rac1
crsctl stop resource ora.rac1.vip -f
crsctl delete resource ora.rac1.vip -f

如果vip還在,可以用如下命令刪除vip
netsh interface ip delete address name="" addr=xx.xx.xx.xx
更新刪除后信息:

cd -d %ORACLE_HOME%\oui\bin
.\setup -updateNodeList ORACLE_HOME=d:\app\11.2.0\grid  "CLUSTER_NODES={rac2}" CRS=TRUE
olsnodes -i -t -s

--執(zhí)行刪除后檢查
cluvfy stage -post nodedel -n rac1 -verbose

增加節(jié)點(diǎn)

notepad C:\Windows\System32\drivers\etc\hosts
127.0.0.1       localhost
10.10.8.10  RAC-SCAN
10.10.8.11  RAC1
10.10.8.13  RAC2
10.10.8.12  RAC1-VIP
10.10.8.14  RAC2-VIP
192.168.1.11    RAC1-PRIV
192.168.1.12    RAC2-PRIV

#配置網(wǎng)絡(luò)參數(shù)

netsh int ipv4 set global dhcpmediasense=disabled
netsh int ipv6 set global dhcpmediasense=disabled
netsh advfirewall set currentprofile state off
netsh int ipv4 set global dhcpmediasense=disabled
netsh int tcp set global chimney=disabled
netsh int tcp set global rss=disabled

#檢查服務(wù)

net stop msdtc
net start RemoteRegistry

#添加節(jié)點(diǎn)

cd  -d %ORACLE_HOME%\oui\bin
set 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.bat
set ROOTHASPL=%OH%\perl\bin\perl -I%OH%\perl\lib -I%OH%\crs\install %OH%\crs\install\roothas.pl -noterm
set ROOTCRSPL=%OH%\perl\bin\perl -I%OH%\perl\lib -I%OH%\crs\install %OH%\crs\install\rootcrs.pl -noterm

#添加后檢查
cluvfy stage -post nodeadd -n rac1 -verbose
#添加db instance

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

參考:
添加crs:https://docs.oracle.com/cd/E11882_01/rac.112/e41959/adddelclusterware.htm#CWADD90997
添加db instance:https://docs.oracle.com/cd/E11882_01/rac.112/e41960/adddelwin.htm#RACAD8200

向AI問一下細(xì)節(jié)

免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI