Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

DNS Server configuration steps for 11gR2 RAC on RHEL

The Domain Name System (DNS) is a hierarchical distributed naming system for computers, services, or any resource connected to the Internet or a private network. It associates various information with domain names assigned to each of the participating entities.
A Domain Name Service translates queries for domain names (which are easier to understand and utilize when accessing the internet) into IP addresses for the purpose of locating computer services and devices worldwide.
DNS provides 11gR2 RAC with the capability of Configuring multiple SCAN IP’s. Also DNS along with GNS (Grid Naming Service) simplifies the administration of Nodes. Oracle 11gR2 RAC supports a maximum of 3 SCAN IP’s.
In this article, I will configure DNS Server for 11gR2 SCAN IP that is required in 11gR2 RAC cluster configuration. If you use /etc/hosts file then only one IP will be taken for configuration and hence a DNS is required for resolving all the SCAN IP’s.
We will configure 3 SCAN IPs as below,
SCAN Name     :       scan-ip.homedns.com
SCAN IP       :
SCAN IP       :
SCAN IP       :
• Install required RPMs
– bind
– bind-libs
– bind-utils
Now copy all the files under /usr/share/doc/bind-9.3.6/sample/etc to /etc
Also copy all the files under /usr/share/doc/bind-9.3.6/sample/var to /var
# cp /usr/share/doc/bind-9.3.6/sample/etc/* /etc/
# cp -r /usr/share/doc/bind-9.3.6/sample/var/named /var

• Generate the DNS key
# dns-keygen
Add the DNS key to the /etc/named.conf file in the below section,
key ddns_key
               algorithm hmac-md5;
               secret "76VVOEPvQRbO0jIIY6FZhaHOiaWpF7QdByEpkY0Bis3UT0uHRbMpBqjgsLPp";
• Add the below line in the /etc/named.conf file in the “view internal” section
zone "homedns.com" IN {
       type master;
       file "homedns.com.zone";
       allow-update { none; };
Here homedns is the domain name.
• Create a zone file
# cd /var/named/
# cp localdomain.zone homedns.com.zone
Add the below entries to the zone file /var/named/homedns.com.zone and /var/named/localdomain.zone file.
scan-ip                 IN A             
scan-ip                 IN A             
scan-ip                 IN A             
• Configure a reverse proxy
To identify the SCAN name from any of the IPS’s we need to configure a reverse proxy.
Add the below entry to /etc/named.conf file in the “view internal” section.
zone "0.168.192.in-addr.arpa." IN {
       type master;
       file "0.168.192.in-addr.arpa";
       allow-update { none; };
Here my SCAN IP is in the subnet 192.168.0, so my entry looks like this.
• Create the reverse proxy file
# cd /var/named
# vi 0.168.192.in-addr.arpa
$ORIGIN 0.168.192.in-addr.arpa.
@ IN SOA homedns.com. root.homedns.com. ( 2
1H )
0.168.192.in-addr.arpa. IN NS homedns.com.
12 IN PTR scan-ip.homedns.com.
13 IN PTR scan-ip.homedns.com.
14 IN PTR scan-ip.homedns.com.
• Start the named service
# chkconfig named on
# service named stop
# service named start
• Configure resolv.conf file on RAC nodes
On all the nodes, edit the /etc/resolv.conf and put your domain name and the DNS server name.
# vi /etc/resolv.conf
search homedns.com
Edit the /etc/nsswitch.conf file and add/edit the below entry.
hosts: dns files nis
[Save and Quit]
Now try to do a nslookup of the SCAN name on all nodes and check if it gets resolved.
# nslookup scan-ip
[It should show below output]
Name: scan-ip.homedns.com
Name: scan-ip.homedns.com
Name: scan-ip.homedns.com
You can see from above output that the scan name is resolving all the 3 IP’s.
Now you can configure SCAN listener in RAC.


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

7 Steps to configure BDR replication in postgresql

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

PostgreSQL Monitoring Tools

PostgreSQL pgBadger