Girish Mahajan (Editor)

Sqlnet.ora

Updated on
Edit
Like
Comment
Share on FacebookTweet on TwitterShare on LinkedInShare on Reddit

In database computing, sqlnet.ora is a plain-text configuration file that contains the information (like tracing options, encryption, route of connections, external naming parameters etc.) on how both Oracle server and Oracle client have to use Oracle Net (formerly Net8 or SQL*Net) capabilities for networked database access.

Contents

Location

The sqlnet.ora file typically resides in $ORACLE_HOME/network/admin on UNIX platforms and %ORACLE_HOME%\NETWORK\ADMIN on Windows operating systems.

Sample file

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, HOSTNAME) NAMES.DEFAULT_DOMAIN = ORACLE.COM TRACE_LEVEL_CLIENT = OFF SQLNET.EXPIRE_TIME = 30 SQLNET.IDENTIX_FINGERPRINT_DATABASE = FINGRDB AUTOMATIC_IPC = ON SQLNET.EXPIRE_TIME = 0 SQLNET.AUTHENTICATION_SERVICES = (ALL) SQLNET.CRYPTO_CHECKSUM_CLIENT = ACCEPTED TNSPING.TRACE_DIRECTORY = /oracle/traces

Profile parameters

This section lists and describes some sqlnet.ora file parameters.

References

Sqlnet.ora Wikipedia