RHEL54“加”Oracle10GRAC“加”裸設(shè)備安裝

1、RHEL5.4+Oracle 10G RAC+裸設(shè)備目錄 TOC o 1-6 h z u HYPERLINK l _Toc453075354 1 IP地址規(guī)劃 PAGEREF _Toc453075354 h 3 HYPERLINK l _Toc453075355 2共享磁盤(pán)存儲(chǔ)(裸設(shè)備)規(guī)劃 PAGEREF _Toc453075355 h 3 HYPERLINK l _Toc453075356 3實(shí)施操作步驟 PAGEREF _Toc453075356 h 4 HYPERLINK l _Toc453075357 3.1環(huán)境準(zhǔn)備及檢查 PAGEREF _Toc453075357 h 4 HYPE

2、RLINK l _Toc453075358 1創(chuàng)建虛擬主機(jī)，規(guī)劃IP PAGEREF _Toc453075358 h 4 HYPERLINK l _Toc453075359 2創(chuàng)建共享磁盤(pán) PAGEREF _Toc453075359 h 4 HYPERLINK l _Toc453075360 3.2系統(tǒng)及內(nèi)核參數(shù)配置 PAGEREF _Toc453075360 h 8 HYPERLINK l _Toc453075361 1各主機(jī)編輯文件 /etc/redhat-release(oracle不支持RHEL5版本) PAGEREF _Toc453075361 h 8 HYPERLINK l _To

3、c453075362 2各主機(jī)創(chuàng)建Oracle用戶組oinstall、dba ；用戶 oracle PAGEREF _Toc453075362 h 8 HYPERLINK l _Toc453075363 4各主機(jī)創(chuàng)建Oracle安裝lv以及軟件存放目錄 PAGEREF _Toc453075363 h 8 HYPERLINK l _Toc453075364 3各主機(jī)創(chuàng)建Oracle安裝目錄 PAGEREF _Toc453075364 h 8 HYPERLINK l _Toc453075365 5各主機(jī)編輯文件 /home/oracle/.bash_profile PAGEREF _Toc4530

4、75365 h 9 HYPERLINK l _Toc453075366 6各主機(jī)編輯文件 /etc/sysctl.conf PAGEREF _Toc453075366 h 9 HYPERLINK l _Toc453075367 7 各主機(jī)編輯文件 /etc/hosts PAGEREF _Toc453075367 h 10 HYPERLINK l _Toc453075368 8各主機(jī)編輯文件 /etc/security/limits.conf PAGEREF _Toc453075368 h 10 HYPERLINK l _Toc453075369 9各主機(jī)編輯文件 /etc/pam.d/logi

5、n PAGEREF _Toc453075369 h 11 HYPERLINK l _Toc453075370 10各主機(jī)編輯文件 /etc/rc.local PAGEREF _Toc453075370 h 11 HYPERLINK l _Toc453075371 11各主機(jī)登錄oracle用戶，配置Oracle SSH互信： PAGEREF _Toc453075371 h 11 HYPERLINK l _Toc453075372 12配置NTP（可選） PAGEREF _Toc453075372 h 12 HYPERLINK l _Toc453075373 13安裝、database需要的rp

6、m包 PAGEREF _Toc453075373 h 12 HYPERLINK l _Toc453075374 14創(chuàng)建LVM裸設(shè)備 PAGEREF _Toc453075374 h 14 HYPERLINK l _Toc453075375 15配置UDEV并且修改裸設(shè)備共享磁盤(pán)權(quán)限 PAGEREF _Toc453075375 h 15 HYPERLINK l _Toc453075376 16建立裸設(shè)備的軟鏈接。 PAGEREF _Toc453075376 h 17 HYPERLINK l _Toc453075377 17創(chuàng)建裸設(shè)備映射文件 PAGEREF _Toc453075377 h 18

7、HYPERLINK l _Toc453075378 18禁止IPTABLES與SELINUX PAGEREF _Toc453075378 h 19 HYPERLINK l _Toc453075379 3.3安裝Oracle10g_RAC PAGEREF _Toc453075379 h 19 HYPERLINK l _Toc453075380 1上傳安裝介質(zhì) PAGEREF _Toc453075380 h 19 HYPERLINK l _Toc453075381 2解壓三個(gè)安裝介質(zhì) PAGEREF _Toc453075381 h 20 HYPERLINK l _Toc453075382 3檢查安

8、裝環(huán)境 PAGEREF _Toc453075382 h 20 HYPERLINK l _Toc453075383 4安裝clusterware PAGEREF _Toc453075383 h 21 HYPERLINK l _Toc453075384 5安裝Oracle Database PAGEREF _Toc453075384 h 36 HYPERLINK l _Toc453075385 6升級(jí)clusterware PAGEREF _Toc453075385 h 42 HYPERLINK l _Toc453075386 7升級(jí)database PAGEREF _Toc453075386 h

9、 44 HYPERLINK l _Toc453075387 8 NETCA創(chuàng)建監(jiān)聽(tīng) PAGEREF _Toc453075387 h 46 HYPERLINK l _Toc453075388 9 DBCA建庫(kù) PAGEREF _Toc453075388 h 53 HYPERLINK l _Toc453075389 10使用裸設(shè)備創(chuàng)建Database PAGEREF _Toc453075389 h 57 HYPERLINK l _Toc453075390 11導(dǎo)出dmp數(shù)據(jù)庫(kù)文件 PAGEREF _Toc453075390 h 73 HYPERLINK l _Toc453075391 12導(dǎo)入dm

10、p數(shù)據(jù)庫(kù)文件 PAGEREF _Toc453075391 h 73 HYPERLINK l _Toc453075392 13開(kāi)啟數(shù)據(jù)庫(kù)歸檔模式 PAGEREF _Toc453075392 h 741 IP地址規(guī)劃IP規(guī)劃示例：主機(jī)名（不能大寫(xiě)）rac1rac2公共IP（eth0）1112私有IP（eth1）1112虛擬IP（eth0）1314ORACLE_SIDorcl1orcl2全局?jǐn)?shù)據(jù)庫(kù)名orcl2共享磁盤(pán)存儲(chǔ)(裸設(shè)備)規(guī)劃存儲(chǔ)磁盤(pán)規(guī)劃示例：(測(cè)試用)用途lv名裸設(shè)備名字大小存放集群注冊(cè)表ocr/dev/vgdata/orcl_ocr/dev/raw/raw1512M表決磁盤(pán)voting

11、disk/dev/vgdata/orcl_vdisk/dev/raw/raw2512Mspfile信息存放/dev/vgdata/rorcl_spfile/dev/raw/raw3128M控制文件/dev/vgdata/rorcl_ctl1/dev/raw/raw4128M控制文件/dev/vgdata/rorcl_ctl2/dev/raw/raw5128M控制文件/dev/vgdata/rorcl_ctl3/dev/raw/raw6128MSysaux表空間/dev/vgdata/rorcl_sysaux/dev/raw/raw71024MSystem表空間/dev/vgdata/rorcl

12、_system/dev/raw/raw81024M系統(tǒng)臨時(shí)表空間/dev/vgdata/rorcl_temp1/dev/raw/raw9128M撤銷(xiāo)表空間/dev/vgdata/rorcl_undo1/dev/raw/raw10512M撤銷(xiāo)表空間/dev/vgdata/rorcl_undo2/dev/raw/raw11512MUser表空間/dev/vgdata/rorcl_users/dev/raw/raw12128M重做日志文件/dev/vgdata/rorcl_redolog1/dev/raw/raw13512M重做日志文件/dev/vgdata/rorcl_redolog2/dev/r

13、aw/raw14512M重做日志文件/dev/vgdata/rorcl_redolog3/dev/raw/raw15512M重做日志文件/dev/vgdata/rorcl_redolog4/dev/raw/raw16512M用戶數(shù)據(jù)表空間/dev/vgdata/rorcl_data1/dev/raw/raw17128M用戶數(shù)據(jù)表空間/dev/vgdata/rorcl_data2/dev/raw/raw18128M用戶數(shù)據(jù)表空間/dev/vgdata/rorcl_data3/dev/raw/raw19128M用戶數(shù)據(jù)表空間/dev/vgdata/rorcl_data4/dev/raw/raw20

14、128M3實(shí)施操作步驟3.1環(huán)境準(zhǔn)備及檢查1創(chuàng)建虛擬主機(jī)，規(guī)劃IP請(qǐng)見(jiàn)IP規(guī)劃示例。要設(shè)定為靜態(tài)IP。主機(jī)名由字母加數(shù)字組成，不得有大寫(xiě)或其他特殊符號(hào)。2創(chuàng)建共享磁盤(pán)見(jiàn)存儲(chǔ)磁盤(pán)規(guī)劃示例。另外由于兩臺(tái)虛擬機(jī)如果不屬于同一臺(tái)物理服務(wù)器，共享磁盤(pán)要設(shè)置為物理，見(jiàn)下圖；共享磁盤(pán)模式應(yīng)為厚置備置零。磁盤(pán)總線應(yīng)該另外再用一條總線，如果原來(lái)用了SCSI0：X，則現(xiàn)在需要用SCSI1：1、SCSI1：2、SCSI1：3。共享磁盤(pán)只需在主機(jī)1建立，主機(jī)2在建磁盤(pán)時(shí)直接指向主機(jī)1的磁盤(pán)位置即可。主機(jī)1創(chuàng)建磁盤(pán)步驟如下主機(jī)2創(chuàng)建磁盤(pán)步驟如下3.2系統(tǒng)及內(nèi)核參數(shù)配置1各主機(jī)編輯文件 /etc/redhat-relea

15、se(oracle不支持RHEL5版本)修改為：Red Hat Enterprise Linux Server release 4 (Tikanga)2各主機(jī)創(chuàng)建Oracle用戶組oinstall、dba ；用戶 oraclegroupadd oinstall groupadd dbauseradd -g oinstall -G dba oracle passwd oracle /密碼設(shè)為 oracle4各主機(jī)創(chuàng)建Oracle安裝lv以及軟件存放目錄lvcreate -L 15G -n lvoracle /dev/vgrootmkfs.ext3 /dev/vgroot/lvoraclemkdi

16、r /oraclemount /dev/vgroot/lvoracle /oraclelvcreate -L 5G -n lvsoftware /dev/vgrootmkfs.ext3 /dev/vgroot/lvsoftwaremkdir /softwaremount /dev/vgroot/lvsoftware /softwarecat/etc/fstab/home/oracle/.bash_profile/home/oracle/.bash_profile/etc/sysctl.conf/etc/hosts/etc/security/limits.conf /etc/pam.d/logi

17、n /etc/rc.local /.ssh/authorized_keysssh rac1 cat /.ssh/id_dsa.pub /.ssh/authorized_keysssh rac2 cat /.ssh/id_rsa.pub /.ssh/authorized_keysssh rac2 cat /.ssh/id_dsa.pub /.ssh/authorized_keys節(jié)點(diǎn)2：ssh rac2 cat /.ssh/id_rsa.pub /.ssh/authorized_keysssh rac2 cat /.ssh/id_dsa.pub /.ssh/authorized_keysssh

18、rac1 cat /.ssh/id_rsa.pub /.ssh/authorized_keysssh rac1 cat /.ssh/id_dsa.pub /.ssh/authorized_keysPS：如果提示是否連接選擇yes，密碼輸入oracle用戶的密碼exec /usr/bin/ssh-agent $SHELL測(cè)試互信是否成功節(jié)點(diǎn)1ssh rac1 datessh rac2 datessh rac1-priv date （會(huì)提示輸入yes 或密碼）ssh rac2-priv date （會(huì)提示輸入yes 或密碼）節(jié)點(diǎn)2ssh rac1 datessh rac2 datessh rac1

19、-priv date （會(huì)提示輸入yes 或密碼）ssh rac2-priv date （會(huì)提示輸入yes 或密碼）（若不需輸入任何東西，時(shí)間又相差不大，則表示成功）SSH等價(jià)配置完成。12配置NTP（可選）rpm -qa |grep ntpchkconfig -level 2345 ntpd onservice ntpd startcat/etc/ntp.conf/etc/ntp/step-tickers/etc/yum.repos.d/rhel-debuginfo.repo/etc/udev/rules.d/60-raw.rules/etc/sysconfig/rawdevices/etc

20、/rc.d/rc.local orcl_raw.confEOFspfile=/dev/raw/raw3control1=/dev/raw/raw4control2=/dev/raw/raw5control3=/dev/raw/raw6sysaux=/dev/raw/raw7system=/dev/raw/raw8temp=/dev/raw/raw9undotbs1=/dev/raw/raw10undotbs2=/dev/raw/raw11users=/dev/raw/raw12redo1_1=/dev/raw/raw13redo1_2=/dev/raw/raw14redo2_1=/dev/ra

21、w/raw15redo2_2=/dev/raw/raw16EOF18禁止IPTABLES與SELINUXchkconfig iptables offchkconfig ip6tables offservice iptables stopservice ip6tables stop禁止SELINUXsetenforce 0sed -i s/SELINUX=.*/SELINUX=disabled/ /etc/selinux/config狀態(tài)如下為關(guān)閉#getenforcePermissive#cat /etc/selinux/config|grep SELINUXSELINUX=disabledS

22、ELINUX=disabledSELINUXTYPE= can take one of these two values:SELINUXTYPE=targeted rootlabtest1 #關(guān)閉selinux后，最好重啟主機(jī)。3.3安裝Oracle10g_RAC1上傳安裝介質(zhì)三個(gè)安裝介質(zhì)上傳到主機(jī)1的/software/目錄下10201_clusterware_linux_x86_64.cpio.gz / clusterware安裝包10201_database_linux_x86_64.cpio.gz / database安裝包p8202632_10205_Linux-x86-64.zip

23、 / 升級(jí)包并給oracle用戶賦予/software目錄權(quán)限：chown -R oracle:ointall /softwarechown -R oracle:ointall /software用oracle用戶登錄2解壓三個(gè)安裝介質(zhì)#gunzip 10201_clusterware_linux_x86_64.cpio.gz#cpio -idmv 10201_clusterware_linux_x86_64.cpio /得到clusterware文件#gunzip 10201_database_linux_x86_64.cpio.gz#cpio -idmv 10201_database_li

24、nux_x86_64.cpio /得到database文件#unzip p8202632_10205_Linux-x86-64.zi /得到Disk1文件#chown -R oracle:oinstall /software#chmod -R 755 / software3檢查安裝環(huán)境 執(zhí)行命令：$ /software/clusterware/cluvfy/runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verboseoraclerac1 cluvfy$ ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -

25、verbosePerforming pre-checks for cluster services setup Checking node reachability.Check: Node reachability from node rac1 Destination Node Reachable? rac2 yes rac1 yes Result: Node reachability check passed from node rac1.Checking user equivalence.Check: User equivalence for user oracle Node Name C

26、omment rac2 passed rac1 passed Result: User equivalence check passed for user oracle.Checking administrative privileges.Check: Existence of user oracle Node Name User Exists Comment rac2 yes passed rac1 yes passed Result: User existence check passed for oracle.Check: Existence of group oinstall Node

27、 Name Status Group ID rac2 exists 500 rac1 exists 500 Result: Group existence check passed for oinstall.Check: Membership of user oracle in group oinstall as Primary Node Name User Exists Group Exists User in Group Primary Comment rac2 yes yes yes yes passed rac1 yes yes yes yes passed Result: Membe

28、rship check for user oracle in group oinstall as Primary passed.Administrative privileges check passed.Checking node connectivity.Interface information for node rac2 Interface Name IP Address Subnet eth0 12 eth1 12 Interface information for node rac1 Interface Name IP Address Subnet eth0 11 eth1 11

29、Check: Node connectivity of subnet Source Destination Connected? rac2:eth0 rac1:eth0 yes Result: Node connectivity check passed for subnet with node(s) rac2,rac1.Check: Node connectivity of subnet Source Destination Connected? rac2:eth1 rac1:eth1 yes Result: Node connectivity check passed for subnet

30、 with node(s) rac2,rac1.Suitable interfaces for the private interconnect on subnet :rac2 eth0:12rac1 eth0:11Suitable interfaces for the private interconnect on subnet :rac2 eth1:12rac1 eth1:11ERROR: Could not find a suitable set of interfaces for VIPs.Result: Node connectivity check failed.Checking

31、system requirements for crs.No checks registered for this product.Pre-check for cluster services setup was unsuccessful on all the nodes.前面都是正確的話，就表示可以安裝。VIP報(bào)錯(cuò)不用理會(huì)。4安裝clusterware 打開(kāi)自己電腦上的Xmanager xstart，遠(yuǎn)程連接到主機(jī)查出本機(jī)的IP ： 再在終端輸入命令：(在/software/clusterware目錄下)$export DISPLAY=:0.0 $export LANG=en_US$ ./r

32、unInstaller -ignoreSysPreReqs后，彈出安裝界面：下一步：修改安裝路徑為crs ；下一步：環(huán)境檢測(cè)，全部通過(guò)；下一步：Add添加主機(jī)2的信息：下一步：編輯eth0 為public，下一步：填入OCR的裸設(shè)備/dev/raw/raw1，下一步：（注意：這里不能填 /devvgdata/rorcl_ocr，不能填鏈接，只能填實(shí)際的裸設(shè)備，創(chuàng)建鏈接只是方便自己查看裸設(shè)備的對(duì)應(yīng)關(guān)系）填入Voting的裸設(shè)備/dev/raw/raw2，下一步：點(diǎn)擊install 進(jìn)行安裝：等待彈出：這一步關(guān)鍵，需要用root用戶在兩臺(tái)主機(jī)執(zhí)行命令/oracle/oraInventory/ora

33、instRoot.sh/oracle/product/10.2.0/crs/root.sh執(zhí)行前先在各主機(jī)編輯文件：vi /oracle/product/10.2.0/crs/bin/vipca 添加 unset LD_ASSUME_KERNELvi /oracle/product/10.2.0/crs/bin/srvctl 添加添加 unset LD_ASSUME_KERNEL編輯好后，在主機(jī)1用root用戶執(zhí)行：#/oracle/oraInventory/orainstRoot.shrootrac1 lib# /oracle/oraInventory/orainstRoot.shChang

34、ing permissions of /oracle/oraInventory to 770.Changing groupname of /oracle/oraInventory to oinstall.The execution of the script is complete在主機(jī)2用root用戶執(zhí)行：#/oracle/oraInventory/orainstRoot.shrootrac2 Server# /oracle/oraInventory/orainstRoot.shChanging permissions of /oracle/oraInventory to 770.Chang

35、ing groupname of /oracle/oraInventory to oinstall.The execution of the script is complete在主機(jī)1用root用戶執(zhí)行：#/oracle/product/10.2.0/crs/root.shrootrac1 lib# /oracle/product/10.2.0/crs/root.shWARNING: directory /oracle/product/10.2.0 is not owned by rootWARNING: directory /oracle/product is not owned by r

36、ootWARNING: directory /oracle is not owned by rootChecking to see if Oracle CRS stack is already configured/etc/oracle does not exist. Creating it now.Setting the permissions on OCR backup directorySetting up NS directoriesOracle Cluster Registry configuration upgraded successfullyWARNING: directory

37、 /oracle/product/10.2.0 is not owned by rootWARNING: directory /oracle/product is not owned by rootWARNING: directory /oracle is not owned by rootSuccessfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: rac1 rac1-priv rac1node 2: rac2 rac2

38、-priv rac2Creating OCR keys for user root, privgrp root.Operation successful.Now formatting voting device: /dev/raw/raw2Format of 1 voting devices complete.Startup will be queued to init within 90 seconds.Adding daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active on

39、 these nodes. rac1CSS is inactive on these nodes. rac2Local node checking complete.Run root.sh on remaining nodes to start CRS daemons.表示成功；在主機(jī)2用root用戶執(zhí)行：#/oracle/product/10.2.0/crs/root.shrootrac2 Server# /oracle/product/10.2.0/crs/root.shWARNING: directory /oracle/product/10.2.0 is not owned by ro

40、otWARNING: directory /oracle/product is not owned by rootWARNING: directory /oracle is not owned by rootChecking to see if Oracle CRS stack is already configured/etc/oracle does not exist. Creating it now.Setting the permissions on OCR backup directorySetting up NS directoriesOracle Cluster Registry

41、 configuration upgraded successfullyWARNING: directory /oracle/product/10.2.0 is not owned by rootWARNING: directory /oracle/product is not owned by rootWARNING: directory /oracle is not owned by rootclscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Successfully ac

42、cumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 1: rac1 rac1-priv rac1node 2: rac2 rac2-priv rac2clscfg: Arguments check out successfully.NO KEYS WERE WRITTEN. Supply -force parameter to override.-force is destructive and will destroy any previous

43、clusterconfiguration.Oracle Cluster Registry for cluster has already been initializedStartup will be queued to init within 90 seconds.Adding daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active on these nodes. rac1 rac2CSS is active on all nodes.Waiting for the Oracl

44、e CRSD and EVMD to startWaiting for the Oracle CRSD and EVMD to startOracle CRS stack installed and running under init(1M)Running vipca(silent) for configuring nodeappsError 0(Native: listNetInterfaces:3) Error 0(Native: listNetInterfaces:3)如果只有主機(jī)2報(bào)錯(cuò)，則往下執(zhí)行，跳到（到這一步報(bào)錯(cuò)誤，針對(duì)這個(gè)錯(cuò)誤，解決方案：手動(dòng)配置vip）如果在兩臺(tái)主機(jī)執(zhí)行都報(bào)錯(cuò)

45、，則運(yùn)行以下命令行從新執(zhí)行root.sh這個(gè)命令start_udevrm -rf ls /etc/oraclrm -rf /etc/oracle/scls_scr/rac1/oracle/cssfatalrm -rf /etc/oracle/scls_scr/rac2/oracle/cssfatal/oracle/product/10.2.0/crs/bin/clsfmt.bin ocr /dev/raw/raw1dd if=/dev/zero of=/dev/raw/raw1 bs=1M count=524dd if=/dev/zero of=/dev/raw/raw2 bs=1M coun

46、t=629到這一步報(bào)錯(cuò)誤，針對(duì)這個(gè)錯(cuò)誤，解決方案：手動(dòng)配置vip在主機(jī)1到/oracle/product/10.2.0/crs/bin目錄下，執(zhí)行命令cd /oracle/product/10.2.0/crs/bin./oifcfg iflisteth0 28eth1 #./oifcfg setif -global eth0/:public#./oifcfg setif -global eth1/:cluster_interconnect#./oifcfg getifeth0 28 global publiceth1 global cluster_interconnect在主機(jī)2運(yùn)行命令查看是

47、否有同樣的輸出結(jié)果#./oifcfg getifeth0 28 global publiceth1 global cluster_interconnect在主機(jī)1手動(dòng)運(yùn)行vipca#export DISPLAY=:0.0 #export LANG=en_US到/oracle/product/10.2.0/crs/bin目錄下#./vipca 彈出窗口：下一步：下一步：只需填入：rac1-vip ；其他三個(gè)空自動(dòng)填入；下一步：點(diǎn)擊完成：結(jié)束后，回到此界面：點(diǎn)擊OK后：檢查安裝看到這，已經(jīng)成功安裝好了clusterware！通過(guò)命令： crs_stat -t 查看，如下：oraclerac1 $

48、crs_stat -tName Type Target State Host ora.rac1.gsd application ONLINE ONLINE rac1 ora.rac1.ons application ONLINE ONLINE rac1 ora.rac1.vip application ONLINE ONLINE rac1 ora.rac2.gsd application ONLINE ONLINE rac2 ora.rac2.ons application ONLINE ONLINE rac2 ora.rac2.vip application ONLINE ONLINE ra

49、c2 5安裝Oracle Database用oracle用戶進(jìn)入/software/ database；運(yùn)行： ./ runInstaller ，彈出界面：下一步：默認(rèn)，下一步：默認(rèn)，下一步：勾上rac2，下一步：檢查通過(guò)，下一步：選擇第三項(xiàng)，不建數(shù)據(jù)庫(kù)，下一步：點(diǎn)擊安裝：在主機(jī)1上執(zhí)行：rootrac1 install# cd .rootrac1 Disk1# cd /oracle/product/10.2.0/db/rootrac1 db# ./root.shRunning Oracle10 root.sh script.The following environment variable

50、s are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/product/10.2.0/dbEnter 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

51、 /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.rootrac1 db#在主機(jī)2上執(zhí)行：rootrac2 bin# /oracle/product/10.2.0/db/root.shRunning Oracle10 root.sh script.The followin

52、g environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /oracle/product/10.2.0/dbEnter 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.Entrie

53、s 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.rootrac2 bin# rootrac2 bin#回到安裝界面點(diǎn)擊OK：點(diǎn)擊結(jié)束；Database安裝完畢！6升級(jí)clusterware在主機(jī)1用oracle用戶執(zhí)行命令：$

54、 crs_stop -all /停止集群進(jìn)入/software/Disk1，運(yùn)行：$ ./ runInstaller，需要注意的是clusterware和database的升級(jí)包都是這一個(gè)，升級(jí)clusterware和database都是運(yùn)行這個(gè)runInstaller文件，不同的是在 Specify Home Details這一頁(yè)面的時(shí)候需要選擇Name 這一行的選框里面的內(nèi)容來(lái)卻分是升級(jí)clusterware還是database。需要先升級(jí)clusterware再升級(jí)database。選擇crs的目錄，下一步：下一步：檢查通過(guò)，下一步：點(diǎn)擊安裝：用root用戶在各主機(jī)執(zhí)行a、b 命令：主機(jī)

55、1：#/oracle/product/10.2.0/crs/bin/crsctl stop crs/oracle/product/10.2.0/crs/install/root102.sh主機(jī)2：/oracle/product/10.2.0/crs/bin/crsctl stop crs/oracle/product/10.2.0/crs/install/root102.sh看到這，表示都很成功；接著回到升級(jí)界面，結(jié)束升級(jí)：用命令：$ crsctl query crs softwareversion 查看已經(jīng)升級(jí)到.0；并查看集群狀態(tài)，已經(jīng)正常；升級(jí)沒(méi)有問(wèn)題。7升級(jí)database用oracl

56、e用戶進(jìn)入/software/Disk1，再次運(yùn)行：$ ./ runInstaller點(diǎn)擊name選項(xiàng)后面的下三角，選擇OraDb10g_home1下一步：去掉勾，下一步：下一步：檢測(cè)通過(guò)，下一步：點(diǎn)擊安裝：各主機(jī)用root用戶執(zhí)行命令：主機(jī)1：主機(jī)2：回到升級(jí)界面，點(diǎn)擊OK，出現(xiàn)：點(diǎn)擊結(jié)束，Database升級(jí)完畢！8 NETCA創(chuàng)建監(jiān)聽(tīng)#su - oracleexport DISPLAY=:0.0export LANG=en_USnetca 核對(duì)兩臺(tái)主機(jī)的以下配置文件，（本次發(fā)行主機(jī)2 (ADDRESS = (PROTOCOL = TCP)(HOST = 12)(PORT = 1521)(

57、IP = FIRST)中HOST變成主機(jī)的物理IP，導(dǎo)致lsnrctl status查看監(jiān)聽(tīng)不正確，后來(lái)根據(jù)主機(jī)1的配置改為后重啟監(jiān)聽(tīng)正常）listener.ora tnsnames.ora # listener.ora.rac1 Network Configuration File: /oracle/product/10.2.0/db/network/admin/listener.ora.rac1# Generated by Oracle configuration tools.LISTENER_RAC1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRE

58、SS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)(IP = FIRST) (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)(IP = FIRST) ) )SID_LIST_LISTENER_RAC1 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/product/10.2.0/db) (PROGRAM = extproc) ) )oraclerac1 admin$oraclerac2 admin

59、$ more listener.ora # listener.ora.rac2 Network Configuration File: /oracle/product/10.2.0/db/network/admin/listener.ora.rac2# Generated by Oracle configuration tools.LISTENER_RAC2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)(IP = FIRST) (ADDRESS = (

60、PROTOCOL = TCP)(HOST = )(PORT = 1521)(IP = FIRST) ) )SID_LIST_LISTENER_RAC2 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /oracle/product/10.2.0/db) (PROGRAM = extproc) ) )oraclerac2 admin$oraclerac1 admin$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /oracle/produc