Re: Oracle needs to be restarted to accept new connections

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 02 Nov 2005 18:00:29 GMT
Message-ID: <Xns970265DC99957SunnySD@68.6.19.6>

"DavidDublin" <davidcotter_at_gmail.com> wrote in news:1130953989.956207.172750_at_g14g2000cwa.googlegroups.com:

> Thanks - I use IP Address for remote connections and domain name for
> local. I have change the local one now to use IP add. Another thing I
> changed was the listener.ora so it specifies the extenal IP Address of
> the machine instead of domainname which was pointing to 127.0.0.1 but I
> don't know why I did this really just to ee if it helps.
>
>

FWIW - if by local you mean you are logged directly onto the same box which hosts the database instance, then SQL*NET is NOT required to connect to the database at all.

Did changing the TNSNAMES.ORA file to use the IP# reduce the the connection time from 30 seconds to close to instantaneous? Received on Wed Nov 02 2005 - 12:00:29 CST