這篇文章給大家分享的是有關(guān)Oracle RAC之環(huán)境準(zhǔn)備的示例分析的內(nèi)容。小編覺得挺實用的，因此分享給大家做個參考，一起跟隨小編過來看看吧。
本次安裝選擇VMmare Workstation 10.0.1 ，創(chuàng)建四臺虛擬機(jī)。如下：
Openfiler （openfileresa-2.99.1-x86_64）
| 機(jī)器名 | IP地址 | ||
| openfiler.localdomain.com | 192.168.199.219 | ||
RAC節(jié)點 （OracleLinux-R6-U4-Server-x86_64）
| 機(jī)器名 | Public-IP | Private-IP | VIP | |||
| 11grac1 | 192.168.199.10 | 192.168.10.10 | 192.168.199.20 | |||
| 11grac2 | 192.168.199.11 | 192.168.10.11 | 192.168.199.21 | |||
| 11grac3 | 192.168.199.12 | 192.168.10.12 | 192.168.199.22 | |||
三臺機(jī)器都配置/etc/hosts，內(nèi)容如下
2.三臺機(jī)器都關(guān)閉防火墻
chkconfig iptables off service iptables stop3.關(guān)閉SeLinux
vi /etc/sysconfig/selinux SELINUX=enforcing 改為 SELINUX=disabled4.配置DNS服務(wù)器（在11grac3服務(wù)器上）
4.1 安裝rpm包
[root@localhost Packages]# rpm -ivh bind-9.8.2-0.17.rc1.0.2.el6.x86_64.rpm warning: bind-9.8.2-0.17.rc1.0.2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY Preparing... ########################################### [100%] 1:bind ########################################### [100%]4.2 編輯/etc/named.conf,替換成如下內(nèi)容
options { directory "/var/named"; }; zone "." IN { type hint; file "named.ca"; }; zone "localhost" IN { type master; file "named.loopback"; }; zone "0.0.127.in-addr.apra" IN { type master; file "named.localhost"; }; zone "localdomain.com" IN { type master; file "localdomain.com.zone"; };4.3 在/var/named/目錄下，新建localdomain.com.zone文件，內(nèi)容如下
$TTL 1D $ORIGIN localdomain.com. @ IN SOA ns.localdomain.com. admin ( 0 ; serial 1D ; refresh 1H ; retry 1W ; expire 3H ) ; minimum IN NS ns ns IN A 172.168.199.12 11grac3 IN A 192.168.199.12 11grac1 IN A 192.168.199.10 11grac2 IN A 192.168.199.11 scan-cluster IN A 192.168.199.304.4 啟動DNS服務(wù)器
[root@11grac3 etc]# chkconfig named on [root@localhost named]# service named restart Stopping named: [ OK ] Starting named: [ OK ]如果發(fā)生了錯誤，嘗試執(zhí)行如下命令試試
[root@localhost named]# rndc-confgen -r /dev/urandom -a wrote key file "/etc/rndc.key"4.5 修改各服務(wù)器dns指向
[root@localhost named]# vi /etc/resolv.conf添加如下內(nèi)容
search localdomain.com nameserver 192.168.199.12注意：這樣設(shè)置完DNS后，網(wǎng)絡(luò)重啟后就失效啦。使用如下方法
vi /etc/sysconfig/network-scripts/ifcfg-eth0 #添加如下兩行 DNS1=192.168.199.12 DOMAIN=localdomain.com重啟網(wǎng)絡(luò)，/etc/resolv.conf中將自動完成DNS的設(shè)置。
4.6 驗證dns
[root@localhost named]# nslookup 11grac1 Server: 192.168.199.12 Address: 192.168.199.12#53 Name: 11grac1.localdomain.com Address: 192.168.199.10 [root@localhost named]# nslookup 11grac2 Server: 192.168.199.12 Address: 192.168.199.12#53 Name: 11grac2.localdomain.com Address: 192.168.199.11 [root@localhost named]# nslookup 11grac3 Server: 192.168.199.12 Address: 192.168.199.12#53 Name: 11grac3.localdomain.com Address: 192.168.199.12 [root@localhost named]# nslookup scan-cluster Server: 192.168.199.12 Address: 192.168.199.12#53 Name: scan-cluster.localdomain.com Address: 192.168.199.305. 建立用戶、建立目錄、修改參數(shù)文件等 （腳本見附件）
[root@localhost scripts]# ./1preusers.sh [root@localhost scripts]# ./2predir.sh [root@localhost scripts]# ./3prelimits.sh [root@localhost scripts]# ./4prelogin.sh [root@localhost scripts]# ./5preprofile.sh [root@localhost scripts]# ./6presysctl.sh6. 建立grid、oracle用戶的無密碼登錄
6.1 在三臺機(jī)器上都執(zhí)行如下命令
[root@11grac1 scripts]# su - oracle 11grac1-> ssh-keygen -t rsa #后面都直接回車 Generating public/private rsa key pair. Enter file in which to save the key (/home/oracle/.ssh/id_rsa): Created directory '/home/oracle/.ssh'. Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /home/oracle/.ssh/id_rsa. Your public key has been saved in /home/oracle/.ssh/id_rsa.pub. The key fingerprint is: 31:43:2d:7e:30:bb:c9:d9:d9:8a:01:a2:51:bc:8b:2d oracle@11grac1.localdomain.com The key's randomart p_w_picpath is: +--[ RSA 2048]----+ | . .. | | o .+ . | | . . .+= | | . o . o+. | | = o oS* o | | E o * o . | | . o . | | . . | | | +-----------------+6.2 在三臺機(jī)器上執(zhí)行如下命令
11grac1-> ssh-copy-id -i .ssh/id_rsa.pub 11grac1 The authenticity of host '11grac1 (192.168.199.10)' can't be established. RSA key fingerprint is cc:d0:c3:de:37:33:a7:cb:91:40:c5:5f:18:07:06:9f. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '11grac1,192.168.199.10' (RSA) to the list of known hosts. oracle@11grac1's password: Now try logging into the machine, with "ssh '11grac1'", and check in: .ssh/authorized_keys to make sure we haven't added extra keys that you weren't expecting. 11grac2-> ssh-copy-id -i .ssh/id_rsa.pub 11grac1 The authenticity of host '11grac1 (192.168.199.10)' can't be established. RSA key fingerprint is cc:d0:c3:de:37:33:a7:cb:91:40:c5:5f:18:07:06:9f. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '11grac1,192.168.199.10' (RSA) to the list of known hosts. oracle@11grac1's password: Now try logging into the machine, with "ssh '11grac1'", and check in: .ssh/authorized_keys to make sure we haven't added extra keys that you weren't expecting. 11grac3-> ssh-copy-id -i .ssh/id_rsa.pub 11grac1 The authenticity of host '11grac1 (192.168.199.10)' can't be established. RSA key fingerprint is cc:d0:c3:de:37:33:a7:cb:91:40:c5:5f:18:07:06:9f. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '11grac1,192.168.199.10' (RSA) to the list of known hosts. oracle@11grac1's password: Now try logging into the machine, with "ssh '11grac1'", and check in: .ssh/authorized_keys to make sure we haven't added extra keys that you weren't expecting.6.3 以上命令會在11grac1的/home/oracle/.ssh目錄下生成authorized_keys，將該文件copy到其他兩機(jī)器上
11grac1-> scp authorized_keys 11grac2:/home/oracle/.ssh/ 11grac1-> scp authorized_keys 11grac3:/home/oracle/.ssh/6.4 重復(fù)6.1~6.3步驟，生成grid用戶的無密碼驗證。
7. 驗證各節(jié)點必須直接是否能無密碼登錄
ssh 11grac1 date ssh 11grac2 date ssh 11grac3 date ssh 11grac3-priv date ssh 11grac2-priv date ssh 11grac1-priv date ssh 11grac1.localdomain.com date ssh 11grac2.localdomain.com date ssh 11grac3.localdomain.com date ssh 11grac3-priv.localdomain.com date ssh 11grac2-priv.localdomain.com date ssh 11grac1-priv.localdomain.com date8. 掛載iscsi硬盤（每臺機(jī)器上都執(zhí)行）
8.1 查找iscsi硬盤
[root@11grac1 scripts]# iscsiadm -m discovery -t sendtargets -p 192.168.199.219 192.168.199.219:3260,1 iqn.2006-01.com.openfiler:fast_recover_area01 192.168.199.219:3260,1 iqn.2006-01.com.openfiler:rac_oradata01 192.168.199.219:3260,1 iqn.2006-01.com.openfiler:rac_ocrdisk03 192.168.199.219:3260,1 iqn.2006-01.com.openfiler:rac_ocrdisk02 192.168.199.219:3260,1 iqn.2006-01.com.openfiler:rac_ocrdisk018.2 設(shè)置開機(jī)自動掛載iscsi盤
iscsiadm -m node -T iqn.2006-01.com.openfiler:rac_oradata01 -p 192.168.199.219 --op update -n node.startup -v automatic iscsiadm -m node -T iqn.2006-01.com.openfiler:fast_recover_area01 -p 192.168.199.219 --op update -n node.startup -v automatic iscsiadm -m node -T iqn.2006-01.com.openfiler:rac_ocrdisk01 -p 192.168.199.219 --op update -n node.startup -v automatic iscsiadm -m node -T iqn.2006-01.com.openfiler:rac_ocrdisk02 -p 192.168.199.219 --op update -n node.startup -v automatic iscsiadm -m node -T iqn.2006-01.com.openfiler:rac_ocrdisk03 -p 192.168.199.219 --op update -n node.startup -v automatic9.創(chuàng)建asm磁盤
9.1 安裝oracleasm-support、oracleasmlib （三臺機(jī)器都執(zhí)行）
注：因oracle linux已經(jīng)將oracleasm內(nèi)置到內(nèi)核中了，所以無需安裝oracleasm的rpm包。如果使用非oracle Linux操作系統(tǒng)。請按裝kmod-oracleasm-2.0.6.rh2-2.el6.x86_64.rpm 包。
[root@11grac2 /]# rpm -ivh oracleasm-support-2.1.8-1.el6.x86_64.rpm warning: oracleasm-support-2.1.8-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY Preparing... ########################################### [100%] 1:oracleasm-support ########################################### [100%] [root@11grac2 /]# rpm -ivh oracleasmlib-2.0.4-1.el6.x86_64.rpm warning: oracleasmlib-2.0.4-1.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY Preparing... ########################################### [100%] 1:oracleasmlib ########################################### [100%][root@11grac1 Packages]# oracleasm configure -i Configuring the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. The current values will be shown in brackets ('[]'). Hitting9.2 將磁盤分區(qū)（只需單節(jié)點執(zhí)行）
9.3 創(chuàng)建asm磁盤
[root@11grac1 ~]# ll /dev/disk/by-path/ ip-192.168.199.219:3260-iscsi-iqn.2006-01.com.openfiler:fast_recover_area01-lun-0 -> ../../sde ip-192.168.199.219:3260-iscsi-iqn.2006-01.com.openfiler:fast_recover_area01-lun-0-part1 -> ../../sde1 ip-192.168.199.219:3260-iscsi-iqn.2006-01.com.openfiler:rac_ocrdisk01-lun-0 -> ../../sdb ip-192.168.199.219:3260-iscsi-iqn.2006-01.com.openfiler:rac_ocrdisk01-lun-0-part1 -> ../../sdb1 ip-192.168.199.219:3260-iscsi-iqn.2006-01.com.openfiler:rac_ocrdisk02-lun-0 -> ../../sdd ip-192.168.199.219:3260-iscsi-iqn.2006-01.com.openfiler:rac_ocrdisk02-lun-0-part1 -> ../../sdd1 ip-192.168.199.219:3260-iscsi-iqn.2006-01.com.openfiler:rac_ocrdisk03-lun-0 -> ../../sdc ip-192.168.199.219:3260-iscsi-iqn.2006-01.com.openfiler:rac_ocrdisk03-lun-0-part1 -> ../../sdc1 ip-192.168.199.219:3260-iscsi-iqn.2006-01.com.openfiler:rac_oradata01-lun-0 -> ../../sdf ip-192.168.199.219:3260-iscsi-iqn.2006-01.com.openfiler:rac_oradata01-lun-0-part1 -> ../../sdf1注意以上iscsi磁盤與/dev/sd*的對應(yīng)關(guān)系。
[root@11grac1 ~]# oracleasm createdisk oradata /dev/sdf1 Writing disk header: done Instantiating disk: done [root@11grac1 ~]# oracleasm createdisk fra /dev/sde1 Writing disk header: done Instantiating disk: done [root@11grac1 ~]# oracleasm createdisk ocr01 /dev/sdb1 Writing disk header: done Instantiating disk: done [root@11grac1 ~]# oracleasm createdisk ocr02 /dev/sdd1 Writing disk header: done Instantiating disk: done [root@11grac1 ~]# oracleasm createdisk ocr03 /dev/sdc1查看磁盤
[root@11grac1 ~]# oracleasm listdisks FRA OCR01 OCR02 OCR03 ORADATA [root@11grac1 ~]#在另外兩臺機(jī)器上執(zhí)行磁盤掃描操作
[root@11grac3 ~]# oracleasm scandisks Reloading disk partitions: done Cleaning any stale ASM disks... Scanning system for ASM disks... Instantiating disk "OCR01" Instantiating disk "OCR03" Instantiating disk "OCR02" Instantiating disk "FRA" Instantiating disk "ORADATA"10. 禁用ntp時間同步服務(wù)
因為11g Clusterware中已經(jīng)提供了時間同步服務(wù)，所以需要禁用ntp服務(wù)。
[root@11grac3 ~]# cd /etc/ [root@11grac3 etc]# mv ntp.conf ntp.conf.bak感謝各位的閱讀！關(guān)于“Oracle RAC之環(huán)境準(zhǔn)備的示例分析”這篇文章就分享到這里了，希望以上內(nèi)容可以對大家有一定的幫助，讓大家可以學(xué)到更多知識，如果覺得文章不錯，可以把它分享出去讓更多的人看到吧！
另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價比高”等特點與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。
重慶分公司
重慶分公司
