环境：

OS：OEL5.6

RAC：10.2.0.1.0

眼下有rac1。rac2。rac3三个节点，下面是删除rac3节点的具体过程

1.删除rac3节点上的数据库实例

[oracle@rac1~]$dbca-silent-deleteInstance-gdbNameRACDB-instanceNameRACDB3-sysDBAUserNamesys-sysDBAPasswordoracle

Deletinginstance

20%complete

21%complete

22%complete

26%complete

33%complete

40%complete

46%complete

53%complete

60%complete

66%complete

Completinginstancemanagement.

70%complete

73%complete

76%complete

80%complete

100%complete

Lookatthelogfile"/u01/app/oracle/product/10.2.0/db_2/cfgtoollogs/dbca/RACDB.log"forfurtherdetails.

2.删除rac3节点上的ASM实例

[oracle@rac1~]$srvctlstopasm-nrac3

[oracle@rac1~]$srvctlremoveasm-nrac3

3.删除rac3节点上的监听

[oracle@rac1~]$netca

watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvYmFkbHk5/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">

watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvYmFkbHk5/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">

4.删除节点3上的$ORACLE_HOME文件夹

[oracle@rac3~]$rm-rf$ORACLE_HOME

更新保留节点的ORACLE_HOME信息

[oracle@rac1~]$cd$ORACLE_HOME/oui/bin

[oracle@rac1bin]$./runInstaller-updateNodelistORACLE_HOME=/u01/app/oracle/product/10.2.0/db_2"CLUSTER_NODES=rac1,rac2"

StartingOracleUniversalInstaller...

Nopre-requisitechecksfoundinoraparam.ini,nosystempre-requisitecheckswillbeexecuted.

'UpdateNodeList'wassuccessful.

5.清除rac上配置信息

rac3节点上：

[oracle@rac3~]$cat$CRS_HOME/opmn/conf/ons.config

localport=6113

remoteport=6200

loglevel=3

useocr=on

rac1节点上：

[oracle@rac1bin]$racgonsremove_configrac3:6200

6.删除rac3节点

rac3节点上：

[root@rac3~]#cd/u01/app/oracle/product/10.2.0/db_1/install（CRS_HOME）

[root@rac3install]#./rootdelete.sh

ShuttingdownOracleClusterReadyServices(CRS):

Stoppingresources.

SuccessfullystoppedCRSresources

StoppingCSSD.

ShuttingdownCSSdaemon.

Shutdownrequestsuccessfullyissued.

Shutdownhasbegun.Thedaemonsshouldexitsoon.

CheckingtoseeifOracleCRSstackisdown...

OracleCRSstackisnotrunning.

OracleCRSstackisdownnow.

RemovingscriptforOracleClusterReadyservices

Updatingocrfilefordowngrade

CleaningupSCRsettingsin'/etc/oracle/scls_scr'

这时候已经删除rac3上的CRS

[oracle@rac1~]$crs_stat-t

NameTypeTargetStateHost

------------------------------------------------------------

ora....B1.instapplicationONLINEONLINErac1

ora....B2.instapplicationONLINEONLINErac2

ora.RACDB.dbapplicationONLINEONLINErac1

ora....SM1.asmapplicationONLINEONLINErac1

ora....C1.lsnrapplicationONLINEONLINErac1

ora.rac1.gsdapplicationONLINEONLINErac1

ora.rac1.onsapplicationONLINEONLINErac1

ora.rac1.vipapplicationONLINEONLINErac1

ora....SM2.asmapplicationONLINEONLINErac2

ora....C2.lsnrapplicationONLINEONLINErac2

ora.rac2.gsdapplicationONLINEONLINErac2

ora.rac2.onsapplicationONLINEONLINErac2

ora.rac2.vipapplicationONLINEONLINErac2

可是此时通过olsnodes查看仍未三个节点

[root@rac1bin]#./olsnodes-n

rac11

rac22

rac33

从集群中删除节点并更新OCR：

[root@rac1install]#./rootdeletenode.shrac3

CRSnodeappsaredeletedsuccessfully

clscfg:EXISTINGconfigurationversion3detected.

clscfg:version3is10GRelease2.

Nodedeletionoperationsuccessful.

'rac3'deletedsuccessfully

rac3节点执行OUI删除CRS安装文件夹

[oracle@rac3~]$cd$CRS_HOME

[oracle@rac3db_1]$cdoui/

[oracle@rac3oui]$cdbin/

[oracle@rac3bin]$./runInstaller-deinstall-silent"REMOVE_HOMES={/u01/app/oracle/product/10.2.0/db_1}"CRS=TRUE-local

StartingOracleUniversalInstaller...

Nopre-requisitechecksfoundinoraparam.ini,nosystempre-requisitecheckswillbeexecuted.

PreparingtolaunchOracleUniversalInstallerfrom/tmp/OraInstall2014-08-25_02-14-19PM.Pleasewait...[oracle@rac3bin]$OracleUniversalInstaller,Version10.2.0.1.0Production

Copyright(C)1999,2005,Oracle.Allrightsreserved.

Startingdeinstall

Deinstallinprogress(MonAug2514:14:23CST2014)

WARNING:Thedirectory:/u01/app/oracle/product/10.2.0/db_1willbedeletedafterdeinstall.

Clickon"Yes"tocontinue.

Clickon"No"toperformdeinstallwithoutdeletingthedirectory.

Clickon"Cancel"togobackto"InventoryDialog".

...............................................................100%Done.

Deinstallsuccessful

Endofinstallphases.(MonAug2514:14:42CST2014)

Endofdeinstallations

Pleasecheck'/u01/app/oracle/oraInventory/logs/silentInstall2014-08-25_02-14-19PM.log'formoredetails.

在rac1节点上更新集群节点信息

[oracle@rac1~]$cd$CRS_HOME/oui/bin/

[oracle@rac1bin]$./runInstaller-updateNodeListORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1"CLUSTER_NODES=rac1,rac2"CRS=TRUE

StartingOracleUniversalInstaller...

Nopre-requisitechecksfoundinoraparam.ini,nosystempre-requisitecheckswillbeexecuted.

'UpdateNodeList'wassuccessful.

至此节点rac3删除完成

优质内容筛选与推荐>>
1、模式识别相似性测度距离计算---几种距离对比
2、[原创][C#] 如何将String类型转换成任意基本类型
3、毕业季·清明节
4、找到最小的m,使n*M的结果只有1，0
5、自定义辅助方法