Sqlnet.ora
Encyclopedia
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 Net8 (or SQL*Net) opportunities.
platforms and %ORACLE_HOME%\NETWORK\ADMIN on Windows operating systems.
NAMES.DEFAULT_DOMAIN = ORACLE.COM
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 30
SQLNET.IDENTIX_FINGERPRINT_DATABASE = FINGRDB
AUTOMATIC_IPC = ON
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 0
SQLNET.AUTHENTICATION_SERVICES = (ALL)
SQLNET.CRYPTO_CHECKSUM_CLIENT = ACCEPTED
TNSPING.TRACE_DIRECTORY = /oracle/traces
Configuration file
In computing, configuration files, or config files configure the initial settings for some computer programs. They are used for user applications, server processes and operating system settings. The files are often written in ASCII and line-oriented, with lines terminated by a newline or carriage...
that contains the information like tracing options, encryption, route of connections, external naming parameters etc on how both Oracle
Oracle Database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
server and Oracle
Oracle Database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
client have to use Net8 (or SQL*Net) opportunities.
Location
The sqlnet.ora file typically resides in $ORACLE_HOME/network/admin on UNIXUnix
Unix is a multitasking, multi-user computer operating system originally developed in 1969 by a group of AT&T employees at Bell Labs, including Ken Thompson, Dennis Ritchie, Brian Kernighan, Douglas McIlroy, and Joe Ossanna...
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
TRACE_LEVEL_CLIENT = OFF
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.| Parameter | Purpose | Default | Values | Example |
|---|---|---|---|---|
| BEQUEATH_DETACH | Turning signal handling on or off (UNIX systems only). | yes | yes; no | BEQUEATH_DETACH=no |
| DEFAULT_SDU_SIZE | Defining the session data unit size. | 2048 bytes | 512 to 32768 bytes | DEFAULT_SDU_SIZE=512 |
| LOG_DIRECTORY_CLIENT | Defining the destination directory for the client to write the logs. | Current directory from which the executable is started | path to the directory | LOG_DIRECTORY_CLIENT=/oracle/net/log |
| LOG_FILE_CLIENT | Defining client's log filename. | sqlnet.log | name of the file | LOG_FILE_CLIENT=client.log |
| LOG_FILE_SERVER | Defining the server's log filename. | sqlnet.log | name of the file | LOG_FILE_SERVER=server.log |
| SQLNET.CRYPTO_CHECKSUM_CLIENT | Client checksum behaviour defining. | accepted | accepted; rejected; requested; required | SQLNET.CRYPTO_CHECKSUM_CLIENT=rejected |
| SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT | Determine the crypto-checksum algorithms used by client. | all available algorithms | md5; sha1 | SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1) |
| SQLNET.CRYPTO_SEED | Determine symbols to generate the cryptographic key. | qwertyuiopasdfghjkl;zxcvbnm,.s1 | 10-70 characters | sqlnet.crypto_seed="kbguhfplhc5c4626fy[67vg;yd" |
| SSL_CIPHER_SUITES | Determine list of cryptographic ciphers used by SSL to encrypt the traffic. | None | SSL_RSA_WITH_3DES_EDE_CBC_SHA; SSL_RSA_WITH_RC4_128_SHA; SSL_RSA_WITH_RC4_128_MD5; SSL_RSA_WITH_DES_CBC_SHA; SSL_DH_anon_WITH_3DES_EDE_CBC_SHA; SSL_DH_anon_WITH_RC4_128_MD5; SSL_DH_anon_WITH_DES_CBC_SHA; SSL_RSA_EXPORT_WITH_RC4_40_MD5; SSL_RSA_EXPORT_WITH_DES40_CBC_SHA; SSL_RSA_WITH_AES_128_CBC_SHA; SSL_RSA_WITH_AES_256_CBC_SHA | SSL_CIPHER_SUITE=(ssl_rsa_with_des_cbc_sha) |