René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
sqlnet.ora | ||
sqlnet.ora
names.directory_path= (tnsnames) sqlnet.expire_time = 30 Specifying client domains to append to unqualified namesLogging and tracing featurestrace_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_clientlog_directory_serverlog_file_servertrace_level_client
Enables tracing if not set to off (which is the default). Possible values: user, admin and support.
trace_unique_clientMiscsqlnet.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 categorizedbequeath_detachdisable_oobnames.connect_timeoutnames.dce.prefixnames.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_timeoutnames.max_open_connectionsnames.message_pool_start_sizenames.nis.meta_mapnames.preferred_serversnames.request_retriesnamesctl.echonamesctl.internal_encrypt_passwordnamesctl.internal_usenamesctl.no_initial_servernamesctl.noconfirmnamesctl.server_passwordnamesctl.trace_levelnamesctl.trace_filenamesctl.trace_directorynamesctl.trace_uniquesqlnet.authentication_kerberos5_servicesqlnet.authentication_gssapi_servicesqlnet.authentication_servicessqlnet.client_registrationsqlnet.crypto_checksum_clientsqlnet.crypto_checksum_serversqlnet.crypto_checksum_type_clientsqlnet.crypto_checksum_type_serversqlnet.crypto_seed
This option seems to be removed with 10g.
sqlnet.encryption_clientsqlnet.encryption_serversqlnet.encryption_types_clientsqlnet.encryption_types_serversqlnet.kerberos5_cc_namesqlnet.kerberos5_clockskewsqlnet.kerberos5_confsqlnet.kerberos5_keytabsqlnet.kerberos5_realmssqlnet.radius_alternatesqlnet.radius_alternate_portsqlnet.radius_alternate_retriessqlnet.radius_authenticationsqlnet.radius_authentication_interfacesqlnet.radius_authentication_portsqlnet.radius_authentication_retriessqlnet.radius_authentication_timeoutsqlnet.radius_challenge_responsesqlnet.radius_secretsqlnet.radius_send_accountingssl_cipher_suitesssl_client_authenticationssl_server_dn_matchssl_versiontcp.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.nodelaytnsping.trace_directorytnsping.trace_leveltrace_directory_clienttrace_directory_servertrace_file_servertrace_filelen_clienttrace_filelen_servertrace_fileno_clienttrace_fileno_servertrace_level_servertrace_timestamp_clienttrace_timestamp_serveruse_cmanuse_dedicated_serverWALLET_LOCATIONThanks
Thanks to Tim Trauernicht who has notified me of an error on this page.
|