Sqlnet.ora

In database computing, sqlnet.ora is a plain-text configuration file that contains the information on how both Oracle server and Oracle client have to use Oracle Net capabilities for networked database access.

Location

The sqlnet.ora file typically resides in on UNIX platforms and on Windows operating systems.

Sample file

NAMES.DIRECTORY_PATH=
NAMES.DEFAULT_DOMAIN = ORACLE.COM
TRACE_LEVEL_CLIENT = ON
SQLNET.EXPIRE_TIME = 30
SQLNET.IDENTIX_FINGERPRINT_DATABASE = FINGRDB
AUTOMATIC_IPC = ON
SQLNET.AUTHENTICATION_SERVICES =
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
	Turning signal handling on or off.
	Defining the session data unit size.	2048 bytes	512 to 2 Mbytes Ora12c
	Defining the destination directory for the client to write the logs.	Current directory from which the executable is started	path to the directory
	Defining client's log filename.	sqlnet.log	name of the file
	Defining the server's log filename.	sqlnet.log	name of the file
	Client checksum behaviour defining.	accepted	accepted; rejected; requested; required
	Determine the crypto-checksum algorithms used by client.	all available algorithms	md5; sha1
	Determine symbols to generate the cryptographic key. This parameter must not be set in CRS environments. CRS will fail to start if this value is set in CRS/Grid.		10-70 characters
	Determine list of cryptographic ciphers used by SSL to encrypt the traffic.