ORACLE rac安装后总结

５.４linux安装oracle总结：Redhat5.4x64安装ORACLE10G修改/etc/vsftpdftpusersanduser__开启FTP１.首先安装以下包：rpm-qglibcglibc-commonglibc-devellibXpbinutilsbinutilscompat-dbcontrol-entergccgcc-c++libstdc++libstdc++-develmakekshsysstatgnome-screensaverlibaio-devellibaioopenmotif22用以下命令检查是否全部成功：$rpm-qa|grepglibc-2glibc-2.3.4-2.13compat-glibc-2.3.2-95.30compat-glibc-2.3.2-95.30glibc-2.3.4-2.13$rpm-qa|grepglibc-develglibc-devel-2.3.4-2.13glibc-devel-2.3.4-2.1332（32位）rpm-qa--queryformat%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n|grep终极查看法２.以root用户身份执行，在两节点上做如下配置。编辑/etc/sysctl.conf文件#vi/etc/sysctl.conf在文件尾部添加下述内容kernel.shmall=2097152kernel.shmmax=4294967297//物理内存的一半kernel.shmmni=4096kernel.sem=25032000100128vm.min_free_kbytes=409600vm.vfs_cache_pressure=200vm.swappiness=40fs.file-max=101365net.ipv4.ip_local_port_range=900065500net.core.rmem_default=1048576//256Knet.core.rmem_max=1048576//1Mnet.core.wmem_default=262144net.core.wmem_max=1048576Sysctl-p生效３.为oracle用户设置Shell限制.Oracle建议对每个Linux帐户可以使用的进程数和打开的文件数设置限制,ROOT登录.(/etc/profilefile(orthefileonSUSEsystems)/etc/profile.local:if[$USER=oracle];thenif[$SHELL=/bin/ksh];thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fifi■FortheCshell(cshortcsh),addthefollowinglinestothe/etc/csh.loginfile(orthefileonSUSEsystems)/etc/csh.login.local:if($USER==oracle)thenlimitmaxproc16384limitdescriptors65536endifAddthefollowinglinestothe/etc/security/limits.conffile:oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile1024oraclehardnofile65536修改/etc/pam.d/login，增加以下内容sessionrequired/lib/security/pam_limits.so配置hangcheck-timer内核模块以root用户身份执行，在两节点上做如下配置。查看模块是否存在#find/lib/modules-namehangcheck-timer.ko编辑/etc/modprobe.conf#vi/etc/modprobe.conf在文件的末尾加入一行optionshangcheck-timerhangcheck_tick=30hangcheck_margin=180配置为自启动vi/etc/rc.d/rc.local在文件的末尾加入一行/sbin/modprobehangcheck_timer启动hangcheck#modprobehangcheck_timer检查hangcheck是否成功启动#grephangcheck/var/log/messages|tail-2如果显示下述信息说明已经成功启动hangcheckMar1612:52:32node2kernel:Hangcheck:startinghangchecktimer0.5.0(tickis180seconds,marginis60seconds).４.创建ORACLE用户及文件夹权限等新增组和用户：groupaddoinstallgroupadddbauseradd-goinstall-Gdbaoraclepasswdoracle创建Oracle的安装目录，并把权限付给oracle用户:mkdiroraclechown-Roracle:oinstall/oracle解压database修改database目录权限，用户和用户组chown-Roracle：oinstalldatabase/chmod-R775database/５.修改/etc/hosts文件及oracle用户里的.bash_profile文件#Getthealiasesandfunctionsif[-f~/.bashrc];then.~/.bashrcfi#UserspecificenvironmentandstartupprogramsPATH=$PATH:$HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbinexportPATHunsetUSERNAMEORA_CRS_BASE=/oracle/crsORA_CRS_HOME=$ORA_CRS_BASE/product/10.2.0/crs_1ORACLE_BASE=/oracle/app#ORACLE_BASE=$ORA_CRS_BASEORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1#ORACLE_HOME=$ORA_CRS_HOMEORACLE_SID=oradb1PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:/usr/local/bin:$PATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$ORA_CRS_HOME/lib:$ORA_CRS_HOME/lib32NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexportORA_CRS_BASEORA_CRS_HOMEPATHNLS_LANGORACLE_BASEORACLE_HOMEORACLE_SIDLD_LIBRARY_PATH６.安装一些RAC_的必要包compat-binutils215-2.15.92.0.2-24.i386.rpmoracleasm-2.6.18-164.el5-2.0.5-1.el5.x86_64.rpmoracleasm-2.6.18-164.el5debug-2.0.5-1.el5.x86_64.rpmoracleasm-2.6.18-164.el5-debuginfo-2.0.5-1.el5.x86_64.rpmoracleasm-2.6.18-164.el5xen-2.0.5-1.el5.x86_64.rpmoracleasmlib-2.0.4-1.el5.x86_64.rpmoracleasm-support-2.1.3-1.el5.x86_64.rpm７.配置SSH用ORACLE用户执行分别在2台机上运行mkdir~/.sshchmod700~/.sshcd.ssh/usr/bin/ssh-keygen-trsa(回车就OK)#/usr/bin/ssh-keygen-tdsa(回车就OK)这可以不做在RAC1机上运行sshname1cat/home/oracle/.ssh/id_rsa.pubauthorized_keys#sshname1cat/home/oracle/.ssh/id_dsa.pubauthorized_keys这可以不做sshname2cat/home/oracle/.ssh/id_rsa.pubauthorized_keys#sshname2cat/home/oracle/.ssh/id_dsa.pubauthorized_keys这可以不做把authorized_keyscp到RAC2中/home/oracle/.ssh/scpauthorized_keysrac2:/home/oracle/.ssh/(分别在2台机上运行)chmod600authorized_keyssshrac2dateexec/usr/bin/ssh-agent$SHELL/usr/bin/ssh-add确定ForwardX11置为no编辑或创建$vi~oracle/.ssh/config内容如下：Host*ForwardX11no8.Ntpdate....IP时间同步Vi/etc/ntp.conf服务端restrict0.0.0.0mask0.0.0.0nomodifyserver127.127.1.0fudge127.127.1.0stratum10driftfile/var/lib/ntp/driftbroadcastdelay0.008authenticatenokeys/etc/ntp/keys运行chkconfigntpon/etc/init.d/ntpdrestart客务端restrict0.0.0.0mask0.0.0.0nomodifyserver127.127.1.0Server..ipfudge127.127.1.0stratum10driftfile/var/lib/ntp/driftbroadcastdelay0.008authenticatenokeys/etc/ntp/keys运行ntpdatedb1出现信息调整的信息表示成功，一般要5分钟走左右如果是把内核时间更新到当前时间，就用下面的命令：hwclock--hctosys检查ntp的版本，如果你使用的是ntp4.2（包括4.2）之后的版本，在restrict的定义中使用了notrust的话，会导致以上错误。使用以下命令检查ntp的版本：ntpd-cversion如何去掉notrust？9.磁盘分区10.配置裸设备vi/etc/udev/rules.d/60-raw.rulesACTION==add,KERNEL==sddlmac1,RUN+=/bin/raw/dev/raw/raw1%NACTION==add,KERNEL==sddlmac2,RUN+=/bin/raw/dev/raw/raw2%NACTION==add,KERNEL==sddlmac5,RUN+=/bin/raw/dev/raw/raw3%NACTION==add,KERNEL==sddlmac6,RUN+=/bin/raw/dev/raw/raw4%NACTION==add,KERNEL==sddlmac7,RUN+=/bin/raw/dev/raw/raw5%NKERNEL==raw[1-5],OWNER=oracle,GROUP=oinstall,MODE=640用RAW-QA查看裸设备情况11.配置asm注意：必须以root身份进行首先在node1执行：[root@node1~]#/etc/init.d/oracleasmconfigureConfiguri