Sqlnet.ora
title: "Sqlnet.ora" type: doc version: 1 created: 2026-02-28 author: "Wikipedia contributors" status: active scope: public tags: ["configuration-files", "oracle-database"] topic_path: "general/configuration-files" source: "https://en.wikipedia.org/wiki/Sqlnet.ora" license: "CC BY-SA 4.0" wikipedia_page_id: 0 wikipedia_revision_id: 0
In database computing, 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 Oracle Net (formerly Net8 or SQL*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= (LDAP, TNSNAMES, HOSTNAME) NAMES.DEFAULT_DOMAIN = ORACLE.COM TRACE_LEVEL_CLIENT = ON SQLNET.EXPIRE_TIME = 30 SQLNET.IDENTIX_FINGERPRINT_DATABASE = FINGRDB AUTOMATIC_IPC = ON 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. ::data[format=table]
| Parameter | Purpose | Default | Values | Example |
|---|---|---|---|---|
| Turning signal handling on or off (UNIX systems only). | ||||
| 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. | ||||
| :: |
References
References
- "Sample Configuration Files".
- "Database Net Services Reference - Profile Parameters". [[Oracle Corporation]].
::callout[type=info title="Wikipedia Source"] This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page. ::