RAC删除节点实验

1、Oracle RAC删除一个节点_3节点的实验1、主机名规划：#Public Network - (eth0)ITPUB个人空间-Z7s.,m D0m1 rac1ITPUB个人空间-x.NpDJTn*y*2 rac2#Private Interconnect - (eth1)ITPUB个人空间*XB h3Y,-V1 rac1priv|_u,H R*S)Zn7n.10.10.12 rac2priv#Public Virtual IP (VIP) addresses - (eth0)VG6!|D?z!R.168.110.21

2、rac1vipD.t.f+bt W/n.168.110.22 rac2vip2、删除数据库实例rac3主机的racdb3To start the database instance removal process, run the following from linux1:dbcainstance managementdelete instance查看状态如下：oraclerac1 $ crs_stat -t/Qjz,tN1iName Type Target State HostRg0O#kEB;-L1WqmlP J S%,eora.SM1.asm application ONLINE ON

3、LINE rac1ITPUB个人空间 y?+oau5O)_!cora.C1.lsnr application ONLINE ONLINE rac1YG7zK5 dora.rac1.gsd application ONLINE ONLINE rac1ITPUB个人空间 J0jERhora.rac1.ons application ONLINE ONLINE rac1ITPUB个人空间$P.fy1hh7nora.rac1.vip application ONLINE ONLINE rac1ITPUB个人空间&iG+zz ora.SM2.asm application ONLINE ONLINE r

4、ac2Ox)mY$Eora.C2.lsnr application ONLINE ONLINE rac2&c+pDH n+L+t1z,Oora.rac2.gsd application ONLINE ONLINE rac2zKYb+_;e+p-|#Mora.rac2.ons application ONLINE ONLINE rac2ITPUB个人空间?|Wb)?J/8zora.rac2.vip application ONLINE ONLINE rac2rEtM ora.SM3.asm application ONLINE ONLINE rac3ITPUB个人空间 lF_#q+O/H4A6x

5、ora.C3.lsnr application ONLINE ONLINE rac3M$aKwK)K/D2Tora.rac3.gsd application ONLINE ONLINE rac3ITPUB个人空间oMdj SQ(rYm |ora.rac3.ons application ONLINE ONLINE rac3T0o.MN/I9b-C I |)oKora.rac3.vip application ONLINE ONLINE rac3ITPUB个人空间#N7w7hT:o5Tuora.racdb.db application ONLINE ONLINE rac2ITPUB个人空间W0D

6、-x41TA9Kora.b1.inst application ONLINE ONLINE rac1ITPUB个人空间pn6s9s5D.?7yora.b2.inst application ONLINE ONLINE rac2ITPUB个人空间;x%vQi)c Kqlora.db_s.cs application ONLINE ONLINE rac13G$p/u0rL)Niora.db1.srv application ONLINE ONLINE rac17nof)N6K!*ufeora.db2.srv application ONLINE ONLINE rac23、删除ASM实例rac3主机

7、的+ASM3oraclerac1 $ srvctl stop asm -n rac3oraclerac1 $ srvctl remove asm -n rac3oraclerac1 $ crs_stat -t_,JFzDR0eh;RName Type Target State HostITPUB个人空间Pk)TBUh-A3$? hL6Fora.SM1.asm application ONLINE ONLINE rac1ITPUB个人空间 hK5E nyJ9|0T8Gora.C1.lsnr application ONLINE ONLINE rac1ITPUB个人空间9E!i W0b1P z:J

8、ora.rac1.gsd application ONLINE ONLINE rac1ITPUB个人空间X5?)V f(aora.rac1.ons application ONLINE ONLINE rac15Kr4ie0A L3Vdb_ora.rac1.vip application ONLINE ONLINE rac1(ixq/j6C4d4iqora.SM2.asm application ONLINE ONLINE rac2ITPUB个人空间Tz+s,ora.C2.lsnr application ONLINE ONLINE rac2ITPUB个人空间4RXH%Zxora.rac2.gs

9、d application ONLINE ONLINE rac2ct& U2UGAora.rac2.ons application ONLINE ONLINE rac2ITPUB个人空间,D.AWlI6Jora.rac2.vip application ONLINE ONLINE rac2ITPUB个人空间Z7U xE0mora.C3.lsnr application ONLINE ONLINE rac3G BH8rF&lFora.rac3.gsd application ONLINE ONLINE rac36u8rL|IfUora.rac3.ons application ONLINE ON

10、LINE rac3+yQk8iCo Tora.rac3.vip application ONLINE ONLINE rac3:x tFVxM.XtTora.racdb.db application ONLINE ONLINE rac2a$ic #$Sora.b1.inst application ONLINE ONLINE rac1ITPUB个人空间6v+O&y6f9A*Dora.b2.inst application ONLINE ONLINE rac2ITPUB个人空间QPjBKZ1ora.db_s.cs application ONLINE ONLINE rac10f+zy?(Y|ora

11、.db1.srv application ONLINE ONLINE rac1ITPUB个人空间 b _7obwo.z3Iurora.db2.srv application ONLINE ONLINE rac2Remove ASM Directories from the Node to be Deleted删除asm一些目录oraclelinux3 $ cd $ORACLE_BASE/adminoraclelinux3 $ rm -rf +ASMoraclelinux3 $ cd $ORACLE_HOME/dbsoraclelinux3 $ rm -f *ASM*Remove ASMLib

12、from the Node to be Deletedrootlinux3 # /etc/init.d/oracleasm stopN Wi.Fo7s;pDropping Oracle ASMLib disks: OK ITPUB个人空间 -g&U D7E6zShutting down the Oracle ASMLib driver: OK rootlinux3 # rpm -qa | grep oracleasmITPUB个人空间s!gZ6l$Tmoracleasm-2.6.18-128.el5-2.0.5-1.el5ITPUB个人空间2KI ?p#mWJ0oracleasmlib-2.0

13、.4-1.el5+qmV+cUoracleasm-support-2.1.3-1.el5rootlinux3 # rpm -ev oracleasm-2.6.18-128.el5-2.0.5-1.el5 oracleasmlib-2.0.4-1.el5 oracleasm-support-2.1.3-1.el5ds W iTZhwarning: /etc/sysconfig/oracleasm saved as /etc/sysconfig/oracleasm.rpmsaverootlinux3 # rm -f /etc/sysconfig/oracleasm.rpmsave|+p9p4T+P

14、n1iyrootlinux3 # rm -f /etc/sysconfig/oracleasm-_dev_oracleasm3n_7T,MO%xrootlinux3 # rm -f /etc/rc.d/init.d/oracleasmITPUB个人空间 G7x)H/nQMrootlinux3 # rm -f /etc/rc0.d/*oracleasm*E$QAN!m1C,P9v#Prootlinux3 # rm -f /etc/rc1.d/*oracleasm*ITPUB个人空间mzLHa|rootlinux3 # rm -f /etc/rc2.d/*oracleasm*ITPUB个人空间 U

15、B$T Gv JErootlinux3 # rm -f /etc/rc3.d/*oracleasm*ITPUB个人空间+Lh$m6x0W.u gRg24t,zrootlinux3 # rm -f /etc/rc4.d/*oracleasm*ITPUB个人空间0d8_ DBEM/rootlinux3 # rm -f /etc/rc5.d/*oracleasm*8I6s9gdrootlinux3 # rm -f /etc/rc6.d/*oracleasm4、删除监听listenerrac3主机的listener_RAC3ITPUB个人空间fv62uvP9tRemove the Listener F

16、rom the Node to be Deletednetcaoraclelinux3$ ps -ef | grep lsnr | grep -v grep | grep -v ocfs | awk print $95、删除数据库软件Remove the Oracle Database Software From the Node to be DeletedFrom the node to be deleted (linux3),cd $ORACLE_HOME/oui/binoraclelinux3$ DISPLAY=:0.0; export DISPLAYoraclelinux3 $ cd

17、$ORACLE_HOME/oui/binoraclelinux3 bin$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES= -localoraclerac bin$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES= -local#S%j-T ES7v%hStarting Oracle Universal Installer.No pre-requisite checks found in oraparam.in

18、i, no system pre-requisite checks will be executed.u$v1cCX3y0gThe inventory pointer is located at /etc/oraInst.locITPUB个人空间*ei&J)&G5kThe inventory is located at /oracle/app/oraInventoryITPUB个人空间1X1t8v,Q$e9IdUpdateNodeList was successful.ITPUB个人空间 qsW4y+-oraclelinux3 $ cd $ORACLE_HOME/oui/bin(E-S)Qcv

19、ynKoraclelinux3 bin$ ./runInstaller（选择de-install）再到第一台机上./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES=rac1,rac2ITPUB个人空间O3SE3EmmITPUB个人空间h$g%z8QpW)UStarting Oracle Universal Installer.No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be execut

20、ed.-a6/V5J-iZThe inventory pointer is located at /etc/oraInst.locp c5?|1IThe inventory is located at /oracle/app/oraInventoryITPUB个人空间9g O?S6l!TsoUpdateNodeList was successful.、删除这个节点从crs中Remove the Node to be Deleted from Oracle Clusterwareoraclerac3 bin$ $ORA_CRS_HOME/bin/racgons remove_config rac

21、3:6200ITPUB个人空间6D/eO(Wshell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directoryITPUB个人空间M9i5&f,O:$Lracgons: Existing key value on rac3 = 6200.4Vn Irracgons: rac3:6200 removed from OCR.oraclerac3 dbs$ grep remoteport $ORA_CRS_HOME/opmn/conf/on

22、s.configITPUB个人空间:Cq*j#kremoteport=6200oraclerac3 dbs$ $ORA_CRS_HOME/bin/oifcfg delif -node rac3_7A6 dO*z/LPROC-4: The cluster registry key to be operated on does not exist.F.nXaPRIF-11: cluster registry errorDisable Oracle Clusterware Applicationsrootrac3 install# ./rootdelete.sh local nosharedvar

23、nosharedhomeCRS-0210: Could not find resource ora.rac3.LISTENER_RAC3.lsnr.ITPUB个人空间R |lq9k$ctShutting down Oracle Cluster Ready Services (CRS):x%A;JQ5QxJun 06 22:58:39.893 | INF | daemon shutting downON/O F(p!MN xgSStopping resources. This could take several minutes.R.W HS;k_r(k(Successfully stopped

24、 CRS resources.hiw!YG4eGStopping CSSD.ITPUB个人空间 xc8Urx:o2I|r-MShutting down CSS daemon.ITPUB个人空间$zN%SKlmShutdown request successfully issued.ITPUB个人空间T+hjKV*T o!rShutdown has begun. The daemons should exit soon.#R8h?4T2h U2Checking to see if Oracle CRS stack is down.U-p0A)ra VK.*iOracle CRS stack is

25、 not running.7C&m+lBNnK1C JTOracle CRS stack is down now.i)c LH5R0f6ifMRemoving script. for Oracle Cluster Ready servicesITPUB个人空间ks F D)m/YUpdating ocr file for downgrade!wG0? O dl6?7m4RCleaning up SCR settings in /etc/oracle/scls_scrl)j.Q2bH/o/Delete Node from Cluster and Update OCRoraclerac1 $ $O

26、RA_CRS_HOME/bin/olsnodes -n1 H E2B.H0w*?C k;Jrac1 16N5a Sqx4brac2 2ITPUB个人空间2c,r Z,z pdr,JRrac3 3rootrac1 install# ./rootdeletenode.sh rac3,3FP$rT4j7R2x&BGCRS-0210: Could not find resource ora.rac3.LISTENER_RAC3.lsnr.5u8?*FIW8_yn wCRS-0210: Could not find resource ora.rac3.ons.E-NIPE)e-CRS-0210: Cou

27、ld not find resource ora.rac3.vip.ITPUB个人空间 h TN(y#(Ej&dCRS-0210: Could not find resource ora.rac3.gsd.l rEb:z WI|3OCRS-0210: Could not find resource ora.rac3.vip.ITPUB个人空间|+Im2YX-b1U2CRS nodeapps are deleted successfullyITPUB个人空间BZ:l8Pk-cuMclscfg: EXISTING configuration version 3 detected.2 IkKa!Xk

28、clscfg: version 3 is 10G Release 2.%u,l&jY*IWSuccessfully deleted 14 values from OCR.Mz9V_!8EKey SYSTEM.erfaces.noderac3 marked for deletion is not there. Ignoring.+2J#NIKYSuccessfully deleted 5 keys from OCR.i1 X4W,zs2aNode deletion operation successful.78t?4S%z.Srac3,3 deleted successfullyo

29、raclerac2 $ $ORA_CRS_HOME/bin/olsnodes -nITPUB个人空间,H%t+K!S!Krac1 1C Kt pq/LqpLnrac2 2Update Node List for Oracle Clusterware Software - (Remove linux3)1Jxtey2Noraclerac3 bin$ cd $ORA_CRS_HOME/oui/binITPUB个人空间Ed*d*n horaclerac3 bin$ ./runInstaller -updateNodeList ORACLE_HOME=$ORA_CRS_HOME CLUSTER_NOD

30、ES= -local CRS=trueITPUB个人空间 B0sK8|k7D%RStarting Oracle Universal Installer.No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.ITPUB个人空间,PE HK(g3 v.n+eXThe inventory pointer is located at /etc/oraInst.loc_ fW8ObVz2jThe inventory is located at /oracle/app/o

31、raInventoryITPUB个人空间W4Qk-DD lql .u;npUpdateNodeList was successful.jG%T V5DcADe-install Oracle Clusterware Softwarecd $ORA_CRS_HOME/oui/bin./runInstallerITPUB个人空间R:dP)k o#xP2s5G7、Update Node List for Remaining Nodes in the Clusteroraclelinux1 $ cd $ORA_CRS_HOME/oui/binZ!FM%F2N-_f Poraclelinux1 bin$

32、./runInstaller -updateNodeList ORACLE_HOME=$ORA_CRS_HOME CLUSTER_NODES=rac1,rac2 CRS=trueITPUB个人空间8w3usA%o2|4t dxStarting Oracle Universal Installer.7c |:l-v、Verify Node to be Deleted is no Longer a Member of the Clusteroraclerac1 bin$ srvctl status nodeapps -n rac3ITPUB个人空间h CZX L-|PRKC-1056 : Failed to get the hostname for node rac3ITPUB个人空间$ci(_0mPM BHPRKH-1001 : HASContext Internal ErrorITPUB个人空间B;FQM ib7z Z OCR Error(Native: getHostName:21)ITPUB个人空间+c,Q,y&IGhoraclerac1 bin$ $ORA_CRS_HOME/bin/crs_stat | grep -i rac3!j0VD%xoraclerac1 bin$ $ORA_CRS_HOME/bin/olsnodes -