HP-UX下配置OracleRAC.doc

一、 安装操作系统节点A节点B机器名Hpux1Hpux2IP192.168.1.3192.168.1.4Visual IP192.168.1.5192.168.1.6Private IP10.0.0.110.0.0.2GateWay192.168.1.2(必须配置，且保持全通)二、 安装操作系统补丁1 上传BUNDLE11i_B.11.23.0408.1.tar，BUNDLE11i_B.11.23.0409.3.tar，otherpatch.zip，sdk14_14210_ia.depot，ssh_A.04.30.003.depot，unzip；.tar与.zip文件放置在不同的目录中。2 解压缩BUNDLE11i_B.11.23.0408.1.tartar xvf BUNDLE11i_B.11.23.0408.1.tar./create_depot_hp-ux_11 （生成depot目录）swinstall在弹出对话框写入depot目录的完整路径，安装补丁，重新启动。系统自动重启动。3 解压缩BUNDLE11i_B.11.23.0409.3.tartar xvf BUNDLE11i_B.11.23.0409.3.tar./create_depot_hp-ux_11 （生成depot目录）swinstall在弹出对话框写入depot目录的完整路径，安装补丁。4 chmod +x unzip将unzip拷贝至/bin下。5 解压缩otherpatch.zipunzip otherpatch.zip./create_depot_hp-ux_11 （生成depot目录）swinstall在弹出对话框写入depot目录的完整路径，安装补丁。6 swinstall s /完整路径/sdk14_14210_ia.depot7 swinstall s /完整路径/ssh_A.04.30.003.depot89三、 操作系统配置（所有节点）1 修改/etc/hosts文件，增加以下内容：192.168.10.21hpux1192.168.10.22hpux2192.168.10.31hpux1-vip192.168.10.32hpux2-vip10.0.0.1hpux1-priv10.0.0.2hpux2-priv2 创建Oracle系统组与用户/usr/sbin/groupadd -g 200 oinstall/usr/sbin/groupadd -g 201 dba/usr/sbin/groupadd -g 202 oper/usr/sbin/useradd -u 200 -g oinstall -G dba,oper oracle#passwd oracle （修改密码）在/home下创建oracle目录：mkdir /home/oraclechown -r oracle:oinstall /home/oracle3 在Oracle用户下：$xhost + hpux1$xhost + hpux2运行$xhost检查。创建/u01/oracle，/u01/crs目录：chown R oracle:oinstall /u014 修改/home/oracle/.dtprofile，增加以下内容：PATH=$PATH:/usr/sbinTEMP=/tmpTMPDIR=/tmpexport TEMP TMPDIRORACLE_BASE=/u01export ORACLE_BASEunset ORACLE_HOMEunset TNS_ADMINumask 022检查已经设置的变量是否已经生效$ umask$ env | more5 在root下检查系统结构：# /bin/getconf KERNEL_BITS结果显示64，正常6 创建象征链接# cd /usr/libln -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.sl7 配置内核参数如果当前值大于要更改的的值，不需更改。使用# /usr/sbin/kcweb F查看并更改内核参数。ParameterRecommended Formula or Valueksi_alloc_max(nproc*8)executable_stack0max_thread_proc1024maxdsiz1073741824 (1 GB)maxdsiz_64bit2147483648 (2 GB)maxssiz134217728 (128 MB)maxssiz_64bit1073741824 (1 GB)maxswapchunks16384 ?maxuprc(nproc*9)/10) 3780msgtql(nproc) 4200msgmap(msgtql+2) 4200+2msgmni(nproc)msgseg32767ninode(8*nproc+2048) 35648ncsize(ninode+1024) 36672 nfile(15*nproc+2048) 65048nflocks(nproc) 4200nkthread(nproc*7)/4)+16) 7366nproc4096semmns(semmni*2) 8400semmni(nproc) 4200semmap(semmni+2) 4202semmnu(nproc-4) 4196semvmx32767shmmaxThe size of physical memory or 1073741824 (0X40000000), whichever is greater. 2576980377 （2G内存60%）Note: To avoid performance degradation, the value should be greater than or equal to the size of the SGA.shmmni512shmseg120vps_ceiling648 禁止操作系统自动激活共享卷组Create a backup copy of the /etc/lvmrc file:# cp /etc/lvmrc /etc/lvmrc_origOpen the /etc/lvmrc file in any text editor and search for the AUTO_VG_ACTIVATE flag.If necessary, change the value of the AUTO_VG_ACTIVATE flag to 0, to disable automatic volume group activation, as follows:AUTO_VG_ACTIVATE=0Search for the custom_vg_activation function in the /etc/lvmrc file.Add vgchange commands to the function, as shown in the following example, to automatically activate existing local volume groups:custom_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 vg00 /sbin/vgchange -a y vg01 /sbin/vgchange -a y vg02 return 0In this example, vg00, vg01, and vg02 are the volume groups that you want to activate automatically when the system restarts.9 磁盘阵列柜配置磁盘阵列柜预先分配三个分区，大小分别为150MB/70MB/剩余，分别用于存储OCR/Voting/Datafile。chmod 755 /dev/rdsk 检索所有磁盘：/usr/sbin/ioscan -fun -C disk，获取磁盘系统名：/dev/dsk/c4t0d1 138MB OCR/dev/dsk/c4t0d2 78MB Voting/dev/dsk/c4t0d3 500GB Datafile在/dev/rdsk下 ls lacrw-r- 1 bin sys 188 0x040100 Jun 3 10:30 c4t0d1crw-r- 1 bin sys 188 0x040200 Jun 3 17:49 c4t0d2crw-r- 1 bin sys 188 0x040300 Jun 3 17:49 c4t0d3运行（注意红色部分一一对应）：mknod ora_ocr_raw c 188 0x040100mknod ora_vot_raw c 188 0x040200OCR：chown root:oinstall /dev/rdsk/c4t0d1chown root:oinstall /dev/rdsk/ora_ocr_rawchmod 640 /dev/rdsk/c4t0d1chmod 640 /dev/rdsk/ora_ocr_raw清空设备里面的数据：dd if=/dev/zero of=/dev/rdsk/c4t0d1 bs=1024000 count=137Voting：chown oracle:dba /dev/rdsk/c4t0d2chown oracle:dba /dev/rdsk/ora_vot_rawchmod 660 /dev/rdsk/c4t0d2chmod 660 /dev/rdsk/ora_vot_raw清空设备里面的数据：dd if=/dev/zero of=/dev/rdsk/c4t0d2 bs=1024000 count=80datafile：chown oracle:dba /dev/rdsk/c4t0d3chmod 660 /dev/rdsk/c4t0d3dd if=/dev/zero of=/dev/rdsk/c4t0d3 bs=1024000 count=300010 重新启动，准备安装CRS四、 配置ssh1 以Oracle用户登录2 在oracle用户home目录中创建.ssh目录，在所有的节点执行：$ mkdir /.ssh$ chmod 700 /.ssh$ /usr/bin/ssh-keygen -t rsa$ /usr/bin/ssh-keygen -t dsa3 生成authorized_keys；在所有的节点执行：ssh hpux1 cat /home/oracle/.ssh/id_rsa.pub authorized_keysssh hpux1 cat /home/oracle/.ssh/id_dsa.pub authorized_keysssh hpux2 cat /home/oracle/.ssh/id_rsa.pub authorized_keysssh hpux2 cat /home/oracle/.ssh/id_dsa.pub authorized_keys在所有的节点重复以上步骤4 在root下修改/opt/ssh/etc/sshd_config：StrictModes noX11Forwarding no使连接不需要密码5 测试ssh配置是否成功$ exec /usr/bin/ssh-agent $SHELL$ /usr/bin/ssh-add在提示下，输入每个通行口令然后执行：ssh hpux1 datessh hpux2 date如果不需要输入任何东东直接显示时间，则配置成功。67五、 安装CRS1 以Oracle用户登录2 运行一下命令$ exec /usr/bin/ssh-agent $SHELL$ /usr/bin/ssh-add在提示下，输入每个通行口令然后执行：ssh hpux1 datessh hpux2 date连接正常后，3 在/usr/local/bin下创建ssh连接# cd /usr/local/bin# ls# ln -s /usr/bin/ssh ssh4 在当前窗口执行安装命令/runInstaller系统的预安装检查会提示警告如下：Checking for PHSS_33278; found Not found.Failed Checking for PHSS_33279; found Not found.Failed Checking for PHSS_33277; found Not found.Failed Checking for PHSS_33279; found Not found.Failed 这是因为系统没有安装HP C Compiler所导致的，没有关系，继续安装。添加hpux2/hpux2-priv/hpux2-vip。lan0为Public，lan1为Private。上图执行的步骤如下，首先在Node1上执行orainstRoot.sh，然后在Node2上执行orainstRoot.sh，然后在Node1上执行root.sh，结果如下即为正常：Hpux1：# ./root.shWARNING: directory /u01 is not owned by rootChecking to see if Oracle CRS stack is already configuredSetting the permissions on OCR backup directorySetting up NS directoriesOracle Cluster Registry configuration upgraded successfullyWARNING: directory /u01 is not owned by rootSuccessfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: hpux1 hpux1-priv hpux1node 2: hpux2 hpux2-priv hpux2Creating OCR keys for user root, privgrp sys.Operation successful.Now formatting voting device: /dev/rdsk/ora_vot_rawFormat of 1 voting devices complete.Startup will be queued to init within 30 seconds.Adding daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active on these nodes. hpux1CSS is inactive on these nodes. hpux2Local node checking complete.Run root.sh on remaining nodes to start CRS daemons.#然后在Node2上执行root.sh，结果如下即为正常：Hpux2：# ./root.shWARNING: directory /u01 is not owned by rootChecking to see if Oracle CRS stack is already configuredSetting the permissions on OCR backup directorySetting up NS directoriesOracle Cluster Registry configuration upgraded successfullyWARNING: directory /u01 is not owned by rootclscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Successfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: hpux1 hpux1-priv hpux1node 2: hpux2 hpux2-priv hpux2clscfg: Arguments check out successfully.NO KEYS WERE WRITTEN. Supply -force parameter to override.-force is destructive and will destroy any previous clusterconfiguration.Oracle Cluster Registry for cluster has already been initializedStartup will be queued to init within 30 seconds.Adding daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active on these nodes. hpux1 hpux2CSS is active on all nodes.Waiting for the Oracle CRSD and EVMD to startOracle CRS stack installed and running under init(1M)Running vipca(silent) for configuring nodeappsThe given interface(s), lan0 is not public. Public interfaces should be used to configure virtual IPs.#正常情况下会在Node1上弹出下图如果提示上表中的黑体字，是因为，服务器默认的网关没有设置，以至安装程序无法确认lan0与lan1哪一个是Public interfaces。检查两个节点的网关设置，确认无误，在Node1节点root用户下执行$ORACLE_CRS_HOME/bin/vipca，过程如下：选择Public，即lan0，千万不要选错。重新回到安装CRS界面Oracle Cluster Verification Utility项会提示Failed，这是Oracle CRS for HP-UX上的Bug，回到命令行下，运行$ORACLE_CRS_HOME/bin/crs_stat t，如果所有的项都为online，则可以进行下一步选择，同时CRS安装正常。The bug is fixed in 10.2.0.3 patchset. Before it is available, please run $ORA_CRS_HOME/bin/crs_stat -tif it reports resources with online status, then it indicates CRS installation completes fine.Please ignore the error and continue with the rest installation task.运行netstat in 察看当前服务器上的IP，检查vip是否生效。5 Sdfs6六、 安装数据库软件安装语言加上”Simplified Chinese”Path选择/u01/oracle提示中的警告如下：Checking for PHSS_33278; found Not found.Failed Checking for PHSS_33279; found Not found.Failed Checking for PHSS_33277; found Not found.Failed Checking for PHSS_33279; found Not found.Failed 这是因为系统没有安装HP C Compiler所导致的，没有关系（同安装CRS）。Checking for maxswapchunks=16384; found no entry.Failed Checking for semmap=4098; found no entry.Failed 这两个参数在HP-UX 11.23版本已经弃用，可以忽略。继续进行下一步。只安装数据库软件（Install database Software only）。在root下运行root.sh# ./root.shRunning Oracle10 root.sh script.The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/oracleEnter the full pathname of the local bin directory: /usr/local/bin: Copying dbhome to /usr/local/bin . Copying oraenv to /usr/local/bin . Copying coraenv to /usr/local/bin .Creating /etc/oratab file.Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.七、 创建数据库修改$ORACLE_HOME/.dtprofile：删除