René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

sqlnet.ora

sqlnet.ora
names.directory_path= (tnsnames)
sqlnet.expire_time = 30

Specifying client domains to append to unqualified names

Logging and tracing features

trace_file_client

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

log_directory_client

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

log_file_client

log_directory_server

log_file_server

trace_level_client

Enables tracing if not set to off (which is the default). Possible values: user, admin and support.

trace_unique_client

Misc

sqlnet.expire_time

Enables dead connection detection, that is, after the specifed 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.

not yet categorized

bequeath_detach

disable_oob

names.connect_timeout

names.dce.prefix

names.default_domain

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

Specifies the order of naming methods that are used when a client tries to connect to a database.
The default is: TNSNAMES, ONAMES, HOSTNAME

names.initial_retry_timeout

names.max_open_connections

names.message_pool_start_size

names.nis.meta_map

names.preferred_servers

names.request_retries

namesctl.echo

namesctl.internal_encrypt_password

namesctl.internal_use

namesctl.no_initial_server

namesctl.noconfirm

namesctl.server_password

namesctl.trace_level

namesctl.trace_file

namesctl.trace_directory

namesctl.trace_unique

sqlnet.authentication_kerberos5_service

sqlnet.authentication_gssapi_service

sqlnet.authentication_services

sqlnet.client_registration

sqlnet.crypto_checksum_client

sqlnet.crypto_checksum_server

sqlnet.crypto_checksum_type_client

sqlnet.crypto_checksum_type_server

sqlnet.crypto_seed

This option seems to be removed with 10g.

sqlnet.encryption_client

sqlnet.encryption_server

sqlnet.encryption_types_client

sqlnet.encryption_types_server

sqlnet.kerberos5_cc_name

sqlnet.kerberos5_clockskew

sqlnet.kerberos5_conf

sqlnet.kerberos5_keytab

sqlnet.kerberos5_realms

sqlnet.radius_alternate

sqlnet.radius_alternate_port

sqlnet.radius_alternate_retries

sqlnet.radius_authentication

sqlnet.radius_authentication_interface

sqlnet.radius_authentication_port

sqlnet.radius_authentication_retries

sqlnet.radius_authentication_timeout

sqlnet.radius_challenge_response

sqlnet.radius_secret

sqlnet.radius_send_accounting

ssl_cipher_suites

ssl_client_authentication

ssl_server_dn_match

ssl_version

tcp.excluded_nodes

This parameter lists the names or IP addresses of nodes from which clients can not connect to the listener. In order for this parameter to take effect, tcp.validnode_checking must be set to yes.

tcp.invited_nodes

This parameter lists the names or IP addresses of nodes from which clients can connect to the listener. In order for this parameter to take effect, tcp.validnode_checking must be set to yes.

tcp.validnode_checking

This parameter can be set to yes in which case only clients hosted on servers listed in tcp.invited_nodes can connect to the listener or clients hosted on servers listed in tcp.excluded_nodes can not connect to the listener.

tcp.nodelay

tnsping.trace_directory

tnsping.trace_level

trace_directory_client

trace_directory_server

trace_file_server

trace_filelen_client

trace_filelen_server

trace_fileno_client

trace_fileno_server

trace_level_server

trace_timestamp_client

trace_timestamp_server

use_cman

use_dedicated_server

WALLET_LOCATION

Thanks

Thanks to Tim Trauernicht who has notified me of an error on this page.