linux6 DNS服务配置+ORACLE11g RAC使用scan和DNS连接

来源:互联网 发布:船舶软件 编辑:程序博客网 时间:2024/06/07 08:23

一.基本信息

本文件将配置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功能,在不同的连接中连接到的实例不同。

原创粉丝点击