6 Replies Latest reply: Feb 3, 2013 9:34 PM by Catch-22 RSS

    Creating a DNS Server on Oracle Linux 5.8 64 bit

    762942
      Hi Guys,

      I am creating a DNS host setup to resolve the SCAN IPs used in Oracle 11g R2 RAC. The Idea is to resolve 3 IP addres in a round robin fashion.

      I am not a hard core linux admin just a DBA.
      Please help me get a pointer to troubleshoot this issue.

      ovmdnsbox is my DNS HOST going to be used by clusterhost1 and clusterhost2. Want to configure sangramkeshari.net as my domain.

      ON ovmdnsbox
      =====================
      added entry in /etc/named.conf

      zone "sangramkeshari.net" IN {
      type master;
      file "sangramkeshari.net.zone";
      allow-update { none; };
      };

      zone "56.168.192.in-addr.arpa" in {
      type master;
      file "56.168.192.in-addr.arpa.zone";
      };

      [root@ovmdnsbox named]# pwd
      /var/named

      [root@ovmdnsbox named]# cat sangramkeshari.net.zone
      $TTL 86400
      @ IN SOA sangramkeshari.net. sangramkeshari.net. (
      42 ; serial (d. adams)
      3H ; refresh
      15M ; retry
      1W ; expiry
      1D ) ; minimum
      IN NS localhost
      localhost IN A 127.0.0.1

      clusterhost-x-scan IN A 192.168.56.131
      clusterhost-x-scan IN A 192.168.56.132
      clusterhost-x-scan IN A 192.168.56.133

      [root@ovmdnsbox named]# cat 56.168.192.in-addr.arpa
      $ORIGIN 56.168.192.in-addr.arpa.
      $TTL 1H
      @ IN SOA sangramkeshari.net. root.sangramkeshari.net. ( 2
      3H
      1H
      1W
      1H )
      56.168.192.in-addr.arpa. IN NS sangramkeshari.net.

      131 IN PTR clusterhost-x-scan.sangramkeshari.net.
      132 IN PTR clusterhost-x-scan.sangramkeshari.net.
      133 IN PTR clusterhost-x-scan.sangramkeshari.net.
      [root@ovmdnsbox named]# service named start
      Starting named:
      Error in named configuration:
      zone localdomain/IN: loaded serial 42
      zone localhost/IN: loaded serial 42
      zone 0.0.127.in-addr.arpa/IN: loaded serial 1997022700
      zone 0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa/IN: loaded serial 1997022700
      zone 255.in-addr.arpa/IN: loaded serial 42
      zone 0.in-addr.arpa/IN: loaded serial 42
      my.internal.zone.db:1: no TTL specified; using SOA MINTTL instead
      zone my.internal.zone/IN: loaded serial 1
      slaves/my.ddns.internal.zone.db:1: no TTL specified; using SOA MINTTL instead
      zone my.ddns.internal.zone/IN: loaded serial 1
      zone sangramkeshari.net/IN: loaded serial 42
      zone 56.168.192.in-addr.arpa/IN: loading master file 56.168.192.in-addr.arpa.zone: file not found
      internal/56.168.192.in-addr.arpa/in: file not found
      my.external.zone.db:1: no TTL specified; using SOA MINTTL instead
      zone my.external.zone/IN: loaded serial 1
      [FAILED]
        • 1. Re: Creating a DNS Server on Oracle Linux 5.8 64 bit
          bigdelboy
          SangramKeshariDash wrote:
          Hi Guys,

          I am creating a DNS host setup to resolve the SCAN IPs used in Oracle 11g R2 RAC. The Idea is to resolve 3 IP addres in a round robin fashion.

          I am not a hard core linux admin just a DBA.
          Please help me get a pointer to troubleshoot this issue.

          ovmdnsbox is my DNS HOST going to be used by clusterhost1 and clusterhost2. Want to configure sangramkeshari.net as my domain.

          ON ovmdnsbox
          =====================
          added entry in /etc/named.conf

          zone "sangramkeshari.net" IN {
          type master;
          file "sangramkeshari.net.zone";
          allow-update { none; };
          };

          zone "56.168.192.in-addr.arpa" in {
          type master;
          Note filename below:
          file "56.168.192.in-addr.arpa.zone";
          };

          [root@ovmdnsbox named]# pwd
          /var/named

          [root@ovmdnsbox named]# cat sangramkeshari.net.zone
          $TTL 86400
          @ IN SOA sangramkeshari.net. sangramkeshari.net. (
          42 ; serial (d. adams)
          3H ; refresh
          15M ; retry
          1W ; expiry
          1D ) ; minimum
          IN NS localhost
          localhost IN A 127.0.0.1

          clusterhost-x-scan IN A 192.168.56.131
          clusterhost-x-scan IN A 192.168.56.132
          clusterhost-x-scan IN A 192.168.56.133
          Note filename here:
          [root@ovmdnsbox named]# cat 56.168.192.in-addr.arpa
          $ORIGIN 56.168.192.in-addr.arpa.
          $TTL 1H
          @ IN SOA sangramkeshari.net. root.sangramkeshari.net. ( 2
          3H
          1H
          1W
          1H )
          56.168.192.in-addr.arpa. IN NS sangramkeshari.net.

          131 IN PTR clusterhost-x-scan.sangramkeshari.net.
          132 IN PTR clusterhost-x-scan.sangramkeshari.net.
          133 IN PTR clusterhost-x-scan.sangramkeshari.net.
          [root@ovmdnsbox named]# service named start
          Starting named:
          Error in named configuration:
          zone localdomain/IN: loaded serial 42
          zone localhost/IN: loaded serial 42
          zone 0.0.127.in-addr.arpa/IN: loaded serial 1997022700
          zone 0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa/IN: loaded serial 1997022700
          zone 255.in-addr.arpa/IN: loaded serial 42
          zone 0.in-addr.arpa/IN: loaded serial 42
          my.internal.zone.db:1: no TTL specified; using SOA MINTTL instead
          zone my.internal.zone/IN: loaded serial 1
          slaves/my.ddns.internal.zone.db:1: no TTL specified; using SOA MINTTL instead
          zone my.ddns.internal.zone/IN: loaded serial 1
          zone sangramkeshari.net/IN: loaded serial 42
          Note error message here:
          zone 56.168.192.in-addr.arpa/IN: loading master file 56.168.192.in-addr.arpa.zone: file not found
          internal/56.168.192.in-addr.arpa/in: file not found
          my.external.zone.db:1: no TTL specified; using SOA MINTTL instead
          zone my.external.zone/IN: loaded serial 1
          [FAILED]
          • 2. Re: Creating a DNS Server on Oracle Linux 5.8 64 bit
            Nik
            Hi. You say filename at you configuratin : "sangramkeshari.net.zone"; but realy created :file "sangramkeshari.net".
            Change configuration or rename file.

            Regards.
            • 3. Re: Creating a DNS Server on Oracle Linux 5.8 64 bit
              Catch-22
              zone 56.168.192.in-addr.arpa/IN: loading master file 56.168.192.in-addr.arpa.zone: file not found
              # cat 56.168.192.in-addr.arpa
              Your configuration specifies: "56.168.192.in-addr.arpa.zone", but you created "56.168.192.in-addr.arpa", which filename does not match.
              • 4. Re: Creating a DNS Server on Oracle Linux 5.8 64 bit
                762942
                You mean renaming the /var/named/sangramkeshari.net.zone to /var/named/sangramkeshari.net will work?
                • 5. Re: Creating a DNS Server on Oracle Linux 5.8 64 bit
                  762942
                  [root@ovmdnsbox ~]# cd /var/named
                  [root@ovmdnsbox named]# ls -ltr
                  total 56
                  drwxrwx--- 2 named named 4096 Oct 13 02:20 data
                  drwxrwx--- 2 named named 4096 Dec 16 00:01 slaves
                  -rw-r--r-- 1 named named 427 Dec 16 00:01 named.zero
                  -rw-r--r-- 1 named named 1892 Dec 16 00:01 named.root
                  -rw-r--r-- 1 named named 426 Dec 16 00:01 named.local
                  -rw-r--r-- 1 named named 424 Dec 16 00:01 named.ip6.local
                  -rw-r--r-- 1 named named 427 Dec 16 00:01 named.broadcast
                  -rw-r--r-- 1 named named 56 Dec 16 00:01 my.internal.zone.db
                  -rw-r--r-- 1 named named 56 Dec 16 00:01 my.external.zone.db
                  -rw-r--r-- 1 named named 195 Dec 16 00:01 localhost.zone
                  -rw-r--r-- 1 named named 340 Dec 16 03:18 localdomain.zone
                  -rw-r--r-- 1 named named 0 Feb 3 01:42 named_querylog
                  -rw-r--r-- 1 named named 316 Feb 3 01:50 56.168.192.in-addr.arpa
                  -rw-r--r-- 1 root root 340 Feb 3 01:57 sangramkeshari.net.zone.old
                  -rw-r--r-- 1 named named 365 Feb 3 01:58 sangramkeshari.net.zone



                  The file name here is 56.168.192.in-addr.arpa

                  [root@ovmdnsbox named]# cat /etc/named.conf|grep arpa
                  zone "56.168.192.in-addr.arpa" in {
                  file "56.168.192.in-addr.arpa.zone";


                  I think I need to remove the .zone here. Right ?

                  What is zone concept here, how does that make difference with and with out zone.
                  • 6. Re: Creating a DNS Server on Oracle Linux 5.8 64 bit
                    Catch-22
                    [root@ovmdnsbox named]# cat /etc/named.conf|grep arpa
                    zone "56.168.192.in-addr.arpa" in {
                    file "56.168.192.in-addr.arpa.zone";
                    File "56.168.192.in-addr.arpa.zone" above is a file name, meaning it refers to a file on your file systems. Nothing else. You can name it anything, but if the file does not exist, it shows an error, like the one you are experiencing.
                    56.168.192.in-addr.arpa/IN: loading master file 56.168.192.in-addr.arpa.zone: file not found