cancel
Showing results for 
Search instead for 
Did you mean: 

A problem about sqlnet.ora

ericfjchen
Regular Advisor

A problem about sqlnet.ora

In Oracle client, do you know what "SQLNET.AUTHENTICATION_SERVICES= (NTS)" does mean in the sqlnet.ora? Pls kindly explain it.

Thanks

Eric
4 REPLIES
Michael Schulte zur Sur
Honored Contributor

Re: A problem about sqlnet.ora

Hi,

here is a good explanation:
http://www.winnetmag.com/Windows/Article/ArticleID/42280/42280.html

greetings,

Michael
Eric Antunes
Honored Contributor

Re: A problem about sqlnet.ora

Hi Eric,

THis is to connect with Windows NT Authentication (Non-Secure).

For both clients and server, you must have the following entry in the SQLNET.ORA:

SQLNET.AUTHENTICATION_SERVICES=(NTS)

Configure the clients to login to the Windows NT domain to which that Win NT server belongs to, or a Windows NT domain that trusts the domain.

After that, you will be able to connect as sysdba. Try this in SQL*Plus:

SQL> connect / as sysdba;

See Metalink Notes 60634.1 and 77665.1 for more info.

Best Regards,

Eric
Each and every day is a good day to learn.
Indira Aramandla
Honored Contributor

Re: A problem about sqlnet.ora

Hi Eric,

SQLNET.AUTHENTICATION_SERVICES parameter is in the sqlnet.ora file.

The SQLNET.ORA file is created by NETWORK MANAGER for all nodes on the
network. The file contains the following types of information:

1. Dead Connection Detection:
2. Optional Tracing Parameters:
3. Default Domains:
4. Oracle Names parameters:
5. Secured Network Services:

Secured Network Services :- If Secured Network Services is installed, the following parameters are required otherwise they can also be commented out:

SQLNET.CRYPTO_SEED =
SQLNET.AUTHENTICATION_SERVICES =

Change it to (NONE)

On UNIX the SQLNET.ORA file must be in $ORACLE_HOME/network/admin. On desktop platforms (including Windows, Netware, Macintosh, and OS/2) the SQL*Net.ORA file should be in the /network/admin file.

Indira A


Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: A problem about sqlnet.ora

hi eric,

see also metalink Note:91210.1

in brief,

NTS (NT Transport Services).

by seting the following parameter sqlnet.ora:

SQLNET.AUTHENTICATION_SERVICES = (NTS)

if you are logged on as a domain user, and you don't have a network connection (network cable temporary removed), you will not be able to connect to the database because the
authentication will try to reach the domain users database on the PDC (Primary Domain Controller) or BDC (Backup Domain Controller).

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)