Re: Connection to NT Oracle Server v7.3.2.2.1 takes too long

Along the same lines as Wolfgang's post, check to see how long it takes that PC to start pinging the server. Ignore the Reply times, just find out how long from the time you type

C:\> ping DB_server

to the time you start gettting replies. If it takes a long time (more than a second) you may want to add your server's IP address to the NT host file. (search for hosts.sam and rename it to hosts)

Regards,

Nigel

In article <lPMm2.8085$7l6.181163_at_tor-nn1.netcom.ca>,   breitliw_nospam_at_centrexcc.com (Wolfgang Breitling) wrote:
> In article <01be33de$85808020$07c809c0_at_pim>, "Stéphane Ramet" <sramet_at_nmg.fr>
wrote:
> >We have multiple Oracle Servers v7.3.2.2.1 on our Ethernet TCP/IP network,
> >both on Windows NT 4.0 Server and WS.
> >We access those servers from Windows NT 4.0 WS's.
> >In some cases (Client X to Server Y), logging to the Server is immediate,
> >whereas in most other cases (Client A to Server B) it takes up to 10
> >minutes to get access to the server, using any client tool (sql*plus,
> >sqlldr73, etc.).
> >It seems that the problem depends on the Cleint's configuration. Any idea
> >what parameters we have wrong on our client stations ?
> >Thanks in advance for replies.
> >
>
> Make sure you have only the way you resolve the connect string specified in
> the NAMES.DIRECTORY_PATH variable in the sqlnet.ora file of each workstation
> e.g. if you are using tnsnames .ora, use NAMES.DIRECTORY_PATH = (tnsnames)
> (nothing else)
> if you are using an oracle names server, use NAMES.DIRECTORY_PATH =
> (onames)
>
> Be especially carefull with the hostname attribute, unless you use it, of
> course). If you have NAMES.DIRECTORY_PATH = (hostname, tnsnames) for example,
> sqlnet will try to find a host matching the connect string on the network,
> which can take quite some time if you have a large network.
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 12 1999 - 16:52:25 CST