ORACLE rac安装后总结.doc

.linux 安装oracle 总结： Redhat5.4 x64安装ORACLE10G修改 /etc/vsftpdftpusers and user_ 开启FTP.首先安装以下包：rpm -q glibc glibc-common glibc-devel libXp binutils binutils compat-db control-enter gcc gcc-c+ libstdc+ libstdc+-devel make ksh sysstat gnome-screensaver libaio-devel libaio openmotif22用以下命令检查是否全部成功：$ rpm -qa |grep glibc-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 |grep glibc-develglibc-devel-2.3.4-2.13glibc-devel-2.3.4-2.13 32（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 = 250 32000 100 128vm.min_free_kbytes=409600vm.vfs_cache_pressure=200vm.swappiness =40fs.file-max = 101365net.ipv4.ip_local_port_range = 9000 65500net.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/profile file (or the file on SUSE systems)/etc/profile.local:if $USER = oracle ; thenif $SHELL = /bin/ksh ; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifi For the C shell (csh or tcsh), add the following lines to the/etc/csh.login file (or the file on SUSEsystems)/etc/csh.login.local:if ( $USER = oracle ) thenlimit maxproc 16384limit descriptors 65536endifAdd the following lines to the /etc/security/limits.conf file:oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536修改/etc/pam.d/login，增加以下内容session required /lib/security/pam_limits.so配置hangcheck-timer内核模块以root用户身份执行，在两节点上做如下配置。查看模块是否存在# find /lib/modules -name hangcheck-timer.ko编辑/etc/modprobe.conf# vi /etc/modprobe.conf在文件的末尾加入一行options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180配置为自启动vi /etc/rc.d/rc.local在文件的末尾加入一行/sbin/modprobe hangcheck_timer启动hangcheck# modprobe hangcheck_timer检查hangcheck是否成功启动# grep hangcheck /var/log/messages | tail -2如果显示下述信息说明已经成功启动hangcheckMar 16 12:52:32 node2 kernel: Hangcheck: starting hangcheck timer 0.5.0 (tick is 180 seconds, margin is 60 seconds).创建ORACLE用户及文件夹权限等新增组和用户：groupadd oinstallgroupadd dbauseradd -g oinstall -G dba oraclepasswd oracle 创建Oracle的安装目录，并把权限付给oracle用户:mkdir oracle chown -R oracle:oinstall /oracle解压database修改database目录权限，用户和用户组chown -R oracle：oinstall database/chmod -R 775 database/. 修改/etc/hosts文件及oracle用户里的.bash_profile文件# Get the aliases and functionsif -f /.bashrc ; then . /.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbinexport PATHunset USERNAMEORA_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.ZHS16GBKexport ORA_CRS_BASE ORA_CRS_HOME PATH NLS_LANG ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH. 安装一些RAC_的必要包compat-binutils215-.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 /.sshchmod 700 /.sshcd .ssh/usr/bin/ssh-keygen -t rsa (回车就OK)#/usr/bin/ssh-keygen -t dsa (回车就OK) 这可以不做在RAC1 机上运行ssh name1 cat /home/oracle/.ssh/id_rsa.pubauthorized_keys#ssh name1 cat /home/oracle/.ssh/id_dsa.pubauthorized_keys这可以不做ssh name2 cat /home/oracle/.ssh/id_rsa.pubauthorized_keys#ssh name2 cat /home/oracle/.ssh/id_dsa.pubauthorized_keys这可以不做把authorized_keys cp 到RAC2中/home/oracle/.ssh/scp authorized_keys rac2:/home/oracle/.ssh/(分别在2台机上运行)chmod 600 authorized_keysssh rac2 dateexec /usr/bin/ssh-agent $SHELL /usr/bin/ssh-add 确定ForwardX11置为no 编辑或创建 $ vi oracle/.ssh/config 内容如下： Host * ForwardX11 no 8.Ntpdate . IP 时间同步Vi /etc/ntp.conf服务端restrict mask nomodifyserver fudge stratum 10driftfile /var/lib/ntp/driftbroadcastdelay 0.008authenticate no keys /etc/ntp/keys运行 chkconfig ntp on /etc/init.d/ntpd restart客务端restrict mask nomodifyserver Server . ipfudge stratum 10driftfile /var/lib/ntp/driftbroadcastdelay 0.008authenticate no keys /etc/ntp/keys运行ntpdate db1出现信息调整的信息表示成功，一般要5分钟走左右如果是把内核时间更新到当前时间，就用下面的命令：hwclock -hctosys 检查ntp的版本，如果你使用的是ntp4.2（包括4.2）之后的版本，在restrict的定义中使用了notrust的话，会导致以上错误。使用以下命令检查ntp的版本：ntpd -c version 如何去掉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=raw1-5, OWNER=oracle, GROUP=oinstall, MODE=640用RAW -QA 查看裸设备情况11.配置asm注意：必须以root 身份进行首先在node1 执行：rootnode1 # /etc/init.d/oracleasm configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets (). Hitting without typing ananswer will keep that current value. Ctrl-C will abort.Default user to own the driver interface : oracleDefault group to own the driver interface : dbaStart Oracle ASM library driver on boot (y/n) n: yFix permissions of Oracle ASM disks on boot (y/n) y: yWriting Oracle ASM library driver configuration: OK Loading module oracleasm: OK Mounting ASMlib driver filesystem: OK Scanning system for ASM disks: OK 提示：如果本步执行出错(可能出错机率最高的是在Scanning system for ASM)，不妨将转换一下命令行三思笔记-手把手教你用VMware 在linux 下安装Oracle10g RAC / QQ：5454589 君三思群：59666289的执行方式，改成:rootnode1 # sh /etc/init.d/oracleasm configure有可能解决你的问题！然后切换至node2 执行rootnode2 # /etc/init.d/oracleasm configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets (). Hitting without typing ananswer will keep that current value. Ctrl-C will abort.Default user to own the driver interface : oracleDefault group to own the driver interface : dbaStart Oracle ASM library driver on boot (y/n) n: yFix permissions of Oracle ASM disks on boot (y/n) y: yWriting Oracle ASM library driver configuration: OK Loading module oracleasm: OK Mounting ASMlib driver filesystem: OK Scanning system for ASM disks: OK 再切换回node1 执行rootnode1 # /etc/init.d/oracleasm createdisk VOL1 /dev/sdd1Marking disk /dev/sdd1 as an ASM disk: OK rootnode1 # /etc/init.d/oracleasm createdisk VOL2 /dev/sde1Marking disk /dev/sde1 as an ASM disk: OK rootnode1 linux-patch# /etc/init.d/oracleasm scandisksScanning system for ASM disks: OK 查看一下当前的磁盘组：Scanning system for ASM disks: OK rootnode1 # /etc/init.d/oracleasm l