如何添加节点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等