如何添加节点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_ROLE DATABASE_STATUS
- ---------------- ---------- ----------------- ----------------------- ------------ --------- ------------------ -----------------
- racdb1 racnode1 10.2.0.5.0 27-DEC-2012 14:52:55 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
- racdb3 racnode3 10.2.0.5.0 27-DEC-2012 15:21:09 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
- racdb2 racnode2 10.2.0.5.0 27-DEC-2012 15:19:52 OPEN NORMAL PRIMARY_INSTANCE ACTIVE
- SQL> exit
- Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
- With the Partitioning, Real Application Clusters, OLAP, Data Mining
- and Real Application Testing options
- [oracle@racnode1 ~]$ crs_stat -t
- Name 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 -t
- Name 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 -t
- Name 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 -t
- Name 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 -t
- Name 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.loc
- The inventory is located at /u01/app/oracle/oraInventory
- 'UpdateNodeList' was successful.
- [oracle@racnode3 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES=racnode3" -local
- 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.loc
- The inventory is located at /u01/app/oracle/oraInventory
- 'UpdateNodeList' was successful.
在racnode3删除oracle database software
- [oracle@racnode3 bin]$ ./runInstaller -deinstall
- 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/OraInstall2012-12-27_05-33-49PM. Please wait ...[oracle@racnode3 bin]$ Oracle Universal Installer, Version 10.2.0.5.0 Production
- Copyright (C) 1999, 2010, Oracle. All rights reserved.
![](https://img-my.csdn.net/uploads/201212/27/1356601101_3112.jpg)
删除nodeapps gsd,ons,vip
- [oracle@racnode1 bin]$ srvctl stop nodeapps -n racnode3
- [oracle@racnode1 ~]$ su - root
- Password:
- [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 racnode3
- Please 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 -t
- Name 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 down
- Stopping 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 services
- Updating ocr file for downgrade
- Cleaning up SCR settings in '/etc/oracle/scls_scr'
- Cleaning up Network socket directories
- [root@racnode3 install]#
在racnode1使用root删除racnode3
- [oracle@racnode1 ~]$ olsnodes -n -i
- racnode1 1 racnode1-vip
- racnode2 2 racnode2-vip
- racnode3 3 <none>
- [oracle@racnode1 ~]$ su - root
- Password:
- [root@racnode1 ~]# cd /u01/app/oracle/product/10.2.0/crs/install
- [root@racnode1 install]# ./rootdeletenode.sh racnode3 3
- CRS nodeapps are deleted successfully
- clscfg: 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=TRUE
- 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.loc
- The 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 -local
- 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.loc
- The 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 -deinstall
- 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/OraInstall2012-12-27_06-04-51PM. Please wait ...[oracle@racnode3 bin]$ Oracle Universal Installer, Version 10.2.0.5.0 Production
- Copyright (C) 1999, 2010, Oracle. All rights reserved.
![](https://img-my.csdn.net/uploads/201212/27/1356602796_7786.jpg)
最后删除相关目录,asm,oraInventory,init等