Re: Oracle needs to be restarted to accept new connections

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 02 Nov 2005 17:41:30 GMT
Message-ID: <Xns970262A7C784ESunnySD@68.6.19.6>

"DavidDublin" <davidcotter_at_gmail.com> wrote in news:1130952703.689175.6020_at_z14g2000cwz.googlegroups.com:

> For local connections I am using tnsnames with hostname specified and
> for remote I use thin JDBC connection string with IP Address specified.
>
> I will investigate further if there is a difference between these two
> methods.
>
> Many thanks.
>

I've been following this thread, so please pardon the interruption. A 30 second delay can be symptomatic of a DNS timeout & then failover to a 2nd DNS server.

A quck test would be to modify the TNSNAMES.ORA file to contain the IP#; instead of the hostname. Received on Wed Nov 02 2005 - 11:41:30 CST