OracleRestart11204“加”ASM“加”RHEL5安裝手冊

1、Oraclle Reestarrt+ASSM+RHHEL5安安裝手冊O(shè)raclle reestarrt數(shù)據(jù)庫庫是在原來來單實(shí)例數(shù)數(shù)據(jù)庫的基基礎(chǔ)上，利利用了Cllusteerwarre增強(qiáng)了了單實(shí)例數(shù)數(shù)據(jù)庫的可可用性.可可以使用ssrvcttl,crrsctll命令管理理單實(shí)例數(shù)數(shù)據(jù)庫，當(dāng)當(dāng)服務(wù)器重重起或進(jìn)程程異常終止止時(shí)，能夠夠自動(dòng)啟動(dòng)動(dòng)數(shù)據(jù)庫.一 OS環(huán)環(huán)境配置1 創(chuàng)建用用戶grouppadd g 6000 dbbauseraadd u 6000 g dbba G dbba orracleeuseraadd u 6001 g dbba G dbba grrid chownn R orracl

2、ee:dbaa /orracleechownn R grrid:ddba /gridd chmodd R 7775 /ooracllechmodd R 7775 /ggrid2 版本及及kernnelRHEL55 5.2以上, kerrnel 2.6.18以后后RHEL66 6.0以后 kerrnel 2.6.32-771.ell6.x886_644 以后 3 安裝rrpm包 查詢r(jià)pmm包是否安安裝rpm -q -qf %NAAME-%VEERSIOON-%RELLEASEE (%ARCCH)n bbinuttils compaat-liibstddc+-33 elfuttils-libee

3、lf elfuttils-libeelf-ddevell gcc gcc-cc+ glibcc glibcc-commmon glibcc-devvel glibcc-heaaderss ksh libaiio libaiio-deevel libgccc libsttdc+ libsttdc+-devvel make syssttat unixOODBC unixOODBC-deveelRHEL 5 binuttils-2.177.50.0.6compaat-liibstddc+-33-33.2.33compaat-liibstddc+-33-33.2.33 (322 bitt)elfutt

4、ils-libeelf-00.1255elfuttils-libeelf-ddevell-0.1125gcc-44.1.22gcc-cc+-44.1.22glibcc-2.55-24glibcc-2.55-24 (32 bit)glibcc-commmon-2.5glibcc-devvel-22.5glibcc-devvel-22.5 (32 bbit)glibcc-heaaderss-2.55ksh-2200600214libaiio-0.3.1006libaiio-0.3.1006 (332 biit)libaiio-deevel-0.3.106libaiio-deevel-0.3.106

5、 (32 bit)libgccc-4.1.2libgccc-4.1.2 (32 bit)libsttdc+-4.11.2libsttdc+-4.11.2 (32 bbit)libsttdc+-devvel 44.1.22make-3.811syssttat-77.0.22unixOODBC-2.2.11unixOODBC-2.2.11 (32 bbit)unixOODBC-deveel-2.2.111unixOODBC-deveel-2.2.111 (322 bitt)REHL66 binuttils-2.200.51.0.2-5.111.el66 (x886_644)compaat-liib

6、capp1-1.10-11 (x886_644)compaat-liibstddc+-33-33.2.33-69.el6 (x866_64)compaat-liibstddc+-33-33.2.33-69.el6.i6866gcc-44.4.44-13.el6 (x866_64)gcc-cc+-44.4.44-13.el6 (x866_64)glibcc-2.112-1.7.ell6 (ii686)glibcc-2.112-1.7.ell6 (xx86_664)glibcc-devvel-22.12-1.7.el6 (x866_64)glibcc-devvel-22.12-1.7.el6.i6

7、866kshlibgccc-4.4.4-13.eel6 (i6866)libgccc-4.4.4-13.eel6 (x86_64)libsttdc+-4.44.4-113.ell6 (xx86_664)libsttdc+-4.44.4-113.ell6.i6686libsttdc+-devvel-44.4.44-13.el6 (x866_64)libsttdc+-devvel-44.4.44-13.el6.i6866libaiio-0.3.1007-100.el66 (x886_644)libaiio-0.3.1007-100.el66.i6886libaiio-deevel-0.3.107-

8、10.eel6 (x86_64)libaiio-deevel-0.3.107-10.eel6.ii686make-3.811-19.el6syssttat-99.0.44-11.el6 (x866_64)unixOODBC-2.2.14-111.ell6 (xx86_664) oor laaterunixOODBC-2.2.14-111.ell6.i6686 oor laaterunixOODBC-deveel-2.2.144-11.el6 (x866_64) or lateerunixOODBC-deveel-2.2.144-11.el6.i6866 or lateer4 kerrnel參參

9、數(shù)編譯/ettc/syysctll.connf,增加加以下內(nèi)容容kerneel.mssgmnbb = 6655366kerneel.mssgmaxx = 6655366kerneel.mssgmnii = 22878kerneel.seem = 250 3200000 1100 1128kerneel.shhmmnii = 44096kerneel.shhmmaxx = 44294996729960kerneel.shhmalll = 220971152net.ccore.rmemm_deffaultt = 22621444net.ccore.rmemm_maxx = 441943304net

10、.ccore.wmemm_deffaultt = 22621444net.ccore.wmemm_maxx = 110485576fs.aiio-maax-nrr = 110485576fs.fiile-mmax = 681157444net.iipv4.ip_llocall_porrt_raange = 90000 66550005 用戶限限制編譯/ettc/seecuriity/llimitts.coonf oraclle haard nnofille 6655366oraclle sooft nnofille 6655366oraclle sooft sstackk 102240orac

11、lle haard nnprocc 163384oraclle sooft nnprocc 163384grid harrd noofilee 655536grid sofft noofilee 655536grid sofft sttack 102440grid harrd npproc 163884grid sofft npproc 1638846 環(huán)境變變量 Oraclle用戶#FOr oraccle eenvexporrt ORRACLEE_SIDD=NGDDWATEESTexporrt ORRACLEE_BASSE=/ooraclleexporrt ORRACLEE_HOMME=$O

12、ORACLLE_BAASE/ddbexporrt LDD_LIBBRARYY_PATTH=$OORACLLE_HOOME/llib:$ORACCLE_HHOME/lib332:/uusr/llib:/libexporrt PAATH=$PATHH:$ORRACLEE_HOMME/biin:$OORACLLE_HOOME/OOPatcch#For commmand aliaasaliass ss=sqllpluss / as ssysdbbaaliass ls=ls -lFaliass bduump=cd /oraccle/ddiag/rdbmms/dwwatesst/DWWATESST/trr

13、acestty erasse HHexporrt TMMOUT=0grid用用戶#For gridd envvexporrt ORRACLEE_SIDD=+ASSMexporrt ORRACLEE_BASSE=/ooraclle exporrt ORRACLEE_HOMME=/ggrid #forr amss hommeexporrt GRRID_HHOME=/griid #foor grrid hhomeexporrt LDD_LIBBRARYY_PATTH=$OORACLLE_HOOME/llib:$ORACCLE_HHOME/lib332:/uusr/llib:/libexporrt P

14、AATH=$ORACCLE_HHOME/bin:$ORAACLE_HOMEE/OPaatch:$GRIID_HOOME/bbin:$PATHH#For commmand aliaasaliass ss=sqllpluss / as ssysassmaliass ls=ls -lFaliass bduump=cd /oraccle/ddiag/asm/+asmm/+ASSM/trracestty erasse HHexporrt TMMOUT=0二 安裝GGrid Infrrastrructuure 1 安裝ggrid Grid用用戶執(zhí)行rrunInnstalller griddHA22-BI-

15、CS011 girrd$ ./runIInstaallerr 選擇skkip ssoftwware updaates 注: 此處處可選擇iinstaall ooraclle grrid iinfraastruucturre sooftwaare oonly或或conffigurre orraclee griid innfrasstruccturee a sstanddalonne seerverr，時(shí)選擇擇后者時(shí)oocr必須須放在ASSM上。選擇os grouup dbba指定oraacle_basee,griid_hoome路徑徑指定oraaInveentorry路徑檢查包,參參數(shù)配置等等注

16、:oraacle resttart不不需要要使使用dnss,無需配配置ressove.conff 可忽略略Root用用戶執(zhí)行oorainnstRooot.ssh ,rroot.sh腳本本 說明: oorainnstRooot.ssh 腳本本是為了設(shè)設(shè)置清單目目錄的權(quán)限限 Root.sh 調(diào)調(diào)用了一些些其它腳本本,主要包包括cluusterrwaree和系統(tǒng)配配置工作.roottHA22-BI-CS011 # /orraclee/oraaInveentorry/orrainsstRooot.shh Changging permmissiions of /oraccle/ooraInnventto

17、ry.Addinng reead,wwritee perrmisssionss forr grooup.Removving readd,wriite,eexecuute ppermiissioons ffor wworldd.Changging grouupnamme off /orraclee/oraaInveentorry too dbaa.The eexecuutionn of the scriipt iis coompleete.roottHA22-BI-CS011 # /grrid/rroot.shPerfoorminng rooot uuser operratioon foor O

18、rraclee 11gg The ffolloowingg envvironnmentt varriablles aare sset aas: OORACLLE_OWWNER= griid OORACLLE_HOOME= /grridEnterr thee fulll paathnaame oof thhe loocal bin direectorry: /usrr/loccal/bbin: Coopyinng dbbhomee to /usrr/loccal/bbin . Coopyinng orraenvv to /usrr/loccal/bbin . Coopyinng cooraenn

19、v too /ussr/loocal/bin .Creatting /etcc/oraatab filee.Entriies wwill be aaddedd to the /etcc/oraatab filee as needded bbyDatabbase Conffigurratioon Asssisttant whenn a ddatabbase is ccreattedFinisshed runnning geneeric partt of roott scrript.Now pproduuct-sspeciific roott acttionss willl bee perrfor

20、mmed.To coonfiggure Gridd Inffrasttructture for a Sttand-Alonne Seerverr runn thee folllowiing ccommaand aas thhe rooot uuser:/gridd/perrl/biin/peerl -I/grrid/pperl/lib -I/ggrid/crs/insttall /griid/crrs/innstalll/rooothaas.pllTo coonfiggure Gridd Inffrasttructture for a Cllusteer exxecutte thhe fool

21、lowwing commmand:/gridd/crss/connfig/conffig.sshThis commmand launnchess thee Griid Innfrasstruccturee Connfiguuratiion WWizarrd. TThe wwizarrd allso ssuppoorts sileent ooperaationn, annd thhe paarameeterss cann be passsed tthrouugh tthe rrespoonse filee thaat iss avaailabble iin thhe innstalllatiio

22、n mmediaa.2 配置SStanddalonneroottHA22-BI-CS011 # /grrid/pperl/bin/perll -I/gridd/perrl/liib -II/griid/crrs/innstalll /ggrid/crs/insttall/rootthas.plUsingg connfiguuratiion pparammeterr fille: /gridd/crss/insstalll/crssconffig_pparammsCreatting tracce diirecttoryUser ignoored Prerrequiisitees duuringg

23、 insstalllatioonLOCALL ADDD MODDE Creatting OCR keyss forr useer ggrid, prrivgrrp ddba.Operaationn succcesssful.LOCALL ONLLY MOODE Succeessfuully accuumulaated neceessarry OCCR keeys.Creatting OCR keyss forr useer rroot, prrivgrrp rroot.Operaationn succcesssful.CRS-44664: Nodde haa2-bii-cs001 suucce

24、sssfullly ppinneed.Addinng Cllusteerwarre enntriees too iniittabb ha2-bbi-css01 20133/10/22 110:100:12 /gridd/cdaata/hha2-bbi-css01/bbackuup_2001310022_11010112.ollrSucceessfuully conffigurred OOraclle Grrid IInfraastruucturre foor a Stanndaloone SServeer執(zhí)行完該腳腳本后會在在/etcc/iniittabb中添加oohasdd啟動(dòng)信息息root

25、tHA22-BI-CS011 # catt /ettc/innittaab|taail -1h1:355:resspawnn:/ettc/innit.dd/iniit.ohhasd run /deev/nuull 22&1 /deev/nuull3 檢查高高可用服務(wù)務(wù)roottHA22-BI-CS011 # /grrid/bbin/ccrscttl chheck hasCRS-44638: Oraacle Highh Avaailabbilitty Seervicces iis onnlineeroottHA22-BI-CS011 # /grrid/bbin/ccrscttl chheck c

26、ssCRS-44530: Commmuniicatiions faillure conttactiing CClustter SSynchhroniizatiion SServiices daemmonroottHA22-BI-CS011 # /grrid/bbin/ccrscttl chheck evmCRS-44533: Eveent MManagger iis onnlinee 注:對于于stanndaloone sserveer來說,crscctl命令令沒有cllusteer,crrs參數(shù),只有haas,csss,evvm參數(shù).如果使用AASM作為為存儲,CCSS服務(wù)務(wù)會自動(dòng)啟啟動(dòng).

27、4 檢查OOCRroottHA22-BI-CS011 # catt /ettc/orraclee/olrr.loccolrcoonfigg_locc=/grrid/ccdataa/loccalhoost/hha2-bbi-css01.oolrcrs_hhome=/griidroottHA22-BI-CS011 # /grrid/bbin/oocrchheckStatuus off Oraacle Clusster Regiistryy is as ffolloows : Verssion : 3 Totaal sppace (kbyytes) : 22621220 Usedd spaace (

28、kbyttes) : 1552 Avaiilablle sppace (kbyytes) : 22619668 ID : 1129733986446 Deviice/FFile Namee : /gridd/cdaata/llocallhostt/loccal.oocr DDevicce/Fiile iinteggrityy cheeck ssucceeededd DDevicce/Fiile nnot cconfiigureed DDevicce/Fiile nnot cconfiigureed DDevicce/Fiile nnot cconfiigureed DDevicce/Fiile

29、 nnot cconfiigureed Clusster regiistryy inttegriity ccheckk succceedded Logiical corrruptiion ccheckk succceedded三 安裝OOraclle Daatabaase Oraclle用戶執(zhí)執(zhí)行runnInsttalleer oraccleHHA2-BBI-CSS01 ddatabbase$./rrunInnstalller 跳過moss支持跳過更新選擇insstalll dattabasse sooftwaare oonly選擇sinngle insttancee dattabasse i

30、nnstalllatiion 選擇engglishh 選擇entterprrise edittion 選擇組件,除oraacle lablle seecuriity,ooraclle daatabaase vvaultt opttion之之外全選指定oraacle_basee,oraacle_homee路徑指定os grouup dbbaRoot用用戶執(zhí)行rroot.sh腳本本 roottHA22-BI-CS011 db# /ooraclle/dbb/rooot.shhPerfoorminng rooot uuser operratioon foor Orraclee 11gg The ffo

31、lloowingg envvironnmentt varriablles aare sset aas: OORACLLE_OWWNER= oraacle OORACLLE_HOOME= /orraclee/dbEnterr thee fulll paathnaame oof thhe loocal bin direectorry: /usrr/loccal/bbin: The cconteents of dbhoome havee nott chaangedd. Noo neeed too oveerwriite.The cconteents of oraeenv havee nott cha

32、angedd. Noo neeed too oveerwriite.The cconteents of coraaenv havve noot chhangeed. NNo neeed tto ovverwrrite.Entriies wwill be aaddedd to the /etcc/oraatab filee as needded bbyDatabbase Conffigurratioon Asssisttant whenn a ddatabbase is ccreattedFinisshed runnning geneeric partt of roott scrript.Now pproduuct-sspeciific roott acttionss willl bee perrformmed.Finisshed prodduct-speccificc rooot acctionns.四 創(chuàng)建AASM DDiskGGroupp Girdd用戶執(zhí)行行asmcca griddHA22-BI-CS011 $asmmca指定asmmsys用用戶密碼創(chuàng)建磁盤組組DGSYYS,冗余余級別exxternnal修改asmm pfiile參數(shù)數(shù)創(chuàng)建磁盤組組DGDAATA, 冗余級別別exteernall