hpunix 11.31+11.18+rac+10.2.02-10.2.04 文档.docx

Oracle 10g RAC 在HP-UX v3+MC ServiceGuard环境的安装【转】收藏OS环境: HP-UX 11.31HA软件: MC/ServiceGuard 11.18+Serviceguard Extension for RACOracle: Oracle10g +补丁Hostname: hp1 hp2作者：gss999991.检查环境# machinfo #查系列号# /usr/contrib/bin/machinfo | grep -i Memory #查看物理内存# /usr/sbin/swapinfo -a #查看交换空间# bdf /tmp #查看/tmp的空间情况，至少400M,推荐1G如果没有400M可以设置oracle用户的环境变量，增加临时空间$ oracle用户执行 vi /.profile,增加export TEMP=/directoryexport TMPDIR=/directory# bdf #至少有10GB 的磁盘空间给Oracle software.# uname -a #查看操作系统的版本# /bin/getconf KERNEL_BITS #查看操作系统bit数 # date #查看每个节点的日期时间，同步时间Tue Nov 25 10:34:33 EAT 2008 #时区要为EAT。# date 11310959 #修改时间# set_parms timezone #修改时区2.编辑相关的配置文件2.1# vi /etc/hosts添加如下内容:21 hp123 hp1-vip21 hp1_priv22 hp224 hp2-vip22 hp2_priv# vi .rhostshp1 roothp2 root2.2#禁止卷组的自动激活# vi /etc/lvmrcauto_vg_activite=0custom_vg_activation()# e.g. /sbin/vgchange -a y -s # parallel_vg_sync /dev/vg00 /dev/vg01 # parallel_vg_sync /dev/vg02 /dev/vg03 /sbin/vgchange -a y -s /dev/vg00 #*添加此行 return 02.3#AIO配置ll /dev/asynccrw-rw-rw- 1 bin bin 101 0x000000 Jun 9 09:38 /dev/async#如果没有开启，可以通过如下方法开启:#创建/dev/async character device/sbin/mknod /dev/async c 101 0x0chown oracle:dba /dev/asyncchmod 660 /dev/async#用SAM在 kernel配置async driver= Kernel Configuration= Kernel= the driver is called asyncdskGenerate new kernel(生成新的kernel)2.4# 查看符合的连接是否存在cd /usr/libls libX*.sl # 如果不存在需要创建ln -s libX11.3 libX11.slln -s libXIE.2 libXIE.slln -s libXext.3 libXext.slln -s libXhp11.3 libXhp11.slln -s libXi.3 libXi.slln -s libXm.4 libXm.slln -s libXp.2 libXp.slln -s libXt.3 libXt.slln -s libXtst.2 libXtst.sl2.5.#调整内核参数#kctune 查内核参数kctune -h -B nproc=4200kctune -h -B ksi_alloc_max=33600kctune -h -B max_thread_proc=1100kctune -h -B maxdsiz=1073741824kctune -h -B maxdsiz_64bit=4294967296kctune -h -B maxssiz=134217728kctune -h -B maxssiz_64bit=1073741824kctune -h -B maxuprc=3688kctune -h -B msgmni=4096kctune -h -B msgtql=4096kctune -h -B ncsize=35840 kctune -h -B nflocks=4096kctune -h -B ninode=34816kctune -h -B nkthread=8416kctune -h -B semmni=8192kctune -h -B semmns=16384kctune -h -B semmnu=4092kctune -h -B semvmx=32767kctune -h -B shmmax=34359738368 kctune -h -B shmmni=512kctune -h -B shmseg=300kctune -h -B vps_ceiling=642.6.创建Oracle用户groupadd -g 500 dbagroupadd -g 501 oinstall/usr/sbin/useradd -u 501 -g oinstall -G dba oraclemkdir /home/oraclechown oracle:oinstall /home/oracleusermod -d /home/oracle oraclemkdir -p /oracle/product/10.2.0/crs_1mkdir -p /oracle/product/10.2.0/db_1chown -R oracle:oinstall /oraclechmod -R 775 /oracle# vi /home/oracle/.rhostshp1 oraclehp2 oraclehp1_pirv oraclehp2_priv oraclehp1-vip oraclehp2-vip oracle2.7.解压缩安装文件$ /opt/java1.4/bin/jar -xvf 10gr2_clusterware_hp.ia64.zip$ /opt/java1.4/bin/jar -xvf 10gr2_database_hp.ia64.zip$ /opt/java1.4/bin/jar -xvf p6810189_10204_HPUX-IA642.8#shutdown -ry 0 #重启服务器3.逻辑卷配置3.1.创建PVinsf -eC disk #生成磁盘设备文件ioscan -funC disk #扫描磁盘设备 ioscan -m dsf #查看磁盘设备名pvcreate -f /dev/rdisk/disk28diskinfo /dev/rdisk/disk283.2.创建vgmkdir /dev/lockvgmkdir /dev/datavgmkdir /dev/archvg1 ll /dev/*/group mknod /dev/lockvg/group c 64 0x010000mknod /dev/datavg/group c 64 0x020000mknod /dev/archvg1/group c 64 0x030000vgcreate /dev/lockvg /dev/disk/disk28vgcreate -s 64 /dev/datavg /dev/disk/disk47 /dev/disk/disk48 /dev/disk/disk49 /dev/disk/disk50 vgcreate /dev/archvg1 /dev/disk/disk513.3.在archvg1上创建arch1文件系统lvcreate -L 150000 -n lvarch1 archvg1newfs -F vxfs -o largefiles /dev/archvg1/lvarch13.4.创建lvlvcreate -n ora_vote01 -L 128 /dev/datavglvcreate -n ora_vote02 -L 128 /dev/datavglvcreate -n ora_vote03 -L 128 /dev/datavglvcreate -n ora_crs01 -L 128 /dev/datavglvcreate -n ora_crs02 -L 128 /dev/datavglvcreate -n ora_spfile -L 128 /dev/datavglvcreate -n ora_pwd -L 128 /dev/datavglvcreate -n db_control01 -L 128 /dev/datavglvcreate -n db_control02 -L 128 /dev/datavglvcreate -n db_control03 -L 128 /dev/datavglvcreate -n db_users01 -L 256 /dev/datavglvcreate -n db_sysaux01 -L 2048 /dev/datavglvcreate -n db_system01 -L 2048 /dev/datavglvcreate -n db_temp01 -L 8192 /dev/datavglvcreate -n db_temp02 -L 8192 /dev/datavglvcreate -n db_temp03 -L 8192 /dev/datavglvcreate -n db_temp04 -L 8192 /dev/datavglvcreate -n db_undo1_01 -L 8192 /dev/datavglvcreate -n db_undo1_02 -L 8192 /dev/datavglvcreate -n db_undo2_01 -L 8192 /dev/datavglvcreate -n db_undo2_02 -L 8192 /dev/datavglvcreate -n db_redo1_01 -L 256 /dev/datavglvcreate -n db_redo1_02 -L 256 /dev/datavglvcreate -n db_redo1_03 -L 256 /dev/datavglvcreate -n db_redo1_04 -L 256 /dev/datavglvcreate -n db_redo1_05 -L 256 /dev/datavglvcreate -n db_redo2_01 -L 256 /dev/datavglvcreate -n db_redo2_02 -L 256 /dev/datavglvcreate -n db_redo2_03 -L 256 /dev/datavglvcreate -n db_redo2_04 -L 256 /dev/datavglvcreate -n db_redo2_05 -L 256 /dev/datavg3.5.对vg,lv设权限chown root.oinstall /dev/datavg/rora_crs0*chown oracle.oinstall /dev/datavg/rora_vote0*chown oracle.dba /dev/datavg/rora_spfilechown oracle.dba /dev/datavg/rora_pwdchown oracle.dba /dev/datavg/rdb_*chmod 664 /dev/datavg/rora_crs0* chmod 664 /dev/datavg/rora_vote0*chmod 660 /dev/datavg/rora_spfilechmod 660 /dev/datavg/rora_pwdchmod 660 /dev/datavg/rdb_*3.6.vgexport vgimport卷组hp1:vgchange -a n /dev/lockvgvgchange -a n /dev/datavgvgexport -v -p -s -m /tmp/lockvg.map /dev/lockvgvgexport -v -p -s -m /tmp/datavg.map /dev/datavgrcp /tmp/lockvg.map hp2:/tmprcp /tmp/datavg.map hp2:/tmphp2: mkdir /dev/lockvg mkdir /dev/datavg mkdir /dev/archvg2 mknod /dev/lockvg/group c 64 0x010000 mknod /dev/datavg/group c 64 0x020000 mknod /dev/archvg2/group c 64 0x030000 vgcreate /dev/archvg2 /dev/disk/disk51vgimport -v -m /tmp/lockvg.map /dev/lockvg /dev/disk/disk28vgimport -v -m /tmp/datavg.map /dev/datavg /dev/disk/disk47 /dev/disk/disk48 /dev/disk/disk49 /dev/disk/disk50strings /etc/lvmtabvgchange -a y /dev/lockvgvgchange -a y /dev/datavgvgcfgbackup /dev/lockvgvgcfgbackup /dev/datavgvgchange -a n /dev/lockvgvgchange -a n /dev/datavgvgchange -a n /dev/archvg2chown root.oinstall /dev/datavg/rora_crs0*chown oracle.oinstall /dev/datavg/rora_vote0*chown oracle.dba /dev/datavg/rora_spfilechown oracle.dba /dev/datavg/rora_pwdchown oracle.dba /dev/datavg/rdb_*chmod 664 /dev/datavg/rora_crs0* chmod 664 /dev/datavg/rora_vote0*chmod 660 /dev/datavg/rora_spfilechmod 660 /dev/datavg/rora_pwdchmod 660 /dev/datavg/rdb_*3.7.在archvg2上创建arch2文件系统lvcreate -L 150000 -n lvarch2 archvg2newfs -F vxfs -o largefiles /dev/archvg2/lvarch2# strings /etc/lvmtab4 集群配置4.1 使用cmquerycl去创建一个集群配置文件，Cmquerycl命令必须在主节点上进行。# cmquerycl -v -C /etc/cmcluster/cmcluster.ascii -n hp1 -n hp24.2# vi /etc/cmcluster/cmcluster.asciiCLUSTER_NAME cluster1NODE_NAME hp1NETWORK_INTERFACE lan2 HEARTBEAT_IP 21NETWORK_INTERFACE lan1NETWORK_INTERFACE lan0 HEARTBEAT_IP 21# CLUSTER_LOCK_LUNFIRST_CLUSTER_LOCK_PV /dev/disk/disk28NODE_NAME hp2NETWORK_INTERFACE lan2 HEARTBEAT_IP 22NETWORK_INTERFACE lan1NETWORK_INTERFACE lan0 HEARTBEAT_IP 22# CLUSTER_LOCK_LUNFIRST_CLUSTER_LOCK_PV /dev/disk/disk28*VOLUME_GROUP /dev/vglock #HA模式需要，RAC模式不需要。VOLUME_GROUP /dev/vgora*OPS_VOLUME_GROUP /dev/vgdata # RAC模式,不需要加lockvg。*NODE_TIMEOUT 6000000 #修改NODE_TIMEOUT为6s。其他参数采用默认值。5.建第一个包pkg_ora1：mkdir /etc/cmcluster/pkg_ora1cmmakepkg -p /etc/cmcluster/pkg_ora1/pkg_ora1.conf# vi /etc/cmcluster/pkg_ora1/pkg_ora1.confPACKAGE_NAME pkg_ora1NODE_NAME hpdb1 #只加节点1.RUN_SCRIPT /etc/cmcluster/pkg_ora1/pkg_tlHALT_SCRIPT /etc/cmcluster/pkg_ora1/pkg_tlMONITORED_SUBNET #11.31版本中代替SUBNET。*VGCHANGE=vgchange -a s # RAC模式*VG0=datavg #需要激活的包，lockvg不需要添加。#LV0=/dev/vgora/lvoradata; FS0=/oradata;FS_MOUNT_OPT0=; FS_UMOUNT_OPT0=; FS_FSCK_OPT0= #HA模式需要。#IP0=23 # RAC模式不用设IP#SUBNET0=function customer_defined_run_cmds# ADD customer defined run commands.: # do nothing instruction, because a function must contain some command. test_return 51# This function is a place holder for customer define functions.# You should define all actions you want to happen here, after the service is# halted.function customer_defined_halt_cmds# ADD customer defined halt commands.: # do nothing instruction, because a function must contain some command. test_return 52# END OF CUSTOMER DEFINED FUNCTIONS6. 增加第二个包# mkdir /etc/cmcluster/pkg_ora2# cmmakepkg -p /etc/cmcluster/pkg_ora2/pkg_ora2.conf# vi /etc/cmcluster/pkg_ora2/pkg_ora2.confPACKAGE_NAME pkg_ora2NODE_NAME hpdb2 #只加节点2.RUN_SCRIPT /etc/cmcluster/pkg_ora2/pkg_tlHALT_SCRIPT /etc/cmcluster/pkg_ora2/pkg_tlMONIT