1、Oraclle Reestarrt+ASSM+RHHEL5安安裝手冊Oraclle reestarrt數據庫庫是在原來來單實例數數據庫的基基礎上，利利用了Cllusteerwarre增強了了單實例數數據庫的可可用性.可可以使用ssrvcttl,crrsctll命令管理理單實例數數據庫，當當服務器重重起或進程程異常終止止時，能夠夠自動啟動動數據庫.一 OS環環境配置1 創建用用戶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包 查詢rpmm包是否安安裝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、數編譯/ettc/syysctll.connf,增加加以下內容容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 環境變變量 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用用戶執行rrunInnstalller griddHA22-BI-

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

16、:oraacle resttart不不需要要使使用dnss,無需配配置ressove.conff 可忽略略Root用用戶執行oorainnstRooot.ssh ,rroot.sh腳本本 說明: oorainnstRooot.ssh 腳本本是為了設設置清單目目錄的權限限 Root.sh 調調用了一些些其它腳本本,主要包包括cluusterrwaree和系統配配置工作.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執行完該腳腳本后會在在/etcc/iniittabb中添加oohasdd啟動信息息root

25、tHA22-BI-CS011 # catt /ettc/innittaab|taail -1h1:355:resspawnn:/ettc/innit.dd/iniit.ohhasd run /deev/nuull 22&1 /deev/nuull3 檢查高高可用服務務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參數,只有haas,csss,evvm參數.如果使用AASM作為為存儲,CCSS服務務會自動啟啟動.

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用戶執執行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用用戶執行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.四 創建AASM DDiskGGroupp Girdd用戶執行行asmcca griddHA22-BI-CS011 $asmmca指定asmmsys用用戶密碼創建磁盤組組DGSYYS,冗余余級別exxternnal修改asmm pfiile參數數創建磁盤組組DGDAATA, 冗余級別別exteernall