创建oracle10g双节点集群

1、.：.；主机配置本卷须知(每个节点):每个节点效力器必需是 双网卡 ，支持tcp/ip协议，安装集群软件效力器要支持udp防火墙封锁service iptables stopSELinux禁用vi /etc/selinux/configSELINUX=disableip地址运用静态配置：static网关要指定# Intel Corporation 82566MM Gigabit Network ConnectionDEVICE=eth0BOOTPROTO=staticIPADDR=10.1.1.NETMASK=GATEWAY=HWADDR=00:1E:

2、37:D6:FA:44ONBOOT=yes重启network :service network restarthostname不要出如今回环地址！假设启动过单机asm效力，请先停顿:$ORACLE_HOME/bin/localconfig delete卸载独占方式的oracle软件先用OUI卸载，再手工清理渣滓文件/etc/*.ora $ORACLE_HOME假设是4以上的版本，降低版本到4/etc/redhat-release-配置etc/hosts (一切节点)# Do not remove the following line, or various programs# that req

3、uire network functionality will fail. localhost.localdomain localhost:1 localhost6.localdomain6 localhost6# public Network - (eth0)10.1.1. xie.uplooking32 xie.uplooking# public virtual IP (eth0:#)10.1.1. xie.uplooking1-vip33 xie.uplooking-vip# private Interconnect - (eth0:0

4、)10.1.2. xie.uplooking1-priv32 xie.uplooking-priv配置 ifcfg-eth0:0 (一切节点)rootxie network-scripts# vi ifcfg-eth0:0# Realtek Semiconductor Co., Ltd. RTL-8/8C/8C+DEVICE=eth0:0BOOTPROTO=staticONBOOT=yesIPADDR=32NETMASK=重启network:service network restart配置hangcheck-timer:用于监视 Li

5、nux 内核能否挂起vi /etc/modprobe.confoptions hangcheck-timer hangcheck_tick=30 hangcheck_margin=180自动加载hangcheck-timer vi /etc/rc.localmodprobe hangcheck-timer检查hangcheck-timer模块能否曾经加载:lsmod | grep hangcheck_timer-创建oracle用户:跑脚本：1./install.sh#/bin/bash. ./adduser.sh. ./sysctl.sh. ./limits.sh. ./mkdir.sh.

6、./chprofile.sh2.adduser.sh#/bin/bashADDGROUPS=oinstall dbaADDUSERS=oraclefor group in $ADDGROUPS ; do if -z $( awk -F: print $1 /etc/group |grep $group) ; then groupadd $group echo Add new group $group else echo Group $group already existed fidonefor user in $ADDUSERS ; do if -z $( awk -F: print $1

7、/etc/passwd |grep $user) ; then useradd $user echo Add new user $user else echo User $user already existed fidoneif $(usermod -g oinstall -G dba oracle) ; then echo Modify user oracle account successelse echo Modify user oracle account failurefi3.sysctl.sh#/bin/bash# echo 250 32000 100 128 /proc/sys

8、/kernel/sem# echo 536870912 /proc/sys/kernel/shmmax# echo 4096 /proc/sys/kernel/shmmni# echo 2097152 /proc/sys/kernel/shmall# echo 65536 /proc/sys/fs/file-max# echo 1024 65000 /proc/sys/net/ipv4/ip_local_port_rangeSYSCTL_FILE=/etc/sysctl.confRCLOCAL_FILE=/etc/rc.localif -f $SYSCTL_FILE ; then if -z

9、$(grep Oracle $SYSCTL_FILE) ; then cat $SYSCTL_FILE $RCLOCAL_FILE /proc/sys/kernel/shmmaxecho 4096 /proc/sys/kernel/shmmniecho 2097152 /proc/sys/kernel/shmallecho 250 32000 100 128 /proc/sys/kernel/semecho 65536 /proc/sys/fs/file-maxecho 1024 65000 /proc/sys/net/ipv4/ip_local_port_rangeEND . $RCLOCA

10、L_FILE echo Add Oracle configure kernel parameters success else echo Oracle configure kernel parameters already existed fifi4.limits.sh#/bin/bashLIMITS_FILE=/etc/security/limits.confif -f $LIMITS_FILE ; then if -z $(grep Oracle $LIMITS_FILE) ; then cat $LIMITS_FILE $PROFILE authorized_keysstu92:10.1

11、.1.su - oraclessh-keygen -t rsassh-keygen -t dsacd .sshcat *.pub authorized_keysstu90:32scp authorized_keys oracle10.1.1.:/home/oracle/.ssh/keys_dbsstu92:10.1.1.cat keys_dbs authorized_keysscp authorized_keys oracle32:/home/oracle/.ssh/测试信任关系:xie.uplooking:ssh xie.uplookingssh xie1.u

12、plookingssh xie-priv.uplookingssh xie1-priv.uplookingxie1.uplookingssh xie.uplookingssh xie1.uplookingssh xie-priv.uplookingssh xie1-priv.uplooking-测试时间同步:-预备公用卷:iscsiiscsi server - stu90yum install scsi-target-utilsvi /etc/tgt/targets.conf- backing-store /dev/sda5 initiator-address /24 -vi

13、/etc/udev/rules.d/55-openiscsi.rules-KERNEL=sd*,BUS=scsi,PROGRAM=/etc/udev/scripts/iscsidev.sh %b,SYMLINK+=iscsi/%c-vi /etc/udev/scripts/iscsidev.sh-#!/bin/bash BUS=$1 HOST=$BUS%:* -e /sys/class/iscsi_host | exit 1 file=/sys/class/iscsi_host/host$HOST/device/session*/iscsi_session*/targetname target

14、_name=$(cat $file) if -z $target_name ; then exit 1 fi echo $target_name#*:-chmod +x /etc/udev/scripts/iscsidev.shchkconfig iscsi offchkconfig iscsid offchkconfig tgtd offservice iscsi startservice iscsid startservice tgtd starttgtadm -lld iscsi -op bind -mode target -tid 1 -I ALLiscsiadm -m discove

15、ry -t sendtargets -p 10.1.1.xx service iscsi startfdisk -l/*重新扫描效力器iscsiadm -m session -uiscsiadm -m discovery -t sendtargets -p 03*/iscsi client:2vi /etc/udev/rules.d/55-openiscsi.rules-KERNEL=sd*,BUS=scsi,PROGRAM=/etc/udev/scripts/iscsidev.sh %b,SYMLINK+=iscsi/%c-vi /etc/udev/scrip

16、ts/iscsidev.sh-#!/bin/bashBUS=$1HOST=$BUS%:* -e /sys/class/iscsi_host | exit 1file=/sys/class/iscsi_host/host$HOST/device/session*/iscsi_session*/targetnametarget_name=$(cat $file)if -z $target_name ; then exit 1fiecho $target_name#*:-chmod +x /etc/udev/scripts/iscsidev.shservice iscsi startiscsiadm

17、 -m discovery -t sendtargets -p 10.1.1.xx -lservice iscsi startfdisk -l对iscsi共享盘分区:fdisk /dev/sdb在一切节点:partprobe /dev/sdb在一切节点将iscsi共享分区变为裸设备:vi /etc/udev/rules.d/60-raw.rules-ACTION=add, KERNEL=sdb1, RUN+=/bin/raw /dev/raw/raw1 %NACTION=add, KERNEL=sdb2, RUN+=/bin/raw /dev/raw/raw2 %NACTION=add, KE

18、RNEL=sdb5, RUN+=/bin/raw /dev/raw/raw3 %NACTION=add, KERNEL=sdb6, RUN+=/bin/raw /dev/raw/raw4 %NKERNEL=raw1, MODE=0660, GROUP=oinstall, OWNER=rootKERNEL=raw2, MODE=0660, GROUP=oinstall, OWNER=oracleKERNEL=raw3, MODE=0660, GROUP=oinstall, OWNER=oracleKERNEL=raw4, MODE=0660, GROUP=oinstall, OWNER=orac

19、le在一切节点重新启动udevstart_udev在一切节点查看rawdevicesll /dev/raw/-集群安装可行性校验:cd /mnttar -zxvf clusterware10GR2_32.tar.gzchown oracle.oinstall clusterware -Rsu - oraclecd /mnt/clusterware/cluvfy/./runcluvfy.sh stage -pre crsinst -n xie,xie1 -verbose报错：oraclexie1 cluvfy$ ./runcluvfy.sh stage -pre crsinst -n xie.u

20、plooking,xie1.uplooking -verbosePerforming pre-checks for cluster services setup Checking node reachability.Check: Node reachability from node xie1 Destination Node Reachable? - - xie1 yes xie yes Result: Node reachability check passed from node xie1把 一切节点 vi /etc/hosts 改成：# Do not remove the follow

21、ing line, or various programs# that require network functionality will fail. localhost.localdomain localhost:1 localhost6.localdomain6 localhost6# public Network - (eth0)10.1.1. xie1.uplooking xie32 xie.uplooking xie# public virtual IP (eth0:#)10.1.1. xie1-vip33 xie-vip# pr

22、ivate Interconnect - (eth0:0)10.1.2. xie1-priv32 xie-priv然后在重新测试信任关系xie.uplooking:ssh xiessh xie1ssh xie-privssh xie1-privxie1.uplookingssh xiessh xie1ssh xie-privssh xie1-priv检查胜利：下面这4个包在5版本不能装上，没关系Check: Package existence for compat-gcc-7.3-2.96.128 Node Name Status Comment - - - xie missi

23、ng failed xie1 missing failed Result: Package existence check failed for compat-gcc-7.3-2.96.128.Check: Package existence for compat-gcc-c+-7.3-2.96.128 Node Name Status Comment - - - xie missing failed xie1 missing failed Result: Package existence check failed for compat-gcc-c+-7.3-2.96.128.Check:

24、Package existence for compat-libstdc+-7.3-2.96.128 Node Name Status Comment - - - xie missing failed xie1 missing failed Result: Package existence check failed for compat-libstdc+-7.3-2.96.128.Check: Package existence for compat-libstdc+-devel-7.3-2.96.128 Node Name Status Comment - - - xie missing

25、failed xie1 missing failed Result: Package existence check failed for compat-libstdc+-devel-7.3-2.96.128.安装clusterware软件(只需在一个节点做，但要手工将其它节点参与到群):/mnt/clusterware/runInstaller在运转/u01/crs_1/root.sh脚本之前,在一切节点修正vipca & srvctl su - oraclecd $CRS_HOME/binvi +123 vipcavi + srvctlunset LD_ASSUME_KERNEL/u01/

26、crs_1/root.sh假设报错:Running vipca(silent) for configuring nodeappsError 0(Native: listNetInterfaces:3) Error 0(Native: listNetInterfaces:3)处理(只需在一个节点做):cd /u01/crs_1/bin#./oifcfg iflist#./oifcfg setif -global eth0/:public #./oifcfg setif -global eth0:0/:cluster_interconnect#./oifcfg ge

27、tif手工运转vipca，完成root.sh脚本!校验集群后台进程的形状:cd /u01/crs_1/binoraclexie bin$ ./crs_stat -tName Type Target State Host -ora.xie.gsd application ONLINE ONLINE xie ora.xie.ons application ONLINE ONLINE xie ora.xie.vip application ONLINE ONLINE xie ora.xie1.gsd application ONLINE ONLINE xie1 ora.xie1.ons applic

28、ation ONLINE ONLINE xie1 ora.xie1.vip application ONLINE ONLINE xie1 在root下备份OCR:cd /u01/crs_1/bin./ocrconfig -export /home/oracle/bk/ocr/ocr1.bk-安装数据库软件(只需在一个节点做，会出现多节点的选择选项):安装时选择只安装软件不建库/mnt/database/runInstaller配置集群的数据库网络:netca打补丁:1.在一切节点用root用户停集群rootxie bin# /etc/init.d/init.crs stoporaclexie

29、bin$ ./crs_stat -tCRS-0184: Cannot communicate with the CRS daemon.2.运转./runInstaller打补丁 1. 先为clusterware 打补丁 ，运转./runInstaller 选择完成之后根据提示运转2个脚本打完补丁后，会自动启动集群效力oraclexie1 bin$ ./crs_stat -tName Type Target State Host -ora.IE.lsnr application ONLINE ONLINE xie ora.xie.gsd application ONLINE ONLINE xie ora.xie.ons application ONLINE ONLINE xie ora.xie.vip application ONLINE ONLINE xie ora.