HP-UX下配置OracleRAC.doc

一、 安裝操作系統(tǒng)節(jié)點(diǎn)A節(jié)點(diǎn)B機(jī)器名Hpux1Hpux2IP192.168.1.3192.168.1.4Visual IP192.168.1.5192.168.1.6Private IP10.0.0.110.0.0.2GateWay192.168.1.2(必須配置，且保持全通)二、 安裝操作系統(tǒng)補(bǔ)丁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在彈出對(duì)話(huà)框?qū)懭雂epot目錄的完整路徑，安裝補(bǔ)丁，重新啟動(dòng)。系統(tǒng)自動(dòng)重啟動(dòng)。3 解壓縮BUNDLE11i_B.11.23.0409.3.tartar xvf BUNDLE11i_B.11.23.0409.3.tar./create_depot_hp-ux_11 （生成depot目錄）swinstall在彈出對(duì)話(huà)框?qū)懭雂epot目錄的完整路徑，安裝補(bǔ)丁。4 chmod +x unzip將unzip拷貝至/bin下。5 解壓縮otherpatch.zipunzip otherpatch.zip./create_depot_hp-ux_11 （生成depot目錄）swinstall在彈出對(duì)話(huà)框?qū)懭雂epot目錄的完整路徑，安裝補(bǔ)丁。6 swinstall s /完整路徑/sdk14_14210_ia.depot7 swinstall s /完整路徑/ssh_A.04.30.003.depot89三、 操作系統(tǒng)配置（所有節(jié)點(diǎn)）1 修改/etc/hosts文件，增加以下內(nèi)容：192.168.10.21hpux1192.168.10.22hpux2192.168.10.31hpux1-vip192.168.10.32hpux2-vip10.0.0.1hpux1-priv10.0.0.2hpux2-priv2 創(chuàng)建Oracle系統(tǒng)組與用戶(hù)/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下創(chuàng)建oracle目錄：mkdir /home/oraclechown -r oracle:oinstall /home/oracle3 在Oracle用戶(hù)下：$xhost + hpux1$xhost + hpux2運(yùn)行$xhost檢查。創(chuàng)建/u01/oracle，/u01/crs目錄：chown R oracle:oinstall /u014 修改/home/oracle/.dtprofile，增加以下內(nèi)容：PATH=$PATH:/usr/sbinTEMP=/tmpTMPDIR=/tmpexport TEMP TMPDIRORACLE_BASE=/u01export ORACLE_BASEunset ORACLE_HOMEunset TNS_ADMINumask 022檢查已經(jīng)設(shè)置的變量是否已經(jīng)生效$ umask$ env | more5 在root下檢查系統(tǒng)結(jié)構(gòu)：# /bin/getconf KERNEL_BITS結(jié)果顯示64，正常6 創(chuàng)建象征鏈接# 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 配置內(nèi)核參數(shù)如果當(dāng)前值大于要更改的的值，不需更改。使用# /usr/sbin/kcweb F查看并更改內(nèi)核參數(shù)。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內(nèi)存60%）Note: To avoid performance degradation, the value should be greater than or equal to the size of the SGA.shmmni512shmseg120vps_ceiling648 禁止操作系統(tǒng)自動(dòng)激活共享卷組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 磁盤(pán)陣列柜配置磁盤(pán)陣列柜預(yù)先分配三個(gè)分區(qū)，大小分別為150MB/70MB/剩余，分別用于存儲(chǔ)OCR/Voting/Datafile。chmod 755 /dev/rdsk 檢索所有磁盤(pán)：/usr/sbin/ioscan -fun -C disk，獲取磁盤(pán)系統(tǒng)名：/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運(yùn)行（注意紅色部分一一對(duì)應(yīng)）：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清空設(shè)備里面的數(shù)據(jù)：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清空設(shè)備里面的數(shù)據(jù)：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 重新啟動(dòng)，準(zhǔn)備安裝CRS四、 配置ssh1 以O(shè)racle用戶(hù)登錄2 在oracle用戶(hù)home目錄中創(chuàng)建.ssh目錄，在所有的節(jié)點(diǎn)執(zhí)行：$ mkdir /.ssh$ chmod 700 /.ssh$ /usr/bin/ssh-keygen -t rsa$ /usr/bin/ssh-keygen -t dsa3 生成authorized_keys；在所有的節(jié)點(diǎn)執(zhí)行：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在所有的節(jié)點(diǎn)重復(fù)以上步驟4 在root下修改/opt/ssh/etc/sshd_config：StrictModes noX11Forwarding no使連接不需要密碼5 測(cè)試ssh配置是否成功$ exec /usr/bin/ssh-agent $SHELL$ /usr/bin/ssh-add在提示下，輸入每個(gè)通行口令然后執(zhí)行：ssh hpux1 datessh hpux2 date如果不需要輸入任何東東直接顯示時(shí)間，則配置成功。67五、 安裝CRS1 以O(shè)racle用戶(hù)登錄2 運(yùn)行一下命令$ exec /usr/bin/ssh-agent $SHELL$ /usr/bin/ssh-add在提示下，輸入每個(gè)通行口令然后執(zhí)行：ssh hpux1 datessh hpux2 date連接正常后，3 在/usr/local/bin下創(chuàng)建ssh連接# cd /usr/local/bin# ls# ln -s /usr/bin/ssh ssh4 在當(dāng)前窗口執(zhí)行安裝命令/runInstaller系統(tǒng)的預(yù)安裝檢查會(huì)提示警告如下：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 這是因?yàn)橄到y(tǒng)沒(méi)有安裝HP C Compiler所導(dǎo)致的，沒(méi)有關(guān)系，繼續(xù)安裝。添加hpux2/hpux2-priv/hpux2-vip。lan0為Public，lan1為Private。上圖執(zhí)行的步驟如下，首先在Node1上執(zhí)行orainstRoot.sh，然后在Node2上執(zhí)行orainstRoot.sh，然后在Node1上執(zhí)行root.sh，結(jié)果如下即為正常：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上執(zhí)行root.sh，結(jié)果如下即為正常：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.#正常情況下會(huì)在Node1上彈出下圖如果提示上表中的黑體字，是因?yàn)?，服?wù)器默認(rèn)的網(wǎng)關(guān)沒(méi)有設(shè)置，以至安裝程序無(wú)法確認(rèn)lan0與lan1哪一個(gè)是Public interfaces。檢查兩個(gè)節(jié)點(diǎn)的網(wǎng)關(guān)設(shè)置，確認(rèn)無(wú)誤，在Node1節(jié)點(diǎn)root用戶(hù)下執(zhí)行$ORACLE_CRS_HOME/bin/vipca，過(guò)程如下：選擇Public，即lan0，千萬(wàn)不要選錯(cuò)。重新回到安裝CRS界面Oracle Cluster Verification Utility項(xiàng)會(huì)提示Failed，這是Oracle CRS for HP-UX上的Bug，回到命令行下，運(yùn)行$ORACLE_CRS_HOME/bin/crs_stat t，如果所有的項(xiàng)都為online，則可以進(jìn)行下一步選擇，同時(shí)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.運(yùn)行netstat in 察看當(dāng)前服務(wù)器上的IP，檢查vip是否生效。5 Sdfs6六、 安裝數(shù)據(jù)庫(kù)軟件安裝語(yǔ)言加上”Simplified Chinese”P(pán)ath選擇/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 這是因?yàn)橄到y(tǒng)沒(méi)有安裝HP C Compiler所導(dǎo)致的，沒(méi)有關(guān)系（同安裝CRS）。Checking for maxswapchunks=16384; found no entry.Failed Checking for semmap=4098; found no entry.Failed 這兩個(gè)參數(shù)在HP-UX 11.23版本已經(jīng)棄用，可以忽略。繼續(xù)進(jìn)行下一步。只安裝數(shù)據(jù)庫(kù)軟件（Install database Software only）。在root下運(yùn)行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.七、 創(chuàng)建數(shù)據(jù)庫(kù)修改$ORACLE_HOME/.dtprofile：刪除