Oracle 10g RAC 删除节点

来源：互联网发布：mysql 修改列属性编辑：程序博客网时间：2024/05/17 04:54

如何添加节点Oracle 10g RAC 添加节点

目前RAC环境如下,先要删除racdb3

SQL> select INSTANCE_NAME,HOST_NAME,VERSION,STARTUP_TIME,STATUS,ACTIVE_STATE,INSTANCE_ROLE,DATABASE_STATUS from gv$INSTANCE;INSTANCE_NAME HOST_NAME  VERSION      STARTUP_TIME      STATUS   ACTIVE_ST INSTANCE_ROLEDATABASE_STATUS---------------- ---------- ----------------- ----------------------- ------------ --------- ------------------ -----------------racdb1 racnode1   10.2.0.5.0      27-DEC-2012 14:52:55    OPEN   NORMAL    PRIMARY_INSTANCEACTIVEracdb3 racnode3   10.2.0.5.0      27-DEC-2012 15:21:09    OPEN   NORMAL    PRIMARY_INSTANCEACTIVEracdb2 racnode2   10.2.0.5.0      27-DEC-2012 15:19:52    OPEN   NORMAL    PRIMARY_INSTANCEACTIVESQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand Real Application Testing options[oracle@racnode1 ~]$ crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora.racdb.db   application    ONLINE    ONLINE    racnode2    ora....b1.inst application    ONLINE    ONLINE    racnode1    ora....b2.inst application    ONLINE    ONLINE    racnode2    ora....b3.inst application    ONLINE    ONLINE    racnode3    ora.....zwc.cs application    ONLINE    ONLINE    racnode1    ora....db1.srv application    ONLINE    ONLINE    racnode1    ora....SM1.asm application    ONLINE    ONLINE    racnode1    ora....E1.lsnr application    ONLINE    ONLINE    racnode1    ora....de1.gsd application    ONLINE    ONLINE    racnode1    ora....de1.ons application    ONLINE    ONLINE    racnode1    ora....de1.vip application    ONLINE    ONLINE    racnode1    ora....SM2.asm application    ONLINE    ONLINE    racnode2    ora....E2.lsnr application    ONLINE    ONLINE    racnode2    ora....de2.gsd application    ONLINE    ONLINE    racnode2    ora....de2.ons application    ONLINE    ONLINE    racnode2    ora....de2.vip application    ONLINE    ONLINE    racnode2    ora....SM3.asm application    ONLINE    ONLINE    racnode3    ora....E3.lsnr application    ONLINE    ONLINE    racnode3    ora....de3.gsd application    ONLINE    ONLINE    racnode3    ora....de3.ons application    ONLINE    ONLINE    racnode3    ora....de3.vip application    ONLINE    ONLINE    racnode3

停止racdb3的instance

[oracle@racnode1 ~]$ srvctl stop instance -d racdb -i racdb3[oracle@racnode1 ~]$ crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora.racdb.db   application    ONLINE    ONLINE    racnode2    ora....b1.inst application    ONLINE    ONLINE    racnode1    ora....b2.inst application    ONLINE    ONLINE    racnode2    ora....b3.inst application    OFFLINE   OFFLINE               ora.....zwc.cs application    ONLINE    ONLINE    racnode1    ora....db1.srv application    ONLINE    ONLINE    racnode1    ora....SM1.asm application    ONLINE    ONLINE    racnode1    ora....E1.lsnr application    ONLINE    ONLINE    racnode1    ora....de1.gsd application    ONLINE    ONLINE    racnode1    ora....de1.ons application    ONLINE    ONLINE    racnode1    ora....de1.vip application    ONLINE    ONLINE    racnode1    ora....SM2.asm application    ONLINE    ONLINE    racnode2    ora....E2.lsnr application    ONLINE    ONLINE    racnode2    ora....de2.gsd application    ONLINE    ONLINE    racnode2    ora....de2.ons application    ONLINE    ONLINE    racnode2    ora....de2.vip application    ONLINE    ONLINE    racnode2    ora....SM3.asm application    ONLINE    ONLINE    racnode3    ora....E3.lsnr application    ONLINE    ONLINE    racnode3    ora....de3.gsd application    ONLINE    ONLINE    racnode3    ora....de3.ons application    ONLINE    ONLINE    racnode3    ora....de3.vip application    ONLINE    ONLINE    racnode3

dbca删除racdb3

racdb3选择Not Used

可以看到racdb3的inst已经删除

[oracle@racnode1 ~]$ crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora.racdb.db   application    ONLINE    ONLINE    racnode2    ora....b1.inst application    ONLINE    ONLINE    racnode1    ora....b2.inst application    ONLINE    ONLINE    racnode2    ora.....zwc.cs application    ONLINE    ONLINE    racnode1    ora....db1.srv application    ONLINE    ONLINE    racnode1    ora....SM1.asm application    ONLINE    ONLINE    racnode1    ora....E1.lsnr application    ONLINE    ONLINE    racnode1    ora....de1.gsd application    ONLINE    ONLINE    racnode1    ora....de1.ons application    ONLINE    ONLINE    racnode1    ora....de1.vip application    ONLINE    ONLINE    racnode1    ora....SM2.asm application    ONLINE    ONLINE    racnode2    ora....E2.lsnr application    ONLINE    ONLINE    racnode2    ora....de2.gsd application    ONLINE    ONLINE    racnode2    ora....de2.ons application    ONLINE    ONLINE    racnode2    ora....de2.vip application    ONLINE    ONLINE    racnode2    ora....SM3.asm application    ONLINE    ONLINE    racnode3    ora....E3.lsnr application    ONLINE    ONLINE    racnode3    ora....de3.gsd application    ONLINE    ONLINE    racnode3    ora....de3.ons application    ONLINE    ONLINE    racnode3    ora....de3.vip application    ONLINE    ONLINE    racnode3

删除racdb3的asm instance

[oracle@racnode1 ~]$ srvctl stop asm -n racnode3[oracle@racnode1 ~]$ srvctl remove asm -n racnode3

racdb3的asm已经删除

[oracle@racnode1 ~]$ crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora.racdb.db   application    ONLINE    ONLINE    racnode2    ora....b1.inst application    ONLINE    ONLINE    racnode1    ora....b2.inst application    ONLINE    ONLINE    racnode2    ora.....zwc.cs application    ONLINE    ONLINE    racnode1    ora....db1.srv application    ONLINE    ONLINE    racnode1    ora....SM1.asm application    ONLINE    ONLINE    racnode1    ora....E1.lsnr application    ONLINE    ONLINE    racnode1    ora....de1.gsd application    ONLINE    ONLINE    racnode1    ora....de1.ons application    ONLINE    ONLINE    racnode1    ora....de1.vip application    ONLINE    ONLINE    racnode1    ora....SM2.asm application    ONLINE    ONLINE    racnode2    ora....E2.lsnr application    ONLINE    ONLINE    racnode2    ora....de2.gsd application    ONLINE    ONLINE    racnode2    ora....de2.ons application    ONLINE    ONLINE    racnode2    ora....de2.vip application    ONLINE    ONLINE    racnode2    ora....E3.lsnr application    ONLINE    ONLINE    racnode3    ora....de3.gsd application    ONLINE    ONLINE    racnode3    ora....de3.ons application    ONLINE    ONLINE    racnode3    ora....de3.vip application    ONLINE    ONLINE    racnode3

netca删除监听

lsnr资源已经删除

[oracle@racnode1 ~]$ crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora.racdb.db   application    ONLINE    ONLINE    racnode2    ora....b1.inst application    ONLINE    ONLINE    racnode1    ora....b2.inst application    ONLINE    ONLINE    racnode2    ora.....zwc.cs application    ONLINE    ONLINE    racnode1    ora....db1.srv application    ONLINE    ONLINE    racnode1    ora....SM1.asm application    ONLINE    ONLINE    racnode1    ora....E1.lsnr application    ONLINE    ONLINE    racnode1    ora....de1.gsd application    ONLINE    ONLINE    racnode1    ora....de1.ons application    ONLINE    ONLINE    racnode1    ora....de1.vip application    ONLINE    ONLINE    racnode1    ora....SM2.asm application    ONLINE    ONLINE    racnode2    ora....E2.lsnr application    ONLINE    ONLINE    racnode2    ora....de2.gsd application    ONLINE    ONLINE    racnode2    ora....de2.ons application    ONLINE    ONLINE    racnode2    ora....de2.vip application    ONLINE    ONLINE    racnode2    ora....de3.gsd application    ONLINE    ONLINE    racnode3    ora....de3.ons application    ONLINE    ONLINE    racnode3    ora....de3.vip application    ONLINE    ONLINE    racnode3

更新oraInventory

racnode1

[oracle@racnode1 bin]$ cd $ORACLE_HOME/oui/bin[oracle@racnode1 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES=racnode1,racnode2"Starting Oracle Universal Installer...No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.The inventory pointer is located at /etc/oraInst.locThe inventory is located at /u01/app/oracle/oraInventory'UpdateNodeList' was successful.

racnode3

[oracle@racnode3 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES=racnode3" -localStarting Oracle Universal Installer...No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.The inventory pointer is located at /etc/oraInst.locThe inventory is located at /u01/app/oracle/oraInventory'UpdateNodeList' was successful.

在racnode3删除oracle database software

[oracle@racnode3 bin]$ ./runInstaller -deinstallStarting 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/OraInstall2012-12-27_05-33-49PM. Please wait ...[oracle@racnode3 bin]$ Oracle Universal Installer, Version 10.2.0.5.0 ProductionCopyright (C) 1999, 2010, Oracle. All rights reserved.

删除nodeapps gsd,ons,vip

[oracle@racnode1 bin]$ srvctl  stop nodeapps -n racnode3[oracle@racnode1 ~]$ su - rootPassword: [root@racnode1 ~]# export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1[root@racnode1 ~]# cd /u01/app/oracle/product/10.2.0/db_1/bin[root@racnode1 bin]# ./srvctl remove nodeapps -n racnode3Please confirm that you intend to remove the node-level applications on node racnode3 (y/[n]) y[root@racnode1 bin]# su - oracle[oracle@racnode1 ~]$ crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora.racdb.db   application    ONLINE    ONLINE    racnode2    ora....b1.inst application    ONLINE    ONLINE    racnode1    ora....b2.inst application    ONLINE    ONLINE    racnode2    ora.....zwc.cs application    ONLINE    ONLINE    racnode1    ora....db1.srv application    ONLINE    ONLINE    racnode1    ora....SM1.asm application    ONLINE    ONLINE    racnode1    ora....E1.lsnr application    ONLINE    ONLINE    racnode1    ora....de1.gsd application    ONLINE    ONLINE    racnode1    ora....de1.ons application    ONLINE    ONLINE    racnode1    ora....de1.vip application    ONLINE    ONLINE    racnode1    ora....SM2.asm application    ONLINE    ONLINE    racnode2    ora....E2.lsnr application    ONLINE    ONLINE    racnode2    ora....de2.gsd application    ONLINE    ONLINE    racnode2    ora....de2.ons application    ONLINE    ONLINE    racnode2    ora....de2.vip application    ONLINE    ONLINE    racnode2    [oracle@racnode1 ~]$

使用root用户在racnode3关闭cluster

[root@racnode3 ~]# cd /u01/app/oracle/product/10.2.0/crs/install[root@racnode3 install]# ./rootdelete.sh CRS-0210: Could not find resource 'ora.racnode3.ons'.CRS-0210: Could not find resource 'ora.racnode3.vip'.CRS-0210: Could not find resource 'ora.racnode3.gsd'.Shutting down Oracle Cluster Ready Services (CRS):Dec 27 17:50:39.554 | INF | daemon shutting downStopping resources. This could take several minutes.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 servicesUpdating ocr file for downgradeCleaning up SCR settings in '/etc/oracle/scls_scr'Cleaning up Network socket directories[root@racnode3 install]#

在racnode1使用root删除racnode3

[oracle@racnode1 ~]$ olsnodes -n -iracnode11racnode1-vipracnode22racnode2-vipracnode33<none>[oracle@racnode1 ~]$ su - rootPassword: [root@racnode1 ~]# cd /u01/app/oracle/product/10.2.0/crs/install[root@racnode1 install]# ./rootdeletenode.sh racnode3 3CRS nodeapps are deleted successfullyclscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Node deletion operation successful.'racnode3' deleted successfully

在racnode1删除racnode3的clusterware

[oracle@racnode1 ~]$ cd $ORA_CRS_HOME/oui/bin[oracle@racnode1 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORA_CRS_HOME "CLUSTER_NODES=racnode1,racnode2" CRS=TRUEStarting Oracle Universal Installer...No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.The inventory pointer is located at /etc/oraInst.locThe inventory is located at /u01/app/oracle/oraInventory'UpdateNodeList' was successful.

在racnode3更新oraInventory

[oracle@racnode3 ~]$ cd $ORA_CRS_HOME/oui/bin[oracle@racnode3 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORA_CRS_HOME "CLUSTER_NODES=racnode3" CRS=TRUE -localStarting Oracle Universal Installer...No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.The inventory pointer is located at /etc/oraInst.locThe inventory is located at /u01/app/oracle/oraInventory'UpdateNodeList' was successful.

在racnode3上删除clusterware

[oracle@racnode3 ~]$ cd $ORA_CRS_HOME/oui/bin[oracle@racnode3 bin]$ ./runInstaller -deinstallStarting 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/OraInstall2012-12-27_06-04-51PM. Please wait ...[oracle@racnode3 bin]$ Oracle Universal Installer, Version 10.2.0.5.0 ProductionCopyright (C) 1999, 2010, Oracle. All rights reserved.

最后删除相关目录,asm,oraInventory,init等