RAC增加节点实验

1、Oracle RAC增加一个节点_3节点的实验1、主机名规划：#Public Network - (eth0)ITPUB个人空间:n 3D0P)J/xPv192.168.110.11 rac1ITPUB个人空间TL#WML7I1luZ,C192.168.110.12 rac2ITPUB个人空间-Y)PpI#fjxg F192.168.110.13 rac3#Private Interconnect - (eth1)ITPUB个人空间a01Xs3Zi E10.10.10.11 rac1privBz!G V s/YS+M jt.10.10.12 rac2privITPUB个人空间 D2.Tum y

2、C&U10.10.10.13 rac3priv#Public Virtual IP (VIP) addresses - (eth0)rY9X9jh#T.168.110.21 rac1vipITPUB个人空间+IMF&U0Ba192.168.110.22 rac2vip&A v?5f.z R 9L.168.110.23 rac3vip2、配置与rac1与rac2一样的环境，包括创建用户，环境变量，验证等。3、Install Oracle Clusterware on the new node在第一个节点上操作以下:J H.y!Uacd $CRS_HOME/oui/binITPUB个人空间T p

3、_!nfj./addNode.sh根据提示完成第个节点的crs安装，安装完后成，运行以下脚本：(T1 E D Ti/oracle/app/oraInventory/orainstRoot.sh rac3ITPUB个人空间)wY(c qL%/oracle/app/crs/install/rootaddnode.shrac1ITPUB个人空间5e B aU y&8wg5dc/oracle/app/crs/root.shrac3详细日志如下：rootrac3 # /oracle/app/oraInventory/orainstRoot.shITPUB个人空间1?&qG|z6FZChanging pe

4、rmissions of /oracle/app/oraInventory to 770.ITPUB个人空间4EF.i;U Changing groupname of /oracle/app/oraInventory to oinstall.ITPUB个人空间3nSz _kd_*xThe execution of the script. is completek7K69l9 mrootrac1 # /oracle/app/crs/install/rootaddnode.shS|3m)pJ E i3uZm)yclscfg: EXISTING configuration version 3 det

5、ected.ITPUB个人空间 BB_#Y?Lclscfg: version 3 is 10G Release 2.ITPUB个人空间.z3J$j+2nAttempting to add 1 new nodes to the configurationITPUB个人空间P!o&5LUsing ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.ITPUB个人空间8lR7uXiw,R9tnode : c#U(s4HN0node 3: rac3 rac3priv rac3ITPUB个人空间&mJ-hh+Creating OCR keys for

6、 user root, privgrp root.RmnWi:C*cssOperation successful.,SfI4S s*M%J/oracle/app/crs/bin/srvctl add nodeapps -n rac3 -A rac3vip/255.255.255.0/eth0 -o /oracle/app/crs5a_VZl:orootrac3 # /oracle/app/crs/root.sh#U rhp,&C!kWARNING: directory /oracle/app is not owned by root6R8c kwwrw%rWARNING: directory

7、/oracle is not owned by rootITPUB个人空间3)HN8_?ZRChecking to see if Oracle CRS stack is already configured;dO.Bd)MI9m;d$/etc/oracle does not exist. Creating it now.-|#l9Wi Ge5rOCR LOCATIONS = /dev/raw/raw1LBH4Hr?EJ5OCR backup directory /oracle/app/crs/cdata/crs does not exist. Creating nowITPUB个人空间 why

8、m$B;cSetting the permissions on OCR backup directoryZFBCvirFSetting up NS directories7hXt1O7j M5kw%|Oracle Cluster Registry configuration upgraded successfullyClu6V2aP/om.tOWARNING: directory /oracle/app is not owned by rootITPUB个人空间a&p&h_%IWARNING: directory /oracle is not owned by rootITPUB个人空间Wv+

9、mt$ao4besclscfg: EXISTING configuration version 3 detected.ITPUB个人空间K wUk_&Dclscfg: version 3 is 10G Release 2.ITPUB个人空间 N7$k.H;MSuccessfully accumulated necessary OCR keys.-Q1G4E-s(TK f ukUsing ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.u9v:SP)r!bODWnode : ITPUB个人空间M3G3|y._1nnode 1: rac1

10、rac1priv rac1ITPUB个人空间0ZbP1o o+Z$node 2: rac2 rac2priv rac2ITPUB个人空间J.x+ntTa Xa3vdjkclscfg: Arguments check out successfully.NO KEYS WERE WRITTEN. Supply -force parameter to override.ITPUB个人空间v7U,NAuR-force is destructive and will destroy any previous clusterITPUB个人空间*L G/i.g4/Wconfiguration.ITPUB个人

11、空间 wiu8x;NOracle Cluster Registry for cluster has already been initialized;S)v5FTg*GRStartup will be queued to init within 30 seconds.ITPUB个人空间J9n8G8oyqBAdding daemons to inittabqOhf+V3k2b/v6w|Expecting the CRS daemons to be up within 600 seconds.ITPUB个人空间j xg)?m0YZ1s:qkCSS is active on these nodes.

12、&Q#gYj(mf ODO T rac1ITPUB个人空间PN,V9n%?n rac2Fn8.k$V*B.E rac3ITPUB个人空间NMlW;wj*a QCSS is active on all nodes.ITPUB个人空间_8w3ku)D L(TWaiting for the Oracle CRSD and EVMD to startITPUB个人空间)FF1N&OX&t-RUWaiting for the Oracle CRSD and EVMD to startph;_1rjbTq6BWaiting for the Oracle CRSD and EVMD to startITPU

13、B个人空间rYeOH6IFGWaiting for the Oracle CRSD and EVMD to start62e-kQ.lB bH:yWaiting for the Oracle CRSD and EVMD to startITPUB个人空间B2R+(u-Y2%iWaiting for the Oracle CRSD and EVMD to start%E1y fA Waiting for the Oracle CRSD and EVMD to start8u C7R+k/p9|R;Waiting for the Oracle CRSD and EVMD to startITPUB

14、个人空间i|fV9Bkyo kWaiting for the Oracle CRSD and EVMD to startStFk-LLOracle CRS stack installed and running under init(1M)ITPUB个人空间%?s9u J6q(y4CRunning vipca(silent) for configuring nodeappsCreating VIP application resource on (0) nodes.w9R2d B_,/kCreating GSD application resource on (0) nodes.*U-J F&

15、VLqCreating ONS application resource on (0) nodes.J7l h*?uStarting VIP application resource on (2) nodes.m3whcr9S#oDStarting GSD application resource on (2) nodes.JOIdI12i E1uRStarting ONS application resource on (2) nodes.&j MDone.4、ITPUB个人空间gU!Iy)(qA6Toraclerac1 $ cat $CRS_HOME/opmn/conf/ons.confi

16、gITPUB个人空间9yu.+f6L53VYlocalport=6113!*u-,fD-Premoteport=6200W:z2A:A#cmzloglevel=3ITPUB个人空间/GI d%fyhuseocr=on?0Mm|$L? syoraclerac1 $ $CRS_HOME/bin/racgons add_config rac3:6200ITPUB个人空间,K9?n,sX3horaclerac3 $ olsnodesITPUB个人空间6c$G1L/v.rac1#*Bx9CbWrac2R;P OR9drac3ITPUB个人空间p6Ag Z.g ;qucQ1U操作后，状态如下：ITPUB个

17、人空间)jz Ci6f,e &wCu,Uoraclerac1 $ crs_stat -tITPUB个人空间TM4t%AQName Type Target State HostITPUB个人空间3WI?4v!CU-ITPUB个人空间zpN$Sora.SM1.asm application OFFLINE OFFLINEITPUB个人空间6upt8II PF3O0(lora.C1.lsnr application ONLINE ONLINE rac1#Oi$pUMLu9|1VPora.rac1.gsd application ONLINE ONLINE rac1kC(z#Q0B(B3J$|_ora

18、.rac1.ons application ONLINE ONLINE rac13w & v;F-dff;Eora.rac1.vip application ONLINE ONLINE rac1ITPUB个人空间 9zy5u6 Kora.SM2.asm application OFFLINE OFFLINEi5g S6)u$UFora.C2.lsnr application ONLINE ONLINE rac2ITPUB个人空间9l$uPklc8mora.rac2.gsd application ONLINE ONLINE rac2ITPUB个人空间5j/5dl:7oora.rac2.ons

19、application ONLINE ONLINE rac2ITPUB个人空间-OEP$)eora.rac2.vip application ONLINE ONLINE rac2;xs i9H5F$z l&vora.rac3.gsd application ONLINE ONLINE rac3ITPUB个人空间wF 1h#UK-Mora.rac3.ons application ONLINE ONLINE rac3&c XN,wA g2yora.rac3.vip application ONLINE ONLINE rac31qO(gL s_.K6gzN:xora.racdb.db applic

20、ation OFFLINE OFFLINE)vD6A wf8pora.b1.inst application OFFLINE OFFLINEITPUB个人空间 KS$_?ora.b2.inst application OFFLINE OFFLINEITPUB个人空间U2zU*K;L-wora.db_s.cs application OFFLINE OFFLINEITPUB个人空间l+ST1m)Lt8z,v4aora.db1.srv application OFFLINE OFFLINE.Go q:gz8Ypora.db2.srv application OFFLINE OFFLINE、Inst

21、all Oracle RDBMS and ASM Home on the new node在第一个节点上操作以下:ITPUB个人空间7a N8R cd $ORACLE_HOME/oui/binwDA8d W./addNode.sh完成后，执行：ITPUB个人空间5Rw3A 3v9i/oracle/app/product/10.2.0/db_1/root.shrac36、Configure the Listener on the new NodeThe following steps need to be done on node3:$ORACLE_HOME/bin/netca只选择rac3进行

22、配置、Create an ASM Instance on the new node.The following steps need to be done on node1:Login as the Oracle user and set the environment to ASM home.$ORACLE_HOME/bin/dbca先配，再建选择instance managementadd instance创建完成后，状态如下：o|i+fL3Xoraclerac3 admin$ crs_stat -tITPUB个人空间 svj$Cp/_tName Type Target State Hos

23、t&W1Q*e9S#M%W+r-2nbG(pQ,dora.SM1.asm application ONLINE ONLINE rac1ITPUB个人空间-l7n-AAB J8Prora.C1.lsnr application ONLINE ONLINE rac13m*ch*d:s3+o2vora.rac1.gsd application ONLINE ONLINE rac1&O-k_Jl/g;cora.rac1.ons application ONLINE ONLINE rac1iu!|de6u,I S9oora.rac1.vip application ONLINE ONLINE rac1!n|;6dMora.SM2.asm application ONLINE ONLINE rac2+m|re t%b m1Pora.C2.lsnr application ONLINE ONLINE rac2ITPUB个人空间6s/l4sxora.rac2.gsd application ONLINE ONLINE rac27_AfI*FBv/xtora.rac2.ons application ONLINE ONLINE rac24XO