From: jxs@wolpoff_nospm_law.com (Jay M. Scheiner)
Subject: Re: After installing Oracle 8.1.5 client, i can't access Oracle Server through SQL*Plus
Date: 2000/08/08
Message-ID: <399017bb.427639303@news.erols.com>#1/1
References: <8mkoae$s2p$1@nnrp1.deja.com> <398ebbd4.338562530@news.erols.com> <8mmshe$c4g$1@nnrp1.deja.com>
X-Trace: dCPZLnWgq9+xvZr/ogWByE3FyOCGRWGqYZUUXOJ2/1w=
NNTP-Posting-Date: 8 Aug 2000 14:25:57 GMT
Newsgroups: comp.databases.oracle.server
X-Complaints-To: abuse@rcn.com


Sorry, I think I told you the wrong file.  Look at sqlnet.ora &
comment out the line, if present, that says 'sqlnet.auth = nts'

NAMES.DEFAULT.DOMAIN = <domain>
#SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY.PATH= (TNSNAMES)

again, maybe copy this file from a working machine.

In init.ora on the server, I have

os_authent_prefix = ""
remote_os_authent = true

Many people will tell you that using external authentication is a weak
security model, but we are in a limited access environment, so it's
not as much of an issue.

On Mon, 07 Aug 2000 17:44:16 GMT, xiaohuiz@my-deja.com wrote:

>I installed Oracle Server 8.1.5 on Windows NT, and installed Oracle
>Client on Windows 95. I use database authentiaction.
>I copied tnsnames.ora form a working client machine to the client that
>doesn't work, it's still have the same problem.
>My tnsnames.ora is :
>COSGITI1.LSIL.COM =
>  (DESCRIPTION =
>    (ADDRESS_LIST =
>      (ADDRESS = (PROTOCOL = TCP)(HOST = cosgiti1)(PORT = 1521))
>    )
>    (CONNECT_DATA =
>      (SERVICE_NAME = cosgiti1.lsilogic)
>    )
>  )
>


_______________
Jay M. Scheiner
Programmer/Analyst
Wolpoff & Abramson, LLP
remove _nospm_ from email address
Opinions are my own only!