Hp3410双机上的oracle rac的配置全手册Word文档下载推荐.docx

1、disk 7 0/4/1/0/4/0.8.0.255.0.4.0 sdisk CLAIMED DEVICE HP 36.4GST336607FC /dev/dsk/c4t4d0 /dev/rdsk/c4t4d0disk 8 0/4/1/0/4/0.8.0.255.0.5.0 sdisk CLAIMED DEVICE HP 36.4GST336607FC /dev/dsk/c4t5d0 /dev/rdsk/c4t5d01.1.3 hosts文件内容配置 hp1#/etcmore /etc/hosts# Configured using SAM by root on Fri Feb 18 18:5

2、6:57 2005# Configured using SAM by root on Fri Feb 18 14:09:05 2005# （#）B.11.11_LRhosts $Revision: 1.9.214.1 $ $Date: 96/10/08 13:20:01 $# The form for each entry is:# aliases# For example:# 192.1.2.34 hpfcrm loghost# See the hosts（4） manual page for more information.# Note: The entries cannot be pr

3、eceded by a space.# The format described in this file is the correct format.# The original Berkeley manual page contains an error in# the format description.127.0.0.1 localhost loopback10.40.90.253 hp2 10.40.90.243 hp1 hp1.10.40.90.16 hp192.168.10.4 hp1 hp1_hb192.168.10.5 hp2 hp2_hb1.1.4 rhosts的文件配置

4、hp1#/more .rhostshp roothp1 roothp2 root1.1.5 网络配置主网卡：10.40.90.243备网卡：10.40.90.16心跳线：192.168.10.41.2 第二台主机配置 hp2 10.40.90.2531.2.1 主机操作系统环境hp2#/uname -aHP-UX hp2 B.11.11 U 9000/800 1333400056 unlimited-user license1.2.2 主机磁盘和磁盘柜环境hp2#/ioscan -fnCdisk1.2.3 hosts文件内容配置 hp2#/more /etc/hosts10.40.90.253

5、 hp2 hp2.10.40.90.243 hp1 10.40.90.16 hp 1.2.4 rhosts的文件配置hp2#/more .rhosts5。网络配置10.40.90.253192.168.10.51.3 两台机器内核参数调整和补丁包1.3.1 内核参数MAXDSIZ 536870912 bytes MAXDSIZ_64BIT 2147483648 bytes SEMMNS 2000 SEMVMX 32768 SHMMAX 1073741824 bytes or Available physical memorySHMMIN 1 SHMMNI 100 SHMSEG 10SEMMNI

6、 70 1.3.2 建立符号连接$ cd /usr/lib$ ln -s /usr/lib/libX11.3 libX11.sl $ ln -s /usr/lib/libXIE.2 libXIE.sl $ ln -s /usr/lib/libXext.3 libXext.sl $ ln -s /usr/lib/libXhp11.3 libXhp11.sl $ ln -s /usr/lib/libXi.3 libXi.sl $ ln -s /usr/lib/libXm.4 libXm.sl $ ln -s /usr/lib/libXp.2 libXp.sl $ ln -s /usr/lib/li

7、bXt.3 libXt.sl $ ln -s /usr/lib/libXtst.2 libXtst.sl 如果没有相应的连接文件。找后面数字最大的替代。如果没有/usr/lib/libXm.4那么就找/usr/lib/libXm.3替代1.3.3 操作系统补定 Sep 2001 HP-UX patch bundle PHCO_23094 PHCO_23772 PHSS_23441 PHNE_23502 当然可以打最新的替代补丁。补丁一般在安装升级盘里面。HWEnable.Gold. ,Bundl11i这几个目录里面1.3.4 修改异步io使用sam工具= Kernel Configuratio

8、n = Kernel the driver is called asyncdsk Generate new kernel Reboot2 第二部分：hp机器安装前配置2.1 建立vghp1#/tmp/vgcreatevi vgcreate.shvgcreate.sh的脚本内容如下：#Create vglockmkdir /dev/vglockmknod /dev/vglock/group c 64 0x010000pvcreate -f /dev/rdsk/c4t0d0vgcreate /dev/vglock /dev/dsk/c4t0d0#Create vgdata01mkdir /dev/

9、vgdata01mknod /dev/vgdata01/group c 64 0x020000pvcreate -f /dev/rdsk/c4t1d0pvcreate -f /dev/rdsk/c4t2d0vgcreate /dev/vgdata01 /dev/dsk/c4t1d0 /dev/dsk/c4t2d0#Create vgdata02mkdir /dev/vgdata02mknod /dev/vgdata02/group c 64 0x030000pvcreate -f /dev/rdsk/c4t3d0pvcreate -f /dev/rdsk/c4t4d0pvcreate -f /

10、dev/rdsk/c4t5d0vgcreate /dev/vgdata02 /dev/dsk/c4t3d0 /dev/dsk/c4t4d0 /dev/dsk/c4t5d0运行这个脚本hp1#/tmp/vgcreatesh vgcreate.shhp1#/tmp/vgcreatevgchange -a y vgdata01hp1#/tmp/vgcreatevgchange -a y vgdata022.2 让vg不要自动激活hp1#/tmp/vgcreatevi /etc/lvmrc设置AUTO_VG_ACTIVATE=02.3 创建lvhp1#/tmp/vgcreatevi oracle_lv

11、.sh内容如下：lvcreate -n P901_control_01.ctl -L 110 /dev/vgdata01lvcreate -n P901_control_02.ctl -L 110 /dev/vgdata01lvcreate -n P901_control_03.ctl -L 110 /dev/vgdata01lvcreate -n P901_system_01.dbf -L 1000 /dev/vgdata01lvcreate -n P901_log1_01.log -L 512 /dev/vgdata01lvcreate -n P901_log1_02.log -L 512

12、 /dev/vgdata01lvcreate -n P901_log1_03.log -L 512 /dev/vgdata01lvcreate -n P901_log2_01.log -L 512 /dev/vgdata01lvcreate -n P901_log2_02.log -L 512 /dev/vgdata01lvcreate -n P901_log2_03.log -L 512 /dev/vgdata01lvcreate -n P901_spfile1.dbf -L 5 /dev/vgdata01lvcreate -n P901_users_01.dbf -L 1000 /dev/

13、vgdata01lvcreate -n P901_temp_01.dbf -L 500 /dev/vgdata01lvcreate -n P901_undotbs_01.dbf -L 2000 /dev/vgdata01lvcreate -n P901_undotbs_02.dbf -L 2000 /dev/vgdata01lvcreate -n P901_example_01.dbf -L 160 /dev/vgdata01lvcreate -n P901_cwmlite_01.dbf -L 100 /dev/vgdata01lvcreate -n P901_indx_01.dbf -L 2

14、00 /dev/vgdata01lvcreate -n P901_tools_01.dbf -L 200 /dev/vgdata01lvcreate -n P901_drsys_01.dbf -L 90 /dev/vgdata01lvcreate -n P901_srvmconfig_01.dbf -L 90 /dev/vgdata01当然这些lv的尺寸随着你的应用不同，你可以自己修改hp1#/tmp/vgcreatesh oracle_lv.sh查看lv建立是否成功hp1#/tmp/vgcreatevgdisplay vgdata012.4 导出vg信息hp1#/tmp/vgcreatevg

15、change -a n vglockhp1#/tmp/vgcreatevgchange -a n vgdata01hp1#/tmp/vgcreatevgchange -a n vgdata02hp1#/tmp/vgcreatevgexport -p -s -v -m vglock.map vglockhp1#/tmp/vgcreatevgexport -p -s -v -m vgdata01.map vgdata01hp1#/tmp/vgcreatevgexport -p -s -v -m vgdata02.map vgdata022.5 导入vg信息到hp2上hp1#/tmp/vgcreat

16、ecd .hp1#/tmprcp -r vgcreate hp2:/tmphp2#/devll /dev/vg00hp2#/tmp/vgcreatemkdir /dev/vglockhp2#/tmp/vgcreatemkdir /dev/vgdata01hp2#/tmp/vgcreatemkdir /dev/vgdata02hp2#/tmp/vgcreatemknod /dev/vglock/group c 64 0x010000hp2#/tmp/vgcreatemknod /dev/vgdata01/group c 64 0x020000hp2#/tmp/vgcreatemknod /dev

17、/vgdata02/group c 64 0x030000hp2#/tmp/vgcreatevgimport -v -s -m vglock.map vglockhp2#/tmp/vgcreatevgimport -v -s -m vgdata01.map vgdata01hp2#/tmp/vgcreatevgimport -v -s -m vgdata02.map vgdata02hp1#/tmpvgdisplay验证导入是否正确。如果原来hp2机器上已经有vg信息请先导出，清除以后才做,用hp2#/tmp/vgcreatevgexport /dev/vglockhp2#/tmp/vgcre

18、atevgexport /dev/vgdata01hp2#/tmp/vgcreatevgexport /dev/vgdata022.6 .生成cluster的配置文件并编辑，并参照本手册的附带的样例配置文件。hp1#/etc/cmclustercmquerycl v -C cluster.ascii -n hp1 -n hp2编辑内容如下：cluster.ascii 文件编辑内容为：CLUSTER_NAME cluster_rac #群集的名字可以修改node_time_out 需要修改大一点改为6秒NETWORK_INTERFACE lan0 HEARTBEAT_IP 192.168.10.

19、4 NETWORK_INTERFACE lan1 HEARTBEAT_IP 10.40.90.243 FIRST_CLUSTER_LOCK_PV /dev/dsk/c4t0d0前面的是心跳线配置。第二个是外网线。但是前面的描述也是用HEARTBEAT_IP还有一个需要修改的是：MAX_CONFIGURED_PACKAGES 4 2.7 检查配置是否正确hp1#/etc/cmclustersh check.shcheck.sh的内容如下cmcheckconf -v -C cluster.ascii2.8 把vg_lock盘作为共享盘hp1#/etc/cmclustervgchange -a y

20、vglock2.9 应用设置hp1#/etc/cmclustersh apply.shapply.sh的内容如下：cmapplyconf -v -C cluster.ascii hp1#/etc/cmclustervgchange -a n vg_lock2.10 启动群集hp1#/etc/cmcluster cmrunclhp1#/etc/cmcluster vgchange -S y -c y vgdata01hp1#/etc/cmclustervgchange -a s vgdata01hp1#/etc/cmcluster remsh hp2 /usr/sbin/vgchange -a

21、s vgdata013 第三部分：oracle安装3.1 Unix User and Group Creation以root用户登录执行：（两台机器上都执行）hp1#/etc/cmcluster groupadd -g 200 dbahp1#/etc/cmclusteruseradd -u 300 -g 200 -d /home/oracle -s /usr/bin/sh -m oraclehp2#/etc/cmcluster groupadd -g 200 dbahp2#/etc/cmclusteruseradd -u 300 -g 200 -d /home/oracle -s /usr/bin/sh -m oracle3.2 修改裸设备的权限hp1#/etc/cmcluster chown oracle:dba /dev/vgdata01/r*hp1#/etc/cmcluster remsh hp2 chown oracle:hp1#/etc/cmcluster chmod 777 /dev/vgdata01hp1#/etc/cmcluster remsh hp2