《[计算机软件及应用]ORACLE10gRACHPUXMCsericeguard安装配置.doc》由会员分享，可在线阅读，更多相关《[计算机软件及应用]ORACLE10gRACHPUXMCsericeguard安装配置.doc（52页珍藏版）》请在三一办公上搜索。
1、ORACLE10g RAC +HP-UX+MC serviceguard安装配置step by step目录一、环境检查1二、编辑相关配置文件22.1更改hosts文件22.2添加root用户的rhosts信任22.3 AIO配置22.4查看符合的连接是否存在22.5.调整内核参数32.6.创建Oracle用户3三、逻辑卷配置43.1.创建PV43.2.创建vg53.3.创建arch1文件系统53.4.创建lv53.5.对vg,lv设权限63.6.vgexport vgimport卷组63.7.创建arch2文件系统7四、 集群配置84.1 创建集群配置文件84.2编辑集群文件84.3验证集群
2、配置文件84.4应用集群配置文件94.5启/停双机并设置卷组信息94.6.建立集群管理包94.6.1建第一个包pkg194.6.2增加第二个包10五、安装CRS软件11六、数据库软件安装22七、打补丁到10.2.0.427八、创建数据库27九、配置NTP时钟服务器36一、系统环境检查OS环境: HP-UX 11.31HA软件: MC/ServiceGuard 11.18+Serviceguard Extension for RACOracle: Oracle10g 10.2.0.1+10.2.0.4补丁Hostname: ldhis1 ldhis2# machinfo #查系列号# /usr/
3、contrib/bin/machinfo | grep -i Memory #查看物理内存# /usr/sbin/swapinfo -a #查看交换空间# bdf /tmp #查看/tmp的空间情况，至少400M,推荐1G# bdf #至少有10GB 的磁盘空间给Oracle software.# uname -a #查看操作系统的版本# /bin/getconf KERNEL_BITS #查看操作系统bit数 # date #查看每个节点的日期时间，同步时间Tue Nov 25 10:34:33 EAT 2008 #时区要为EAT。# date 11310959 #修改时间# set_par
4、ms timezone #修改时区二、编辑相关配置文件2.1更改hosts文件# vi /etc/hosts添加如下内容:222.3.25.121 ldhis1222.3.25.122 ldhis2222.3.25.123 ldhis1-vip222.3.25.124 ldhis2-vip10.1.0.121 ldhis1_priv10.1.0.122 ldhis2_priv(此处必须用下划线)2.2添加root用户的rhosts信任# vi .rhostsldhis1 rootldhis2 root2.3 AIO配置（此步11.31版本可不做）# ll /dev/asynccrw-rw-rw
5、- 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/usr/sbin/setprivgrp -f /etc/privgroup #重启生效#用SAM在 kernel配置async driver= Kernel Configuration= Module= the driver is called a
6、syncdskGenerate 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 libXldhis11.3 libXldhis11.slln -s libXi.3 libXi.slln -s libXm.4 libXm.slln -s libXp.2 libXp.slln -s libXt.3 libXt.slln -s libXtst.2
7、libXtst.sl2.5.调整内核参数#kctune 查内核参数kctune -h -B nproc=4200kctune -h -B ksi_alloc_max=33600kctune -h -B max_thread_proc=1200kctune -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
8、=2048kctune -h -B msgtql=2048kctune -h -B ncsize=35840 kctune -h -B nflocks=2048kctune -h -B ninode=34816kctune -h -B nkthread=8416kctune -h -B semmni=2048kctune -h -B semmns=16384kctune -h -B semmnu=4092kctune -h -B semvmx=32767kctune -h -B shmmax=34359738368 kctune -h -B shmmni=512kctune -h -B shm
9、seg=300kctune -h -B vps_ceiling=642.6.创建Oracle用户#用SAM创建orasrv和oracle用户，orasrv、oracle主组为dba,副组为oinstall。#用SAM创建dba和oinstall组#注：两个节点gid及uid保持一致#注2：orasrv的home directory为/rdbm/orasrv#注3：oracle的home directory为/usr/local/oraclemkdir -p /rdbm/orasrv/product/10.2.0/crsmkdir -p /rdbm/orasrv/product/10.2.0/d
10、bchown -R orasrv:dba /rdbm/orasrvchmod -R 775 /rdbm/orasrv添加oracle用户的rhosts信任# vi /rdbm/orasrv /.rhostsldhis1 orasrvldhis2 orasrvldhis1_priv orasrvldhis2_priv orasrvldhis1-vip orasrvldhis2-vip orasrv$#vi /.profileexport ORACLE_BASE=/rdbm/orasrvexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/dbexport
11、ORACLE_CRS_HOME=$ORACLE_BASE/product/10.2.0/crsexport ORACLE_SID=orcl1export NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport ORA_NLS22=$ORACLE_HOME/occommon/nls/admin/dataexport TMP=/var/tmpexport TEMP=/var/tmpexport ORACLE_TERM=xtermexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/
12、lib：$ORACLE_CRS_HOME/libexport PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_CRS_HOME/binexport ORACLE_OWNER=orasrvexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlibPS1=whoamihostnameexport PS1第二个节点ORACLE_SID=orcl2三、逻辑卷配置3.1.创建vg#用SAM创建vglock和vgdata#注：vgdata的
13、pe size设为64MB3.4.创建lvvi /tmp/sh/lvcreate.shlvcreate -n lv_ora_crs1-L 256 vgdatalvcreate -n lv_ora_crs2-L 256 vgdatalvcreate -n lv_ora_vote1-L 256 vgdatalvcreate -n lv_ora_vote2-L 256 vgdatalvcreate -n lv_ora_vote3-L 256 vgdatalvcreate -n lv_system01-L 8192 vgdatalvcreate -n lv_sysaux01-L 8192 vgdata
14、lvcreate -n lv_user01-L 8192 vgdatalvcreate -n lv_undotbs1_01-L 20480 vgdatalvcreate -n lv_undotbs2_01-L 20480 vgdatalvcreate -n lv_temp01-L 20480 vgdatalvcreate -n lv_temp02-L 20480 vgdatalvcreate -n lv_redo1_01-L 512 vgdatalvcreate -n lv_redo1_02-L 512 vgdatalvcreate -n lv_redo1_03-L 512 vgdatalvc
15、reate -n lv_redo2_01-L 512 vgdatalvcreate -n lv_redo2_02-L 512 vgdatalvcreate -n lv_redo2_03-L 512 vgdatalvcreate -n lv_spfile -L256 vgdatalvcreate -n lv_control01-L 256 vgdatalvcreate -n lv_control02-L 256 vgdatalvcreate -n lv_control03-L 256 vgdatalvcreate -n lv_dfsys01-L 8192 vgdatalvcreate -n lv
16、_dfbb01-L 8192 vgdatalvcreate -n lv_dfmis01-L 8192 vgdatalvcreate -n lv_dfhis01-L 40960 vgdatalvcreate -n lv_dfhis02-L 40960 vgdatalvcreate -n lv_dfhis03-L 40960 vgdatalvcreate -n lv_dfhis04-L 40960 vgdatalvcreate -n lv_dfhis05-L 40960 vgdatalvcreate -n lv_dfhis06-L 40960 vgdatalvcreate -n lv_dfhis0
17、7-L 40960 vgdatalvcreate -n lv_dfhis08-L 40960 vgdatalvcreate -n lv_dfhis09-L 40960 vgdatalvcreate -n lv_dfhis10-L 40960 vgdatalvcreate -n lv_dfhis11-L 40960 vgdatalvcreate -n lv_dfhis12-L 40960 vgdatalvcreate -n lv_dfhis13-L 40960 vgdatalvcreate -n lv_dfhis14-L 40960 vgdatalvcreate -n lv_dfhis15-L
18、40960 vgdatalvcreate -n lv_dfhis16-L 40960 vgdatalvcreate -n lv_dfhis17-L 40960 vgdatalvcreate -n lv_dfhis18-L 40960 vgdatalvcreate -n lv_dfhis19-L 40960 vgdatalvcreate -n lv_dfhis20-L 40960 vgdatalvcreate -n lv_dfhis21-L 40960 vgdatalvcreate -n lv_dfhis22-L 40960 vgdatalvcreate -n lv_dfhis23-L 4096
19、0 vgdatalvcreate -n lv_dfhis24-L 40960 vgdatalvcreate -n lv_dfhis25-L 40960 vgdatalvcreate -n lv_dfhis26-L 40960 vgdatalvcreate -n lv_dfhis27-L 40960 vgdatalvcreate -n lv_dfhis28-L 40960 vgdatalvcreate -n lv_dfhis29-L 40960 vgdatalvcreate -n lv_dfhis30-L 40960 vgdatalvcreate -n lv_dfhis31-L 40960 vg
20、datalvcreate -n lv_dfhis32-L 40960 vgdatalvcreate -n lv_dfhis33-L 40960 vgdatalvcreate -n lv_dfhis34-L 40960 vgdatalvcreate -n lv_dfhis35-L 40960 vgdatalvcreate -n lv_dfhis36-L 40960 vgdatalvcreate -n lv_dfhis37-L 40960 vgdatalvcreate -n lv_dfhis38-L 40960 vgdatalvcreate -n lv_dfhis39-L 40960 vgdata
21、lvcreate -n lv_dfhis40-L 40960 vgdatalvcreate -n lv_dfhis41-L 40960 vgdatalvcreate -n lv_dfhis42-L 40960 vgdatalvcreate -n lv_dfhis43-L 40960 vgdatalvcreate -n lv_dfhis44-L 40960 vgdatalvcreate -n lv_dfhis45-L 40960 vgdatalvcreate -n lv_dfindex01-L 40960 vgdatalvcreate -n lv_dfindex02-L 40960 vgdata
22、lvcreate -n lv_dfindex03-L 40960 vgdatalvcreate -n lv_dfindex04-L 40960 vgdatalvcreate -n lv_dfindex05-L 40960 vgdatalvcreate -n lv_dfindex06-L 40960 vgdatalvcreate -n lv_dfindex07-L 40960 vgdatalvcreate -n lv_dfindex08-L 40960 vgdatalvcreate -n lv_dfindex09-L 40960 vgdatalvcreate -n lv_dfindex10-L
23、40960 vgdatalvcreate -n lv_dfindex11-L 40960 vgdatalvcreate -n lv_dfindex12-L 40960 vgdatalvcreate -n lv_dfindex13-L 40960 vgdatalvcreate -n lv_dfindex14-L 40960 vgdatalvcreate -n lv_dfindex15-L 40960 vgdatalvcreate -n lv_dfindex16-L 40960 vgdatalvcreate -n lv_dfindex17-L 40960 vgdatalvcreate -n lv_
24、dfindex18-L 40960 vgdatalvcreate -n lv_dfindex19-L 40960 vgdatalvcreate -n lv_dfindex20-L 40960 vgdatalvcreate -n lv_dfindex21-L 40960 vgdatalvcreate -n lv_dfindex22-L 40960 vgdatalvcreate -n lv_dfindex23-L 40960 vgdatalvcreate -n lv_dfindex24-L 40960 vgdatalvcreate -n lv_dfindex25-L 40960 vgdatalvc
25、reate -n lv_dfindex26-L 40960 vgdatalvcreate -n lv_dfindex27-L 40960 vgdatalvcreate -n lv_dfindex28-L 40960 vgdatalvcreate -n lv_dfindex29-L 40960 vgdatalvcreate -n lv_dfindex30-L 40960 vgdatalvcreate -n lv_dfindex31-L 40960 vgdatalvcreate -n lv_dfindex32-L 40960 vgdatalvcreate -n lv_dfindex33-L 409
26、60 vgdatalvcreate -n lv_dfindex34-L 40960 vgdatalvcreate -n lv_dfindex35-L 40960 vgdatalvcreate -n lv_dfindex36-L 40960 vgdatalvcreate -n lv_dfindex37-L 40960 vgdatalvcreate -n lv_dfindex38-L 40960 vgdatalvcreate -n lv_dfindex39-L 40960 vgdatalvcreate -n lv_dfindex40-L 40960 vgdatalvcreate -n lv_dfi
27、ndex41-L 40960 vgdatalvcreate -n lv_dfindex42-L 40960 vgdatalvcreate -n lv_dfindex43-L 40960 vgdatalvcreate -n lv_dfindex44-L 40960 vgdatalvcreate -n lv_dfindex45-L 40960 vgdatalvcreate -n lv_dfindex46-L 40960 vgdatalvcreate -n lv_dfindex47-L 40960 vgdatalvcreate -n lv_dfindex48-L 40960 vgdatalvcrea
28、te -n lv_dfindex49-L 40960 vgdatalvcreate -n lv_dfindex50-L 40960 vgdatalvcreate -n lv_dfindex51-L 40960 vgdatalvcreate -n lv_dfindex52-L 40960 vgdatalvcreate -n lv_dfindex53-L 40960 vgdatalvcreate -n lv_dfindex54-L 40960 vgdatalvcreate -n lv_dfindex55-L 40960 vgdatalvcreate -n lv_dfdata4g01-L 4096
29、vgdatalvcreate -n lv_dfdata4g02-L 4096 vgdatalvcreate -n lv_dfdata4g03-L 4096 vgdatalvcreate -n lv_dfdata4g04-L 4096 vgdatalvcreate -n lv_dfdata4g05-L 4096 vgdatalvcreate -n lv_dfdata4g06-L 4096 vgdatalvcreate -n lv_dfdata4g07-L 4096 vgdatalvcreate -n lv_dfdata4g08-L 4096 vgdatalvcreate -n lv_dfdata
30、4g09-L 4096 vgdatalvcreate -n lv_dfdata4g10-L 4096 vgdatalvcreate -n lv_dfdata10g01-L 10240 vgdatalvcreate -n lv_dfdata10g02-L 10240 vgdatalvcreate -n lv_dfdata10g03-L 10240 vgdatalvcreate -n lv_dfdata10g04-L 10240 vgdatalvcreate -n lv_dfdata10g05-L 10240 vgdatalvcreate -n lv_dfdata10g06-L 10240 vgd
31、atalvcreate -n lv_dfdata10g07-L 10240 vgdatalvcreate -n lv_dfdata10g08-L 10240 vgdatalvcreate -n lv_dfdata10g09-L 10240 vgdatalvcreate -n lv_dfdata10g10-L 10240 vgdatalvcreate -n lv_dfdata10g11-L 10240 vgdatalvcreate -n lv_dfdata10g12-L 10240 vgdatalvcreate -n lv_dfdata10g13-L 10240 vgdatalvcreate -
32、n lv_dfdata10g14-L 10240 vgdatalvcreate -n lv_dfdata10g15-L 10240 vgdatalvcreate -n lv_dfdata40g01-L 40960 vgdatalvcreate -n lv_dfdata40g02-L 40960 vgdatalvcreate -n lv_dfdata40g03-L 40960 vgdatalvcreate -n lv_dfdata40g04-L 40960 vgdatalvcreate -n lv_dfdata40g05-L 40960 vgdata3.5.对vg,lv设权限chown oras
33、rv:dba /dev/vgdata/rlv*chown root:oinstall /dev/vgdata/rlv_ora_crs*chown orasrv:oinstall /dev/vgdata/rlv_ora_vote*chmod 660 /dev/vgdata/r*chmod 664 /dev/vgdata/rlv_ora_crs* chmod 664 /dev/vgdata/rlv_ora_vote*3.6.vgexport vgimport卷组ldhis1:vgchange -a n /dev/vglockvgchange -a n /dev/vgdatavgexport -v
34、-p -s -m /tmp/vglock.map /dev/vglockvgexport -v -p -s -m /tmp/vgdata.map /dev/vgdatarcp /tmp/vglock.map ldhis2:/tmprcp /tmp/vgdata.map ldhis2:/tmpldhis2: mkdir /dev/vglock mkdir /dev/vgdata mknod /dev/vglock/group c 64 0x010000 mknod /dev/vgdata/group c 64 0x020000vgimport -v -s -m /tmp/vglock.map /
35、dev/vglockvgimport -v -s -m /tmp/vgdata.map /dev/vgdata #strings /etc/lvmtabvgchange -a y /dev/vglockvgchange -a y /dev/vgdatavgcfgbackup /dev/vglockvgcfgbackup /dev/vgdatavgchange -a n /dev/vglockvgchange -a n /dev/vgdatachown orasrv:dba /dev/vgdata/rlv*chown root:oinstall /dev/vgdata/rlv_ora_crs*c
36、hown orasrv:oinstall /dev/vgdata/rlv_ora_vote*chmod 660 /dev/vgdata/r*chmod 664 /dev/vgdata/rlv_ora_crs* chmod 664 /dev/vgdata/rlv_ora_vote*四、 集群配置4.1 创建集群配置文件使用cmquerycl去创建一个集群配置文件，Cmquerycl命令必须在主节点上进行。# cmquerycl -v -C /etc/cmcluster/cmcluster.ascii -n ldhis1 -n ldhis24.2编辑集群文件# vi /etc/cmcluster/
37、cmcluster.asciiCLUSTER_NAME cluster1NODE_NAMEldhis1 NETWORK_INTERFACElan2 HEARTBEAT_IP10.0.0.1 NETWORK_INTERFACElan900 HEARTBEAT_IP199.1.1.11# CLUSTER_LOCK_LUN FIRST_CLUSTER_LOCK_PV/dev/dsk/c2t0d0# Route information# route id 1: 10.0.0.1# route id 2: 199.1.1.11# CAPACITY_NAME# CAPACITY_VALUE# Warnin
38、g: There are no standby network interfaces for lan2.# Link Aggregate lan900 contains the following port(s): lan0# Warning: There are no standby network interfaces for lan900.NODE_NAMEldhis2 NETWORK_INTERFACElan2 HEARTBEAT_IP10.0.0.2 NETWORK_INTERFACElan900 HEARTBEAT_IP199.1.1.12# CLUSTER_LOCK_LUN FI
39、RST_CLUSTER_LOCK_PV/dev/dsk/c2t0d0*OPS_VOLUME_GROUP/dev/vglockOPS_VOLUME_GROUP/dev/vgdata4.3验证集群配置文件# cmcheckconf -v -C /etc/cmcluster/cmcluster.asciivgchange -a y /dev/vglockvgchange -a y /dev/vgdata4.4应用集群配置文件cmapplyconf -v -C /etc/cmcluster/cmcluster.ascii将卷组vgdata去激活：#vgchange -a n vgdata4.5启/停双
40、机并设置卷组信息先将卷组vgdata去激活：#vgchange -a n vgdata#cmruncl v（启动）#cmviewcl v（查看是否启动）通过在每个节点上vgdisplay -v vgdata进行查看，可见每个卷组vgdata卷都为激活状态。4.6.建立集群管理包4.6.1建第一个包pkg1mkdir /etc/cmcluster/pkg1cmmakepkg -p /etc/cmcluster/pkg1/pkg1.conf# vi /etc/cmcluster/pkg1/pkg1.confPACKAGE_NAME pkg1NODE_NAME ldhis1 #只加节点1.RUN_S
41、CRIPT /etc/cmcluster/pkg1/tlHALT_SCRIPT /etc/cmcluster/pkg1/tl# cmmakepkg -s /etc/cmcluster/pkg1/tl（生成脚本）# vi /etc/cmcluster/pkg1/tl*VGCHANGE=vgchange -a s # RAC模式注意：注释掉VGCHANGE=vgchange -a e*VG0=vgdata #需要激活的卷组，vglock不需要添加，如有第二个，则添加VG1。# rcp /etc/cmcluster/pkg1/tl ldhis2:/etc/cmcluster/pkg1/# cmche
42、ckconf -C /etc/cmcluster/cmcluster.ascii # cmcheckconf -P /etc/cmcluster/pkg1/pkg1.conf# cmhaltcl -v -f# cmapplyconf -v -C /etc/cmcluster/cmcluster.ascii -P /etc/cmcluster/pkg1/pkg1.conf# cmruncl -v -f 4.6.2增加第二个包# mkdir /etc/cmcluster/pkg2# cmmakepkg -p /etc/cmcluster/pkg2/pkg2.conf# vi /etc/cmclus
43、ter/pkg2/pkg2.confPACKAGE_NAME pkg2NODE_NAME hpdb2 #只加节点2.RUN_SCRIPT /etc/cmcluster/pkg2/tlHALT_SCRIPT /etc/cmcluster/pkg2/tl# cmmakepkg -s /etc/cmcluster/pkg2/tl# vi /etc/cmcluster/pkg2/tlVGCHANGE=vgchange -a s # RAC模式注意：注释掉VGCHANGE=vgchange -a eVG0=vgdata #需要激活的包，vglock不需要添加。# rcp /etc/cmcluster/p
44、kg2/tl ldhis2:/etc/cmcluster/pkg2# cmcheckconf -P /etc/cmcluster/pkg2/pkg2.conf# cmapplyconf -v -P /etc/cmcluster/pkg2/pkg2.conf# cmhaltcl -v -f# cmruncl -v -f/etc/rc.config.d/cmcluster中AUTOSTART_CMCLD=1自动启动MC，一般设为AUTOSTART_CMCLD=0。五、安装CRS软件Crs 软件放在数据库光盘2客户端，目录clusterware中。安装前测试两台主机以orasrv用户可以实现远程无口令rlogin。$oraclerac1
