Sqlnet.ora

From Oracle FAQ
Jump to: navigation, search

Sqlnet.ora is a text file that provides SQL*Net with basic configuration details like tracing options, default domain, encryption, etc. This file can be found in the ORACLE HOME\NETWORK\ADMIN directory.

Sample sqlnet.ora files[edit]

Example 1:

NAMES.DIRECTORY_PATH= (LDAP, TNSNAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN = WORLD
TRACE_LEVEL_CLIENT = OFF
SQLNET.EXPIRE_TIME = 30

Example 2:

automatic_ipc = ON               # Set to OFF for PC's
trace_level_client = OFF         # Set to 16 if tracing is required
sqlnet.expire_time = 0           # Idle time in minutes
sqlnet.authentication_services = (ALL)
names.directory_lookup = (TNSNAMES,ONAMES)
names.default_domain = world
name.default_zone = world

Parameters[edit]

Some of the parameters that can be set in sqlnet.ora:

names.default_domain[edit]

The value of this parameter is appended to the net service name if the net service name doesn't already have a domain.

names.directory_path[edit]

Specifies the order of naming methods that are used when a client tries to connect to a database. Possible values: TNSNAMES, LDAP, ONAMES, HOSTNAME, EZCONNECT.

sqlnet.expire_time[edit]

Enables dead connection detection, that is, after the specified time (in minutes) the server checks if the client is still connected. If not, the server process exits. This parameter must be set on the server.

trace_level_client[edit]

Enables tracing if not set to off (or 0, which is the default). Possible values: USER (4), ADMIN (10) and SUPPORT (16).

trace_file_client[edit]

Specifies the name of the (client) trace file. The default is sqlnet.trc.

trace_directory_client[edit]

Specifies the destination directory in which the trace file goes. The default is the current directory in which the executable is started.

automatic_ipc[edit]

When automatic_ipc=on, SQL*Net will bypass the network layer and make direct local connections to the database. This is useful on database servers.

bequeath_detach[edit]

The default is NO (turn signal handling on). When a local connection (bequeath connection) is established, Oracle installs its own signal handlers to automatically reap all child processes. However this may trash other child process handling functions outside of Oracle. When a process establishes a local connection and then creates a child process unrelated to Oracle, the process fails to get the exit status of the child process.

By setting BEQUEATH_DETACH=YES, Oracle turns off its own signal handlers and pass all child processes over to the UNIX init process (pid = 1). The init process will take over responsibility to checks for "defunct" child processes and terminate them.

sqlnet.outbound_connect_timeout[edit]

Time in seconds after which a connection attempt will be timed out. After timeout, the client will try to connect to the next host on the ADDRESS_LIST. This facilitates quick fail-over in case a system/node is down. This parameter should typically be set to +- 3 seconds. If not set, the client connection will block for the default TCP connect timeout duration.

tcp.connect_timeout[edit]

In 11.1 and above this parameter sets the timeout for establishing a TCP connection.

Oracle documentation[edit]

The full Oracle documentation is located in the Net Services Reference Guide, chapter 5: 10gR2; 11gR2.