程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> Oracle數據庫 >> Oracle教程 >> 【Oracle】RAC刪除節點

【Oracle】RAC刪除節點

編輯:Oracle教程

【Oracle】RAC刪除節點


環境:

OS:OEL5.6

RAC:10.2.0.1.0

目前有rac1,rac2,rac3三個節點,以下是刪除rac3節點的詳細過程

1.刪除rac3節點上的數據庫實例

[oracle@rac1 ~]$ dbca -silent -deleteInstance -gdbName RACDB -instanceName RACDB3 -sysDBAUserName sys -sysDBAPassword oracle

Deleting instance

20% complete

21% complete

22% complete

26% complete

33% complete

40% complete

46% complete

53% complete

60% complete

66% complete

Completing instance management.

70% complete

73% complete

76% complete

80% complete

100% complete

Look at the log file "/u01/app/oracle/product/10.2.0/db_2/cfgtoollogs/dbca/RACDB.log" for further details.

2.刪除rac3節點上的ASM實例

[oracle@rac1 ~]$ srvctl stop asm -n rac3

[oracle@rac1 ~]$ srvctl remove asm -n rac3

3.刪除rac3節點上的監聽

[oracle@rac1 ~]$ netca

\

\

\

\

\

\

\

4.刪除節點3上的$ORACLE_HOME目錄

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

更新保留節點的ORACLE_HOME信息

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

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

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

'UpdateNodeList' was successful.

5.清除rac上配置信息

rac3節點上:

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

localport=6113

remoteport=6200

loglevel=3

useocr=on

rac1節點上:

[oracle@rac1 bin]$ racgons remove_config rac3:6200

6.刪除rac3節點

rac3節點上:

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

[root@rac3 install]# ./rootdelete.sh

Shutting down Oracle Cluster Ready Services (CRS):

Stopping resources.

Successfully stopped CRS resources

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

Shutdown has begun. The daemons should exit soon.

Checking to see if Oracle CRS stack is down...

Oracle CRS stack is not running.

Oracle CRS stack is down now.

Removing script for Oracle Cluster Ready services

Updating ocr file for downgrade

Cleaning up SCR settings in '/etc/oracle/scls_scr'

這時候已經刪除rac3上的CRS

[oracle@rac1 ~]$ crs_stat -t

Name Type Target State Host

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

ora....B1.inst application ONLINE ONLINE rac1

ora....B2.inst application ONLINE ONLINE rac2

ora.RACDB.db application ONLINE ONLINE rac1

ora....SM1.asm application ONLINE ONLINE rac1

ora....C1.lsnr application ONLINE ONLINE rac1

ora.rac1.gsd application ONLINE ONLINE rac1

ora.rac1.ons application ONLINE ONLINE rac1

ora.rac1.vip application ONLINE ONLINE rac1

ora....SM2.asm application ONLINE ONLINE rac2

ora....C2.lsnr application ONLINE ONLINE rac2

ora.rac2.gsd application ONLINE ONLINE rac2

ora.rac2.ons application ONLINE ONLINE rac2

ora.rac2.vip application ONLINE ONLINE rac2

但是此時通過olsnodes查看仍未三個節點

[root@rac1 bin]# ./olsnodes -n

rac1 1

rac2 2

rac3 3

從集群中刪除節點並更新OCR:

[root@rac1 install]# ./rootdeletenode.sh rac3

CRS nodeapps are deleted successfully

clscfg: EXISTING configuration version 3 detected.

clscfg: version 3 is 10G Release 2.

Node deletion operation successful.

'rac3' deleted successfully

rac3節點運行OUI刪除CRS安裝目錄

[oracle@rac3 ~]$ cd $CRS_HOME

[oracle@rac3 db_1]$ cd oui/

[oracle@rac3 oui]$ cd bin/

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

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-08-25_02-14-19PM. Please wait ...[oracle@rac3 bin]$ Oracle Universal Installer, Version 10.2.0.1.0 Production

Copyright (C) 1999, 2005, Oracle. All rights reserved.

Starting deinstall

Deinstall in progress (Mon Aug 25 14:14:23 CST 2014)

WARNING:The directory: /u01/app/oracle/product/10.2.0/db_1 will be deleted after deinstall.

Click on "Yes" to continue.

Click on "No" to perform deinstall without deleting the directory.

Click on "Cancel" to go back to "Inventory Dialog".

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

Deinstall successful

End of install phases.(Mon Aug 25 14:14:42 CST 2014)

End of deinstallations

Please check '/u01/app/oracle/oraInventory/logs/silentInstall2014-08-25_02-14-19PM.log' for more details.

在rac1節點上更新集群節點信息

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

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

Starting Oracle Universal Installer...

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.

'UpdateNodeList' was successful.

至此節點rac3刪除完畢

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved