RACforRHEL5裸设备

1、RAC for RHEL5 裸设备一、安装前准备工作iptables stopselinux disbaled以下操作无特别说明都在2个节点上配置1./etc/hostscat >> /etc/hosts <<EOF10.10.10.1 pri0110.10.10.2 pri02192.168.1.101 rac01192.168.1.102 rac02192.168.1.201 vip01192.168.1.202 vip02EOF2.查看要求的安装包rpm -q binutils compat-db control-center gcc gcc-c+ glibc g

2、libc-common libstdc+ libstdc+-devel make ksh sysstat libaio openmotif22 libXp compat-libstdc+ compat-gcc-c+ compat-gcc（按以下顺序安装不会出现依赖包问题，并用tab按键补全）rpm -ivh compat-dbrpm -ivh kernel-headersrpm -ivh glibc-headersrpm -ivh glibc-develrpm -ivh libgomprpm -ivh gccrpm -ivh libstdc+-develrpm -ivh gcc-c+rpm -

3、ivh kshrpm -ivh sysstatrpm -ivh libXprpm -ivh openmotif22rpm -ivh compat-libstdc+rpm -ivh compat-gcc-c+rpm -ivh compat-gcc3.vi /etc/redhat-releaseredhat-4#Red Hat Enterprise Linux Server release 5 (Tikanga)4.在安装数据库软件过程中，可能遇到找不到libstdc+.so.5的问题，通过以下方式通过ln -s /usr/lib/libstdc+.so.6 /usr/lib/libstdc+.s

4、o.55.检查系统是否满足安装oracle10G的最低要求（略、此服务器完全满足）grep MemTotal /proc/meminfogrep SwapTotal /proc/meminfo 应该不低于2Gdf -h6.创建用户和组groupadd -g 1001 oinstallgroupadd -g 1002 dbauseradd -u 1001 -m -g oinstall -G dba oracleid oraclepasswd oracle7.创建软件安装目录和数据库目录（此以实例orcl为例）mkdir -p /u01/app/oraclemkdir -p /u02/oradat

5、a/orclmkdir -p /u02/oracrschown -R oracle:oinstall /u01 /u02chmod -R 775 /u01 /u028.配置系统内核8.1 /etc/sysctl.confcat >> /etc/sysctl.conf <<EOFkernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default=262144net.core.wm

6、em_default=262144net.core.rmem_max=262144net.core.wmem_max=262144EOFsysctl -p8.2验证内核参数的修改sysctl -a | grep shmsysctl -a | grep semsysctl -a | grep file-maxsysctl -a | grep ip_local_port_rangesysctl -a | grep rmem_defaultsysctl -a | grep rmem_maxsysctl -a | grep wmem_defaultsysctl -a | grep wmem_max9.

7、设置shell对oracle用户的限制cat >> /etc/security/limits.conf <<EOForacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536EOFcat >> /etc/pam.d/login <<EOFsession required /lib/security/pam_limits.soEOFcat >> /etc/profile <<EOFif $USER =

8、"oracle" ; then if $SHELL = "/bin/ksh" ; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022fiEOFcat >> /etc/csh.login <<EOFif ( $USER = "oracle" ) then limit maxproc 16384 limit descriptors 65536 umask 022endifEOF10.配置Hangcheck计时

9、器modprobe hangcheck-timer hangcheck_tick=30 hangcheck_margin=180cat >> /etc/rc.d/rc.local<<EOFmodprobe hangcheck-timer hangcheck_tick=30 hangcheck_margin=180EOF11.为oracle用户建立安全ssh通道11.1 每台主机以oracle用户登录mkdir /.sshchmod 755 /.sshssh-keygen -t rsassh-keygen -t dsa11.2 rac01，以oracle登录ssh rac

10、01 cat /.ssh/id_rsa.pub >> /.ssh/authorized_keysssh rac01 cat /.ssh/id_dsa.pub >> /.ssh/authorized_keysssh rac02 cat /.ssh/id_rsa.pub >> /.ssh/authorized_keysssh rac02 cat /.ssh/id_dsa.pub >> /.ssh/authorized_keysscp /.ssh/authorized_keys rac02:/.ssh/chmod 644 /.ssh/authorize

11、d_keysrac02上：chmod 644 /.ssh/authorized_keys11.3 所有集群主机上测试ssh rac01 datessh rac02 date不需要密码说明ssh配置成功。12. 绑定裸设备12.1共享磁盘设置在物理主机上使用starwind软件（iscsi服务器端）分割出2个大小分别为5G和3G的镜像文件。在虚拟主机rac01和rac02上安装iscsi客户端。使用如下命令连接iscsi服务器端,并设置开机启动服务。service iscsi startiscsiadm -m node -T 11 -p 192.168.1.146 -liscsiadm -m n

12、ode -T 22 -p 192.168.1.146 -lcat >>/etc/rc.Local <<EOFiscsiadm -m node -T 11 -p 192.168.1.146 -liscsiadm -m node -T 22 -p 192.168.1.146 -lEOFiscsi客户端使用fdisk发现共享磁盘，这里为sdb和sdc。fdisk -lfdisk /dev/sdbfdisk /dev/sdcpartprobe -s目的小大小 (MB)标准化大小 (MB)磁盘设备原始设备Oracle Cluster Registry100200/dev/sdb1

13、/dev/raw/raw1Oracle CRS Voting2050/dev/sdb2/dev/raw/raw2SYSTEM 表空间500600/dev/sdb3/dev/raw/raw3SYSAUX 表空间8001200/dev/sdb5/dev/raw/raw4UNDOTBS1 表空间500600/dev/sdb6/dev/raw/raw5UNDOTBS2 表空间500600/dev/sdb7/dev/raw/raw6EXAMPLE 表空间160200/dev/sdb8/dev/raw/raw7USERS 表空间120200/dev/sdb9/dev/raw/raw8TEMP 表空间250

14、600/dev/sdb10/dev/raw/raw9SPFILE550/dev/sdb11/dev/raw/raw10口令文件550/dev/sdb12/dev/raw/raw11控制文件 1110200/dev/sdb13/dev/raw/raw12控制文件 2110200/dev/sdb14/dev/raw/raw13控制文件 3110200/dev/sdb15/dev/raw/raw14重做日志 1_1120200/dev/sdc1/dev/raw/raw15重做日志 1_2120200/dev/sdc2/dev/raw/raw16重做日志 1_3120200/dev/sdc3/dev/

15、raw/raw17重做日志 2_1120200/dev/sdc5/dev/raw/raw18重做日志 2_2120200/dev/sdc6/dev/raw/raw19重做日志 2_3120200/dev/sdc7/dev/raw/raw20磁盘空间总计：3,9005,95012.2 root用户编辑/etc/udev/rules.d/60-raw.rulescat >> /etc/udev/rules.d/60-raw.rules <<EOFACTION="add", KERNEL="sdb1", RUN+="/bin/

16、raw /dev/raw/raw1 %N"ACTION="add", KERNEL="sdb2", RUN+="/bin/raw /dev/raw/raw2 %N"ACTION="add", KERNEL="sdb3", RUN+="/bin/raw /dev/raw/raw3 %N"ACTION="add", KERNEL="sdb5", RUN+="/bin/raw /dev/raw/raw4 %N"A

17、CTION="add", KERNEL="sdb6", RUN+="/bin/raw /dev/raw/raw5 %N"ACTION="add", KERNEL="sdb7", RUN+="/bin/raw /dev/raw/raw6 %N"ACTION="add", KERNEL="sdb8", RUN+="/bin/raw /dev/raw/raw7 %N"ACTION="add", KERN

18、EL="sdb9", RUN+="/bin/raw /dev/raw/raw8 %N"ACTION="add", KERNEL="sdb10", RUN+="/bin/raw /dev/raw/raw9 %N"ACTION="add", KERNEL="sdb11", RUN+="/bin/raw /dev/raw/raw10 %N"ACTION="add", KERNEL="sdb12", RU

19、N+="/bin/raw /dev/raw/raw11 %N"ACTION="add", KERNEL="sdb13", RUN+="/bin/raw /dev/raw/raw12 %N"ACTION="add", KERNEL="sdb14", RUN+="/bin/raw /dev/raw/raw13 %N"ACTION="add", KERNEL="sdb15", RUN+="/bin/raw /de

20、v/raw/raw14 %N"ACTION="add", KERNEL="sdc1", RUN+="/bin/raw /dev/raw/raw15 %N"ACTION="add", KERNEL="sdc2", RUN+="/bin/raw /dev/raw/raw16 %N"ACTION="add", KERNEL="sdc3", RUN+="/bin/raw /dev/raw/raw17 %N"ACTI

21、ON="add", KERNEL="sdc5", RUN+="/bin/raw /dev/raw/raw18 %N"ACTION="add", KERNEL="sdc6", RUN+="/bin/raw /dev/raw/raw19 %N"ACTION="add", KERNEL="sdc7", RUN+="/bin/raw /dev/raw/raw20 %N"KERNEL="raw1-9", O

22、WNER="oracle", GROUP="oinstall", MODE="640"KERNEL="raw10-9", OWNER="oracle", GROUP="oinstall", MODE="640"KERNEL="raw20", OWNER="oracle", GROUP="oinstall", MODE="640"EOFstart_udev12.3 以 oracl

23、e 用户身份创建符号链接。 su - oracleln -s /dev/raw/raw1 /u02/oracrs/ocr.crsln -s /dev/raw/raw2 /u02/oracrs/vote.crsln -s /dev/raw/raw3 /u02/oradata/orcl/system01.dbfln -s /dev/raw/raw4 /u02/oradata/orcl/sysaux01.dbfln -s /dev/raw/raw5 /u02/oradata/orcl/undo101.dbfln -s /dev/raw/raw6 /u02/oradata/orcl/undo201.d

24、bfln -s /dev/raw/raw7 /u02/oradata/orcl/example01.dbfln -s /dev/raw/raw8 /u02/oradata/orcl/users01.dbfln -s /dev/raw/raw9 /u02/oradata/orcl/temp01.dbfln -s /dev/raw/raw10 /u02/oradata/orcl/spfileorcl.ora ln -s /dev/raw/raw11 /u02/oradata/orcl/PWDorcl.oraln -s /dev/raw/raw12 /u02/oradata/orcl/control

25、01.ctlln -s /dev/raw/raw13 /u02/oradata/orcl/control02.ctlln -s /dev/raw/raw14 /u02/oradata/orcl/control03.ctlln -s /dev/raw/raw15 /u02/oradata/orcl/redo1_1.logln -s /dev/raw/raw16 /u02/oradata/orcl/redo1_2.logln -s /dev/raw/raw17 /u02/oradata/orcl/redo1_3.logln -s /dev/raw/raw18 /u02/oradata/orcl/r

26、edo2_1.logln -s /dev/raw/raw19 /u02/oradata/orcl/redo2_2.logln -s /dev/raw/raw20 /u02/oradata/orcl/redo2_3.log12.4 创建原始设备映射文件$HOME/orcl_raw.confcat > $HOME/orcl_raw.conf << EOFsystem=/u02/oradata/orcl/system01.dbfsysaux=/u02/oradata/orcl/sysaux01.dbfexample=/u02/oradata/orcl/example01.dbfun

27、dotbs1=/u02/oradata/orcl/undo101.dbfundotbs2=/u02/oradata/orcl/undo201.dbfusers=/u02/oradata/orcl/users01.dbftemp=/u02/oradata/orcl/temp01.dbfspfile=/u02/oradata/orcl/spfileorcl.orapwdfile=/u02/oradata/orcl/PWDorcl.oracontrol01=/u02/oradata/orcl/control01.ctlcontrol02=/u02/oradata/orcl/control02.ctl

28、control03=/u02/oradata/orcl/control04.ctlredo1_1=/u02/oradata/orcl/redo1_1.logredo1_2=/u02/oradata/orcl/redo1_2.logredo1_3=/u02/oradata/orcl/redo1_3.logredo2_1=/u02/oradata/orcl/redo2_1.logredo2_2=/u02/oradata/orcl/redo2_2.logredo2_3=/u02/oradata/orcl/redo2_3.logEOF13.准备安装CRS和数据库软件su - oraclevi /hom

29、e/oracle/.bash_profile添加:export DBCA_RAW_CONFIG=$HOME/orcl_raw.confexport ORACLE_BASE=/u01/app/oracleexport ORACLE_CRS/crs/db_1export ORACLE_SID=orcl1#export ORACLE_SID=orcl2(在节点2上的实例名)export PATH=$PATH:$HOME/bin:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/libexport LC_CTYPE=en_US.U

30、TF-8 export NLS_LANG=AMERICAN_AMERICA.UTF8export DISPLAY=1:0.0source .bash_profile二、安装 CRS1.CRS安装环境检查./runcluvfy.sh stage -pre crsinst -n rac01,rac02 -verbose注：可能提示有些安装包没装，忽略。./runInstaller2.在提示运行脚本root.sh，在第二个节点上出现如下错误：Running vipca(silent) for configuring nodeapps/home/oracle/product/10.2.0/crs/jd

31、k/jre/bin/java: error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory这是由于LD_ASSUME_KERNEL参数设置不正确引起,解决如下：2.1 在所有节点机器的$ORACLE_CRS_HOME/bin/vipca文件中找到如下内容：       Remove this workaround when the bug 3937317 is fixed

32、       arch=uname -m       if "$arch" = "i686" -o "$arch" = "ia64"        then            LD_ASSUME_KERNEL=2.4.19&#

33、160;           export LD_ASSUME_KERNEL       fi       #End workaround在fi后新添加一行：unset LD_ASSUME_KERNEL2.2 $ORACLE_CRS_HOME/bin/srvctl文件 （需要在所有节点上操作）# vi /oracle/product/10.2.0/crs/bin/srvctl找到如下内容：LD_ASSUME_KERNEL=2.4.19export LD_ASSUME_KERNEL同样在其后新增加一行：unset LD_ASSUME_KERNEL2.3 用root用户执行以下命令在一号机上运行如果马上运行vipca会报告如下错误Error 0(Native: listNetInterfaces:3) Error 0(Native: listNetInterfaces:3)必须先设置oifcfg setif -global eth0/:publicoifcfg setif -global e