Oracle Database Discussions

Hi,

I have a Solaris 2.6 system running oracle 8.1.7 client and the problem is that every transaction results in a DNS request.

There are hundreds of transactions and the DNS server is being overloaded.

We are not using oracle names.

here is the sqlnet.ora:

# SQLNET.ORA Network Configuration File: /opt/OraHome1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

Here is the entry in the tnsnames.ora for the service in question:

TOEBOC =
(DESCRIPTION =
(ADDRESS_LIST=
(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP) (HOST=dbora01) (PORT=1642))
(ADDRESS=(PROTOCOL=TCP) (HOST=dbora02) (PORT=1642))
)
(CONNECT_DATA=
(SERVICE_NAME=TOEBOC)
(FAILOVER_MODE=(TYPE=SESSION))
)
)

I was able to get rid of the DNS requests for dbora01 by adding the IP to the /etc/hosts.

But for some reason I keep seeing a DNS request going out for the service name (TOEBOC)

Why is oracle trying to resolve the service name?

Shouldn't it just care about the connection address?

BTW: The transactions work fine, but the DNS server needs to be relieved from these extra un-needed DNS requests.

Any help / direction would be much apprecieted!!

Thanks,

Steve