Re: 10 sec delay connecting to Oracle?

More on DNS resolution problems:

When I had the same problem with SQL Server 7, my experiments led me to the conclusion that name resolution attempts were happening in the following order. HOSTS file, DNS, LMHOSTS file, other SMB (Master browser, WINS, etc.). I was having the problem because all our systems were pointing to the DNS server at our ISP which had no knowledge of internal systems. I had not known there would ever be a reason to resolve local system names using DNS.

My stopgap solution was to add an entry to resolve the SQL Server into the HOSTS file on each machine. Eventually, I set up the DNS Server service on our NT/WINS server and configured it to get information about local machines from the WINS database.

On Thu, 09 May 2002 07:47:26 -0500, Paul Clement <UseAdddressAtEndofMessage_at_swspectrum.com> wrote:

>On Thu, 09 May 2002 10:43:33 GMT, harry <a_at_abc.com> wrote:
>
>¤ Firstly applogies for cross posting but not too sure which one to post this in
>¤
>¤ Using Oracle 8i on NT server 4 (sp6a)
>¤
>¤ Why is there a delay of approx 10 sec's eveytime I try to connect to my Oracle database.
>¤
>¤ Using either an ODBC or OLEDB connection from Visual Basic, Access, TOAD makes no difference. Once
>¤ the initial connection has been made then it's instant to reconnect but the 1st time is really
>¤ getting on my nerves
>¤
>¤ Any ideas?
>
>I'll second Frank's suggestion. I've seen delays like this before with Oracle
>and it's usually a DNS name resolution problem.
>
>
>Paul ~~~ pclement_at_ameritech.net
>Microsoft MVP (Visual Basic)

--
Steve Jorgensen
Database application developer - available
http://www.coho.net/~jorgens