【文章內(nèi)容簡(jiǎn)介】 SM library driver configuration: doneInitializing the Oracle ASMLib driver: [ OK ]Scanning the system for Oracle ASMLib disks: [ OK ]接下來(lái)告訴 ASMLib 驅(qū)動(dòng)程序要使用哪些磁盤。注意，這些磁盤是不包含任何內(nèi)容。命令格式：/etc/這里只在其中一個(gè)節(jié)點(diǎn)中配置即可，另外一個(gè)基點(diǎn)能夠自動(dòng)檢測(cè)到配置[root@rac1 ~] /etc/Marking disk VOL1 as an ASM disk: [ OK ][root@rac1 ~] /etc/Marking disk VOL2 as an ASM disk: [ OK ][root@rac1 ~] /etc/Marking disk VOL3 as an ASM disk: [ OK ][root@rac1 ~] /etc/Writing Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: [ OK ]Scanning the system for Oracle ASMLib disks: [ OK ][root@rac2 ~] /etc/Writing Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: [ OK ]Scanning the system for Oracle ASMLib disks: [ OK ]在兩個(gè)節(jié)點(diǎn)上掃描ASM磁盤[root@rac1 ~] /etc/VOL1VOL2VOL3[root@rac2 ~] /etc/VOL1VOL2VOL3二 、安裝oracle cluster安裝依賴包安裝oracle集群所需要的軟件包，兩個(gè)節(jié)點(diǎn)都要安裝。Rpm –qa |grep patpatgcc32c++patlibstdc++patlibstdc++openmotifgccc++libstdc++libstdc++devel修改內(nèi)核參數(shù)修改linux內(nèi)核參數(shù)，兩個(gè)節(jié)點(diǎn)都要修改[root@rac1 ~] cat /etc/ EOF = 2097152 = 2147483648 = 4096 = 250 32000 100 128 = 65536 = 1024 65000 = 262144 = 262144 = 262144 = 262144 EOF使之立即生效[root@rac1 ~] sysctl –p修改系統(tǒng)版本在安裝的時(shí)候如果linux的版本較高的話，會(huì)報(bào)錯(cuò)，所以手動(dòng)修改linux版本，將原有的注銷或者刪除。[root@rac1 ~] more /etc/redhatrelease Red Hat Enterprise Linux AS release 3 (Taroon)添加用戶限制為 oracle 用戶設(shè)置 Shell 限制（兩個(gè)節(jié)點(diǎn)都要修改）Oracle 建議對(duì)每個(gè) Linux 帳戶可以使用的進(jìn)程數(shù)和打開(kāi)的文件數(shù)設(shè)置限制。要進(jìn)行這些更改，以 root 用戶的身份執(zhí)行下列命令：[root@rac1 ~]cat /etc/security/ EOForacle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536EOF進(jìn)oracle下查看用戶資源[oracle@rac1 ~]$ ulimit acore file size (blocks, c) 0data seg size (kbytes, d) unlimitedscheduling priority (e) 0file size (blocks, f) unlimitedpending signals (i) 4096max locked memory (kbytes, l) 32max memory size (kbytes, m) unlimitedopen files (n) 1024pipe size (512 bytes, p) 8POSIX message queues (bytes, q) 819200realtime priority (r) 0stack size (kbytes, s) 10240cpu time (seconds, t) unlimitedmax user processes (u) 2047virtual memory (kbytes, v) unlimitedfile locks (x) unlimited安全設(shè)置[root@rac1 ~] cat /etc/EOF session required /lib/security/ EOF配置hangcheck計(jì)時(shí)器這是linux提供的一個(gè)內(nèi)核級(jí)IOFencing模塊。這個(gè)模塊會(huì)監(jiān)控linux 內(nèi)核運(yùn)行的狀態(tài)。如果linux長(zhǎng)時(shí)間掛起，這個(gè)內(nèi)核會(huì)自動(dòng)的重啟系統(tǒng)。這個(gè)模塊在內(nèi)核空間運(yùn)行，不受負(fù)載的影響。 配置這個(gè)模塊需要兩個(gè)參數(shù)： hangcheck_tick：多長(zhǎng)時(shí)間檢查一次，缺省是30秒 hangcheck_margin：延遲上限，缺省是180秒 hangchecktime模塊會(huì)根據(jù)hangcheck_tick的設(shè)置，定時(shí)檢查內(nèi)核，只要兩次檢查的時(shí)間間隔小于hangcheck_tick+hangcheck_margin，都會(huì)認(rèn)為內(nèi)核是運(yùn)行正常，否則認(rèn)為系統(tǒng)異常，該模塊會(huì)自動(dòng)重啟系統(tǒng)。 CRS本身還有一個(gè)參數(shù)：MissCount參數(shù)。上面的三個(gè)參數(shù)影響RAC的重構(gòu)，假設(shè)節(jié)點(diǎn)間心跳信息丟失，Clusterware必須確保在進(jìn)行重構(gòu)時(shí)，故障節(jié)點(diǎn)確實(shí)是dead狀態(tài)。 嚴(yán)重問(wèn)題：節(jié)點(diǎn)臨時(shí)負(fù)載過(guò)高導(dǎo)致心跳丟失，然后其他節(jié)點(diǎn)開(kāi)始重構(gòu)，但是節(jié)點(diǎn)卻沒(méi)有重啟（沒(méi)有dead），這就會(huì)損壞數(shù)據(jù)庫(kù)。 因此要保證MissCount必須大于hangcheck_tick+hangcheck_margin的和。這樣可以保證節(jié)點(diǎn)開(kāi)始重構(gòu)時(shí)，其他節(jié)點(diǎn)已經(jīng)被hangchecktimer模塊重啟。配置 Hangcheck 計(jì)時(shí)器，兩個(gè)節(jié)點(diǎn)都要做。[root@rac1 ~] modprobe hangchecktimer hangcheck_tick=30 hangcheck_margin=180[root@rac1 ~] cat /etc/EOFmodprobe hangchecktimer hangcheck_tick=30 hangcheck_margin=180EOF添加環(huán)境變量Oracle軟件環(huán)境配置創(chuàng)建安裝目錄,兩個(gè)節(jié)點(diǎn)都要?jiǎng)?chuàng)建。mkdir p /oracle/app/oracle/10g/crs_1mkdir p /oracle/app/oracle/10g/db_1chown R oracle:oinstall /oracle/app/oracle/10g/crs_1 chown R oracle:oinstall /oracle/app/oracle/10g/db_1chmod R 775 /oracle/app/oracle/10g/crs_1 chmod R 775 /oracle/app/oracle/10g/db_1oracle 用戶的環(huán)境變量在oracle用戶下，編輯/home/oracle/.bash_profile添加如下內(nèi)容：在rac1機(jī)器上修改export ORACLE_SID=oradb1export ORACLE_BASE= /oracle/app/oracle/10gexport CRS_HOME=$ORACLE_BASE/product/db_1export ORACLE_HOME= /oracle/app/oracle/10g/crs_1export LD_LIBRARY_PATH= /oracle/app/oracle/10g/db_1/lib:/lib:/usr/lib:/usr/local/lib:/usr/X11R6/libexport TNS_ADMIN= /oracle/app/oracle/10g/db_1/network/adminexport ORA_NLS33= /oracle/app/oracle/10g/db_1/omon/nls/admin/dataexport ORACLE_OWNER=oracleexport PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/oracle/app/oracle/10g/db_1/bin:/oracle/app/oracle/10g/crs_1/binexport LD_LIBRARY_PATHexport PATH=$PATH:$ORACLE_HOME/binCLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibCLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexport PATH CLASSPATH在rac2上修改export ORACLE_SID=oradb2export ORACLE_BASE=/oracle/app/oracle/10gexport CRS_HOME=$ORACLE_BASE/product/db_1export ORACLE_HOME=/oracle/app/oracle/10g/crs_1export LD_LIBRARY_PATH=/oracle/app/oracle/10g/db_1/lib:/lib:/usr/lib:/usr/local/lib:/usr/X11R6/libexport TNS_ADMIN=/oracle/app/oracle/10g/db_1/network/adminexport ORA_NLS33=/oracle/app/oracle/10g/db_1/omon/nls/admin/dataexport ORACLE_OWNER=oracleexport PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/oracle/app/oracle/10g/db_1/bin:/oracle/app/oracle/10g/crs_1/binexport LD_LIBRARY_PATHexport PATH=$PATH:$ORACLE_HOME/binCLASSPATH=$CLASSPATH:$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibCLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlibexport PATH CLASSPATH安裝ntp服務(wù)器為了保證兩個(gè)節(jié)點(diǎn)的時(shí)間保持一致，因此配置ntp作為時(shí)間服務(wù)器[root@rac1 ~] mv /etc/ /etc/[root@rac1 ~] vi /etc/server local clockfudge stratum 10driftfile /var/lib/ntp/driftbroadcastdelay [root@rac1 ~] /etc/Starting ntpd: [ OK ]在另外一個(gè)節(jié)點(diǎn)指定接收rac1節(jié)點(diǎn)為時(shí)間服務(wù)器修改hosts文件在節(jié)點(diǎn)一上[root@rac1 ~] vi /etc/hosts rac1 rac1vip rac1priv rac2 rac2vip rac2priv在節(jié)點(diǎn)2上[root@rac2 ~] vi /etc/hosts rac2 rac2vip rac2priv rac1 rac1vip rac1priv建立用戶等效性在安裝 Ora