Oracle11gRAC在RHEL62(x8664)上成功安裝

1、Oracle 11gRAC實施文檔1). Hardware RequirementsAll hardware Requirements is OK!2)You aare frree too channge thhe IP addreesses to suuit yoour neetworkk, butt remeember to sttay coonsisttent wwith tthose adjusstmentts thrroughoout thhe resst of the aarticlle.Once thhe bassic innstalllationn is ccompleete,

2、 iinstalll thee folllowingg packkages whilsst loggged iin as the rroot uuser. This incluudes tthe 644-bit and 332-bitt verssions of soome paackagees.cd /meddia/GHHOST/PPackagges#注意/meddia/GHHOST/PPackagges為RHHEL安裝目目錄，根據(jù)實實際情況進(jìn)行行調(diào)整。有些些包需要從網(wǎng)網(wǎng)上下載。rpm -Uvvh binnutilss-2.*rrpm -UUvh coompat-libsttdc+-33*r

3、ppm -Uvvh elffutilss-libeelf-0.*rpm -Uvvh elffutilss-libeelf-deevel-*rpm -Uvvh gccc-4.*rrpm -UUvh gccc-c+-4.*rrpm -UUvh gllibc-22.*rpmm -Uvhh glibbc-commmon-22.*rpmm -Uvhh glibbc-devvel-2.*rpm -Uvh glibcc-headders-22.*rpmm -Uvhh ksh-2*rpmm -Uvhh libaaio-0.*rpm -Uvh libaiio-devvel-0.*rpm -Uvh libgccc

4、-4.*rpm -Uvh llibstddc+-44.*yum insstall libsttdc*rppm -Uvvh libbstdc+-devvel-4.*rpm -Uvh make-3.*rppm -Uvvh syssstat*rpm -Uvh uunixODDBC-2.*rpm -Uvh unixOODBC-ddevel-2.*# Instaall thhe folllowinng pacckage from the OOraclee gridd mediia.cd /homme/oraacle/ggrid/rrpmrpm -Uvvh cvuuqdiskk*3）1. Crreate

5、OS grroups usingg the commaand beelow. Enterr thesse commmandss as tthe rroot user:#/usr/ssbin/ggroupaadd -gg 501 oinsttall#/usr/ssbin/ggroupaadd -gg 502 dba#/usr/ssbin/ggroupaadd -gg 504 asmaddmin#/usr/ssbin/ggroupaadd -gg 506 asmdbba#/usr/ssbin/ggroupaadd -gg 507 asmopper2. Creaate thhe useers thh

6、at wiill owwn thee Oraccle sooftwarre usiing thhe commmandss:#/usr/ssbin/uuseraddd -u 502 -g oinnstalll -G ddba,assmdba oraclle#/usr/ssbin/uuseraddd -u 503 -g oinnstalll -G asmaddmin,aasmdbaa,asmoopergrid#注意501為為編號，根據(jù)據(jù)實際情況而而定3. Set the ppasswoord foor thee oraccle acccountt usinng thee folllowingg c

7、ommmand. Replaace paassworrd witth youur ownn passwword.#注意，下面是是修改密碼passwd oracllepasswd grid3) If yyou arre nott usinng DNSS, thee /ettc/hossts ffile mmust ccontaiin thee folllowingg infoormatiion.127.0.00.1 llocalhhost.llocalddomainn loocalhoost# PPublicc172.333.10.3 GIS-AA.locaaldomaain GIS-AA172

8、.333.10.4 GIS-BB.locaaldomaain GIS-BB# Priivate1172.322.50.33 GGIS-A-priv.localldomaiin GGIS-A-priv1172.322.50.44 GGIS-B-priv.localldomaiin GGIS-B-priv# Virttual1799 raac1-viip.loccaldommain rac1-vip1700 raac2-viip.loccaldommain rac2-vip# SCAN1172.333.10.223 rrac-sccan.loocaldoom

9、ain rac-scan#注意，這些IIP根據(jù)實際際情況而定，GGIS-A為為服務(wù)器名稱稱4)Add oor ameend thhe folllowinng linnes too the /etcc/syscctl.coonf ffile.fs.aio-max-nnr = 110485776fs.filee-max = 68115744kernel.shmalll = 220971552kernel.shmmaax = 110545004960kernel.shmmnni = 44096# semapphoress: semmmsl, semmnns, seemopm, semmmnikern

10、el.sem = 250 320000 100 128net.ipvv4.ip_locall_portt_rangge = 99000 665500net.corre.rmeem_deffault=2621444net.corre.rmeem_maxx=41944304net.corre.wmeem_deffault=2621444net.corre.wmeem_maxx=10488586Run thee folllowingg commmand tto chaange tthe cuurrentt kernnel paarametters./sbin/ssysctll -pAdd thee

11、folllowingg linees to the /etc/securrity/llimitss.conff fille.oracle ssoft nprroc 2047oracle hhard nprroc 163844oracle ssoft noffile 1024oracle hhard noffile 655366Add thee folllowingg linees to the /etc/pam.dd/logiin fiile, iif it does not aalreaddy exiist.sessionn rrequirred pamm_limiits.sooDisabl

12、ee secuure liinux bby ediiting the /etc/selinnux/coonfig filee, makking ssure tthe SEELINUXX flagg is sset ass folllows.SELINUXX=disaabledAlternaativelly, thhis allterattion ccan bee donee usinng thee GUI tool (Systtem Adminnistraation Seccurityy Leveel andd Fireewall). Cliick onn the SELinnux taab

13、andd disaable tthe feeaturee.Either confiigure NTP, or maake suure itt is nnot coonfiguured sso thee Oraccle Cllusterr Timee Syncchroniizatioon Serrvice (ctsssd) caan synnchronnize tthe tiimes oof thee RAC nodess. In this case we wiill deeconfiigure NTP.# serviice nttpd sttopShuttinng dowwn ntppd: O

14、K # chkcoonfig ntpd off# mv /eetc/nttp.connf /ettc/ntpp.conff.origg# rm /vvar/ruun/ntppd.piddIf you are uusing NTP, you mmust aadd thhe -xx opttion iinto tthe foollowiing liine inn the /etcc/syscconfigg/ntpdd fille.OPTIONSS=-x -u nttp:ntpp -p /var/rrun/nttpd.piidThen reestartt NTP.# serviice nttpd r

15、eestarttCreate the ddirecttoriess in wwhich the OOraclee softtware will be innstallled.mkdir -p /uu01/appp/11.2.0/ggridmkdir -p /u001/appp/oraccle/prroductt/11.22.0/dbb_1chown -R oraacle:ooinstaall /uu01chmod -R 7755 /u011/Login aas thee oraccle usser annd addd the folloowing liness at tthe ennd of

16、the .bash_profiile fiile.#此文件的文件件格式很重要要，最好coopy其他服服務(wù)器文件，進(jìn)進(jìn)行修改。下下面為griid用戶下的的.bashh_proffile。OORACLEE_SID根根據(jù)實際情況況而定# .bashh_proffile# Get tthe alliasess and functtionsif -ff /.bbashrcc ; tthen. /.bbashrccfi# User speciific eenviroonmentt and starttup prrogrammsPATH=$PPATH:$HOME/binexport PATHalias ll

17、s=lss -FA ORACLE_SID=+ASM2; expoort ORRACLE_SID ORACLE_BASE=/u01/app/ggrid; exporrt ORAACLE_BBASE ORACLE_HOME=/u01/app/111.2.00/gridd; expport OORACLEE_HOMEE ORACLE_PATH=/u01/app/ooraclee/commmon/orracle/sql; exporrt ORAACLE_PPATH ORACLE_TERM=xtermm; expport OORACLEE_TERMM NLS_DATTE_FORRMAT=DD-MOON-

18、YYYYY HH224:MI:SS; exporrt NLSS_DATEE_FORMMAT TNS_ADMMIN=$OORACLEE_HOMEE/netwwork/aadmin; expoort TNNS_ADMMIN ORA_NLSS11=$OORACLEE_HOMEE/nls/data; expoort ORRA_NLSS11 NLS_LANNG=AMEERICANN_AMERRICA.ZZHS16GGBK; eexportt NLS_LANG PATH=.:$JAVVA_HOMME/biin:$PPATH:$HOMEE/bin:$ORACCLE_HOOME/biin PATH=$PATH

19、:/usrr/bin:/bin:/usr/bin/XX11:/uusr/loocal/bbin PATH=$PATH:/u011/app/commoon/oraacle/bbin export PATH LD_LIBRRARY_PPATH=$ORACLLE_HOMME/libb LD_LIBRRARY_PPATH=$LD_LLIBRARRY_PATTH:$OORACLEE_HOMEE/oraccm/libb LD_LIBRRARY_PPATH=$LD_LLIBRARRY_PATTH:/llib:/uusr/liib:/ussr/loccal/liib export LD_LIIBRARYY_P

20、ATHH CLASSPAATH=$OORACLEE_HOMEE/JRE CLASSPAATH=$CLASSSPATH:$ORAACLE_HHOME/jjlib CLASSPAATH=$CLASSSPATH:$ORAACLE_HHOME/rrdbms/jlib CLASSPAATH=$CLASSSPATH:$ORAACLE_HHOME/nnetworrk/jliib export CLASSSPATH THREADSS_FLAGG=natiive; eexportt THREEADS_FFLAG export TEMP=/tmp export TMPDIIR=/tmmp umask 0022 a

21、lias ssqlpluus=rllwrap sqlpllus alias rrman=rlwraap rmaan alias gggsci=rlwrrap gggsci alias llogdummp=rllwrap logduump alias aasmcmdd=rlwwrap aasmcmdd alias bbase=cd $OORACLEE_BASEE alias hhome=cd $OORACLEE_HOMEE用UDEV掛接接存儲如果用下面的這這種方式編輯輯規(guī)則文件，uudev設(shè)置置是可以出來來的編輯more 99-orracle-asmdeevicess.rulees文件注意：如果

22、rooot下執(zhí)行行scsi_id -whiteelisteed -rreplacce-whiitespaace -devicce=/deev/emccpowerra得到的編編碼跟3600060166030811350044e1a0aa4d8caade3111一致表示格格式正確。此此文件格式很很重要，最好好從其他服務(wù)務(wù)器上coppy，修改KERNEL=emccpowerra, SSUBSYSSTEM=blocck, PPROGRAAM=sscsi_iid -wwhitellistedd -reeplacee-whittespacce -ddevicee=/devv/emcppoweraa, RE

23、ESULT=3600060166030811350044e1a0aa4d8caade3111, NAAME=aasm-1, OWNNER=ggrid, GROUUP=assmadmiin, MODE=06600rootcchnap-itd644 rulees.d# /sbiin/staart_uddev正在啟動 uddev：確確定rootcchnap-itd644 rulees.d# ls -l /deev/asmm-1*brw-rw- 11 gridd asmaadmin 8, 177 1月 28 200:00 /dev/aasm-1brw-rww- 1 griid asmmadminn 8

24、, 117 1月 28 220:00 /dev/asm-22brw-rw- 11 gridd asmaadmin 8, 177 1月 28 200:00 /dev/aasm-4Installl the Grid InfraastrucctureMake suure thhe raac1 aand rrac2 virtuual maachinees aree starrted, then loginn to rac1 as tthe orracle user and sstart the OOraclee insttallerr.注意：現(xiàn)在rooot下執(zhí)行行xhostt +再到ggrid用戶戶執(zhí)

25、行下面程程序./runInnstalllerSelect the Instaall annd Connfigurre Griid Inffrastrructurre forr a Cllusterr opttion, then clickk the Nextt buttton.注意：安裝時請請參考使用UUDEV在OOraclee Linuux 6上安安裝Oraccle 111g RACC() (四) - Zhoong Weeichenng Stuudy Nootes - 博客頻道道 - CSSDN.NEET.htmm和使用UDDEV在Orracle Linuxx 6上安裝裝Oraclle 11gg RAC() (五) - Zhonng Weiichengg Studdy Nottes - 博客頻道 - CSDDN.NETT.htm。Skip sooftwarre upddatesInstalll any Confiigure Oraclle Griid Inffrastrructurre forr a CllusterrAdvanceed Insstallaationadd Simmplifiied Chhinesee不配置GN