I already had SQLNET.AUTHENTICATION_SERVICES= (NONE) on my workstation.

Would it make any difference on the server?

Below are the TNSPing times.
The first one is the 10g(10.1.0.3.0) server and the second one is a
8i(8.1.7.4.1) server.

-Mark


C:\Documents and Settings\mark>tnsping rms_bb.world

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
28-FEB-2005 14:24:11

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
C:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
BETA)(PORT = 1521)) (CONNECT_DATA = (SID = RMSB)))
OK (1350 msec)

C:\Documents and Settings\mark>tnsping rms_dc.world

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
28-FEB-2005 14:25:08

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
C:\oracle\ora92\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
DELTA)(PORT = 1521)) (CONNECT_DATA = (SID = RMSC)))
OK (1250 msec)



-----Original Message-----
From: Joyce Paul [mailto:[Email address protected]
Sent: Sunday, February 20, 2005 3:34 PM
To: Rhoades, Mark A SPL Contractor
Subject: RE: Slow login to 10g database


**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Hi Mark,

Make a change in ?/network/admin/sqlnet.ora

#SQLNET.AUTHENTICATION_SERVICES= (NTS)
SQLNET.AUTHENTICATION_SERVICES= (NONE)

The NTS is the default. It means that Oracle authenicates the OS
credentials of each users with a NT server, ie, domain controller. NONE
means don't do it.

Set to NONE, you should get almost immediate login. The same issue
exists in Oracle 9i as well.

Regards, Paul

-----Original Message-----
From: Rhoades Mark A SPL Contractor
[mailto:oracledba-ezmlmshield-x95137693.[Email address protected]
Sent: Saturday, 19 February 2005 3:31 AM
To: LazyDBA Discussion
Subject: Slow login to 10g database


I have a Oracle 10.1.0.3.0 Enterprise under Windows 2000 and 2003
server. I am having problems with slow logins. It takes about 30+
seconds to login to the database. It doesn't matter if connect from the
console or a remote workstation. The client version doesn't make any
difference.

-Mark





_______________________________________________________
CAUTION - This message may contain privileged and confidential
information intended only for the use of the addressee named above.
If you are not the intended recipient of this message you are hereby
notified that any use, dissemination, distribution or reproduction of
this message is prohibited. If you have received this message in error
please notify Yarra Valley Water immediately. Any views expressed in
this message are those of the individual sender and may not necessarily
reflect the views of Yarra Valley Water.
_______________________________________________________




Oracle LazyDBA home page