Oracle11GR2RAC及負(fù)載均衡搭建手冊(cè)_第1頁(yè)
Oracle11GR2RAC及負(fù)載均衡搭建手冊(cè)_第2頁(yè)
Oracle11GR2RAC及負(fù)載均衡搭建手冊(cè)_第3頁(yè)
Oracle11GR2RAC及負(fù)載均衡搭建手冊(cè)_第4頁(yè)
Oracle11GR2RAC及負(fù)載均衡搭建手冊(cè)_第5頁(yè)
已閱讀5頁(yè),還剩73頁(yè)未讀, 繼續(xù)免費(fèi)閱讀

下載本文檔

版權(quán)說(shuō)明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請(qǐng)進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡(jiǎn)介

1、Oracle 11G R2 RAC安裝手冊(cè)基礎(chǔ)知識(shí)RAC是什么RAC,全稱rreal aappliccationn clussters,譯譯為“實(shí)時(shí)應(yīng)應(yīng)用集群”,是是Oraclle新版數(shù)據(jù)據(jù)庫(kù)中采用的的一項(xiàng)新技術(shù)術(shù),是高可用用性的一種,也也是Oraccle數(shù)據(jù)庫(kù)庫(kù)支持網(wǎng)格計(jì)計(jì)算環(huán)境的核核心技術(shù)。RAC的優(yōu)缺點(diǎn)點(diǎn)優(yōu)點(diǎn)Oracle RAC支持持Oraclle9i、10g、11g版本,可可以支持244 x 7 有效的數(shù)據(jù)據(jù)庫(kù)應(yīng)用系統(tǒng)統(tǒng),在低成本本服務(wù)器上構(gòu)構(gòu)建高可用性性數(shù)據(jù)庫(kù)系統(tǒng)統(tǒng),并且自由由部署應(yīng)用,無(wú)無(wú)需修改代碼碼。在Oraacle RRAC環(huán)境下下,Oraccle集成提提供了集群軟軟件和存儲(chǔ)管

2、管理軟件,為為用戶降低了了應(yīng)用成本。當(dāng)當(dāng)應(yīng)用規(guī)模需需要擴(kuò)充時(shí),用用戶可以按需需擴(kuò)展系統(tǒng),以以保證系統(tǒng)的的性能。多節(jié)點(diǎn)負(fù)載均衡衡; 提供高可用:故故障容錯(cuò)和無(wú)無(wú)縫切換功能能,將硬件和和軟件錯(cuò)誤造造成的影響最最小化; 通過(guò)并行執(zhí)行技技術(shù)提高事務(wù)務(wù)響應(yīng)時(shí)間通常常用于數(shù)據(jù)分分析系統(tǒng); 通過(guò)橫向擴(kuò)展提提高每秒交易易數(shù)和連接數(shù)數(shù)通常常對(duì)于聯(lián)機(jī)事事務(wù)系統(tǒng); 節(jié)約硬件成本,可可以用多個(gè)廉廉價(jià)PC服務(wù)器代代替昂貴的小小型機(jī)或大型型機(jī),同時(shí)節(jié)節(jié)約相應(yīng)維護(hù)護(hù)成本; 可擴(kuò)展性好,可可以方便添加加刪除節(jié)點(diǎn),擴(kuò)擴(kuò)展硬件資源源。缺點(diǎn)相對(duì)單機(jī),管理理更復(fù)雜,要要求更高; 可能會(huì)增加軟件件成本Oracle RAC原理理在一個(gè)應(yīng)

3、用環(huán)境境當(dāng)中,所有有的服務(wù)器使使用和管理同同一個(gè)數(shù)據(jù)庫(kù)庫(kù),目的是為為了分散每一一臺(tái)服務(wù)器的的工作量,硬硬件上至少需需要兩臺(tái)以上上的服務(wù)器,而而且還需要一一個(gè)共享存儲(chǔ)儲(chǔ)設(shè)備。同時(shí)時(shí)所有服務(wù)器器上的OS都應(yīng)該是是同一類OSS,根據(jù)負(fù)載載均衡的配置置策略,當(dāng)一一個(gè)客戶端發(fā)發(fā)送請(qǐng)求到某某一臺(tái)服務(wù)的的listeener后,這這臺(tái)服務(wù)器根根據(jù)我們的負(fù)負(fù)載均衡策略略,會(huì)把請(qǐng)求求發(fā)送給本機(jī)機(jī)的RAC組件處處理也可能會(huì)會(huì)發(fā)送給另外外一臺(tái)服務(wù)器器的RAC組件處處理,處理完完請(qǐng)求后,RRAC會(huì)通過(guò)過(guò)集群軟件來(lái)來(lái)訪問(wèn)共享存存儲(chǔ)設(shè)備.邏輯結(jié)構(gòu)上看:每一個(gè)參加集群群的節(jié)點(diǎn)有一一個(gè)獨(dú)立的iinstannce,這些些inst

4、aance訪問(wèn)問(wèn)同一個(gè)數(shù)據(jù)據(jù)庫(kù)。每一個(gè)節(jié)點(diǎn)的llinstaance都有有自己的SGGA。每一個(gè)節(jié)點(diǎn)的llinstaance都有有自己的baackgroound pprocesss。每一個(gè)節(jié)點(diǎn)的llinstaance都有有自己的reedo loogs。每一個(gè)節(jié)點(diǎn)的iinstannce都有自自己的unddo表空間。所有節(jié)點(diǎn)都共享享一份dattafilees和contrrolfilles。三類Resouurce:VIP - 虛虛擬IP地址(Virrtual IP) OCR - OOraclee Clusster RRegisttry(集群群注冊(cè)文件),記錄每個(gè)個(gè)節(jié)點(diǎn)的相關(guān)關(guān)信息Voting Disk

5、,仲裁機(jī)制用用于仲裁多個(gè)個(gè)節(jié)點(diǎn)向共享享節(jié)點(diǎn)同時(shí)寫寫的行為,這這樣 做是為了避避免發(fā)生沖突突。RAC環(huán)境設(shè)計(jì)計(jì)服務(wù)器配置操作系統(tǒng)主機(jī)名內(nèi)存網(wǎng)卡Redhat Enterrprisee Linuux 5.44rac12Geth0(Puublic)eth1(Prrive)Redhat Enterrprisee Linuux 5.44rac22Geth0(Puublic)eth1(Prrive)用戶組規(guī)劃GroupNaameGroupIDD說(shuō)明HOSTl501Oracle清清單和軟件所所有者rac1,raac2i504Oracle自自動(dòng)存儲(chǔ)管理理組rac1,raac2asmdba506ASM數(shù)據(jù)庫(kù)管管理

6、員組rac1,raac2asmopenn507ASM操作員組組rac1,raac2dba502數(shù)據(jù)庫(kù)管理員rac1,raac2用戶規(guī)劃UserIDUserNammeGroup說(shuō)明HOST口令501gridldbaasmadmiinasmdbaasmoperrOracle Clustter用戶rac1rac2grid1233502oracleldbaasmdbaOracle數(shù)數(shù)據(jù)庫(kù)管理員員rac1rac2oracle1123IP規(guī)劃主機(jī)名公用IP私有IP虛擬IPrac111111111rac212122122Scan

7、IP000存儲(chǔ)規(guī)劃存儲(chǔ)組件Block DDeviceeASMlib NameSizeOCR/dev/sddbOCR_VOLL11G/dev/sddcOCR_VOLL21G/dev/sdddOCR_VOLL31G數(shù)據(jù)文件/dev/sddeDATA_VOOL110G文件備份/dev/sddfBACK_VOOL15GOracle RAC搭建建配置共享存儲(chǔ)(ASM依賴)方法一:vmwware wworksttationn 9虛擬共共享存儲(chǔ)在VM安裝目錄錄VMwaare Woorkstaation下下執(zhí)行命令:#vmwaree-vdisskmanaager.eexe -cc -s 1

8、1GB -aa lsillogic -t 2 D:raacDiskkdb011.vmdkk#vmwaree-vdisskmanaager.eexe -cc -s 11GB -aa lsillogic -t 2 D:raacDiskkdb022.vmdkk#vmwaree-vdisskmanaager.eexe -cc -s 11GB -aa lsillogic -t 2 D:raacDiskkdb033.vmdkk#vmwaree-vdisskmanaager.eexe -cc -s 110GB -a lsiilogicc -t 22 D:rracDisskdb004.vmddk#vmware

9、e-vdisskmanaager.eexe -cc -s 55GB -aa lsillogic -t 2 D:raacDiskkdb055.vmdkk修改rac1和和rac2下的的.vmx文件件,在最后一一行添加如下下內(nèi)容:diskLibb.dataaCacheeMaxSiize=0 diskLibb.dataaCacheeMaxReeadAheeadSizze=0diskLibb.dataaCacheeMinReeadAheeadSizze=0diskLibb.dataaCacheePageSSize=44096diskLibb.maxUUnsynccedWriites = 0disk.lo

10、ockingg = FFALSEscsi1.sshareddBus = virrtual scsi1.ppresennt = TRUEscsi1.vvirtuaalDev = lssilogiicscsi1:00.modee = iindepeendentt-perssistenntscsi1:00.deviiceTyppe = diskscsi1:00.pressent = TRUUEscsi1:00.fileeName = D:racDDiskddb01.vvmdkscsi1:11.modee = iindepeendentt-perssistenntscsi1:11.deviiceTyp

11、pe = diskscsi1:11.pressent = TRUUEscsi1:11.fileeName = D:racDDiskddb02.vvmdk scsi1:22.modee = iindepeendentt-perssistenntscsi1:22.deviiceTyppe = diskscsi1:22.pressent = TRUUEscsi1:22.fileeName = D:racDDiskddb03.vvmdk scsi1:33.modee = iindepeendentt-perssistenntscsi1:33.deviiceTyppe = diskscsi1:33.pr

12、essent = TRUUEscsi1:33.fileeName = D:racDDiskddb04.vvmdkscsi1:44.modee = iindepeendentt-perssistenntscsi1:44.deviiceTyppe = diskscsi1:44.pressent = TRUUEscsi1:44.fileeName = D:racDDiskddb05.vvmdk重新打開虛擬機(jī)機(jī),并啟動(dòng)。磁盤分區(qū),在rrac1執(zhí)行行#fdisk /dev/sdbDevice contaains nneitheer a vvalid DOS ppartittion ttable, nor

13、 Sun, SGI oor OSF dissklabeel Buildinng a nnew DOOS dissklabeel. Chhangess willl remaain inn memoory onnly, until yyou deecide to wrrite tthem. Afterr thatt, of coursse, thhe preeviouss contentt wont be recovverablle. Warningg: invvalid flag 0 x00000 of partiition tablee 4 wiill bee corrrectedd by w

14、w(ritee)Commandd (m ffor heelp): pDisk /ddev/sddb: 10048 MBB, 104485760000 byytes 64 headds, 322 secttors/ttrack, 10000 cyliinderss Units = cyliinderss of 22048 * 512 = 10448576 bytess Deviice Booot Sttart Endd Bloccks Id SSystemm Commandd (m ffor heelp): nCommandd actiion e extennded p primaary paa

15、rtitiion (11-4)pPartitiion nuumber (1-4): 1First ccylindder (11-10000, deffault 1):Using ddefaullt vallue 1 Last cyylindeer or +sizee or +sizeMM or +sizeKK (1-11000, defauult 10000): Using ddefaullt vallue 10000 Commandd (m ffor heelp): wThe parrtitioon tabble haas beeen alttered! Callingg iocttl()

16、tto re-read partiition tablee. Syncingg diskks.#fdisk /dev/sdc 重復(fù)上面操操作#fdisk /dev/sdd 重復(fù)上面操操作#fdisk /dev/sde 重復(fù)上面操操作#fdisk /dev/sdf 重復(fù)上面操操作方法二:Linnux moount掛載載(待解決)安裝依賴包#yum innstalll -y eexpectt* isccsi* bbinutiils* ccompatt-libsstdc+* exppat* eelfutiils-liibelf* gcc* glibbc* kssh* liibgcc*#yum inn

17、stalll -y ppdksh* libggomp* compaat-db* libXXp* liibaio* cpp* setaarch* syssttat* llibstddc+* make-3*#yum innstalll -y uunixODDBC#yum innstalll -y uunixODDBC-deevel查看依賴包安裝裝狀況#rpm -qq -qff %NNAME-%VERRSION-%REELEASEE(%AARCH)n bbinutiils elfutills-libbelf elfutills-libbelf expat gcc gcc-c+ glibc glibc

18、-ccommonn glibc-ddevel glibc-hheaderrs ksh libaio libaio-devell libgcc libstdcc+ libstdcc+-deevel make pdksh sysstatt unixODBBC unixODBBC-devvel執(zhí)行結(jié)果binutills-.6-226.el55(x86_64)elfutills-libbelf-00.137-3.el55(x86_64)elfutills-libbelf-00.137-3.el55(i3866)elfutills-libbelf-00.137-3.el55(x86_

19、64)elfutills-libbelf-00.137-3.el55(i3866)expat-11.95.88-11.eel5_8(x86_664)expat-11.95.88-11.eel5_8(i386)gcc-4.11.2-544.el5(x86_664)gcc-c+-4.1.2-54.el5(xx86_644)glibc-22.5-1118.el55_10.22(i6866)glibc-22.5-1118.el55_10.22(x86_64)glibc-ccommonn-2.5-118.eel5_100.2(x886_64)glibc-ddevel-2.5-1118.ell5_10.2

20、(x866_64)glibc-ddevel-2.5-1118.ell5_10.2(i3886)glibc-hheaderrs-2.55-118.el5_110.2(xx86_644)ksh-2011006211-18.eel5(x886_64)libaio-0.3.1106-5(x86_664)libaio-0.3.1106-5(i386)libaio-devell-0.3.106-55(i3866)libaio-devell-0.3.106-55(x86_64)libgcc-4.1.22-54.eel5(x886_64)libgcc-4.1.22-54.eel5(i3386)libstdcc

21、+-4.1.2-554.el55(x86_64)libstdcc+-4.1.2-554.el55(i3866)libstdcc+-deevel-44.1.2-54.ell5(x866_64)libstdcc+-deevel-44.1.2-54.ell5(i3886)make-3.81-3.el5(xx86_644)pdksh-55.2.144-37.eel5_8.1(x866_64)sysstatt-7.0.2-12.el5(xx86_644)unixODBBC-2.22.11-110.el55(i3866)unixODBBC-2.22.11-110.el55(x86_64)unixODBBC

22、-devvel-2.2.11-10.ell5(x866_64)unixODBBC-devvel-2.2.11-10.ell5(i3886)網(wǎng)絡(luò)配置修改rac1和和rac2的netwoork#vi /ettc/syssconfiig/nettworkNETWORKKING=yyesNETWORKKING_IIPV6=nnoHOSTNAMME=racc1 #此處處為主機(jī)名GATEWAYY=54#vi /ettc/syssconfiig/nettworkNETWORKKING=yyesNETWORKKING_IIPV6=nnoHOSTNAMME=racc2GATEWAYY=172

23、.16.1.254修改rac1和和rac2的hostss#vi /ettc/hossts#eth00-Publlic IPP#111 racc1122 racc2#eth11PRIVVATE IIP#111 rac11-privv122 rac22-privv#VIP#111 rac11-vip122 rac22-vip#SCANN#000 racc-clusster-sscan重啟rac1和和rac2網(wǎng)絡(luò)絡(luò)服務(wù)#servicce nettwork restaart配置虛擬IP#ifconffi

24、g etth0:0 111 neetmaskk 255.255.00.0 upp#ifconffig etth0:0 112 neetmaskk 255.255.00.0 upp*注:虛擬IPP在重啟網(wǎng)絡(luò)絡(luò)服務(wù)會(huì)被卸卸載,需要重重新設(shè)置。配置NTPD服服務(wù)NTPD服務(wù)為為Grid的檢檢查項(xiàng),提供供時(shí)間同步服服務(wù)。修改NTPD參參數(shù)文件(rrac1,rac2)#vi /ettc/syssconfiig/ntppdSYNC_HWWCLOCKK=yesOPTIONSS=-x -u nttp:ntpp -p /var/rrun/nttpd.piid修改rac1的的ntpd.conf文文件,刪除原原有內(nèi)

25、容錄入入以下內(nèi)容#cp /ettc/ntpp.conff /etcc/ntp.conf.bak#vi /ettc/ntpp.conffrestricct 0.00.0.0 mask 0.0.00.0 noomodiffyserver127.1127.1.0fudge1127.1227.1.00 straatum 110restricct 12driftfiile /vvar/liib/ntpp/drifftbroadcaastdellay 0.008authentticatee nokeys /eetc/nttp/keyys清空rac1的的ntpseerverss原有內(nèi)容#

26、cp /ettc/ntpp/ntpsserverrs /ettc/ntpp/ntpsserverrs.bakk#vi /ettc/ntpp/ntpsserverrs編輯rac1的的step-tickeers,添加加一行#cp /ettc/ntpp/stepp-tickkers /etc/nntp/sttep-tiickerss.bak#vi /ettc/ntpp/stepp-tickkers127.1277.1.0修改rac2的的ntpd.conf文文件,刪除原原有內(nèi)容錄入入以下內(nèi)容#cp /ettc/ntpp.conff /etcc/ntp.conf.bak#vi /ettc/ntpp.co

27、nffrestricct 0.00.0.0 mask 0.0.00.0 noomodiffyserver127.1127.1.0server211fudge1127.1227.1.00 straatum 110driftfiile /vvar/liib/ntpp/drifftbroadcaastdellay 0.008authentticatee nokeys /eetc/nttp/keyys清空rac2的的ntpseerverss原有內(nèi)容#cp /ettc/ntpp/ntpsserverrs /ettc/ntpp/ntpsserverrs.bakk#vi /ettc/ntpp/ntpsser

28、verrs編輯rac2的的step-tickeers,添加加一行#cp /ettc/ntpp/stepp-tickkers /etc/nntp/sttep-tiickerss.bak#vi /ettc/ntpp/stepp-tickkers111#rac11的ip地址rac1節(jié)點(diǎn)重重啟NTPDD服務(wù)#servicce ntppd resstartrac2節(jié)點(diǎn)停停止NTPDD服務(wù),racc1重啟NTPDD服務(wù)后5、6分鐘再執(zhí)行行#servicce ntppd stoop#ntpdatte racc1#servicce ntppd staartNTPD啟用自自動(dòng)加載(rrac1

29、,rac2)#chkconnfig nntpd oon關(guān)閉服務(wù)關(guān)閉rac1和和rac2無(wú)用用的senddmail和和cups服務(wù)務(wù),加快開機(jī)機(jī)速度。#chkconnfig ssendmaail offf#chkconnfig ccups ooff用戶、用戶組創(chuàng)建用戶和用戶戶組#groupaadd -gg 501 oinsttall#groupaadd -gg 502 dba#groupaadd -gg 504 asmaddmin#groupaadd -gg 506 asmdbba#groupaadd -gg 507 asmopper#useraddd -u 501 -g oinnstalll

30、-G ddba,assmadmiin,asmmdba,aasmopeer griid#useraddd -u 502 -g oinnstalll -G ddba,assmdba oraclle#id oraacle#id griid修改用戶密碼#passwdd oraccle#passwdd gridd文件夾及權(quán)限#mkdir -p /uu01/appp/griid/#mkdir -p /uu01/appp/11.2.0/ggrid/pproducct/db_1#mkdir -p /uu01/appp/oraaInvenntory#chown -R grrid:oiinstalll /u001

31、/appp#mkdir -p /uu01/appp/oraacle/pproducct/11.2.0/ddb_1#chown -R orracle:oinsttall /u01/aapp/orracle#chmod -R 7775 /u001修改系統(tǒng)參數(shù)修改rac1和和rac2的limitts.connf#vi /ettc/seccurityy/limiits.coonf#ORACCLE SEETTINGGgrid ssoft nprroc 2047grid hhard nprroc 163844grid ssoft noffile 1024grid hhard noffile 655366o

32、racle ssoft nprroc 2047oracle hhard nprroc 163844oracle ssoft noffile 1024oracle hhard noffile 655366修改rac1和和rac2的/etc/pam.dd/logiin#vi /ettc/pamm.d/loogin#ORACCLE SEETTINGGsessionn rrequirred pamm_limiits.soo修改rac1和和rac2的/etc/syscttl.connf#vi /ettc/syssctl.cconf#ORACCLE SEETTINGGfs.aio-max-nnr = 11

33、0485776fs.filee-max = 68115744kernel.shmalll = 220971552kernel.shmmaax = 55368700912kernel.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_

34、maxx = 100485866執(zhí)行命令(raac1、rac2)#sysctll -p修改rac1和和rac2的profiile,在末末尾添加#vi /ettc/proofileif $UUSER = oraacle | $USSER = gridd ; thenif $SHELLL = /bin/kksh ; theenulimiit -p 163844ulimiit -n 655366elseulimiit -u 163844 -n 665536fiumask 022 fi執(zhí)行命令(raac1、rac2)#sourcee /etcc/proffile修改rac1和和rac2的/etc/cs

35、h.llogin#vi /ettc/cshh.logiinif ( $UUSER = oraacle | $UUSER = griid ) thenlimit maxprroc 166384limit descrriptorrs 655536endifEOFCSH修改grid用用戶的環(huán)境變變量#su - ggrid$cd /hoome/grrid/$vi .baash_prrofileeTMP=/tmmp; exxport TMPTMPDIR=$TMP; expoort TMMPDIRORACLE_SID=+ASM1; expoort ORRACLE_SIDORACLE_BASE=/u01/a

36、pp/ggrid; exporrt ORAACLE_BBASEORACLE_HOME=/u01/app/111.2.00/gridd/prodduct/ddb_1; exporrt ORAACLE_HHOMENLS_DATTE_FORRMAT=yyyy-mm-ddd HH244:MI:SSS; eexportt NLS_DATE_FORMAATTHREADSS_FLAGG=natiive; eexportt THREEADS_FFLAGPATH=$OORACLEE_HOMEE/bin:$PATHH; expport PPATHTHREADSS_FLAGG=natiive; eexportt T

37、HREEADS_FFLAGPATH=$OORACLEE_HOMEE/bin:$PATHH; expport PPATHif $UUSER = oraacle | $USSER = gridd ; thenif $SHELLL = /bin/kksh ; theenulimiit -p 163844ulimiit -n 655366elseulimiit -u 163844 -n 665536fi umaask 0222fi#su - ggrid$cd /hoome/grrid/$vi .baash_prrofileeTMP=/tmmp; exxport TMPTMPDIR=$TMP; expo

38、ort TMMPDIRORACLE_SID=+ASM2; expoort ORRACLE_SIDORACLE_BASE=/u01/app/ggrid; exporrt ORAACLE_BBASEORACLE_HOME=/u01/app/111.2.00/gridd/prodduct/ddb_1; exporrt ORAACLE_HHOMENLS_DATTE_FORRMAT=yyyy-mm-ddd HH244:MI:SSS; eexportt NLS_DATE_FORMAATTHREADSS_FLAGG=natiive; eexportt THREEADS_FFLAGPATH=$OORACLEE

39、_HOMEE/bin:$PATHH; expport PPATHTHREADSS_FLAGG=natiive; eexportt THREEADS_FFLAGPATH=$OORACLEE_HOMEE/bin:$PATHH; expport PPATHif $UUSER = oraacle | $USSER = gridd ; thenif $SHELLL = /bin/kksh ; theenulimiit -p 163844ulimiit -n 655366elseulimiit -u 163844 -n 665536fi umaask 0222fi執(zhí)行命令(raac1、rac2)$sour

40、cee .bassh_proofile修改oraclle用戶的環(huán)環(huán)境變量#su - ooraclee$cd /hoome/orracle/$vi .baash_prrofilee# Oraclle Setttingss oraccleTMP=/tmmp; exxport TMPTMPDIR=$TMP; expoort TMMPDIRORACLE_BASE=/u01/app/ooraclee; expport OORACLEE_BASEEORACLE_HOME=$ORACCLE_BAASE/prroductt/11.22.0/dbb_1; eexportt ORACCLE_HOOMEORACLE

41、_SID=oorcl1; expoort ORRACLE_SIDORACLE_TERM=xtermm; expport OORACLEE_TERMMPATH=/uusr/sbbin:$PPATH; exporrt PATTHPATH=$OORACLEE_HOMEE/bin:$PATHH; expport PPATHLD_LIBRRARY_PPATH=$ORACLLE_HOMME/libb:/libb:/usrr/lib; expoort LDD_LIBRRARY_PPATHCLASSPAATH=$OORACLEE_HOMEE/JRE:$ORACCLE_HOOME/jllib:$OORACLEE

42、_HOMEE/rdbmms/jliib; exxport CLASSSPATHNLS_DATTE_FORRMAT=yyyy-mm-ddd HH244:MI:SSS; eexportt NLS_DATE_FORMAATNLS_LANNG=AMEERICANN_AMERRICA.ZZHS16GGBK;exxport NLS_LLANGif $UUSER = oraacle | $USSER = gridd ; thenif $SHELLL = /bin/kksh ; theenulimiit -p 163844ulimiit -n 655366elseulimiit -u 163844 -n 66

43、5536fiumask 022fi#su - ggrid$cd /hoome/grrid/$vi .baash_prrofilee# Oraclle Setttingss oraccleTMP=/tmmp; exxport TMPTMPDIR=$TMP; expoort TMMPDIRORACLE_BASE=/u01/app/ooraclee; expport OORACLEE_BASEEORACLE_HOME=$ORACCLE_BAASE/prroductt/11.22.0/dbb_1; eexportt ORACCLE_HOOMEORACLE_SID=oorcl2; expoort ORR

44、ACLE_SIDORACLE_TERM=xtermm; expport OORACLEE_TERMMPATH=/uusr/sbbin:$PPATH; exporrt PATTHPATH=$OORACLEE_HOMEE/bin:$PATHH; expport PPATHLD_LIBRRARY_PPATH=$ORACLLE_HOMME/libb:/libb:/usrr/lib; expoort LDD_LIBRRARY_PPATHCLASSPAATH=$OORACLEE_HOMEE/JRE:$ORACCLE_HOOME/jllib:$OORACLEE_HOMEE/rdbmms/jliib; exx

45、port CLASSSPATHNLS_DATTE_FORRMAT=yyyy-mm-ddd HH244:MI:SSS; eexportt NLS_DATE_FORMAATNLS_LANNG=AMEERICANN_AMERRICA.ZZHS16GGBK;exxport NLS_LLANGif $UUSER = oraacle | $USSER = gridd ; thenif $SHELLL = /bin/kksh ; theenulimiit -p 163844ulimiit -n 655366elseulimiit -u 163844 -n 665536fiumask 022fi執(zhí)行命令(ra

46、ac1、rac2)$sourcee .bassh_proofile配置用戶等效性性使用Oraclle用戶,在在所有節(jié)點(diǎn)執(zhí)執(zhí)行#su - ooraclee$ssh-keeygen -t rssaGeneratting ppublicc/privvate rrsa keey paiir.Enter ffile iin whiich too savee the key (/homee/oraccle/.sssh/idd_rsa): Createdd direectoryy /hoome/orracle/.ssh.Enter ppassphhrase (emptty forr no ppassphhr

47、ase): Enter ssame ppassphhrase againn: Your iddentifficatiion haas beeen savved inn /homme/oraacle/.ssh/iid_rsaa.Your puublic key hhas beeen saaved iin /hoome/orracle/.ssh/id_rssa.pubb.The keyy finggerpriint iss:be:8b:334:fd:c9:344:a7:22f:d2:f7:d99:30:11f:2e:48:d66 oraccleraac1$ssh-keeygen -t dssaGe

48、neratting ppublicc/privvate ddsa keey paiir.Enter ffile iin whiich too savee the key (/homee/oraccle/.sssh/idd_dsa): Enter ppassphhrase (emptty forr no ppassphhrase): Enter ssame ppassphhrase againn: Your iddentifficatiion haas beeen savved inn /homme/oraacle/.ssh/iid_dsaa.Your puublic key hhas beee

49、n saaved iin /hoome/orracle/.ssh/id_dssa.pubb.The keyy finggerpriint iss:4f:bc:44b:9a:a6:cdd:1c:115:e7:67:922:94:aa2:cd:50:144 oraccleraac1使用Oraclle用戶,在在節(jié)點(diǎn)racc1執(zhí)行$cat /hhome/ooraclee/.sshh/*.puub /homee/oraccle/.sssh/auuthoriized_kkeys$ssh raac2 caat /hoome/orracle/.ssh/*.pubb /home/oraclle/.sssh/au

50、tthorizzed_keeys $scp /hhome/ooraclee/.sshh/authhorizeed_keyys racc2:/hoome/orracle/.ssh/authoorizedd_keyss驗(yàn)證Oraclle用戶等效效性,在所有有節(jié)點(diǎn)執(zhí)行$ssh raac2 daate$ssh raac1 daate$ssh raac2-viip datte$ssh raac1-viip datte$ssh raac2-prriv daate$ssh raac1-prriv daates使用grid用用戶,在所有有節(jié)點(diǎn)執(zhí)行#su - ggrid$ssh-keeygen -t rssaG

51、eneratting ppublicc/privvate rrsa keey paiir.Enter ffile iin whiich too savee the key (/homee/gridd/.sshh/id_rrsa): Createdd direectoryy /hoome/grrid/.sssh.Enter ppassphhrase (emptty forr no ppassphhrase): Enter ssame ppassphhrase againn: Your iddentifficatiion haas beeen savved inn /homme/griid/.ss

52、sh/id_rsa.Your puublic key hhas beeen saaved iin /hoome/grrid/.sssh/idd_rsa.pub.The keyy finggerpriint iss:39:1c:ff5:9b:76:e11:de:220:40:e0:e88:20:777:fa:cd:977 griddrac11$ssh-keeygen -t dssaGeneratting ppublicc/privvate ddsa keey paiir.Enter ffile iin whiich too savee the key (/homee/gridd/.sshh/id

53、_ddsa): Enter ppassphhrase (emptty forr no ppassphhrase): Enter ssame ppassphhrase againn: Your iddentifficatiion haas beeen savved inn /homme/griid/.sssh/id_dsa.Your puublic key hhas beeen saaved iin /hoome/grrid/.sssh/idd_dsa.pub.The keyy finggerpriint iss:08:a4:11b:87:89:fbb:cd:993:3f:5d:f88:7b:f

54、f6:67:dd:4cc griddrac11使用grid用用戶,在節(jié)點(diǎn)點(diǎn)rac1執(zhí)行行$ cat /home/grid/.ssh/*.pubb /home/grid/.ssh/authoorizedd_keyss$ssh raac2 caat /hoome/grrid/.sssh/*.pub /hoome/grrid/.sssh/auuthoriized_kkeys$scp /hhome/ggrid/.ssh/aauthorrized_keys rac2:/homee/gridd/.sshh/authhorizeed_keyys驗(yàn)證grid用用戶等效性,在在所有節(jié)點(diǎn)執(zhí)執(zhí)行$ssh raac2

55、 daate$ssh raac1 daate$ssh raac2-viip datte$ssh raac1-viip datte$ssh raac2-prriv daate$ssh raac1-prriv daates重啟rac1、rac2#reboott安裝ASM檢查系統(tǒng)及內(nèi)核核版本#uname aLinux rrac2 22.6.188-164.el5 #1 SMPP Tue Aug 118 15:51:488 EDT 2009 x86_664 x866_64 xx86_644 GNU/Linuxx#lsb_reeleasee aLSBVerssion: :coree-3.1-amd644

56、:coree-3.1-ia32:core-3.1-nnoarchh:grapphics-3.1-aamd64:graphhics-33.1-iaa32:grraphiccs-3.11-noarrchDistribbutor ID: RRedHattEnterrpriseeServeerDescripption: RRed Haat Entterpriise Liinux SServerr releease 55.4 (TTikangga)Releasee: 55.4Codenamme: TTikangga下載與系統(tǒng)及內(nèi)內(nèi)核版本對(duì)應(yīng)應(yīng)的ASM下載地址:http:/technnetworrk/se

57、rrver-sstoragge/linnux/doownloaads/inndex.hhtml當(dāng)前版本:oracleaasm-2.6.18-164.eel5-2.0.5-11.el5.x86_664oracleaasm-2.6.18-164.eel5debbug-2.0.5-11.el5.x86_664oracleaasm-2.6.18-164.eel5-deebuginnfo-2.0.5-11.el5.x86_664oracleaasm-2.6.18-164.eel5xenn-2.0.5-1.eel5.x886_64oracleaasmlibb-2.0.4-1.eel5.x886_64ora

58、cleaasm-suupportt-2.1.8-1.eel5.x886_64安裝asm包,按按順序安裝#rpm -iivh nodepps oraacleassmlib-2.0.44-1.ell5.x866_64.rrpm#rpm -iivh nodepps oraacleassm-suppport-2.1.88-1.ell5.x866_64.rrpm#rpm -iivh nodepps oraacleassm-2.66.18-1164.ell5-2.00.5-1.el5.xx86_644.rpm#rpm -iivh nodepps oraacleassm-2.66.18-1164.ell5-

59、debbuginffo-2.00.5-1.el5.xx86_644.rpm#rpm -iivh nodepps oraacleassm-2.66.18-1164.ell5debuug-2.00.5-1.el5.xx86_644.rpm#rpm -iivh nodepps oraacleassm-2.66.18-1164.ell5xen-2.0.55-1.ell5.x866_64.rrpm初始化asmllib,在所所有節(jié)點(diǎn)執(zhí)行行#/usr/ssbin/ooracleeasm cconfiggure -iConfiguuring the OOraclee ASM libraary drriver.

60、 This wiill coonfiguure thhe on-boot propeertiess of tthe Orracle ASM llibrarry driver. Thee folllowingg quesstionss willl deteerminee whetther tthe drriver is loaded on booot annd whaat perrmissiions iit willl havve. TThe cuurrentt valuueswill bee showwn in brackkets (). Hiittingg wwithouut typping

溫馨提示

  • 1. 本站所有資源如無(wú)特殊說(shuō)明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請(qǐng)下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請(qǐng)聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁(yè)內(nèi)容里面會(huì)有圖紙預(yù)覽,若沒(méi)有圖紙預(yù)覽就沒(méi)有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫(kù)網(wǎng)僅提供信息存儲(chǔ)空間,僅對(duì)用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對(duì)用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對(duì)任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請(qǐng)與我們聯(lián)系,我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對(duì)自己和他人造成任何形式的傷害或損失。

評(píng)論

0/150

提交評(píng)論