Re: Oracle 8i login is very slow

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sun, 13 Apr 2003 05:36:08 +1000
Message-ID: <1KZla.12980$1s1.210580@newsfeeds.bigpond.com>

Any reason you have three names resolution methods listed?

Presumably, you actually only use tnsnames, so why not set it so? Then make sure that things like DNS entries are identical, \windows\drivers\etc\hosts are likewise, and that anything else you use to map an ip address to a machine name is configured identically on both machines

You might also remove the NTS setting for authentication services and see if that makes a difference.

Regards
HJR "John D" <zafemail_john_at_yahoo.com> wrote in message news:2fcf2d80.0304120919.5c1de5e1_at_posting.google.com...
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:<l3Tla.12693$1s1.207459_at_newsfeeds.bigpond.com>...
> > Check your sqlnet.ora on both machines. I suspect they are not
identical.
> >
> > Regards
> > HJR
> >
>
> They are identical:
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Received on Sat Apr 12 2003 - 14:36:08 CDT