HPUX11.23_oracle10g_servicesguard(自己)

1、HPUX11.23_oracle10g_serviceguard环境：系统-HPUX11.23 数据库-oracle10.2.0.1 双机软件-servicesguard 虚拟存储-starwind俩个锁盘vg01、vg02一个数据文件卷组oradatavgOracle数据库已经安装在系统中，软件目录在本地磁盘中，数据库文件在oradatavg中磁盘分布状态091926# ioscan -kfnC disk091926Class I H/W Path Driver S/W State H/W Type Description091926=091926disk 0 0/0/2/0.0.0.0 s

2、disk CLAIMED DEVICE TEAC DV-28E-N091926 /dev/dsk/c0t0d0 /dev/rdsk/c0t0d0091926disk 1 0/1/1/0.0.0 sdisk CLAIMED DEVICE COMPAQ BF14684970091926 /dev/dsk/c2t0d0 /dev/rdsk/c2t0d0 091926 /dev/dsk/c2t0d0s1 /dev/rdsk/c2t0d0s1091926 /dev/dsk/c2t0d0s2 /dev/rdsk/c2t0d0s2091926 /dev/dsk/c2t0d0s3 /dev/rdsk/c2t0

3、d0s3091926disk 2 255/0/0.0.0.0 sdisk CLAIMED DEVICE ROCKET IMAGEFILE091926 /dev/dsk/c4t0d0 /dev/rdsk/c4t0d0091926disk 3 255/0/2.0.0.0 sdisk CLAIMED DEVICE ROCKET IMAGEFILE091926 /dev/dsk/c5t0d0 /dev/rdsk/c5t0d0091926disk 4 255/0/3.0.0.0 sdisk CLAIMED DEVICE ROCKET IMAGEFILE091926 /dev/dsk/c6t0d0 /de

4、v/rdsk/c6t0d0编辑hosts文件#vi /etc/hosts127.0.0.1 localhostloopback135.160.10.1hp110.0.0.1hp1_heart135.160.10.2hp210.0.0.2hp2_heart135.160.10.5hp在hp1和hp2中分别安装servicesguard软件#mount /dev/dsk/c0t0d0 /cdrom#swinstall配置双机互信在hp1和hp2中分别执行#vi /.rhostshp1 roothp2 root测试互信#rloginhp1#rloginhp2创建锁盘在hp1上执行#cd/dev#mk

5、dirvg01#mkdirvg02#ls/dev/*/group#mknod/dev/vg01/group c 64 0 x020000#mknod/dev/vg02/group c 64 0 x030000创建锁盘#pvcreate /dev/rdsk/c4t0d0#vgcreate vg01 /dev/dsk/c4t0d0#pvcreate /dev/rdsk/c5t0d0#vgcreate vg02 /dev/dsk/c5t0d0复制锁盘到hp2上(01)关闭vg01和vg02#vgchange a n vg01#vgchange a n vg02创建卷组映射#vgexport p s

6、m /tmp/vg01.map /dev/vg01#vgexport p s m /tmp/vg02.map /dev/vg02将卷组映射复制到hp2#rcp /tmp/vg01.map hp2：/tmp/#rcp /tmp/vg02.map hp2：/tmp/复制锁盘到hp2(02)在hp2上执行#cd /dev#mkdir vg01#mkdir vg02#ls /dev/*/group#mknod /dev/vg01/group c 64 0 x020000#mknod /dev/vg02/group c 64 0 x030000(需要与hp1一致)复制锁盘到hp2(03)将卷组信息导入到

7、hp2中#vgimport s m /tmp/vg01.map /dev/vg01#vgimport s m /tmp/vg02.map /dev/vg02激活锁盘卷组#vgchange a y vg01#vgchange a y vg02关闭锁盘卷组#vgchange a n vg01#vgchange a n vg02配置SG指定集群节点和生成集群配置模版文件#cmquerycl v C /etc/cmcluster/oraha n hp1 n hp2#vi /etc/cmcluster/oraha编辑oraha文件CLUSTER_NAMEcluster1FIRST_CLUSTER_LOC

8、K_VG/dev/vg01SECOND_CLUSTER_LOCK_VG/dev/vg02NODE_NAMEhp1 NETWORK_INTERFACElan0 HEARTBEAT_IP135.160.10.1 NETWORK_INTERFACElan1 HEARTBEAT_IP10.0.0.1# CLUSTER_LOCK_LUN FIRST_CLUSTER_LOCK_PV /dev/dsk/c4t0d0 SECOND_CLUSTER_LOCK_PV /dev/dsk/c5t0d0# Warning: There are no standby network interfaces for lan0

9、.NODE_NAMEhp2 NETWORK_INTERFACElan0 HEARTBEAT_IP135.160.10.2 NETWORK_INTERFACElan1 HEARTBEAT_IP10.0.0.2# CLUSTER_LOCK_LUN FIRST_CLUSTER_LOCK_PV /dev/dsk/c4t0d0 SECOND_CLUSTER_LOCK_PV /dev/dsk/c5t0d0NODE_TIMEOUT5000000VOLUME_GROUP/dev/oradatavgVOLUME_GROUP/dev/vg01VOLUME_GROUP/dev/vg02(参考oraha文件)配置SG

10、验证集群配置#cmcheckconf k v C /etc/cmcluster/oraha分发配置文件#vgchange a y /dev/vg01#vgchange a y /dev/vg02#cmapplyconf k v C /etc/cmcluster/oraha#vgchange a n /dev/vg01#vgchange a n /dev/vg02SG集群应用运行集群#cmruncl v查看集群状态#cmviewcl v停用集群#cmhaltcl f v 无包时的Cmviewcl -v112159CLUSTER STATUS 112159cluster1 up 112159 11

11、2159 NODE STATUS STATE 112159 hp1 up running 112159 112159 Cluster_Lock_LVM:112159 VOLUME_GROUP PHYSICAL_VOLUME STATUS 112159 /dev/vg01 /dev/dsk/c4t0d0 up 112159 /dev/vg02 /dev/dsk/c5t0d0 up 112159 112159 Network_Parameters:112159 INTERFACE STATUS PATH NAME 112159 PRIMARY up 0/1/2/0 lan0 112159 PRIM

12、ARY up 0/1/2/1 lan1 112159 112159 NODE STATUS STATE 112159 hp2 up running 112159 112159 Cluster_Lock_LVM:112159 VOLUME_GROUP PHYSICAL_VOLUME STATUS 112159 /dev/vg01 /dev/dsk/c4t0d0 up 112159 /dev/vg02 /dev/dsk/c5t0d0 up 112159 112159 Network_Parameters:112159 INTERFACE STATUS PATH NAME 112159 PRIMAR

13、Y up 0/1/2/0 lan0 112159 PRIMARY up 0/1/2/1 lan1配置oracle包在hp1上执行#mkdir /etc/cmcluster/oracle#cmmakepkg p /etc/cmcluster/oracle/oracle.conf#vi /etc/cmcluster/oracle/oracle.conf编辑oracle.conf修改一下行PACKAGE_NAMEoraclePACKAGE_TYPEFAILOVERNODE_NAMEhp1NODE_NAMEhp2RUN_SCRIPT/etc/cmcluster/oracle/oracle.shHALT

14、_SCRIPT/etc/cmcluster/oracle/oracle.shSCRIPT_LOG_FILE/etc/cmcluster/oracle/oracle.sh.log(参考oracle.conf文件)创建、编辑程序包控制脚本#cmmakepkg s /etc/cmcluster/oracle/oracle.sh#vi /etc/cmcluster/oracle/oracle.sh修改一下行VGCHANGE=vgchange -a e# DefaultCVM_ACTIVATION_CMD=vxdg -g $DiskGroup set activation=exclusivewrite“

15、VG0=oradatavg“LV0=/dev/oradatavg/lvoradata; FS0=/oradata; FS_MOUNT_OPT0=-o rw; FS_UMOUNT_OPT0=; FS_FSCK_OPT0=FS_TYPE0=vxfs“IP0=135.160.10.5SUBNET0=135.160.10.0“function customer_defined_run_cmds# ADD customer defined run commands.: # do nothing instruction, because a function must contain some comma

16、nd./etc/cmcluster/oracle/oraclestart.shtest_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 instructi

17、on, because a function must contain some command./etc/cmcluster/oracle/oraclestop.shtest_return 52创建、编辑oracle启动脚本#vi /etc/cmcluster/oracle/oraclestart.shsu - oracle -c lsnrctl startsu - oracle -c sqlplus /nolog EOFconnect /as sysdbastartupexitEOF创建、编辑oracle关闭脚本#vi /etc/cmcluster/oracle/oraclestop.sh

18、su - oracle -c lsnrctl stopsu - oracle -c sqlplus /nolog EOFconnect /as sysdbashutdown immediateexitEOF分发程序包控制脚本#rcp /etc/cmcluster/oracle/oracle.sh hp2:/etc/cmcluster/oracle/oracle.sh#rcp /etc/cmcluster/oracle/oralcestart.sh hp2:/etc/cmcluster/oracle/oraclestart.sh#rcp /etc/cmcluster/oracle/oracles

19、top.sh hp2:/etc/cmcluster/oracle/oraclestop.sh赋予脚本执行权限hp1：#chmod 700 /etc/cmcluster/oracle/*hp2：#chmod 700 /etc/cmcluster/oracle/*配置程序包验证程序包配置模版#cmcheckconf v P /etc/cmcluster/oracle/oracle.conf在节点间分发配置文件#cmapplyconf v P /etc/cmcluster/oracle/oracle.conf启动及操作SG启动Cluster# cmruncl -v # cmruncl -v n hp

20、ux1-n hpux1在已运行的Cluster中增加一个节点运行# cmrunnode -v hpux2 在已运行的Cluster中停止一个节点运行# cmhaltnode -f -v hpux2停止整个Cluster# cmhaltcl -f -v 启动Package# cmrunpkg -n hpux1 oracle # cmmodpkg e hpux1 oracle停止Package，不切换# cmhaltpkg pkg 移动Package# cmhaltpkg -n hpux1 oracle# cmrunpkg n hpux2 oracle # cmmodpkg -e oracle单服

21、务器启动#cmruncl n hpux1#cmruncl n hpux2查看运行情况# cmviewcl v配置完包后的cmviewcl -v115240CLUSTER STATUS 115240cluster1 up 115240 115240 NODE STATUS STATE 115240 hp1 up running 115240 115240 Cluster_Lock_LVM:115240 VOLUME_GROUP PHYSICAL_VOLUME STATUS 115240 /dev/vg01 /dev/dsk/c4t0d0 up 115240 /dev/vg02 /dev/dsk/c5t0d0 up 115240 115240 Network_Parameters:115240 INTERFACE STATUS PATH NAME 115240 PRIMARY up 0/1/2/0 lan0 115240 PRIMARY up 0/1/2/1 lan1 115240115240 PACKAGE STATUS STATE AUTO_RUN NODE 115240 oracle up running enabled hp1 115240 115240 Polic