A problem about sqlnet.ora

[ericfjchen]

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

Thanks

Eric

[Michael Schulte zur Sur]

Hi,

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

greetings,

Michael

[Eric Antunes]

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

[Indira Aramandla]

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

[Yogeeraj_1]

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