《ORACLE rac安装后总结6440.docx》由会员分享，可在线阅读，更多相关《ORACLE rac安装后总结6440.docx（17页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、.linux 安装oracle 总结： Redhat5.4 x64安装ORACLE10G修改 /eetc/vssftpdfttpuserrs annd usser_ 开启FTTP.首先安装以以下包：rpm -q glibcc glibbc-commmon gglibc-devell libXXp binnutilss binuutils compaat-db contrrol-ennter ggcc gccc-c+ libsstdc+ libsstdc+-deveel makke kshh syssstat ggnome-screeensaveer libbaio-ddevel libaiio
2、 opeenmotiif22用以下命令检查查是否全部成成功：$ rpm -qa |ggrep gglibc-2glibbc-2.33.4-2.13compat-glibcc-2.3.2-95.30commpat-gglibc-2.3.22-95.330glibbc-2.33.4-2.13$ rpm -qa |ggrep gglibc-devellglibcc-deveel-2.33.4-2.13glibc-ddevel-2.3.44-2.133 32（332位）rpm -qaa -quueryfoormat %NAAME-%VERSSION-%RELLEASE (%AARCH)n|ggrep
3、终极查看法.以roott用户身份执执行，在两节节点上做如下下配置。编辑/etc/syscttl.connf文件# vi /eetc/syysctl.conf在文件尾部添加加下述内容kernel.shmalll = 220971552kernel.shmmaax = 442949667297/ 物理理内存的一半半kernel.shmmnni = 44096kernel.sem = 250 320000 100 128vm.min_free_kbytees=4099600vm.vfs_cachee_presssure=200vm.swapppinesss =400fs.filee-max = 10
4、11365net.ipvv4.ip_locall_portt_rangge = 99000 665500net.corre.rmeem_deffault = 10448576/ 2556Knet.corre.rmeem_maxx = 100485766/ 1MMnet.corre.wmeem_deffault = 2622144net.corre.wmeem_maxx = 100485766Sysctl -p生效.为 oraacle 用用户设置 SShell 限制.Oracle 建议对每个个 Linuux 帐户可可以使用的进进程数和打开开的文件数设设置限制,RROOT登录录.(/etc/prr
5、ofilee filee (or the ffile oon SUSSE sysstems)/etc/profiile.loocal:if $UUSER = oraacle ; thhenif $SSHELL = /bbin/kssh ; thennulimit -p 166384ulimit -n 655536elseulimit -u 166384 -n 655536fifi For tthe C shelll (cshh or ttcsh), add the ffollowwing llines to thhe/etc/cssh.loggin fiile (oor thee filee
6、on SSUSEsystemss)/etcc/csh.loginn.locaal:if ( $UUSER = orracle ) thhenlimit mmaxprooc 163384limit ddescriiptorss 655336endifAdd thee folllowingg linees to the /etc/ssecuriity/liimits.conf file:oracle soft nprocc 20477oracle hard nprocc 163884oracle soft nofille 10224oracle hard nofille 655536修改/etc/
7、pam.dd/logiin，增加以以下内容sessionn rrequirred /liib/seccurityy/pam_limitts.so配置hangccheck-timerr内核模块以root用户户身份执行，在在两节点上做做如下配置。查看模块是否存存在# find /lib/modulles -nname hangccheck-timerr.ko编辑/etc/modprrobe.cconf# vi /eetc/moodprobbe.connf在文件的末尾加加入一行optionss hanggcheckk-timeer hanngchecck_ticck=30 hangccheck_ma
8、rgiin=1800配置为自启动vi /etcc/rc.dd/rc.llocal在文件的末尾加加入一行/sbin/mmodproobe haangcheeck_tiimer启动hangccheck# modprrobe hhangchheck_ttimer检查hangccheck是是否成功启动动# grep hangccheck /var/log/mmessagges | taail -22如果显示下述信信息说明已经经成功启动hhangchheckMar 16 12:522:32 nnode2 kerneel: Haangcheeck: sstartiing haangcheeck tiime
9、r 00.5.0 (tickk is 1180 seecondss, marrgin iis 60 seconnds).创建ORAACLE用户户及文件夹权权限等新增组和用户：groupaddd oinnstalllgroupaddd dbaauseraddd -g ooinstaall -GG dba oracllepasswd oraclle 创建Oraclle的安装目目录，并把权权限付给orracle用用户:mkdir ooraclee chown -R oraacle:ooinstaall /ooraclee解压databbase修改databbase目录录权限，用户户和用户组chown
10、 -R oraacle：ooinstaall daatabasse/chmod -R 7755 dataabase/. 修改/etc/hostss文件及orracle用用户里的.bbash_pprofille文件# Get tthe alliasess and functtionsif -ff /.bbashrcc ; tthen . /.bashhrcfi# User speciific eenviroonmentt and starttup prrogrammsPATH=$PPATH:$HOME/bin:/usr/bbin:/eetc:/uusr/sbbin:/uusr/uccb:$HOO
11、ME/biin:/ussr/binn/X11:/sbinnexport PATHunset UUSERNAAMEORA_CRSS_BASEE=/oraacle/ccrsORA_CRSS_HOMEE=$ORAA_CRS_BASE/produuct/100.2.0/crs_11ORACLE_BASE=/oraccle/appp#ORACLEE_BASEE=$ORAA_CRS_BASEORACLE_HOME=$ORACCLE_BAASE/prroductt/10.22.0/dbb_1#ORACLEE_HOMEE=$ORAA_CRS_HOMEORACLE_SID=ooradb11PATH=$OORAC
12、LEE_HOMEE/bin:$ORA_CRS_HHOME/bbin:/uusr/loocal/bbin:$PPATHLD_LIBRRARY_PPATH=$ORACLLE_HOMME/libb:$ORAACLE_HHOME/llib32:$ORA_CRS_HHOME/llib:$OORA_CRRS_HOMME/libb32NLS_LANNG=AMEERICANN_AMERRICA.ZZHS16GGBKexport ORA_CCRS_BAASE ORRA_CRSS_HOMEE PATHH NLS_LANG ORACLLE_BASSE ORAACLE_HHOME OORACLEE_SID LD_LI
13、IBRARYY_PATHH. 安装一些RACC_的必要包包compat-binuttils2115-2.115.92.0.2-224.i3886.rpmmoracleaasm-2.6.18-164.eel5-2.0.5-11.el5.x86_664.rpmmoracleaasm-2.6.18-164.eel5debbug-2.0.5-11.el5.x86_664.rpmmoracleaasm-2.6.18-164.eel5-deebuginnfo-2.0.5-11.el5.x86_664.rpmmoracleaasm-2.6.18-164.eel5xenn-2.0.5-1.eel5.x886_
14、64.rpmoracleaasmlibb-2.0.4-1.eel5.x886_64.rpmoracleaasm-suupportt-2.1.3-1.eel5.x886_64.rpm.配置SSHH 用ORACLEE用户执行分别在2台机上上运行mkdir /.sshhchmod 7700 /.sshcd .sshh/usr/biin/sshh-keyggen -tt rsa (回车就OOK)#/usr/bbin/sssh-keyygen -t dsaa (回车就就OK) 这这可以不做在RAC1 机机上运行ssh naame1 ccat /hhome/ooraclee/.sshh/id_rrsa.p
15、uubauuthoriized_kkeys#ssh naame1 ccat /hhome/ooraclee/.sshh/id_ddsa.puubauuthoriized_kkeys这可可以不做ssh namme2 caat /hoome/orracle/.ssh/id_rssa.pubbautthorizzed_keeys#ssh naame2 ccat /hhome/ooraclee/.sshh/id_ddsa.puubauuthoriized_kkeys这可可以不做把authorrized_keys cp 到RRAC2中/home/oraclle/.sssh/scp autthorizze
16、d_keeys raac2:/hhome/ooraclee/.sshh/(分别在2台机机上运行)chmod 6600 auuthoriized_kkeysssh racc2 datteexec /uusr/biin/sshh-agennt $SHHELL /usr/biin/sshh-add 确定ForwaardX111置为no 编辑或创建 $ vi oraclle/.sssh/connfig 内容如下： Host * ForwarddX11 nno 8.Ntpdaate . IP 时间同步步Vi /etcc/ntp.conf服务端restricct 0.00.0.0 mask 0.0.00.
17、0 noomodiffyserver 127.1127.1.0fudge 1127.1227.1.00 straatum 110driftfiile /vvar/liib/ntpp/drifftbroadcaastdellay 0.008authentticatee no keys /eetc/nttp/keyys运行 chkcconfigg ntp on /eetc/innit.d/ntpd restaart客务端restricct 0.00.0.0 mask 0.0.00.0 noomodiffyserver 127.1127.1.0Server . ippfudge 1127.1227.
18、1.00 straatum 110driftfiile /vvar/liib/ntpp/drifftbroadcaastdellay 0.008authentticatee no keys /eetc/nttp/keyys运行ntpdaate ddb1出现信信息调整的信信息表示成功功，一般要55分钟走左右右如果是把内核时时间更新到当当前时间，就就用下面的命命令：hwcclock -hcttosys 检查ntp的版版本，如果你你使用的是nntp4.22（包括4.2）之后的的版本，在rrestriict的定义义中使用了nnotrusst的话，会会导致以上错错误。使用以以下命令检查查ntp的版版本：
19、ntppd -c versiion 如何去掉nottrust？9.磁盘分区10.配置裸设设备vi /etcc/udevv/rulees.d/660-raww.ruleesACTION=addd,KERRNEL=sddllmac1,RUN+=/biin/raww /devv/raw/raw1 %NACTION=addd,KERRNEL=sddllmac2,RUN+=/biin/raww /devv/raw/raw2 %NACTION=addd,KERRNEL=sddllmac5,RUN+=/biin/raww /devv/raw/raw3 %NACTION=addd,KERRNEL=sddllm
20、ac6,RUN+=/biin/raww /devv/raw/raw4 %NACTION=addd,KERRNEL=sddllmac7,RUN+=/biin/raww /devv/raw/raw5 %NKERNEL=raww1-5, OWWNER=oraclle, GGROUP=oinsstall, MODDE=6440用RAW -QAA 查看裸设设备情况11.配置assm注意：必须以rroot 身身份进行首先在nodee1 执行：rootnnode1 # /etc/iinit.dd/oraccleasmm conffigureeConfiguuring the OOraclee ASM lib
21、raary drriver.This wiill coonfiguure thhe on-boot propeertiess of tthe Orracle ASM llibrarrydriver. The folloowing questtions will deterrmine whethher thhe driiver iisloaded on booot annd whaat perrmissiions iit willl havve. Thhe currrent valueeswill bee showwn in brackkets (). Hittting wiithoutt ty
22、piing annanswer will keep that curreent vaalue. Ctrl-C willl aboort.Defaultt userr to oown thhe driiver iinterfface : orracleDefaultt grouup to own tthe drriver interrface : ddbaStart OOraclee ASM libraary drriver on booot (yy/n) n: yyFix perrmissiions oof Oraacle AASM diisks oon booot (y/n) yy: yWr
23、itingg Oraccle ASSM libbrary driveer connfigurrationn: OOK Loadingg moduule ooracleeasm: OKK Mountinng ASMMlib ddriverr fileesysteem: OK Scanninng sysstem ffor ASSM dissks: OK 提示：如果本步步执行出错(可能出错机机率最高的是是在Scannning systeem forr ASM)，不妨将转转换一下命令令行三思笔记-手把手教你你用VMwaare 在linuxx 下安装Oraacle100g RACC httpp:/www
24、w.5ieenet.ccom/ QQQ：54545589 君三三思群：5996662889的执行方式，改改成:rootnnode1 # ssh /ettc/iniit.d/ooracleeasm cconfiggure有可能解决你的的问题！然后切换至noode2 执执行rootnnode2 # /etc/iinit.dd/oraccleasmm conffigureeConfiguuring the OOraclee ASM libraary drriver.This wiill coonfiguure thhe on-boot propeertiess of tthe Orracle ASM
25、 llibrarrydriver. The folloowing questtions will deterrmine whethher thhe driiver iisloaded on booot annd whaat perrmissiions iit willl havve. Thhe currrent valueeswill bee showwn in brackkets (). Hittting wiithoutt typiing annanswer will keep that curreent vaalue. Ctrl-C willl aboort.Defaultt userr
26、 to oown thhe driiver iinterfface : orracleDefaultt grouup to own tthe drriver interrface : ddbaStart OOraclee ASM libraary drriver on booot (yy/n) n: yyFix perrmissiions oof Oraacle AASM diisks oon booot (y/n) yy: yWritingg Oraccle ASSM libbrary driveer connfigurrationn: OOK Loadingg moduule ooracl
27、eeasm: OKK Mountinng ASMMlib ddriverr fileesysteem: OK Scanninng sysstem ffor ASSM dissks: OK 再切换回nodde1 执行行rootnnode1 # /etc/iinit.dd/oraccleasmm creaatedissk VOLL1 /deev/sddd1Markingg diskk /deev/sddd1 ass an AASM diisk: OK rootnnode1 # /etc/iinit.dd/oraccleasmm creaatedissk VOLL2 /deev/sdee1Marki
28、ngg diskk /deev/sdee1 ass an AASM diisk: OK rootnnode1 linuxx-patcch# /etc/iinit.dd/oraccleasmm scanndiskssScanninng sysstem ffor ASSM dissks: OK 查看一下当前的的磁盘组：Scanninng sysstem ffor ASSM dissks: OK rootnnode1 # /etc/iinit.dd/oraccleasmm listtdiskssVOL1VOL2Node2 上上也查看一下下当前磁盘组组：rootnnode2 # /etc/iinit.
29、dd/oraccleasmm scanndiskssScanninng sysstem ffor ASSM dissks: OK rootnnode2 # /etc/iinit.dd/oraccleasmm listtdiskssVOL1VOL2三思笔记-手把手教你你用VMwaare 在linuxx 下安装Oraacle100g RACC httpp:/wwww.5ieenet.ccom/ QQQ：54545589 君三三思群：5996662889Ok,配置完成成，准备进入入到crs 的安装阶段段一些命令Etc/gruub.connf 修修改内核 enforrcing=0 -Xhost +Xc
30、lock 确认介介面Export DISPLLAY=:00.0Export LNAG=en_USS调整语语言在oracell用户下查看看crrs_staat -t 则显示示集群状态打补补丁前要Crs_sstop -all停止止集群Netca 创建数据库 dbca当未成功时完全全卸载RACCrm -f /etc/iinit.dd/initt.cssddrm -ff /etcc/initt.d/innit.crrs rrm -f /etc/init.d/iniit.crssd rrm -f /etc/init.d/iniit.evmmd rrm -f /etc/rc2.dd/K96iinit.ccrs rm -ff /etcc/rc2.d/S966init.crs rm -f /ettc/rc33.d/K996initt.crs rm -f /eetc/rcc3.d/SS96iniit.crss rmm -f /etc/rrc5.d/K96innit.crrs rrm -f /etc/rc5.dd/S96iinit.ccrs rm -RRf /ettc/oraacle/sscls_sscr rm -ff /etcc/initttab.ccrs cp /eetc/innittabb.origg /etcc/initttab