Oracle 11g R2 RAC：配置 DNS 解析 SCAN VIP

Oracle 11gR2Grid Infrastructure (CRS) 中引入了 Single Client Access Name (SCAN) 來簡化用戶端對資料庫服務的通路。

本文将詳細介紹如何配置 DNS 來解析 SCAN VIP

示範環境

OracleEnterprise Linux 5.6

一、安裝 DNS Server

rpm -ivhbind-9.3.6-16.P1.el5.i386.rpm

rpm -ivhbind-chroot-9.3.6-16.P1.el5.i386.rpm

rpm -ivhcaching-nameserver-9.3.6-16.P1.el5.i386.rpm

DNS的守護程序

/usr/sbin/named   

/usr/sbin/rndc

DNS的腳本

/etc/init.d/named

DNS的端口

53       953(tcp udp) 

DNS的配置檔案

/var/named/chroot/etc/named.conf(主配置檔案)  

/var/named/chrootsample/ for example named configuration files.

//

// DONOT EDIT THIS FILE - use system-config-bind or an editor

// tocreate named.conf - edits to this file will be lost on

// caching-nameserver package upgrade.

//

------建立 named.conf 配置檔案

[[email protected] etc]# cp-p named.caching-nameserver.conf named.conf

[[email protected] etc]# ls-lt

total 28

-rw-r----- 1 rootnamed  113 Jun  1 07:46 rndc.key

-rw-r----- 1 rootnamed 1230 Jan 14  2011named.caching-nameserver.conf

-rw-r----- 1 rootnamed 1230 Jan 14  2011 named.conf

-rw-r----- 1 rootnamed  955 Jan 14  2011 named.rfc1912.zones

-rw-r--r-- 1 rootroot  3519 Feb 27  2006 localtime

-------編輯剛剛建立的 named.conf 檔案，按照如下方式修改：

 listen-on port 53 { 127.0.0.1; };

 allow-query { localhost; };

 match-clients { localhost; };

 match-destinations { localhost; };

 allow-query-cache { localhost; };

将上述entry中的 host 資訊全部修改為 any，注意保留源檔案中的空格

2、配置正向解析和反向解析 zone

------配置正向解析 zone

[[email protected] etc]# vinamed.rfc1912.zones

zone"oracle.com" IN {

 type master;

 file "rac.oracle.zone";

 allow-update { none; };

};

------配置反向解析 zone

[[email protected] etc]# vinamed.rfc1912.zones

zone"8.168.192.in-addr.arpa" IN {

 type master;

 file "rac.oracle.local";

 allow-update { none; };

};

這裡需要注意的是，反向解析從左到右讀取ip位址時是以相反的方向解釋的，是以需要将ip位址反向排列。這裡，192.168.8.*網段的反向解析域名為"8.168.192.in-addr.arpa"。

3、利用模闆檔案建立用于正向解析和反向解析資料庫檔案

[[email protected] etc]# cd/var/named/chroot/var/named

[[email protected] named]#ls -lt

total 44

-rw-r----- 1root  named  198 Jan 14 2011 localdomain.zone

-rw-r----- 1root  named  195 Jan 14 2011 localhost.zone

-rw-r----- 1root  named  427 Jan 14 2011 named.broadcast

-rw-r----- 1root  named 1892 Jan 14  2011 named.ca

-rw-r----- 1root  named  424 Jan 14 2011 named.ip6.local

-rw-r----- 1root  named  426 Jan 14 2011 named.local

-rw-r----- 1root  named  427 Jan 14 2011 named.zero

drwxrwx--- 2 namednamed 4096 Aug 26  2004 data

drwxrwx--- 2 namednamed 4096 Jul 27  2004 slaves

-----建立正向解析資料庫檔案

[[email protected]]#  cp -p localhost.zonerac.oracle.zone

-----建立方向解析資料庫檔案

[[email protected]]#  cp -p named.localrac.oracle.local

-----配置正向解析資料庫檔案

[[email protected] named]#vim rac.oracle.zone

$TTL 86400

@ IN SOA oracle.comroot.oracle.com (

 42 ; serial (d. adams)

 3H ; refresh

 15M ; retry

 1W ; expiry

 1D ) ; minimum

 IN NS oracle.com

rac-scan IN A192.168.8.31

rac-scan IN A192.168.8.32

rac-scan IN A192.168.8.33

注意：無論RAC有多少節點，SCAN VIP 的個數隻能有3個

-----配置反向解析資料庫檔案

[[email protected] named]#vim rac.oracle.local

$TTL 86400

@ IN SOA oracle.com.root.oracle.com. (

 1997022700 ; Serial

 28800 ; Refresh

 14400 ; Retry

 3600000 ; Expire

 86400 ) ; Minimum

 IN NS oracle.com.

31 IN PTRrac-scan.oracle.com.

32 IN PTRrac-scan.oracle.com.

33 IN PTRrac-scan.oracle.com.

注意：

（1） 數字寫IP 位址的最後一個。如192.168.6.100, 就寫100

（2） rac-scan. 後面有一個點

4、重新開機 DNS Server

[[email protected] named]#service named restart

Stopping named:[  OK ]

Starting named:[  OK ]

5、配置 DNS 用戶端

[[email protected] named]#more /etc/resolv.conf

#search oracle.com

#nameserver 8.8.8.8

nameserver192.168.8.11

注意，如有必要刻意修改 /etc/nsswitch.conf 檔案配置主機解析方式

6、驗證 DNS 配置

[[email protected] named]#nslookup 192.168.8.32

Server:         192.168.8.11

Address:        192.168.8.11#53

32.8.168.192.in-addr.arpa       name = rac-scan.oracle.com.

[[email protected] named]#cd /var/named/chroot/var/named

[[email protected] named]#nslookup rac-scan

Server:         192.168.8.11

Address:        192.168.8.11#53

Name:   rac-scan.oracle.com

Address:192.168.8.31

Name:   rac-scan.oracle.com

Address:192.168.8.32

Name:   rac-scan.oracle.com

Address:192.168.8.33

[[email protected] named]#nslookup rac-scan.oracle.com

Server:         192.168.8.11

Address:        192.168.8.11#53

Name:   rac-scan.oracle.com

Address:192.168.8.33

Name:   rac-scan.oracle.com

Address:192.168.8.31

Name:   rac-scan.oracle.com

Address:192.168.8.32

[[email protected] named]#nslookup 192.168.8.32

Server:         192.168.8.11

Address:        192.168.8.11#53

32.8.168.192.in-addr.arpa       name = rac-scan.oracle.com.

#eth0 - PUBLIC

192.168.8.11rac1.oracle.com rac1

192.168.8.12rac2.oracle.com rac2

#VIP

192.168.8.21rac1-vip.oracle.com rac1-vip

192.168.8.22rac2-vip.oracle.com rac2-vip

#eth1 - PRIVATE

10.10.10.11rac1-priv1

10.10.10.12rac2-priv2

轉載請注明作者出處及原文連結，否則将追究法律責任：

作者：xiangsir

原文連結：http://blog.csdn.net/xiangsir/article/details/9236199

QQ：444367417

MSN：[email protected]