ORACLE11GR2在REDHAT63环境中搭建RAC集群及简单维护

《ORACLE11GR2在REDHAT63环境中搭建RAC集群及简单维护》由会员分享，可在线阅读，更多相关《ORACLE11GR2在REDHAT63环境中搭建RAC集群及简单维护（76页珍藏版）》请在装配图网上搜索。

1、1、 系统环境1.1、 硬件环境服务器：vmware 10，新建个虚拟机主机名分别为rac1和rac2，每个虚拟机分配40G磁盘空间，添加两个网络适配器。其中第二个适配器网络连接调整为自定义，且两个节点保持一致。Widonwss本机ip：192.1168.6.11.2、 软件环境数据库：oraacle111.2.0.4 dattabasee-x86-64GRID：orracle111.2.00.4_grrid-x886-64 操作系统：rhhel-seerver-6.3-xx86_644采用最小化化安装1.3、 网络环境Ip地址规划分分配为IP 名称子网掩码IP 地址Rac1-puublic2

2、55.2555.255.0192.1688.6.11Rac2-puublic255.2555.255.0192.1688.6.12Rac1-prrivatee255.2555.255.02.2.2.22Rac2-prrivatee255.2555.255.02.2.2.33Rac1-viip255.2555.255.0192.1688.6.13Rac2-viip255.2555.255.0192.1688.6.14SCAN255.2555.255.0192.1688.6.151.4、 共享磁盘分区计划创建四个共共享磁盘sddb、sdc、sddd、sdee，每个磁盘盘计划分三个分分区2、 前期环

3、境准备1.2.1 配置静态地址vi /etcc/syscconfigg/netwwork-sscriptts/ifccfg-etth0修改ip地址。每每个虚拟机eeth0网卡卡为publlic，DEVICE=eth00BOOTPROOTO=sstaticcHWADDR=00:00C:29:D1:4EE:A6NM_CONTTROLLEED=yeesONBOOT=yesTYPE=EEthernnet*UUID=ee59cb66a0-deeb0-41164-a22b0-8bb4dcc00cb0277IPADDR=192.1168.6.11NETMASKK=255.255.2255.0GATEWAYY

4、=192.168.66.1vi /etcc/syscconfigg/netwwork-sscriptts/ifccfg-etth1修改ip地址。每每个虚拟机eeth1网卡卡位privvateDEVICE=eth11BOOTPROOTO=sstaticcHWADDR=00:00C:29:D1:4EE:A6NM_CONTTROLLEED=yeesONBOOT=yesTYPE=EEthernnet*UUID=ee59cb66a0-deeb0-41164-a22b0-8bb4dcc00cb0277IPADDR=2.2.22.2NETMASKK=255.255.2255.0修改完成后执行行service

5、e netwwork rrestarrt2.2 在rac11和rac2上分分别关闭防火火墙servicee iptaables stop -停停止防火墙chkconffig ipptablees offf -禁用防火墙墙2.3 在rac11和rac2上分分别修改主机机名vi /etcc/syscconfigg/netwwork 重启生效效，一个racc1，另一个个rac2HOSTNAMME=racc12.4 在rac11和rac2 上分别改hhosts vi /ettc/hossts 添加对应的iip信息#publicc192.1688.6.1880 racc1192.1688.6.1881

6、racc2#privatte2.2.2.11 racc1-priiv2.2.2.22 racc2-priiv#virtuaal192.1688.6.1882 racc1-vipp192.1688.6.1883 racc2-vipp#scan192.1688.6.1884 cluuster-scan2.5 在rac11和rac2上分分别执行配置置内核参数vi /etcc/syscctl.coonf加入以下内容fs.aio-max-nnr = 110485776fs.filee-max = 68115744kernel.shmalll = 221474883648kernel.shmmaax =

7、66871944767366kernel.shmmnni = 44096kernel.sem = 250 320000 100 128net.ipvv4.ip_locall_portt_rangge = 99000 665500net.corre.rmeem_deffault = 2622144net.corre.rmeem_maxx = 411943044net.corre.wmeem_deffault = 2622144net.corre.wmeem_maxx = 100485866使修改参数立即即生效：sysctl -p2.6 在rac11和rac2上分分别执行修改改limittsvi

8、/etcc/secuurity/limitts.connf加入以下信息grid sooft npproc 22047grid haard npproc 116384grid sooft noofile 1024grid haard noofile 655366oracle soft nprocc 20477oracle hard nprocc 163884oracle soft nofille 10224oracle hard nofille 6555362.7 在rac11和rac2上分分别修改/eetc/paam.d/lloginvi /etcc/pam.d/loggin加入以下信息ses

9、sionn requuired /lib/securrity/ppam_liimits.so sessionn requuired pam_llimitss.so2.8 在rac11和rac2上分分别执行修改改/etc/profiilevi /etcc/proffile加入以下信息if $UUSER = oraacle | $USSER = gridd ; thenif $SSHELL = /bbin/kssh ; thennulimit -p 166384ulimit -n 655536elseulimit -u 166384 -n 655536fiumask 0022fi2.9 在rac1

10、1和rac2 上分别执行行禁用 seelinuxxvi /etcc/seliinux/cconfigg修改 SELIINUX值SELINUXX=disaabled2.10 在rac11和rac2上分分别执行停止止 ntp 服务servicee ntpdd stoppchkconffig nttpd offfmv /etcc/ntp.conf /etc/ntp.cconf.bbak2.11 在rac1和和rac2上分分别处理/ddev/shhm 共享内内存不足的处处理df -h 查看tmppfs分区是是否大于1GG，如果过小小需增加。vi /etcc/fstaab 默认的：tmppfs /dde

11、v/shhm tmppfs deefaultts 0 00改成：tmpfs /dev/sshm tmmpfs ddefaullts,siize=10024m 00 0mount -o remmount /dev/shm2.12 在rac1和和rac2上分分别检查软件件是否全部安安装 rpm -qaa | grrep biinutills-rpm -qaa | grrep coompat-libsttdc+-rpm -qaa | grrep ellfutills-libbelf-rpm -qaa | grrep ellfutills-libbelf-ddevel-rpm -qaa | grrep

12、 gllibc-rpm -qaa | grrep gllibc-ccommonn-rpm -qaa | grrep gllibc-ddevel-rpm -qaa | grrep gccc-rpm -qaa | grrep gccc-c+-rpm -qaa | grrep liibaio-rpm -qaa | grrep liibaio-devell-rpm -qaa | grrep liibgcc-rpm -qaa | grrep liibstdcc+-rpm -qaa | grrep liibstdcc+-deevel-rpm -qaa | grrep maake-rpm -qaa | gr

13、rep syysstatt-rpm -qaa | grrep unnixODBBC-rpm -qaa | grrep unnixODBBC-devvel-2.13 在rac1和和rac2 2分别将未未安装的包通通过yum安安装mkdir /yummount /dev/ccdrom /yumvi /etcc/yum.reposs.d/chhenbinn.repoo添加以下内容 rhel-chenbbinname=Reed Hatt Enteerprisse Linnux $rreleassever - $baasearcch - DDebugbaseurll=filee:/yyum/enable

14、dd=1gpgchecck=1gpgkey=file:/ettc/pkii/rpm-gpg/RRPM-GPPG-KEYY-redhhat-reeleaseeyum lisst -查看可用包包yum -yy insttall bbinutiils* ccompatt-* ellfutills-libbelf* gcc-* gcc-* keernel-* kshh-* liibaio-* libbgcc-* libggomp-* libsstdc+-* maake-* numacctl-deevel-* syssstat-* unixxODBC-* pdkksh*2.14 在oraddb1和rac

15、2上分分别关闭不需需要的服务chkconffig auutofs offchkconffig accpid ooffchkconffig seendmaiil offfchkconffig cuups-coonfig-daemoon offfchkconffig cppus offfchkconffig xffs offfchkconffig lmm_senssors ooffchkconffig gppm offfchkconffig oppenibdd offchkconffig pccmcia offchkconffig cppuspeeed offfchkconffig nffsloc

16、kk offchkconffig ipp6tablles offfchkconffig rppcidmaapd offfchkconffig appmd offfchkconffig seendmaiil offfchkconffig arrptablles_jff offchkconiifg miicrocoode_cttl offfchkconffig rppcgssdd offchkconffig nttpd offf3、 添加组和用户233.1 在rac11和rac2上分分别添加orracle和和grid用用户和组groupaddd -g 501 ooinstaallgroupaddd

17、 -g 502 ddbagroupaddd -g 503 oopergroupaddd -g 504 aasmadmmingroupaddd -g 505 aasmopeergroupaddd -g 506 aasmdbaauseraddd -g ooinstaall -GG dba,asmdbba,opeer oraacleuseraddd -g ooinstaall -GG asmaadmin,asmdbba,asmmoper,oper,dba ggrid3.2 在rac11和rac2上分分别为oraacle和ggrid用户户设密码passwd oracllepasswd grid3.3

18、在rac11和rac2上分分别创建目录录grid 和 oraacle 用用户的mkdir -p /u001/appp/oracclemkdir -p /u001/appp/griddmkdir -p /u001/appp/11.22.0/grridchown -R griid:oinnstalll /u011/app/gridchown -R griid:oinnstalll /u011/app/11.2.0chown -R oraacle:ooinstaall /uu01/appp/oraaclechmod -R 7755 /u011mkdir -p /u001/appp/oraIInven

19、ttorychown -R griid:oinnstalll /u011/app/oraInnventoorychmod -R 7755 /u011/app/oraInnventoory3.4 在rac11和rac2上分分别修改orracle用用户的.baash_prrofilee文件vi /homme/oraacle/.bash_profiileexport ORACLLE_SIDD=rac11export ORACLLE_BASSE=/u001/appp/oraccleexport ORACLLE_HOMME=$ORRACLE_BASE/produuct/111.2.0/dbhomme_1

20、export LD_LIIBRARYY_PATHH=$ORAACLE_HHOME/llibexport NLS_DDATE_FFORMATT=yyyyy-mm-dd HHH24:MII:SSexport TMP=/tmpexport TMPDIIR=$TMMPexport PATH=$PATHH:$ORAACLE_HHOME/bbin3.5 在rac11和rac2上分分别修改grrid用户的.bbash_pprofille文件vi /homme/griid/.baash_prrofileeexport ORACLLE_SIDD=+ASMM1export ORACLLE_BASSE=/u001/

21、appp/griddexport ORACLLE_HOMME=/u001/appp/11.22.0/grridexport LD_LIIBRARYY_PATHH=$ORAACLE_HHOME/llibexport NLS_DDATE_FFORMATT=yyyyy-mm-dd HHH24:MII:SSexport PATH=$ORACCLE_HOOME/biin:$PAATH注意另外一台数数据库实例名名须做相应修修改：Oracle：exporrt ORAACLE_SSID=raac2grid：exxport ORACLLE_SIDD=+ASMM23.6 建立 sssh 等效性性（可不配置置）Ro

22、ot用户等等效性可不用用配置，配置置了仅管理服服务器方便，ggird用户户和oraccle的sssh等效性由由安装程序配配置，mkdir /.sshh chmod 7755 /.ssh ssh-keyygen -t rsaassh-keyygen -t dsaacat /.ssh/iid_rsaa.pub /.ssh/authoorizedd_keysscat /.ssh/iid_dsaa.pub /.ssh/authoorizedd_keyss在rac1上执执行ssh racc2 catt /.sssh/idd_rsa.pub /.ssh/aauthorrized_keys ssh racc

23、2 catt /.sssh/idd_dsa.pub /.ssh/aauthorrized_keys在rac2上执执行ssh racc1 catt /.sssh/idd_rsa.pub /.ssh/aauthorrized_keys ssh racc1 catt /.sssh/idd_dsa.pub /.ssh/aauthorrized_keys在两台服务器上上验证是否可可以正常访问问对方，执行行时不再提示示输入密码，则表示示SSH 对对等性配置成成功ssh racc1 dattessh racc2 dattessh racc1-priiv dattessh racc2-priiv datte4

24、、 添加共享磁盘（VVM）44.1 在本机上创创建共享磁盘盘生产环境使用共共享存储，直直接略过在windowws的cmdd中进入VMwware WWorksttationn安装目录，执执行命令创建建磁盘：注意意创建共享磁磁盘的路径及及文件大小，例如我的VVM装在c盘盘，cd c:PPrograam Filles (xx86)VVMwareeVMwaare Woorkstaationvmware-vdiskkmanagger.exxe -c -s 5gg -a llsiloggic -tt 2 FF:shddiskvvot.vmmdkVmware-vdiskkmanagger.exxe -c -

25、s 2gg -a llsiloggic -tt 2 FF:shddiskffra.vmmdkvmware-vdiskkmanagger.exxe -c -s 5gg -a llsiloggic -tt 2 FF:shddiskddata.vvmdkvmware-vdiskkmanagger.exxe -c -s 5gg -a llsiloggic -tt 2 FF:shddiskddata1.vmdkk4.2 将共享磁盘盘挂到两台虚虚拟机关闭两台虚拟机机并退出VMM，分别用记记事本打开虚虚拟机安装位位置中虚拟机机名字. vvmx，添加以下内容disk.EnnableUUUID=TRUEdisk

26、.loockingg = FFALSEscsi1.ssharedd = TTRUEdiskLibb.dataaCacheeMaxSiize = 0diskLibb.dataaCacheeMaxReeadAheeadSizze = 0diskLibb.dataaCacheeMinReeadAheeadSizze = 0diskLibb.dataaCacheePageSSize= 40966diskLibb.maxUUnsynccedWriites = 0 scsi1.ppresennt = TRUEscsi1.vvirtuaalDev = lssilogiicscsil.sshareddBus

27、= VIRRTUALscsi1:00.pressent = TRUUEscsi1:00.modee = iindepeendentt-perssistenntscsi1:00.fileeName = F:shdiskkvot.vmdkscsi1:00.deviiceTyppe = diskscsi1:00.redoo = scsi1:11.pressent = TRUUEscsi1:11.modee = iindepeendentt-perssistenntscsi1:11.fileeName = F:shdiskkfra.vmdkscsi1:11.deviiceTyppe = diskscs

28、i1:11.redoo = scsi1:22.pressent = TRUUEscsi1:22.modee = iindepeendentt-perssistenntscsi1:22.fileeName = F:shdiskkdataa.vmdkkscsi1:22.deviiceTyppe = diskscsi1:22.redoo = scsi1:33.pressent = TRUUEscsi1:33.modee = iindepeendentt-perssistenntscsi1:33.fileeName = F:shdiiskdaata1.vvmdkscsi1:33.deviiceTypp

29、e = diskscsi1:33.redoo = 4.3 两个虚拟机机开机，格式式化硬盘，确确认是否共享享成功。在rac1上执执行fdsik -l -确认看以以正常看到ssdb,sbbc,sddd,sde按前期规划创建建分区，分区区完成后在rrac2 中中执行fdiisk -ll 查询是否否同步4.4 在rac11和rac22上分别将裸裸设备文件和和分区设备文文件进行绑定定vi /etcc/udevv/rulees.d/660-raww.rulees 根据磁盘情况修修改下面信息息加入到文件件中ACTIION=add, KERNNEL=sdb1, RUNN+=/bbin/raaw /deev/r

30、aww/raw11 %NACTION=addd, KEERNEL=sdbb2, RRUN+=/bin/raw /dev/rraw/raaw2 %NNACTION=addd, KEERNEL=sdbb3, RRUN+=/bin/raw /dev/rraw/raaw3 %NNACTION=addd, KEERNEL=sdcc1, RRUN+=/bin/raw /dev/rraw/raaw4 %NNACTION=addd, KEERNEL=sdcc2, RUUN+=/bin/rraw /ddev/raaw/raww5 %NACTION=addd, KEERNEL=sdcc3, RRUN+=/bin/

31、raw /dev/rraw/raaw6 %NNACTION=addd, KEERNEL=sddd1, RRUN+=/bin/raw /dev/rraw/raaw7 %NNACTION=addd, KEERNEL=sddd2, RRUN+=/bin/raw /dev/rraw/raaw8 %NNACTION=addd, KEERNEL=sddd3, RRUN+=/bin/raw /dev/rraw/raaw9 %NNKERNEL=raww0-9, OWWNER=grid, GROOUP=aasmadmmin, MODE=06600此处、KEERNEL=”raw00-9” 100以必须单独独指定，

32、否则则无效、MODE=”0666”和GROOUP=”oinsttall”的设置，在在后面的chheck会报报warinng应改为:MODDE=”0660 GROOUP=”asmaddmin”执行：starrt_udeev命令，此处建议重重启虚拟机执行 raw -qa查看看绑定状态:确保两个节节点看以看到到相同的内容容执行ls -ll /devv/raw/查看 裸设设备归属权限限:5、 安装Grid55.1 在rac11和rac2上分分别安装cvvuqdissk包在两个 Oraacle RRAC 节点点上安装操作作系统程序包包 cvuqqdisk。ccvuqdiisk RPPM 包含在在 Ora

33、ccle Grrid Innfrasttructuure 安装装介质上的 rpm 目目录中。rpm -iivh cvvuqdissk-1.00.7-1.rpm5.2 检查 CRRS 的安装装环境只需要在其中一一个节点的ggird用户户执行.执行行需提前设置置好gridd、oraccle用户sssh等效性性，本次不检检查./runclluvfy.sh sttage -pre ccrsinsst -n rac1,rac2 -verbbose未检测通过的显显示为faiiled，根根据情况修复复一下即可：resollv.connf不一致的的DNS问题题可以忽略5.3 安装Griid Inffrastr

34、ructurre软件5.3.1 开始安装export DISPLLAY=1992.1688.6.188:0.0 ./runInnstalller5.3.2 语言支持中中文5.3.3 配置Scaan namme与hosst文件一致致此处的SCANN_NAMEE与/etcc/hostts 文件中中的scann地址保持一一致5.3.4 Grid用用户等效性配配置点击setupp出现提示安装成成功。Next5.3.5 创建OCRR磁盘组设置asm密码码 5.3.6 选择griid安装位置置Packagee这个只要确确保安装了kksh即可。 Taskk resoolve此项项是因为没有有使用dnss解析

35、scaan，可忽略略5.3.7 开始安装5.3.8 执行脚本在每个服务器上上以roott身份执行图图中的2个脚脚本，两个节节点都执行完完成后点OKK。/u01/appp/oraaInvenntory/orainnstRooot.sh/u01/appp/griid/11.2.0/rroot.ssh出现以下字样表表示在该节点点安装成功Configuure Orracle Grid Infraastruccture for aa Clusster . suucceedded5.4 确认Griid安装5.4.1 CRS状态态crs_staat -t -v除GSD外其他他全部为onnlinecrsctl

36、 stat res -t5.4.2 votinng dissk状态crsctl queryy css voteddisk# STATTE Fille Uniiversaal Id File Name Disk groupp- - - - -1. ONLIINE 7bb8903ff49cc884fa8bbf06d1199bdff5dfe33 (ORCCL:DISSK01) CRSDDG5.4.3 检查Orracle集群注册表表(OCR)ocrchecckStatus of Orracle Clustter Reegistrry is as foollowss :Versionn : 3Total

37、 sspace (kbyttes) : 2621120Used sppace (kbytees) : 2264Availabble sppace (kbytees) : 2598556ID : 155103600228Device/File Name : +CRRSDGDevice/File integgrity checkk succceededdDevice/File not cconfigguredDevice/File not cconfigguredDevice/File not cconfigguredDevice/File not cconfigguredClusterr reg

38、iistry integgrity checkk succceededdLogicall corrruptioon cheeck byypasseed duee to nnon-prrivileeged uuser5.4.4 检查CRRS状态crsctl checkk crsCRS-46338: Orracle High Availlabiliity Seervicees is onlinneCRS-45337: Cllusterr Readdy Serrvicess is oonlineeCRS-45229: Cllusterr Syncchroniizatioon Serrvicess i

39、s oonlineeCRS-45333: Evvent MManageer is onlinne6、 ASM磁盘组配配置66.1 检查监听状状态gridrrac01 $ llsnrcttl staatus(DESCRIIPTIONN=(ADDDRESS=(PROTTOCOL=ipc)(KEY=LLISTENNER)(DESCRIIPTIONN=(ADDDRESS=(PROTTOCOL=tcp)(HOST=172.118.3.2211)(PPORT=11521) (DEESCRIPPTION=(ADDRRESS=(PROTOOCOL=ttcp)(HHOST=1172.188.3.2113)(PO

40、ORT=15521)Servicees Summmary.Servicee +ASSM haas 1 iinstannce(s).Instancce +AASM1, stattus REEADY, has 11 handdler(ss) forr thiss servvice.The commmand complleted succeessfullly6.2 创建DATTA磁盘组以grid用户户执行asmmca命令，创创建DATAADG和FRRADG两个个磁盘组。6.3 创建FLAA磁盘组：FLASHDGG创建成功，退退出ASMCCA。验证：crs_stat -t -vv或 crssctl s

41、stat rres -tt7、 安装数据库软件件77.1 切换到orracle用用户export DISPLLAY=1992.1688.6.188:0.0 ./runInnstalller 7.2 两个节点安安装7.3 oraclle用户等效效性输入oraclle用户密码码。点击seetup7.4 选择路径径7.5 执行rooot脚本在两个节点上，分分别以rooot身份执行行上述脚本，然然后点击OKK。数据库软件安装装完成，点击击closee退出。7.6 测试数据库库安装完成oraclleracc1$ sqlpllus / as syysdba SQL*Pllus: RReleasse 11.

42、2.0.44.0 Prroducttion oon Wedd Oct 1 22:42:566 20144 Copyriight (c) 19982, 22011, Oraclle. Alll rigghts rreservved. Conneccted tto an idle instaance. SQL8、 使用DBCA创创建数据库88.1 使用oraacle用户户登录，执行行dbca 8.2 启用em8.3 选择asmm磁盘组8.4 选择FRAA磁盘组：确定是否启用用快速恢复区区、归档日志志设置最大连接接数8.5 注意选合适适的字符集点击exit完完成安装9、 集群数据库维护护99.1 所

43、有Orracle实例状态srvctl statuus dattabasee -d ooradbInstancce racc1is rrunninng on node node11Instancce racc2 is runniing onn nodee nodee29.2 单个Orracle实例状态srvctl statuus insstancee -d ooradb -i raac1Instancce racc1is ruunningg on nnode nnode19.3 节点应用程程序状态srvctl statuus noddeappssVIP nodde1-viip is enabll

44、edVIP nodde1-viip is runniing onn nodee: nodde1VIP nodde2-viip is enablledVIP nodde2-viip is runniing onn nodee: nodde2Networkk is eenableedNetworkk is rrunninng on node: nodee1Networkk is rrunninng on node: nodee2GSD is disabbledGSD is not rrunninng on node: nodee1GSD is not rrunninng on node: node

45、e2ONS is enablledONS daeemon iis runnning on noode: nnode1ONS daeemon iis runnning on noode: nnode29.4 节点应用程程序配置srvctl confiig noddeappssNetworkk exissts: 11/192.168.00.0/2555.2555.0.0/eth0, typee statticVIP exiists: /nodee1-vipp/192.168.11.151/192.1168.0.0/2555.255.0.0/eeth0, hostiing noode noode1V

46、IP exiists: /nodee2-vipp/192.168.11.152/192.1168.0.0/2555.255.0.0/eeth0, hostiing noode noode2GSD exiistsONS exiists: Locall portt 61000, remmote pport 66200, EM poort 200169.5 数据库配置置srvctl confiig dattabasee -d ooradb -aDatabasse uniique nname: oradbbDatabasse namme: orradbOracle home: /u011/app/or

47、aclle/prooduct/11.2.0/dbhhome_11Oracle user: oraccleSpfile: +DATTADG/ooradb/spfilleoraddb.oraaDomain:Start ooptionns: oppenStop opptionss: immmediatteDatabasse rolle: PRRIMARYYManagemment ppolicyy: AUTTOMATIICServer poolss: oraadbDatabasse insstancees: raac1,raac2Disk Grroups: DATAADG,FRRADGMount pp

48、oint pathss:Servicees:Type: RRACDatabasse is enablledDatabasse is adminnistraator mmanageed9.6 ASM状状态srvctl statuus asmmASM is runniing onn nodee2,nodde19.7 ASM配配置srvctl confiig asmm -aASM homme: /uu01/appp/11.2.0/ggridASM lisstenerr: LISSTENERRASM is enablled.9.8 TNS监监听器状态srvctl statuus lisstenerrL

49、isteneer LISSTENERR is eenableedListeneer LISSTENERR is rrunninng on node(s): nnode2,node119.9 TNS监监听器配置srvctl confiig lisstenerr -aName: LLISTENNERNetworkk: 1, Ownerr: griidHome: /u01/appp/11.2.0/ggrid oon nodde(s) node22,nodee1End poiints: TCP:115219.10 SCAN状状态srvctl statuus scaanSCAN VIIP scaan1

50、iss enabbledSCAN VIIP scaan1 iss runnning oon nodde nodde2SCAN VIIP scaan2 iss enabbledSCAN VIIP scaan2 iss runnning oon nodde nodde1SCAN VIIP scaan3 iss enabbledSCAN VIIP scaan3 iss runnning oon nodde nodde19.11 SCAN配配置srvctl confiig scaanSCAN naame: cclusteer-scaan.loccaldommain, Netwoork: 11/192.

51、168.00.0/2555.2555.0.0/eth0SCAN VIIP namme: sccan1, IP: /clustter-sccan.loocaldoomain/192.1168.1.57SCAN VIIP namme: sccan2, IP: /clustter-sccan.loocaldoomain/192.1168.1.58SCAN VIIP namme: sccan3, IP: /clustter-sccan.loocaldoomain/192.1168.1.599.12 验证所有集群群节点间的时时钟同步cluvfy comp clockksync -verbboseResu

52、lt: Checck of clockk timee offssets ppasseddOracle Clustter Tiime Syynchroonizattion SServicces chheck ppasseddVerificcationn of CClock Synchhronizzationn acrooss thhe cluuster nodess was succeessfull.9.13 登陆数据库sqlpluss / ass sysddbaset paggesizee 999set linnesizee 2009.14 查看实例状态态select instaance_nname,sstatuss fromm gv$iinstannce;9.15 检查所有节点点crscrsctl checkk clusster allcrsctl checkk crssu griddsqlplsuu / ass sysaasm sttartupp10、 集群的启停1010.1 停止所有节节点上的实例例srvctl statuus dattabasee -d ooradb检查所有的节点点上的实例状状态srvctl statuus dattabasee d ooradb10.2 启动所有节节点上的实例例srvctl startt dataabase -d raacdb76