【導(dǎo)讀】、主機(jī)操作系統(tǒng)必備的RPM程序包 4. 、數(shù)據(jù)庫(kù)節(jié)點(diǎn)規(guī)劃 5. 、網(wǎng)絡(luò)及存儲(chǔ)配置 6. 、編輯內(nèi)核參數(shù) 7. 、為Oracle用戶設(shè)置資源限制 8. 、在共享磁盤上創(chuàng)建分區(qū) 11. 、配置authorized_keys文件權(quán)限 15. 、驗(yàn)證SSH用戶等效性 15. 、編輯$ORA_CRS_HOME/bin下的vipca和srvctl文件 26. 、完成clusterware的安裝 34. 、portaldb1和portaldb2上執(zhí)行相關(guān)步驟 48. 、portaldb和portaldb2備份OCR和Votingdisk 50. 、安裝dbsoftware升級(jí)包 51. 、runInstaller中查看已安裝好的產(chǎn)品 61. 、確認(rèn)監(jiān)聽(tīng)配置成功 67. 、wpsdb數(shù)據(jù)庫(kù)設(shè)置歸檔位置 105. 在X86架構(gòu)上，Oracle10gRAC能被下列操作系統(tǒng)所支持：

　　

【正文】 env 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 script.Now productspecific root actions will be performed.portaldb1:/u01/app/oracle/product/portaldb1:/u01/app/oracle/product/portaldb2:/u01/app/oracle/product/portaldb2:/u01/app/oracle/product/Running Oracle10 script...The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/Enter 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 script.Now productspecific root actions will be performed.portaldb2:/u01/app/oracle/product/1腳本執(zhí)行完后，點(diǎn)擊“OK”，完成安裝。八、安裝Oracle clusterware 、安裝clusterware升級(jí)包以oracle用戶登錄到主節(jié)點(diǎn)portaldb1的圖形界面，打開(kāi)升級(jí)包目錄“Disk1”。直接執(zhí)行“./runInstaller”。升級(jí)包中的[Certified Versions]已經(jīng)包含了SuSE10，所以不用像安裝clusterware和db那樣要做額外操作。 從“Deinstall Products”中可以看到已安裝的軟件在“Specify Home Details”界面中指定Name和Path顯示的節(jié)點(diǎn)中包含了“portaldb1”和“portaldb2”顯示的“wanring”標(biāo)識(shí)目前的SWAP SPACE未達(dá)到要求，其余均為“Succeeded”。點(diǎn)擊“Yes”執(zhí)行安裝。安裝完成后，需要在portaldb1和portaldb2上執(zhí)行下列三步、portaldb1和portaldb2上執(zhí)行相關(guān)步驟 以root用戶登錄portaldb1執(zhí)行./crsctl stop 以root用戶登錄portaldb1執(zhí)行./crsctl stop 、portaldb和portaldb2備份OCR和Voting diskportaldb1:~ dd if=/dev/raw/raw2 of=/tmp/2047968+0 records in2047968+0 records out1048559616 bytes ( GB) copied, seconds, MB/sportaldb1:/u01/app/oracle/product/portaldb2:~ dd if=/dev/raw/raw2 of=/tmp/2047968+0 records in2047968+0 records out1048559616 bytes ( GB) copied, seconds, MB/sPortaldb2:/u01/app/oracle/product/九、安裝Oracle database Software 、安裝db software升級(jí)包以oracle用戶登錄到主節(jié)點(diǎn)portaldb1的圖形界面，打開(kāi)升級(jí)包目錄“Disk1”。直接執(zhí)行“./runInstaller”。升級(jí)包中的[Certified Versions]已經(jīng)包含了SuSE10，所以不用像安裝clusterware和db那樣要做額外操作。 點(diǎn)擊“Next”執(zhí)行安裝從“Deinstall Products”“Name”選擇“ORACLE_HOME”不填入郵箱地址，點(diǎn)擊“Yes”，繼續(xù)安裝。顯示的節(jié)點(diǎn)中包含了“portaldb1”和“portaldb2”顯示的“wanring”標(biāo)識(shí)目前的SWAP SPACE未達(dá)到要求，其余均為“Succeeded”。點(diǎn)擊“Yes”執(zhí)行安裝。1在portaldb1和portaldb2上，$ORACLE_HOME目錄中分別執(zhí)行 portaldb1:/u01/app/oracle/product/Running Oracle 10g script...The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/Enter the full pathname of the local bin directory: [/usr/local/bin]: The file dbhome already exists in /usr/local/bin. Overwrite it? (y/n) [n]: The file oraenv already exists in /usr/local/bin. Overwrite it? (y/n) [n]: The file coraenv already exists in /usr/local/bin. Overwrite it? (y/n) [n]: Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of script.Now productspecific root actions will be performed.Portaldb1:/u01/app/oracle/product/portaldb2:/u01/app/oracle/product/Running Oracle 10g script...The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/Enter the full pathname of the local bin directory: [/usr/local/bin]: The file dbhome already exists in /usr/local/bin. Overwrite it? (y/n) [n]: The file oraenv already exists in /usr/local/bin. Overwrite it? (y/n) [n]: The file coraenv already exists in /usr/local/bin. Overwrite it? (y/n) [n]: Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of script.Now productspecific root actions will be performed.portaldb2:/u01/app/oracle/product/1執(zhí)行完上述兩個(gè)腳本后，點(diǎn)擊“OK”，完成升級(jí)工作。、安裝補(bǔ)丁Patch 8350262 Oracle ，會(huì)導(dǎo)致企業(yè)管理器配置不成功，但數(shù)據(jù)庫(kù)能夠正常使用。具體表現(xiàn)如下圖所示：（從上圖可知，portaldb已經(jīng)創(chuàng)建完畢，但企業(yè)管理器的URL無(wú)法顯示，需安裝Patch 8350262來(lái)解決。）一、將Patch 8350262上傳到portaldb1和portaldb2兩節(jié)點(diǎn)的$ORACLE_HOME/OPatch目錄下。：。解壓該補(bǔ)丁，會(huì)生成一個(gè)名為8350262的目錄。二、修改portaldb1和portaldb2兩節(jié)點(diǎn)上Oracle用戶的環(huán)境變量。在PATH變量中加入“/u01/app/oracle/product/”。這么做的目的是使用opatch命令安裝補(bǔ)丁。三、在portaldb1上以oracle用戶登錄,在$ORACLE_HOME/OPatch/8350262目錄下安裝補(bǔ)丁。執(zhí)行opatch apply命令安裝補(bǔ)丁，詳情見(jiàn)截圖oracle@portaldb1:/u01/app/oracle/product/opatch apply四、在portaldb2上以oracle用戶登錄在$ORACLE_HOME/OPatch/8350262目錄下安裝補(bǔ)丁。執(zhí)行opatch apply命令安裝補(bǔ)丁，詳情見(jiàn)截圖oracle@portaldb2:/u01/app/oracle/product/opatch apply、runInstaller中查看已安裝好的產(chǎn)品回到Disk1目錄下，執(zhí)行./runInstaller可以看到已經(jīng)安裝好的產(chǎn)品包括Oracle Clusterware Oracle Database 10g Release 2 Patch Set 4 Oracle Database Oracle Database 10g Release 2 Patch Set 4 Interim patches Interim Patch 8350262十、配置監(jiān)聽(tīng)程序、配置監(jiān)聽(tīng)程序 以oracle用戶登錄到主節(jié)點(diǎn)portaldb1的圖形界面，進(jìn)入$ORACLE_HOME/bin目錄，執(zhí)行./netca，在彈出的對(duì)話框中進(jìn)行如下操作：選中“Cluster configuration”配置集群監(jiān)聽(tīng)點(diǎn)擊“Select all nodes”選中“portaldb1”和“portaldb2”選中“Listener configuration”，配置監(jiān)聽(tīng)。點(diǎn)擊“Next”繼續(xù)。使用默認(rèn)值“Add”，點(diǎn)擊“Next”，繼續(xù)。使用默認(rèn)值“LISTENER”，點(diǎn)擊“Next”，繼續(xù)。使用默認(rèn)值，點(diǎn)擊“Next”，繼續(xù)。使用默認(rèn)值，點(diǎn)擊“Next”，繼續(xù)。選中“No”，點(diǎn)擊“Next”，繼續(xù)。監(jiān)聽(tīng)配置完畢，點(diǎn)擊“Next”，完成。、確認(rèn)監(jiān)聽(tīng)配置成功oracle@portaldb1:/u01/app/oracle/product/ crs_stat t vName Type R/RA F/FT Target State Host ora.... application 0/5 0/0 ONLINE ONLINE portaldb1ora.... application 0/5 0/0 ONLINE ONLINE portaldb2ora.... application 0/5 0/0 ONLINE ONLINE portaldb1ora.... application 0/3 0/0 ONLINE ONLINE portaldb1ora.... application 0/0 0/0 ONLINE ONLINE portaldb1ora.... application 0/5 0/0 ONLINE ONLINE portaldb2