如何添加节点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.
racnode3
[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.
删除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.
最后删除相关目录,asm,oraInventory,init等