OracleRestart11204“加”ASM“加”RHEL5安装手册

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