一.基本信息
本文件将配置DNS服务器,并且测试oracle11Gr2下使用SCAN和DNS配置网络连接。
本文件涉及到的机器
| DNS机器 | 集群节点1 | 集群节点1 | 客户端 |
OS | Rhel63 | Rhel63 | Rhel63 | Win7 |
IP | 192.168.114.138 | IP:192.168.114.141 VIP:192.168.114.143 Priv:172.168.114.141 | IP:192.168.114.142 VIP:192.168.114.144 Priv:172.168.114.142 | 192.168.114.127 |
SCAN IP: 192.168.114.145 192.168.114.146 192.168.114.147 | ||||
|
|
|
|
|
# cat /etc/issue
Red Hat Enterprise Linux Server release 6.3(Santiago)
Kernel \r on an \m
SQL> select * from V$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise EditionRelease 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 -Production
NLSRTL Version 11.2.0.4.0 - Production
二.DNS服务器配置:
安装相应的包
[root@dns ~]# yum install bind bind-devel bind-chrootcaching-nameserver
[root@dns ~]# cat /etc/resolv.conf
search localdomain
nameserver 192.168.114.138
保证resolv.conf不会自动修改
[root@dns ~]#chattr+i /etc/resolv.conf
修改named.conf
[root@dns ~]# vi/etc/named.conf
修改:
listen-on port 53 {any; };
allow-query { any; }; --也可以是具体IP段,如192.168.110.0/24;
并为配置简单,将一些安装相关的用//注释掉
options {
listen-on port 53 {any; };
listen-on-v6 port 53 { ::1; };
directory "/var/named";
dump-file "/var/named/data/cache_dump.db";
statistics-file "/var/named/data/named_stats.txt";
memstatistics-file "/var/named/data/named_mem_stats.txt";
allow-query { any; };
recursion yes;
// dnssec-enable yes;
// dnssec-validation yes;
// dnssec-lookaside auto;
/* Path to ISC DLV key */
// bindkeys-file "/etc/named.iscdlv.key";
// managed-keys-directory "/var/named/dynamic";
};
logging {
channel default_debug {
file"data/named.run";
severity dynamic;
};
};
zone "." IN {
type hint;
file "named.ca";
};
include"/etc/named.rfc1912.zones";
//include "/etc/named.root.key";
named.conf中只有“.”区域,其他的在/etc/named.rfc1912.zones中配置
修改/etc/named.rfc1912.zones
在/etc/named.rfc1912.zones中创建正向反向区域
[root@dns ~]# vi/etc/named.rfc1912.zones
加入下面两部分
zone "pera.com"IN {
type master;
file "pera.com.zone";
allow-update { none; };
};
zone "114.168.192.in-addr.arpa"IN {
type master;
file "192.168.114.arpa";
allow-update { none; };
};
创建正反向解析文件
[root@dns ~]# cd /var/named/
[root@dns named]# cp -p named.localhost pera.com.zone
[root@dns named]# cp -p named.localhost 192.168.114.arpa
修改正向解析:
[root@dns named]# vi /var/named/pera.com.zone
$TTL 5M
@ IN SOA @ rname.invalid. (
0 ; serial
1D ; refresh
1H ; retry
1W ; expire
3H) ; minimum
NS @
A 192.168.114.138
AAAA ::1
dns A 192.168.114.138
DNS1 CNAME dns
ftp A 192.168.114.138
mail A 192.168.114.138
racn-cluster-scan A 192.168.114.145
racn-cluster-scan A 192.168.114.146
racn-cluster-scan A 192.168.114.147
@ MX 5 mail.localdomain
$GENERATE 10-250 stu$ A 192.168.114.$
修改反向解析:
[root@dns ~]# vi/var/named/192.168.114.arpa
$TTL 1D
@ IN SOA @ rname.invalid. (
0 ; serial
1D ; refresh
1H ; retry
1W ; expire
3H) ; minimum
NS pera.com.
A 127.0.0.1
AAAA ::1
138 PTR dns
145 PTR racn-cluster-scan.pera.com.
146 PTR racn-cluster-scan.pera.com.
147 PTR racn-cluster-scan.pera.com.
启动named
[root@dns named]# /etc/rc.d/init.d/namedrestart
Stopping named: [ OK ]
Starting named: [ OK ]
检查
[root@dns ~]# netstat -anp|grep :53
tcp 0 0 192.168.114.138:53 0.0.0.0:* LISTEN 2104/named
tcp 0 0 127.0.0.1:53 0.0.0.0:* LISTEN 2104/named
tcp 0 0 ::1:53 :::* LISTEN 2104/named
udp 0 0 0.0.0.0:5353 0.0.0.0:* 1930/avahi-daemon
udp 0 0 172.168.146.138:53 0.0.0.0:* 2104/named
udp 0 0 192.168.114.138:53 0.0.0.0:* 2104/named
udp 0 0 127.0.0.1:53 0.0.0.0:* 2104/named
udp 0 0 ::1:53 :::* 2104/named
[root@dns~]# nslookup
> 192.168.114.138
Server: 192.168.114.138
Address: 192.168.114.138#53
138.114.168.192.in-addr.arpa name = dns.pera.com.
> dns
Server: 192.168.114.138
Address: 192.168.114.138#53
Name: dns.pera.com
Address: 192.168.114.138
> dns1
Server: 192.168.114.138
Address: 192.168.114.138#53
dns1.pera.com canonical name = dns.pera.com.
Name: dns.pera.com
Address: 192.168.114.138
> racn-cluster-scan
Server: 192.168.114.138
Address: 192.168.114.138#53
Name: racn-cluster-scan.pera.com
Address: 192.168.114.145
Name: racn-cluster-scan.pera.com
Address: 192.168.114.146
Name: racn-cluster-scan.pera.com
Address: 192.168.114.147
> racn-cluster-scan.pera.com
Server: 192.168.114.138
Address: 192.168.114.138#53
Name: racn-cluster-scan.pera.com
Address: 192.168.114.146
Name: racn-cluster-scan.pera.com
Address: 192.168.114.147
Name: racn-cluster-scan.pera.com
Address: 192.168.114.145
> 192.168.114.146
Server: 192.168.114.138
Address: 192.168.114.138#53
146.114.168.192.in-addr.arpa name = racn-cluster-scan.pera.com.
三.集群使用scan和DNS访问
修改集群两节点的resolv.conf
其他linux访问时只需要修改:
[root@racnode2 grid]# vi /etc/resolv.conf
search localdomain
nameserver 192.168.114.138
保证resolv.conf不会自动修改
chattr +i /etc/resolv.conf
集群节点hosts文件
[root@racn2 ~]# more /etc/hosts
127.0.0.1 localhost localhost.pera.com localhost4 localhost4.pera.com4
::1 localhost localhost.pera.com localhost6 localhost6.pera.com6
192.168.114.141 racn1.pera.com racn1
192.168.114.142 racn2.pera.com racn2
192.168.114.143 racn1-vip.pera.com racn1-vip
192.168.114.144 racn2-vip.pera.com racn2-vip
172.168.1.141 racn1-priv.pera.com racn1-priv
172.168.1.142 racn2-priv.pera.com racn2-priv
192.168.114.145 racn-cluster-scan.pera.com racn-cluster-scan
192.168.114.146 racn-cluster-scan.pera.com racn-cluster-scan
192.168.114.147 racn-cluster-scan.pera.com racn-cluster-scan
在保证以前内容正确的条件进行集群安装或修改现在集群,保证scan ip的访问正常(本文不做讨论)
可参考:http://blog.csdn.net/bamuta/article/details/24410801
四.在客户端连接该集群
Windows下进行连接:
首先需要,配好DNS:
修改tnsnames.ora
vmpera =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = racn-cluster-scan.pera.com)(PORT =1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pera)
)
)
另外需要修改hosts文件把加入以下内容
192.168.114.127 localhost
--经测试,加入本网段内任一IP都可以,不管能不能ping通。
进行连接
SQL> conn system/oracle@vmpera
已连接。
简单测试具有oad_balance功能,在不同的连接中连接到的实例不同。