Oracle Host Naming


In the case of Host Naming, service names are stored using an IP-Address translation mechanism, ie. a host name alias. Host names are mapped to a server global database name using a names resolution service such as DNS (Domain Name System), NIS (Network Information Service) or even a centrally maintained set of host files such as /etc/hosts. Host Naming can be used without a tnsnames.ora file. Thus only the most simplistic of Oracle network access can be used.

Host naming can be used in simplistic environments where no advanced features such as load balancing, failover, connection pooling, etc. are required. Host naming removes the neccessity for lookups into the tnsnames.ora file. Also host naming is only available for TCP/IP connections. The global database name, a concatenation of the database name and the domain name, is used as the host name of an alias for an existing network name resolution service such as DNS. Files shown below constitute example host naming resolution and DNS configuration files for a Solaris box.

# cat /etc/hosts

#
# Internet host table
#
127.0.0.1       localhost       
256.152.4.51    dev	dev.xyz.com	loghost
256.152.4.52    test	test.xyz.com
256.152.5.53	prod	prod.xyz.com

# cat /etc/resolv.conf

search localdomain
domain xyz.com
nameserver 256.152.4.51 
nameserver 256.152.4.52
nameserver 256.152.4.53
nameserver 127.0.0.1