HP-UX下配置OracleRAC.doc

一、 安裝操作系統(tǒng)節(jié)點A節(jié)點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(必須配置，且保持全通)二、 安裝操作系統(tǒng)補丁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在彈出對話框?qū)懭雂epot目錄的完整路徑，安裝補丁，重新啟動。系統(tǒng)自動重啟動。3 解壓縮BUNDLE11i_B.11.23.0409.3.tartar xvf BUNDLE11i_B.11.23.0409.3.tar./create_depot_hp-ux_11 （生成depot目錄）swinstall在彈出對話框?qū)懭雂epot目錄的完整路徑，安裝補丁。4 chmod +x unzip將unzip拷貝至/bin下。5 解壓縮otherpatch.zipunzip otherpatch.zip./create_depot_hp-ux_11 （生成depot目錄）swinstall在彈出對話框?qū)懭雂epot目錄的完整路徑，安裝補丁。6 swinstall s /完整路徑/sdk14_14210_ia.depot7 swinstall s /完整路徑/ssh_A.04.30.003.depot89三、 操作系統(tǒng)配置（所有節(jié)點）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)組與用戶/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用戶下：$xhost + hpux1$xhost + hpux2運行$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)自動激活共享卷組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 磁盤陣列柜配置磁盤陣列柜預(yù)先分配三個分區(qū)，大小分別為150MB/70MB/剩余，分別用于存儲OCR/Voting/Datafile。chmod 755 /dev/rdsk 檢索所有磁盤：/usr/sbin/ioscan -fun -C disk，獲取磁盤系統(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ī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 重新啟動，準(zhǔn)備安裝CRS四、 配置ssh1 以O(shè)racle用戶登錄2 在oracle用戶home目錄中創(chuàng)建.ssh目錄，在所有的節(jié)點執(zhí)行：$ mkdir /.ssh$ chmod 700 /.ssh$ /usr/bin/ssh-keygen -t rsa$ /usr/bin/ssh-keygen -t dsa3 生成authorized_keys；在所有的節(jié)點執(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é)點重復(fù)以上步驟4 在root下修改/opt/ssh/etc/sshd_config：StrictModes noX11Forwarding no使連接不需要密碼5 測試ssh配置是否成功$ exec /usr/bin/ssh-agent $SHELL$ /usr/bin/ssh-add在提示下，輸入每個通行口令然后執(zhí)行：ssh hpux1 datessh hpux2 date如果不需要輸入任何東東直接顯示時間，則配置成功。67五、 安裝CRS1 以O(shè)racle用戶登錄2 運行一下命令$ exec /usr/bin/ssh-agent $SHELL$ /usr/bin/ssh-add在提示下，輸入每個通行口令然后執(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ù)安裝檢查會提示警告如下：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 這是因為系統(tǒng)沒有安裝HP C Compiler所導(dǎo)致的，沒有關(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.#正常情況下會在Node1上彈出下圖如果提示上表中的黑體字，是因為，服務(wù)器默認(rèn)的網(wǎng)關(guān)沒有設(shè)置，以至安裝程序無法確認(rèn)lan0與lan1哪一個是Public interfaces。檢查兩個節(jié)點的網(wǎng)關(guān)設(shè)置，確認(rèn)無誤，在Node1節(jié)點root用戶下執(zhí)行$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 察看當(dāng)前服務(wù)器上的IP，檢查vip是否生效。5 Sdfs6六、 安裝數(shù)據(jù)庫軟件安裝語言加上”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 這是因為系統(tǒng)沒有安裝HP C Compiler所導(dǎo)致的，沒有關(guān)系（同安裝CRS）。Checking for maxswapchunks=16384; found no entry.Failed Checking for semmap=4098; found no entry.Failed 這兩個參數(shù)在HP-UX 11.23版本已經(jīng)棄用，可以忽略。繼續(xù)進行下一步。只安裝數(shù)據(jù)庫軟件（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.七、 創(chuàng)建數(shù)據(jù)庫修改$ORACLE_HOME/.dtprofile：刪除