ORACLE11GR2在REDHAT63環(huán)境中搭建RAC集群及簡單維護

1、系統(tǒng)環(huán)境硬件環(huán)境服務器：vvmwarre 100，新建個個虛擬機主主機名分別別為racc1和raac2，每每個虛擬機機分配400G磁盤空空間，添加加兩個網(wǎng)絡絡適配器。其中第二二個適配器器網(wǎng)絡連接接調整為自自定義，且且兩個節(jié)點點保持一致致。Widonnws本機機ip：1192.1168.66.1軟件環(huán)境數(shù)據(jù)庫：ooraclle11.2.0.4 daatabaase-xx86-664GRID：oraccle111.2.00.4_ggrid-x86-64 操作系統(tǒng)：rhell-serrver-6.3-x86_64采用用最小化安安裝網(wǎng)絡環(huán)境Ip地址規(guī)規(guī)劃分配為為IP 名稱稱子網(wǎng)掩碼IP 地址址Rac1

2、-publlic255.2255.2255.00192.1168.66.11Rac2-publlic255.2255.2255.00192.1168.66.12Rac1-privvate255.2255.2255.002.2.22.2Rac2-privvate255.2255.2255.002.2.22.3Rac1-vip255.2255.2255.00192.1168.66.13Rac2-vip255.2255.2255.00192.1168.66.14SCAN255.2255.2255.00192.1168.66.15共享磁盤分分區(qū)計劃創(chuàng)建四四個共享磁磁盤sdbb、sdc、ssdd、ssd

3、e，每每個磁盤計計劃分三個個分區(qū)前期環(huán)境準準備 配置靜靜態(tài)地地址vi /eetc/ssyscoonfigg/nettworkk-scrriptss/ifccfg-eeth0修改ip地地址。每個個虛擬機eeth0網(wǎng)網(wǎng)卡為puublicc，DEVICCE=eeth0BOOTPPROTOO=sttaticcHWADDDR=000:0CC:29:D1:44E:A66NM_COONTROOLLEDD=yeesONBOOOT=yyesTYPE=Ethherneet*UUID=e599cb6aa0-deeb0-44164-a2b00-8b44dcc00cb0227IPADDDR=1992.1668.6.11

4、NETMAASK=2255.2255.2255.00GATEWWAY=1192.1168.66.1vi /eetc/ssyscoonfigg/nettworkk-scrriptss/ifccfg-eeth1修改ip地地址。每個個虛擬機eeth1網(wǎng)網(wǎng)卡位prrivatteDEVICCE=eeth1BOOTPPROTOO=sttaticcHWADDDR=000:0CC:29:D1:44E:A66NM_COONTROOLLEDD=yeesONBOOOT=yyesTYPE=Ethherneet*UUID=e599cb6aa0-deeb0-44164-a2b00-8b44dcc00cb0227IPADD

5、DR=2.2.2.2NETMAASK=2255.2255.2255.00修改完成后后執(zhí)行serviice nnetwoork rrestaart 在raac1和rac22上分別關關閉防火墻墻serviice iiptabbles stopp 停止防防火墻chkcoonfigg ipttablees offf -禁用用防火墻 在raac1和rac22上分別修修改主機名名vi /eetc/ssyscoonfigg/nettworkk 重重啟生效，一個raac1，另另一個raac2HOSTNNAME=rac11 在raac1和rac22 上分別別改hossts vi /etc/hostts 添加對應

6、應的ip信信息#publlic192.1168.66.1800 raac1192.1168.66.1811 raac2#privvate2.2.22.1 raac1-ppriv2.2.22.2 raac2-ppriv#virttual192.1168.66.1822 raac1-vvip192.1168.66.1833 raac2-vvip#scann192.1168.66.1844 cllusteer-sccan 在raac1和rac22上分別執(zhí)執(zhí)行配置內內核參數(shù)vi /eetc/ssyscttl.coonf加入以下內內容fs.aiio-maax-nrr = 110485576fs.fiil

7、e-mmax = 681157444kerneel.shhmalll = 2214744836448kerneel.shhmmaxx = 66871994767736kerneel.shhmmnii = 44096kerneel.seem = 250 320000 1000 1228net.iipv4.ip_llocall_porrt_raange = 90000 6655000net.ccore.rmemm_deffaultt = 22621444net.ccore.rmemm_maxx = 441943304net.ccore.wmemm_deffaultt = 22621444net.c

8、core.wmemm_maxx = 110485586使修改參數(shù)數(shù)立即生效效：syscttl -pp 在raac1和rac22上分別執(zhí)執(zhí)行修改llimittsvi /eetc/ssecurrity/limiits.cconf加入以下信信息grid softt nprroc 22047grid hardd nprroc 1163844grid softt noffile 10244grid hardd noffile 655336oraclle sooft nnprocc 20447oraclle haard nnprocc 163384oraclle sooft nnofille 10024o

9、raclle haard nnofille 655536 在raac1和rac22上分別修修改/ettc/paam.d/logiinvi /eetc/ppam.dd/loggin加入以下信信息sessiion rrequiired /libb/seccuritty/paam_liimitss.so sessiion rrequiired pam_limiits.sso 在raac1和rac22上分別執(zhí)執(zhí)行修改/etc/proffilevi /eetc/pprofiile加入以下信信息if $USEER = oraacle | $USEER = griid ; thhenif $SHEELL =

10、 /bbin/kksh ; tthenulimiit -pp 163384ulimiit -nn 655536elseulimiit -uu 163384 -n 655536fiumaskk 0222fi 在raac1和rac22 上分別別執(zhí)行禁用用 sellinuxxvi /eetc/sselinnux/cconfiig修改 SEELINUUX值SELINNUX=ddisabbled 在raac1和rac22上分別執(zhí)執(zhí)行停止 ntp 服務serviice nntpd stoppchkcoonfigg ntppd offfmv /eetc/nntp.cconf /etcc/ntpp.connf

11、.baak 在racc1和rac22上分別處處理/deev/shhm 共享享內存不足足的處理df -hh 查看看tmpffs分區(qū)是是否大于11G，如果果過小需增增加。vi /eetc/ffstabb 默認的：ttmpfss /deev/shhm tmmpfs defaaultss 0 00改成：tmpfss /deev/shhm tmmpfs defaaultss,sizze=10024m 0 0mountt -o remoount /devv/shmm 在racc1和rac22上分別檢檢查軟件是是否全部安安裝 rpm -qa | greep biinutiils-rpm -qa | gree

12、p coompatt-libbstdcc+-rpm -qa | greep ellfutiils-llibellf-rpm -qa | greep ellfutiils-llibellf-deevel-rpm -qa | greep gllibc-rpm -qa | greep gllibc-commmon-rpm -qa | greep gllibc-deveel-rpm -qa | greep gccc-rpm -qa | greep gccc-c+-rpm -qa | greep liibaioo-rpm -qa | greep liibaioo-devvel-rpm -qa | gre

13、ep liibgccc-rpm -qa | greep liibstddc+-rpm -qa | greep liibstddc+-deveel-rpm -qa | greep maake-rpm -qa | greep syysstaat-rpm -qa | greep unnixODDBC-rpm -qa | greep unnixODDBC-ddevell- 在racc1和rac22 2分別別將未安裝裝的包通過過yum安安裝mkdirr /yuummountt /deev/cddrom /yummvi /eetc/yyum.rreposs.d/cchenbbin.rrepo添加以下內內容

14、 rheel-chhenbiinname=Red Hat Enteerpriise LLinuxx $reeleasseverr - $baseearchh - DDebuggbaseuurl=ffile:/yyum/enablled=11gpgchheck=1gpgkeey=fiile:/ettc/pkki/rppm-gppg/RPPM-GPPG-KEEY-reedhatt-relleaseeyum llist -查查看可用包包yum -y iinstaall bbinuttils* commpat-* ellfutiils-llibellf* ggcc-* gccc-* kernnel-*

15、 kshh-* llibaiio-* libggcc-* libbgompp-* llibsttdc+-* mmake-* nuumacttl-deevel-* syysstaat-* unixxODBCC-* ppdkshh* 在oraadb1和rac22上分別關關閉不需要要的服務chkcoonfigg auttofs offchkcoonfigg acppid ooffchkcoonfigg senndmaiil offfchkcoonfigg cupps-coonfigg-daeemon offchkcoonfigg cpuus offfchkcoonfigg xfss offfchkc

16、oonfigg lm_senssors offchkcoonfigg gpmm offfchkcoonfigg opeenibdd offfchkcoonfigg pcmmcia offchkcoonfigg cpuuspeeed offfchkcoonfigg nfsslockk offfchkcoonfigg ip66tablles ooffchkcoonfigg rpccidmaapd ooffchkcoonfigg apmmd offfchkcoonfigg senndmaiil offfchkcoonfigg arpptablles_jjf offfchkcoonifgg miccr

17、ocoode_cctl ooffchkcoonfigg rpccgssdd offfchkcoonfigg ntppd offf添加組和用用戶 在raac1和rac22上分別添添加oraacle和和gridd用戶和組組grouppadd -g 5501 ooinsttallgrouppadd -g 5502 ddbagrouppadd -g 5503 oopergrouppadd -g 5504 aasmaddmingrouppadd -g 5505 aasmoppergrouppadd -g 5506 aasmdbbauseraadd -g oiinstaall -G dbba,assmdb

18、aa,opeer orracleeuseraadd -g oiinstaall -G assmadmmin,aasmdbba,assmopeer,opper,ddba ggrid 在raac1和rac22上分別為為oraccle和ggrid用用戶設密碼碼passwwd orracleepasswwd grrid 在raac1和rac22上分別創(chuàng)創(chuàng)建目錄ggrid 和 orraclee 用戶的的mkdirr -p /u011/appp/oraaclemkdirr -p /u011/appp/griidmkdirr -p /u011/appp/11.2.0/griddchownn -R gridd

19、:oinnstalll /uu01/aapp/ggridchownn -R gridd:oinnstalll /uu01/aapp/111.2.0chownn -R oraccle:ooinsttall /u011/appp/oraaclechmodd -R 775 /u011mkdirr -p /u011/appp/oraaInveentorrychownn -R gridd:oinnstalll /uu01/aapp/ooraInnventtorychmodd -R 775 /u011/appp/oraaInveentorry 在raac1和rac22上分別修修改oraacle用用戶的.b

20、bash_proffile文文件vi /hhome/oraccle/.bashh_proofileeexporrt ORRACLEE_SIDD=racc1exporrt ORRACLEE_BASSE=/uu01/aapp/ooraclleexporrt ORRACLEE_HOMME=$OORACLLE_BAASE/pproduuct/111.2.0/dbbhomee_1exporrt LDD_LIBBRARYY_PATTH=$OORACLLE_HOOME/llibexporrt NLLS_DAATE_FFORMAAT=yyyyy-mm-ddd HHH24:MMI:SSSexporrt TMMP

21、=/ttmpexporrt TMMPDIRR=$TMMPexporrt PAATH=$PATHH:$ORRACLEE_HOMME/biin 在raac1和rac22上分別修修改griid用戶的.bashh_proofilee文件vi /hhome/gridd/.baash_pprofiileexporrt ORRACLEE_SIDD=+ASSM1exporrt ORRACLEE_BASSE=/uu01/aapp/ggridexporrt ORRACLEE_HOMME=/uu01/aapp/111.2.0/grridexporrt LDD_LIBBRARYY_PATTH=$OORACLLE_HO

22、OME/llibexporrt NLLS_DAATE_FFORMAAT=yyyyy-mm-ddd HHH24:MMI:SSSexporrt PAATH=$ORACCLE_HHOME/bin:$PATTH注意另外一一臺數(shù)據(jù)庫庫實例名須須做相應修修改：Oraclle：exxportt ORAACLE_SID=rac22grid：expoort OORACLLE_SIID=+AASM2 建立 ssh 等效性（可不配置）Root用用戶等效性性可不用配配置，配置置了僅管理理服務器方方便，giird用戶戶和oraacle的的ssh等等效性由安安裝程序配配置，mkdirr /.ssh chmodd 7555

23、 /.ssh ssh-kkeygeen -tt rsaassh-kkeygeen -tt dsaacat /.sssh/idd_rsaa.pubb /.sssh/aauthoorizeed_keeyscat /.sssh/idd_dsaa.pubb /.sssh/aauthoorizeed_keeys在rac11上執(zhí)行ssh rrac2 cat /.sssh/iid_rssa.puub /.ssh/authhorizzed_kkeys ssh rrac2 cat /.sssh/iid_dssa.puub /.ssh/authhorizzed_kkeys在rac22上執(zhí)行ssh rrac1 ca

24、t /.sssh/iid_rssa.puub /.ssh/authhorizzed_kkeys ssh rrac1 cat /.sssh/iid_dssa.puub /.ssh/authhorizzed_kkeys在兩臺服務務器上驗證證是否可以以正常訪問問對方，執(zhí)執(zhí)行時不再再提示輸入入密碼，則表表示SSHH 對等性性配置成功功ssh rrac1 dateessh rrac2 dateessh rrac1-privv dattessh rrac2-privv datte添加共享磁磁盤（VMM） 在本機機上創(chuàng)建共共享磁盤生產(chǎn)環(huán)境使使用共享存存儲，直接接略過在winddows的的cmd中進入VMMw

25、aree Worrkstaationn安裝目錄錄，執(zhí)行命命令創(chuàng)建磁磁盤：注意意創(chuàng)建共享享磁盤的路路徑及文件件大小，例如我的的VM裝在在c盤，cd c:Proogramm Filles (x86)VMwwareVMwaare WWorksstatiionvmwarre-vddiskmmanagger.eexe -c -ss 5g -a llsiloogic -t 22 F:shddiskvot.vmdkkVmwarre-vddiskmmanagger.eexe -c -ss 2g -a llsiloogic -t 22 F:shddiskfra.vmdkkvmwarre-vddiskmmanag

26、ger.eexe -c -ss 5g -a llsiloogic -t 22 F:shddiskdataa.vmddkvmwarre-vddiskmmanagger.eexe -c -ss 5g -a llsiloogic -t 22 F:shddiskdataa1.vmddk 將共享享磁盤掛到到兩臺虛擬擬機關閉兩臺虛虛擬機并退退出VM，分分別用記事事本打開虛虛擬機安裝裝位置中虛虛擬機名字字. vmmx，添加以下內內容disk.EnabbleUUUID=TRUEEdisk.lockking = FFALSEEscsi11.shaared = TTRUEdiskLLib.ddataCCachee

27、MaxSSize = 00diskLLib.ddataCCacheeMaxRReadAAheaddSizee = 0diskLLib.ddataCCacheeMinRReadAAheaddSizee = 0diskLLib.ddataCCacheePageeSizee= 44096diskLLib.mmaxUnnsynccedWrritess = 0 scsi11.preesentt = TRUEEscsi11.virrtuallDev = llsiloogicscsill.shaaredBBus = VIIRTUAALscsi11:0.ppreseent = TRRUEscsi11:0.mm

28、ode = iindeppendeent-ppersiistenntscsi11:0.ffileNName = FF:shhdiskkvott.vmddkscsi11:0.ddevicceTyppe = disskscsi11:0.rredo = scsi11:1.ppreseent = TRRUEscsi11:1.mmode = iindeppendeent-ppersiistenntscsi11:1.ffileNName = FF:shhdiskkfraa.vmddkscsi11:1.ddevicceTyppe = disskscsi11:1.rredo = scsi11:2.pprese

29、ent = TRRUEscsi11:2.mmode = iindeppendeent-ppersiistenntscsi11:2.ffileNName = FF:shhdiskkdatta.vmmdkscsi11:2.ddevicceTyppe = disskscsi11:2.rredo = scsi11:3.preesentt = TRUEEscsi11:3.modde = inddepenndentt-perrsisttentscsi11:3.filleNamme = F:shdiiskddata11.vmddkscsi11:3.devviceTType = ddiskscsi11:3.r

30、eddo = 兩個虛虛擬機開機機，格式化化硬盤，確確認是否共共享成功。在rac11上執(zhí)行fdsikk -l 確認看以以正?？吹降絪db,sbc,sdd,sde按前期規(guī)劃劃創(chuàng)建分區(qū)區(qū)，分區(qū)完完成后在rrac2 中執(zhí)行ffdiskk -l 查詢是否否同步 在raac1和rrac2上上分別將裸裸設備文件件和分區(qū)設設備文件進進行綁定vi /eetc/uudev/rulees.d/60-rraw.rruless 根據(jù)磁盤情情況修改下下面信息加加入到文件件中ACTTION=addd, KERNNEL=sdbb1, RUN+=/bbin/rraw /dev/raw/raw11 %NACTIOON=add,

31、KEERNELL=ssdb2, RUUN+=/binn/raww /deev/raaw/raaw2 %NACTIOON=add, KEERNELL=ssdb3, RUUN+=/binn/raww /deev/raaw/raaw3 %NACTIOON=add, KEERNELL=ssdc1, RUN+=/bbin/rraw /dev/raw/raw44 %NACTIOON=add, KEERNELL=ssdc2, RRUN+=/biin/raaw /ddev/rraw/rraw5 %NACTIOON=add, KEERNELL=ssdc3, RUN+=/bbin/rraw /dev/raw/ra

32、w66 %NACTIOON=add, KEERNELL=ssdd1, RUN+=/bbin/rraw /dev/raw/raw77 %NACTIOON=add, KEERNELL=ssdd2, RUN+=/bbin/rraw /dev/raw/raw88 %NACTIOON=add, KEERNELL=ssdd3, RUN+=/bbin/rraw /dev/raw/raw99 %NKERNEEL=raw0-9, OOWNERR=grrid, GROOUP=asmaadminn, MMODE=06660此處、KERNNEL=”raw0-9” 110以必須須單獨指定定，否則無無效、MODDE=”0

33、6666”和GRROUP=”oinsstalll”的設置，在在后面的ccheckk會報waaringg應改為:MMODE=”06600 GGROUPP=”asmaadminn”執(zhí)行：sttart_udevv命令，此處建議議重啟虛擬擬機執(zhí)行 raaw -qqa查看綁綁定狀態(tài):確保兩個個節(jié)點看以以看到相同同的內容執(zhí)行l(wèi)s -l /dev/raw/查看 裸裸設備歸屬屬權限:安裝Griid 在raac1和rac22上分別安安裝cvuuqdissk包在兩個 OOraclle RAAC 節(jié)點點上安裝操操作系統(tǒng)程程序包 ccvuqddisk。cvuqqdiskk RPMM 包含在在 Oraacle Grid

34、d Inffrasttructture 安裝介質質上的 rrpm 目目錄中。rpm -ivhh cvuuqdissk-1.0.7-1.rppm 檢查 CRS 的安裝環(huán)環(huán)境只需要在其其中一個節(jié)節(jié)點的giird用戶戶執(zhí)行.執(zhí)執(zhí)行需提前前設置好ggrid、oraccle用戶戶ssh等等效性，本本次不檢查查./runncluvvfy.ssh sttage -pree crssinstt -n rac11,racc2 -vverboose未檢測通過過的顯示為為failled，根根據(jù)情況修修復一下即即可：reesolvv.connf不一致致的DNSS問題可以以忽略 安裝GGrid Infrrastrruc

35、tuure軟件件 開始安安裝exporrt DIISPLAAY=1992.1668.6.18:00.0 ./runnInsttalleer 語言支支持中文 配置SScan namee與hosst文件一一致此處的SCCAN_NNAME與與/etcc/hossts 文文件中的sscan地地址保持一一致 Griid用戶等等效性配置置點擊settup出現(xiàn)提示安安裝成功。Nextt 創(chuàng)建OOCR磁盤盤組設置asmm密碼 選擇ggrid安安裝位置Packaage這個個只要確保保安裝了kksh即可可。 TTask resoolve此此項是因為為沒有使用用dns解解析scaan，可忽忽略 開始安安裝 執(zhí)行腳腳

36、本在每個服務務器上以rroot身身份執(zhí)行圖圖中的2個個腳本，兩兩個節(jié)點都都執(zhí)行完成成后點OKK。/u01/app/oraIInvenntoryy/oraainsttRoott.sh/u01/app/gridd/11.2.0/roott.sh出現(xiàn)以下字字樣表示在在該節(jié)點安安裝成功Confiiguree Oraacle Gridd Inffrasttructture for a Cllusteer suucceeeded 確認GGrid安安裝 CRSS狀態(tài)crs_sstat -t -v除GSD外外其他全部部為onllinecrscttl sttat rres -t votting diskk狀態(tài)c

37、rscttl quuery css voteediskk# STTATE Filee Uniiverssal IId Fiile NName Diskk grooup- 1. ONNLINEE 7b88903ff49ccc84faa8bf006d1999bdff5dfee3 (OORCL:DISKK01) CRSSDG 檢查Oraccle集群注冊冊表(OCRR)ocrchheckStatuus off Oraacle Clusster Regiistryy is as ffolloows :Versiion : 3Totall spaace (kbyttes) : 26621200Used s

38、pacce (kkbytees) : 22664Availlablee spaace (kbyttes) : 25598566ID : 151003602228Devicce/Fiile NName : +CCRSDGGDevicce/Fiile iinteggrityy cheeck ssucceeededdDevicce/Fiile nnot cconfiigureedDevicce/Fiile nnot cconfiigureedDevicce/Fiile nnot cconfiigureedDevicce/Fiile nnot cconfiigureedClustter rregiss

39、try inteegritty chheck succceedeedLogiccal ccorruuptioon chheck bypaassedd duee to non-privvilegged uuser 檢查CRS狀態(tài)crscttl chheck crsCRS-44638: Oraacle Highh Avaailabbilitty Seervicces iis onnlineeCRS-44537: Cluusterr Reaady SServiices is oonlinneCRS-44529: Cluusterr Synnchroonizaationn Serrvicees iss

40、 onllineCRS-44533: Eveent MManagger iis onnlineeASM磁盤盤組配置 檢查監(jiān)監(jiān)聽狀態(tài)griddracc01 $ llsnrcctl sstatuus(DESCCRIPTTION=(ADDDRESSS=(PRROTOCCOL=iipc)(KEY=LISTTENERR)(DESCCRIPTTION=(ADDDRESSS=(PRROTOCCOL=ttcp)(HOSTT=1722.18.3.2111)(PPORT=15211) (DESSCRIPPTIONN=(ADDDRESSS=(PPROTOOCOL=tcp)(HOSST=1772.188.3.2213

41、)(PORTT=15221)Serviices SummmaryServiice +ASMM haas 1 insttancee(s).Instaance +ASSM1, staatus READDY, hhas 11 hanndlerr(s) for thiss serrvicee.The ccommaand ccomplletedd succcesssfullly 創(chuàng)建DDATA磁磁盤組以gridd用戶執(zhí)行行asmcca命令，創(chuàng)創(chuàng)建DATTADG和和FRADDG兩個磁磁盤組。 創(chuàng)建FFLA磁盤盤組：FLASHHDG創(chuàng)建建成功，退退出ASMMCA。驗證：crrs_sttat -t -vv或

42、crrsctll staat rees -tt安裝數(shù)據(jù)庫庫軟件 切換到到oraccle用戶戶exporrt DIISPLAAY=1992.1668.6.18:00.0 ./runnInsttalleer 兩個節(jié)節(jié)點安裝 oraacle用用戶等效性性輸入oraacle用用戶密碼。點擊seetup 選擇擇路徑 執(zhí)行rroot腳腳本在兩個節(jié)點點上，分別別以rooot身份執(zhí)執(zhí)行上述腳腳本，然后后點擊OKK。數(shù)據(jù)庫軟件件安裝完成成，點擊cclosee退出。 測試數(shù)數(shù)據(jù)庫安裝裝完成oraaclerac11$ sqlpplus / ass syssdba SQL*Pluss: Reeleasse 111.2

43、.00.4.0 PProduuctioon onn Wedd Octt 1 222:422:56 20144 Copyyrighht (cc) 19982, 20111, Orraclee. Alll riightss resserveed. Connnecteed too an idlee insstancce. SQL使用DBCCA創(chuàng)建數(shù)數(shù)據(jù)庫 使用ooraclle用戶登登錄，執(zhí)行行dbcaa 啟用eem 選擇aasm磁盤盤組 選擇FFRA磁盤盤組：確定是否否啟用快速速恢復區(qū)、歸檔日志志設置最大大連接數(shù) 注意選選合適的字符符集點擊exiit完成安安裝集群數(shù)據(jù)庫庫維護 所有Oraccle實例

44、狀態(tài)態(tài)srvcttl sttatuss dattabasse -dd oraadbInstaance rac11is rrunniing oon noode nnode11Instaance rac22 is runnning on nnode nodee2 單個Oraccle實例狀態(tài)態(tài)srvcttl sttatuss insstancce -dd oraadb -i raac1Instaance rac11is rrunniing oon noode nnode11 節(jié)點應應用程序狀狀態(tài)srvcttl sttatuss noddeapppsVIP nnode11-vipp is enabbl

45、edVIP nnode11-vipp is runnning on nnode: nodde1VIP nnode22-vipp is enabbledVIP nnode22-vipp is runnning on nnode: nodde2Netwoork iis ennableedNetwoork iis ruunninng onn nodde: nnode11Netwoork iis ruunninng onn nodde: nnode22GSD iis diisablledGSD iis noot ruunninng onn nodde: nnode11GSD iis noot ruun

46、ninng onn nodde: nnode22ONS iis ennableedONS ddaemoon iss runnningg on nodee: noode1ONS ddaemoon iss runnningg on nodee: noode2 節(jié)點應應用程序配配置srvcttl coonfigg noddeapppsNetwoork eexistts: 11/1922.1688.0.00/2555.2555.0.00/ethh0, ttype statticVIP eexistts: /nodee1-viip/1992.1668.1.151/192.168.0.0/255.255.

47、0.0/eth00, hoostinng noode nnode11VIP eexistts: /nodee2-viip/1992.1668.1.152/192.168.0.0/255.255.0.0/eth00, hoostinng noode nnode22GSD eexisttsONS eexistts: LLocall porrt 61100, remoote pport 62000, EMM porrt 20016 數(shù)據(jù)庫庫配置srvcttl coonfigg dattabasse -dd oraadb -aDatabbase uniqque nname: oraadbDatabba

48、se namee: orradbOraclle hoome: /u011/appp/oraacle/prodduct/11.22.0/ddbhomme_1Oraclle usser: oraccleSpfille: +DATAADG/ooradbb/spffileooradbb.oraaDomaiin:Startt opttionss: oppenStop optiions: immmediaateDatabbase rolee: PRRIMARRYManaggemennt poolicyy: AUUTOMAATICServeer poools: oraadbDatabbase insttancees: rrac1,rac22Disk Grouups: DATAADG,FFRADGGMountt poiint ppathss:Serviices:Type: RACCDatabbase is eenablledDatabbase is aadminnistrratorr mannagedd ASMM狀態(tài)srvcttl sttatuss asmmASM iis ruunninng onn nodde2,nnode11 ASMM配置srvcttl coonfigg a