数据库RAC安装过程.docx

1、vi /etc/sysconfig/networkHOSTNAME=db12.vi /etc/hosts localhost0 db11 db22 vdb13 vbd20 priv11 priv13.配置System kernel Parameters：vi /etc/sysctl.confkernel.shmall = 2097152kernel.shmmax = 2147483648kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 1048576net.core.rmem_max = 1048576net.core.wmem_default = 262144net.core.wmem_max = 2621444.sysctl p5.grep MemTotal /proc/meminfo grep SwapTotal /proc/meminfo df -m /tmp/ df -h uname -a6.groupadd oinstall groupadd dba useradd -u 200 -g oinstall -G dba oracle passwd oracle7.mkdir -p /u01/app/oracle/product/10.2.0/dbmkdir -p /u01/app/oracle/product/10.2.0/crs chown -R oracle:oinstall /u01/app/oracle chmod -R 775 /u01/app/oracle8.vi /etc/sysconfig/network-scripts/ifcfg-eth2DEVICE=eth2BOOTPROTO=static HWADDR=84:2B:2B:07:1F:96 ONBOOT=yes HOTPLUG=no #DHCP_HOSTNAME= IPADDR=vi /etc/sysconfig/network-scripts/ifcfg-eth3DEVICE=eth3BOOTPROTO=static ONBOOT=yes HOTPLUG=no #DHCP_HOSTNAME= IPADDR=71/etc/init.d/network reload9.vi /etc/security/limits.conforacle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 6553610.vi /etc/pam.d/login session required /lib/security/pam_limits.so11.vi /etc/profileif $USER = oracle ; then if $SHELL = /bin/ksh ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi12.date s 13:00:0013.ORACLE_BASE=/u01/app/oracle ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db CRS_HOME=$ORACLE_BASE/product/10.2.0/crs ORACLE_SID=ywkdb2 ORACLE_TERM=xterm NLS_LANG=AMERICAN_AMERICA.AL32UTF8 TMPDIR=/var/tmp umask 022NLS_DATE_FORMAT=YYYY/MM/DD hh24:mi:ss ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data TNS_ADMIN=$ORACLE_HOME/network/admin export ORACLE_BASE ORACLE_HOME CRS_HOME ORACLE_SID export NLS_LANGexport TMPDIR NLS_DATE_FORMAT ORA_NLS33 TNS_ADMIN DISPLAY LIBPATH=$ORACLE_HOME/lib export LIBPATH PATH=$PATH:$ORACLE_HOME/bin:$CRS_HOME/bin:/usr/sbin export PATH14.source /.bash_profile15.分别在每个节点中以oracle用户登录，进行以下操作mkdir /.ssh chmod 755 /.ssh 755$ ssh-keygen -t rsa$ ssh-keygen -t dsatouch /.ssh/authorized_keysssh db1 cat /home/oracle/.ssh/id_rsa.pubauthorized_keysssh db1 cat /home/oracle/.ssh/id_dsa.pubauthorized_keysssh db2 cat /home/oracle/.ssh/id_rsa.pubauthorized_keysssh db2 cat /home/oracle/.ssh/id_dsa.pubauthorized_keysscp /.ssh/authorized_keys oracledb2:/home/oracle/.ssh/authorized_keysoracledb1 $ chmod 600 /.ssh/authorized_keysoracledb1 $ exec /usr/bin/ssh-agent $SHELLssh-addssh db1 date ssh db2 date ssh priv1 date ssh priv2 date16.iscsiadm -m discovery -t sendtargets -p 00:3260iscsiadm -m node -T .openfiler:tsn.1234567890 -p 00:3260 -l/bin/raw /dev/raw/raw1 /dev/sdb1/bin/raw /dev/raw/raw2 /dev/sdc1/bin/raw /dev/raw/raw3 /dev/sdd1/bin/raw /dev/raw/raw4 /dev/sde1/bin/raw /dev/raw/raw5 /dev/sdf1/bin/raw /dev/raw/raw6 /dev/sdg1/bin/raw /dev/raw/raw7 /dev/sdh117.vi /etc/udev/rules.d/60-raw.rulesACTION=add, KERNEL=/dev/sdb1,RUN+=/bin/raw /dev/raw/raw1 %NACTION=add, ENVMAJOR=8,ENVMINOR=17,RUN+=/bin/raw /dev/raw/raw1 %M %mACTION=add, KERNEL=/dev/sdc1,RUN+=/bin/raw /dev/raw/raw2 %NACTION=add, ENVMAJOR=8,ENVMINOR=33,RUN+=/bin/raw /dev/raw/raw2 %M %mACTION=add, KERNEL=/dev/sdd1,RUN+=/bin/raw /dev/raw/raw3 %NACTION=add, ENVMAJOR=8,ENVMINOR=49,RUN+=/bin/raw /dev/raw/raw3 %M %mACTION=add, KERNEL=/dev/sde1,RUN+=/bin/raw /dev/raw/raw4 %NACTION=add, ENVMAJOR=8,ENVMINOR=65,RUN+=/bin/raw /dev/raw/raw4 %M %mACTION=add, KERNEL=/dev/sdf1,RUN+=/bin/raw /dev/raw/raw5 %NACTION=add, ENVMAJOR=8,ENVMINOR=81,RUN+=/bin/raw /dev/raw/raw5 %M %mACTION=add, KERNEL=/dev/sdg1,RUN+=/bin/raw /dev/raw/raw6 %NACTION=add, ENVMAJOR=8,ENVMINOR=97,RUN+=/bin/raw /dev/raw/raw6 %M %mACTION=add, KERNEL=/dev/sdh1,RUN+=/bin/raw /dev/raw/raw7 %NACTION=add, ENVMAJOR=8,ENVMINOR=113,RUN+=/bin/raw /dev/raw/raw7 %M %m18.chown root:oinstall /dev/raw/raw1chown root:oinstall /dev/raw/raw2chown oracle:oinstall /dev/raw/raw3chown oracle:oinstall /dev/raw/raw4chown oracle:oinstall /dev/raw/raw5chown oracle:oinstall /dev/raw/raw6chown oracle:oinstall /dev/raw/raw7chmod 640 /dev/raw/raw1chmod 640 /dev/raw/raw2chmod 660 /dev/raw/raw3chmod 660 /dev/raw/raw4chmod 660 /dev/raw/raw5chmod 660 /dev/raw/raw6chmod 660 /dev/raw/raw719.vi /etc/udev/rules.d/99-raw-perms.rulesKERNEL=raw1, MODE=0640, GROUP=oinstall, OWNER=root KERNEL=raw2, MODE=0640, GROUP=oinstall, OWNER=rootKERNEL=raw3, MODE=0660, GROUP=oinstall, OWNER=oracle KERNEL=raw4, MODE=0660, GROUP=oinstall, OWNER=oracleKERNEL=raw5, MODE=0660, GROUP=oinstall, OWNER=oracleKERNEL=raw6, MODE=0660, GROUP=oinstall, OWNER=oracle KERNEL=raw7, MODE=0660, GROUP=oinstall, OWNER=oracle20.配置asm以root身份登录，分别在每个节点中执行rpm -ivh oracleasm-support-2.1.3-1.el5.x86_64.rpmrpm -ivh oracleasm-2.6.18-194.el5-2.0.5-1.el5.x86_64.rpm rpm -ivh oracleasmlib-2.0.4-1.el5.x86_64.rpmcd /lib/modules/2.6.18-164.el5/kernel/drivers/addon/oracleasm/sbin/insmod oracleasm.ko/etc/init.d/oracleasm configure/etc/init.d/oracleasm createdisk VOL1 /dev/sdg1/etc/init.d/oracleasm createdisk VOL2 /dev/sdh1gunzip 10201_clusterware_linux_x86_64.cpio.gzcpio -idmv 10201_clusterware_linux_x86_64.cpio21、用oracle用户安装cluster./runInstaller -ignoreSysPreReqs4，RAC2节点上执行root.sh之前需要编辑两个文件，这两个文件都位于-各个节点都进行配置/u01/app/oracle/product/10.2.0/crs/bin下，文件名分别为vipca和srvctl。首先编辑vipca文件，找到如下内容：Remove this workaround when the bug 3937317 is fixedarch=uname -mif $arch = i686 -o $arch = ia64 thenLD_ASSUME_KERNEL=2.4.19export LD_ASSUME_KERNELfi#End workaround在fi 后新添加一行：unset LD_ASSUME_KERNEL然后编辑srvctl文件，找到如下内容：LD_ASSUME_KERNEL=2.4.19export LD_ASSUME_KERNEL同样在其后新增加一行：unset LD_ASSUME_KERNEL对应的报错信息是：/opt/ora