RAC应用集群介绍

1、RAC应用集群一实施规划平台：操作系统： RedHat Enterprise Linux Advanced Server 5.0内存大小小： 220488M交换空间间： 220488M硬盘空间间： 110G网卡配置置： 22（puubliic IIP，VVituual IP ,Prrivaate IP）主机结点点：2（nodde1，nodde2）存储设备备：1 （DBB fiies）网络规划划Nodee1 公共共 1922.1668.1100.1011Nodee2 公共共 1922.1668.1100.1022Nodee1-vvip 虚虚拟 1992.1168.1000.2001Nodee2-

2、vvip 虚虚拟 1992.1168.1000.2002Nodee1-pprivv 专专用 199.1668.1100.1011Nodee2-pprivv 专专用 199.1668.1100.1022安装流程程安装虚虚拟机vvmwaare Serrverr 1.0.99安装RRHELL5.44配置RRHELL操作系系统复制第第二台虚虚拟机配置双双机信任任关系建立AASM存存储安装cclussterrwarre软件件安装ddataabasse软件件配置监监听Liisteenerr建立数数据库实实例二新建建虚拟机机1选择择-新新建，虚虚拟机名名为RAAC1，loccatiion为为F:vmwwar

3、eeRAAC1，网卡接接口选择择桥接网网络方式式(Usse bbriddgedd neetwoorkiing)，适配配器选择择LSII Loogicc，虚拟拟硬盘选选择SCCSI，硬盘容容量选择择10GG，然后后选择每每次扩充充扩充22G(SSpliit ddiskk innto 2GBB fiiless)，不不选择立立即分配配。然后按AAdd添添加硬盘盘，先添添加一个个1000M的硬硬盘，选选择立即即分配方方式(AAlloocatte aall dissk sspacce nnow)，该盘盘作为VVotiingDDiskk盘，目目录存放放位置为为F:vmwwareeshhareedisskV

4、Votiingddiskk，虚拟拟设备结结点选择择SCSSI 11：1 Harrd DDiskk2，模模式选择择一致即即：inndeppenddentt-pperssisttentt。然后再添添加一个个1000M的硬硬盘，选选择立即即分配，该盘作作为OCCRdiisk盘盘，目录录存放位位置为：F:vmwwareeshhareedisskOOCRddiskk，硬盘盘选择SSCSII 1：2，模模式为 一致。再添加一一个2GG的硬盘盘用作AASM的的数据文文件的空空间，选选择立即即分配和和2G扩扩充一个个文件，目录位位置为FF:vvmwaareshaareddiskkASSMdiisk，硬盘选选择

5、SCCSI 1：33，模式式选择一一致。再添加一一个1.3G的的硬盘用用作ASSM的闪闪回区，选择立立即分配配，目录录位置为为F:vmwwareeshhareedisskAASMddiskk2，硬硬盘选择择SCSSI 11：4，模式选选择一致致性。再添加一一块网卡卡，用作作两台虚虚拟机之之间的通通信，连连接方式式选择HHostt-onnly模模式并选选择（cconnnectt att poowerr onn）。2. 开开启该虚虚拟机，安装RRHELL 5.4，注注意事项项：交换分区区分2GG，主机机名为nnodee1，eeth00为1992.1168.1000.1001，eeth11为199.

6、1668.1100.1011 作为为nodde1-priiv，自自定义安安装包时时，选择择开发、服务器器以及基基本系统统的全部部，防火火墙关闭闭，seelinnux设设为ennablled禁禁用。安装好之之后，编编辑F:vmmwarreRRAC11Reed HHat Linnux.vmxx，添加加如下一一段（可可以使那那四个磁磁盘真正正的作为为共享盘盘）：diskk.loockiing = “fallse”diskklibb.daataCCachheMaaxSiize = “0”diskklibb.daataCCachheMaaxReeadAAheaadSiize = “0”diskklibb

7、.daataCCachheMiinReeadAAheaadSiize = “0”diskklibb.daataCCachhePaageSSizee = “40996”diskklibb.maaxUnnsynnceddWriitess = “0”scsii1:11.deevicceTyype = “dissk”scsii1:22.deevicceTyype = “dissk”scsii1:33.deevicceTyype = “dissk”scsii1:44.deevicceTyype = “dissk”RHELL系统配配置#unaame r2.6.1288-1664.eel5#vimm /et

8、tc/hhostts（加加上如下下一段）192.1688.1000.1101 nodde1192.1688.1000.1102 nodde2192.1688.1000.2201 nodde1-vipp192.1688.1000.2202 nodde2-vipp19.1168.1000.1001 nodde1-priiv19.1168.1000.1002 nodde2-priiv#vimm /eetc/syssctll.coonf（加上如如下一段段）Kernnel.shmmalll = 209971552Kernnel.shmmmaxx = 536687009122Kernnel.shmmmni

9、i = 40996Kernnel.semm = 2500 3220000 1000 1128Fs.ffilee-maax = 6555366Net.ipvv4.iip_llocaal_pportt_raangee = 10224 6650000Net.corre.rrmemm_deefauult = 1104885766Net.corre.rrmemm_maax = 100485576Net.corre.wwmemm_deefauult = 22621144Net.corre.wwmemm_maax = 26621444#syssctll p （是该文文件生效效）#vimm /eetc/sec

10、curiity/limmitss.coonf（加上如如下一段段）Oraccle sooft npprocc 220477Oraccle haard npprocc 1163884Oraccle sooft noofille 10224Oraccle haard noofille 655536#vimm /eetc/pamm.d/loggin（加上如如下一段段）Sesssionn reqquirred /libb/seecurrityy/paam_llimiits.so#vimm /eetc/rc.loaal (挂起检检测时间间定时器器，检测测对方有有没有宕宕机)Modpprobbe hanng

11、chheckk-tiimerr haangcchecck-ttickk=300 haangcchecck_mmarggin=20#grooupaadd oinnstaall#grooupaadd dbaa#useeraddd m g ooinsstalll G ddba#passswdd orraclle#vimm /hhomee/orraclle/.bassh_pproffileeExpoort TMPPDIRR=/ttmpExpoort ORAACLEE_BAASE=/u001/aapp/oraacleeExpoort ORAACLEE_HOOME=$ORRACLLE_BBASEE/prr

12、oduuct/10.2.00/dbb_1Expoort ORAACLEE_SIID=RRACDDB1Expoort ORAACLEE_TEERM=xteermExpoort PATTH=$ORAACLEE_HOOME/binn:/uusr/binn:$PPATHHExpoort LD_LIBBRARRY_PPATHH=$OORACCLE_HOMME/bbin:/biin:/usrr/biin:/usrr/loocall/biin:/usrr/X111R66/biinExpoort CLAASSPPATHH=$OORACCLE_HOMME/JJRE:$ORRACLLE_HHOMEE/jllib:

13、$ORRACLLE_HHOMEE/rddbmss/jllibUlimmit u 1163884 n 6655336Umassk 0022#mkddir p /u011/appp/ooraccle#choown R ooraccle:oinnstaall /u001#chmmod R 7775 /u001#fdiisk /deev/ssdb#fdiisk /deev/ssdc#fdiisk /deev/ssdd#fdiisk /deev/ssde#parrtprrobee#rpmm ivhh orraclleassm-ssuppportt-*#rpmm ivhh ooraccleaasm-2.6

14、6.188-1664.eel5.*#rpmm ivhh ooraccleaasmllib*#rpmm ivhh coompaat-ggcc-7.33.2-2.996.1128.i3886.rrpm#rpmm Uvh commpatt-liibsttdc+-77* -forrce#rpmm ivhh coompaat-llibsstdcc-devvel-7.33.2#rpmm ivhh coompaat-ggcc-c+* #serrvicce ooraccleaasm connfiggureeOraccleOinsstalllYY#vimm /eetc/udeev/rrulees.dd/600-

15、raaw.rrulees(加加上如下下一段)ACTIION=”addd”,KEERNEEL=”/deev/ssdb11”,RUUN+=”/biin/rraw /deev/rraw11 %NN”ACTIION=”addd”,ENNVMMAJOOR=”8”,ENNVMMINOOR=”17”,RUUN+=”/biin/rraw /deev/rraw/raww1 %M %m” (其中的主主设备号号可以通通过lss l /devv/sdd*查看看)ACTIION=”addd”,KEERNEEL=”/deev/ssdc11”,RUUN+=”/biin/rraw /deev/rraw22 %NN”ACTII

16、ON=”addd”,ENNVMMAJOOR=”8”,ENNVMMINOOR=”33”,RUUN+=”/biin/rraw /deev/rraw/raww2 %M %m”KERNNEL=”raww1-2”,OWWNERR=”oraaclee”,GRROUPP=”oinnstaall”,MOODE=”6400”#staart_udeev#ls l /deev/rraw/*#shuutdoown h noww三复制制出第二二台虚拟拟机1.将复复制之后后的名称称为RAAC1的的改为RRAC22，另外外编辑RRed Hatt Liinuxx.vmmx查找找文件中中的RAAC1将将它改为为RACC2，然然

17、后编辑辑RACC2.vvmdkk将文件件中的RRAC11改为RRAC22（如下下所示）:RW 4419222566 SPPARSSE “RACC2-ss0011.vmmdk”RW 4419222566 SPPARSSE “RACC2-ss0022.vmmdk”RW 4419222566 SPPARSSE “RACC2-ss0033.vmmdk”RW 4419222566 SPPARSSE “RACC2-ss0044.vmmdk”RW 4419222566 SPPARSSE “RACC2-ss0055.vmmdk”RW 1102440 SSPARRSE “RACC2-ss0066.vmmdk”2

18、.打开开RACC2，选选择Crreatte3.配置置nodde2操操作系统统#hosstnaame nodde2#vimm /eetc/syssconnfigg/neetwoorkHOSTTNAMME=nnodee2#vimm /eetc/hossts127.0.00.1 nnodee2 llocaalhoost.loccalddomaain loccalhhostt#cd /ettc/ssyscconffig/nettworrk-sscriiptss/#catt iffcfgg-etth0.bakk#catt iffcfgg-etth0#catt iffcfgg-etth1.bakk#cat

19、t iffcfgg-etth1#mv ifccfg-ethh0.bbak ifccfg-ethh0#mv ifccfg-ethh1.bbak ifccfg-ethh1#ifcconffig etth0 | ggrepp HWWadddr#catt iffcfgg-etth0 | ggrepp ADDDR#ifcconffig etth1 | ggrepp Hwwadddr#catt iffcfgg-etth1 | ggrepp ADDDR#catt /hhomee/orraclle/.bassh_pproffilee | greep OORACCLE_SIDDExpoort ORRACLLE_

20、SSID=RACCDB22#pinng nnodee1#pinng nnodee2#pinng nnodee1-pprivv#pinng nnodee2-pprivv4.时间间同步Nodee2# sssh nnodee1Nodee1# seerviice xinnetdd sttarttNodee1# chhkcoonfiig ttimee-sttreaam oonNodee1# chhkcoonfiig xxineetd onNodee1# chhkcoonfiig nntpdd onnNodee1#serrvicce nntpdd reestaartNodee1#exiitNodee2#c

21、roontaab e0-599/1 * * * * rddatee s 1192.1688.1000.11010-599/1 * * * * nntpddatee 1992.1168.1000.1001Nodee2# /ettc/rresoolv.connfNodee2# sssh nnodee1Nodee1# /ettc/rresoolv.connf四配置置双机信信任关系系Nodee1#su orraclleNodee1$mkddir .ssshNodee1$chmmod 7000 .ssshNodee1$ sssh-kkeyggen t rsaaNodee1$ sssh-kkeyggen

22、-tt ddsaNodee2#su orraclleNodee2$mkddir .ssshNodee2$chmmod 7000 .ssshNodee2$sshh-keeygeen -t rsaaNodee2$sshh-keeygeen -t dssaNodee1$ caat /hoome/oraaclee/.sssh/id_rsaa.puub /homme/ooraccle/.sssh/aauthhoriizedd_keeysNodee1$ caat /hoome/oraaclee/.sssh/id_dsaa.puub /homme/ooraccle/.sssh/aauthhoriizedd_

23、keeysNodee1$sshh noode22 caat /homme/ooraccle/.sssh/iid_rrsa.pubb /hhomee/orraclle/.sshh/auuthoorizzed_keyysNodee1$sshh noode22 caat /homme/ooraccle/.sssh/iid_ddsa.pubb /hhomee/orraclle/.sshh/auuthoorizzed_keyysNodee1$ sccp /homme/ooraccle/.sssh/aauthhoriizedd_keeys noode22:/hhomee/orraclle/.sshh/au

24、uthoorizzed_keyys五配置置ASMMNodee1#serrvicce ooraccleaasm connfiggureeNodee1#serrvicce ooraccleaasm creeateedissk vvol11 /devv/sddd1Nodee1#serrvicce ooraccleaasm creeateedissk vvol22 /devv/sdde1Nodee1#serrvicce ooraccleaasm scaandiiskssNodee1#serrvicce ooraccleaasm lisstdiiskssNodee1#sshh noode22Nodee2

25、#serrvicce ooraccleaasm scaandiiskssNodee2#serrvicce ooraccleaasm lisstdiiskssNodee2#exiitNodee1#cd /orradiiskNodee1#unzzip oraaclee10gg01_cluusteer*Nodee1#choown R ooraccle:oinnstaall /ooraddiskkNodee1#chmmod R 7775 /orradiisk然后注销销以orraclle登录录Nodee1$cd /orradiisk/cluusteerwaare/cluuvfyyNodee1$./rru

26、nccluvvfy.sh staage pree ccrsiinstt -n nodde1.nodde2 -vverbboseeNodee1$expportt LAANG=en_USNodee1$/orradiisk/cluusteerwaare/runnInsstalllerr -ignnoreeSyssPreeReqqs这里注意意1.安安装路径径为/uu01/appp/orraclle/pprodductt/100.2.0/ccrs_1 22.Sppeciify Cllustter Connfigguraatioon 中中添加上上nodde2的的信息 3.SSpeccifyy Neetwo

27、ork Intterffacee Ussagee中检查查一下eeth00和etth1的的接口类类型有没没有反，应该eeth00为puubliic，eeth11为prrivaate。 4.指指定OCCR配置置的路径径为/ddev/raww/raaw1，外部存存储 5.指指定VootinngDiisk的的路径为为/deev/rraw/raww2，外外部存储储 6.安安装过程程中最重重要的：在noode22上用nntpddatee 1992.1168.1000.1001与nnodee1同步步（手工工进行且且最好是是每两三三秒同步步一次）。 7.当当安装完完成即出出现要执执行两个个文件的的窗口时时，一

28、定定要将如如下步骤骤操作完完之后才才可以点点击OKK。Nodee1#/u001/aapp/oraaclee/orraInnvenntorry/ooraiinsttRooot.sshNodee2#/u001/aapp/oraaclee/orraInnvenntorry/ooraiinsttRooot.sshNodee1#/u001/aapp/oraaclee/prroduuct/10.2.00/crrs_11/rooot.sh（注意，在这里里的执行行过程中中要查看看/deev/rraw/raww*是不不是属于于oraaclee和oiinsttalll组）Nodee2#/u001/aapp/ora

29、aclee/prroduuct/10.2.00/crrs_11/rooot.sh(在这里里执行完完会报错错，此时时要修改改/u001/aapp/oraaclee/prroduuct/10.2.00/crrs_11/biin/vvipcca和ssrvcctl )如下下所示：Nodee2#vimm viipcaaif “Sarrch” = “i6886”o “Sarrch” = “ia664” thenn LD_ASSSUMEE_KEERNEEL=22.4.19 expportt LDD_ASSSUMME_KKERNNELfiunseet LLD_AASSUUME_KERRNELL （加上这这句话

30、）Nodee2#vimm srrvcttlLD_AASSUUME_KERRNELL=2.4.119expoort LD_ASSSUMEE_KEERNEELunseet LLD_AASSUUME_KERRNELL（*） NNodee2#/u001/aapp/oraaclee/prroduuct/10.2.00/crrs_11/rooot.shNodee2#cd /u001/aapp/oraaclee/prroduuct/10.2.00/crrs_11/biin/Nodee2#expportt LLANGG=enn_USS.UTTF-88Nodee2#./vvipcca (会报报错)Nodee2#

31、./ooifccfg iifliistNodee2#./ooifccfg seetiff -glooball eeth00/1992.1168.1000.0:pubbliccNodee2#./ooifccfg seetiff -glooball eeth11/199.1668.1100.0:cclussterr_innterrconnnecctNodee2#./ooifccfg geetiffNodee2#./vvipcca （该项项配置过过程中注注意两个个vipp的配置置，完成成之后回回到noode11上的cclussterrwarre安装装界面点点击okk）集群软件件安装完完成之后后：No

32、dee1#cd /u001/aapp/oraaclee/prroduuct/10.2.00/crrs_11/biinNodee1#./ccrs_staat -tt (可可以看到到有六个个)Nodee1#sshh noode22Nodee2#cd /u001/aapp/oraaclee/prroduuct/10.2.00/crrs_11/biinNodee2#./ccrs_staat -tNodee2#./ccrs_stoop oraa.noode22.viipNodee2#./ccrs_staart orra.nnodee2.vvipNodee2#taiil -3 /ettc/iinittta

33、bbNodee1#taiil -3 /ettc/iinitttabb六Cllustterwwaree卸载自动卸载载：$ORRACLLE_HHOMEE/innstaall/roootdeelette.ssh$ORRACLLE_HHOMEE/innstaall/roootdeeinsstalll.ssh手工卸载载：#srvvctll sstopp noodeaappss n nnodee1#rm -rrvf /eetc/oraaclee/*#rm -rrvf /eetc/iniit.dd/innit.*#rm -rrvf /eetc/rc33.d/*.ccrs#rm -rrvf /eetc/rc5

34、5.d/*.ccrs#cp /eetc/iniittaab.oorigg /etcc/innitttab#ps ef | ggrepp crrs#ps ef | ggrepp csss#ps ef | ggrepp evvm#rm rvff /tmpp/.ooraccle/*#rm rvff /vvar/tmpp/.ooraccle/*#rm -rrvf /uu01/appp/orraclle/*#dd if=/deev/zzeroo oof=/devv/Vootinngdiisk bs=10224 ccounnt=11000000#dd if=/deev/zzeroo oof=/devv/O

35、CCRdiisk bbs=110244 coountt=10000000#dd if=/deev/zzeroo oof=/devv/ASSMdiisk bbs=110244 coountt=200000000#dd if=/deev/zzeroo oof=/devv/ASSMdiisk22 bbs=110244 coountt=133000000#shuutdoown r nnow七安装装数据库库软件检查：Nodee1#catt /eetc/hosstsNodee1#catt /eetc/syssctll.coonfNodee1#catt /etcc/seecurrityy/liimitts.

36、cconffNodee1#catt /etcc/paam.dd/looginnNodee1#catt /etcc/reedhaat-rreleeaseeNodee1#catt /hhomee/orraclle/.bassh_pproffilee注销以ooraccle用用户登录录Nodee1$cd /orradiisk/dattabaaseNodee1$./rrunIInsttalller ignnoreeSyssPreeReqqs注意在指指定路径径时的路路径：/u011/appp/ooraccle/prooducct/110.22.0/db_1 在SSpeccifyy Haardwwaree

37、Cllustter Insstalllattionn Moode然然后将nnodee1和nnodee2都勾勾选上。八.配置置监听选择集群群配置（Cluusteer cconffiguurattionn）两个结点点都选上上Nodee1$cd /uu01/appp/orraclle/pprodductt/100.2.0/ccrs_1/bbin/Nodee1$./ccrs_staat -tNodee1$./ccrs_staat |mooreNodee1$./ccrs_staat -p |mooreNodee1$sshh noode22Nodee2$cd /uu01/appp/orraclle/ppr

38、odductt/100.2.0/ccrs_1/bbin/Nodee2$./ccrs_staat -tNodee2$./ccrs_staat | mmoree (查查询每个个namme的具具体信息息)Nodee2$./ccrs_staat p |morre（查查询更具具体的信信息）九建立立数据库库实例Nodee1$dbcca安装的数数据库的的名称为为RACCDB选择ASSM自动动存储管管理创建初始始化参数数文件的的路径为为：ORRACLLE_BBASEE/addminn/+AASM/pfiile/iniit.ooraASM的的两个磁磁盘建立立成为外外部的，一个命命名为RRAC_VOLLGRPP1

39、,另另一个命命名为FFLASSH_RRECOOVERRY_AAREAADataabaee coompoonennt中的的em仓仓库可选选可不选选字符集选选成ZHHS166GBKK安装完成成之后：Nodee1$cd /u001/aapp/oraaclee/prroduuct/10.2.00/crrs_11/biinNodee1$./ccrs_staat -t (此时时会看到到十三个个RACC的管理理进程)Nodee1$sshh noode22Nodee2$cd /u001/aapp/oraaclee/prroduuct/10.2.00/crrs_11/biinNodee2$./ccrs_staat -t (133个)十测试试RACCNodee2断电电，不可可使用sshuttdowwn h nnow，要使用用非正常常关机，否则不不会产生生飘移。Nodee1$ /uu01/appp/orraclle/pprodductt/100.2.0/ccrs_1/bbin/crss_sttat t (等待时时间为11-5分分钟就可可以看到到nodde2的的虚拟IIP飘移移到了nnodee1上)Nodee2上电电，再来来查看，会看到到虚拟IIP飘移移了回来来。十一.RRAC启启停及