SQLNET.ORA

Example SQLNET.ORA

WALLET_LOCATION =

(SOURCE =

(METHOD = FILE)

(METHOD_DATA =

(DIRECTORY = /home/oracle/wallet)

)

)

SQLNET.WALLET_OVERRIDE = TRUE


SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 12

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12

SQLNET.EXPIRE_TIME=5


NAMES.DIRECTORY_PATH= (tnsnames, ezconnect)

Parameters

NAMES.DIRECTORY_PATH

Example entry...

NAMES.DIRECTORY_PATH= (tnsnames, ezconnect)

  • tnsnames - (Local Naming Method) allows you to connect by specifying a name that maps to a connect descriptor in tnsnames.ora
  • ezconnect/hostname - (Easy Connect Naming Method) allows you to connect using a sytnax that avoids the need for any naming or directory system.
    CONNECT myuser@[//]host[:port][/myservice][:server][/myinstance]
  • ldap - (Directory Naming Method) connect identifiers are mapped to connect descriptors contained in an LDAP-compliant directory server, such as Oracle Internet Directory and Microsoft Active Directory.
  • nis - (NIS external naming method) resolve an Oracle database name through Network Information Service (NIS)
  • onames
  • cde - (CDS external naming method) resolve an Oracle database name in Distributed Computing Environment (DCE)

SQLNET.ALLOWED_LOGON_VERSION

Deprecated in 12.1

SQLNET.ALLOWED_LOGON_VERSION_CLIENT

Related Errors: ORA-28040

SQLNET.ALLOWED_LOGON_VERSION_SERVER

SQLNET.EXPIRE_TIME

Default: 0

Example entry...

SQLNET.EXPIRE_TIME=5

Related Errors: ORA-03135

When this parameter is set to a non-zero value, a 10 byte probe packet will be sent from node to node at an interval roughly corresponding to the number (of minutes) specified.
This setting is a key enabler for Oracle Dead Connection Detection (DCD) and can also be helpful in avoiding idle timeouts set in firewall configuration.
The default of 0 means no probe packets will be sent.
This value is read each time a new connection is made. i.e. you do not need to restart or reload the listener for this to take effect.

SQLNET.INBOUND_CONNECT_TIMEOUT

Specifies the time, in seconds, for the client to complete its connect request to the listener after the network connection had been established.

Default: 60 seconds

Example entry...

SQLNET.INBOUND_CONNECT_TIMEOUT=60

Related Errors: ORA-03136

This value is read each time a new connection is made. i.e. you do not need to restart or reload the listener for this to take effect.
A value of 0 signifies an unlimited timeout
Also consider setting INBOUND_CONNECT_TIMEOUT_listener in LISTENER.ORA.
Oracle recommend setting SQLNET.INBOUND_CONNECT_TIMEOUT slightly higher than INBOUND_CONNECT_TIMEOUT_listener.

SQLNET.WALLET_OVERRIDE

SSL_CLIENT_AUTHENTICATION

SSL_VERSION

WALLET_LOCATION

Example entry...

WALLET_LOCATION =

(SOURCE =

(METHOD = FILE)

(METHOD_DATA =

(DIRECTORY = /home/oracle/wallet)

)

)

Logging & Tracing Parameters

Client

LOG_DIRECTORY_CLIENT

Specifies the directory for the client log file

Example entry...

LOG_DIRECTORY_CLIENT=/u01/app/oracle/product/180000/network/log

Default...

$ORACLE_HOME/network/log

LOG_FILE_CLIENT

Example entry...

LOG_FILE_CLIENT=sqlnet.log

Default...

sqlnet.log

TRACE_DIRECTORY_CLIENT

Example entry...

TRACE_DIRECTORY_CLIENT=/u01/app/oracle/product/180000/network/trace

TRACE_FILE_CLIENT

Example entry...

TRACE_FILE_CLIENT=client.trc

TRACE_FILELEN_CLIENT

Specifies the size of the trace file in KB

Example entry...

TRACE_FILELEN_CLIENT=1024

Best used in conjunction with TRACE_FILENO_CLIENT

Default...

0

TRACE_FILENO_CLIENT

Specifies the number of trace files

Example entry...

TRACE_FILENO_CLIENT=7

Cycle through 7 trace files. Best used in conjunction with TRACE_FILELEN_CLIENT

Default...

0

TRACE_LEVEL_CLIENT

Example entry...

TRACE_LEVEL_CLIENT=16

Or...

TRACE_LEVEL_CLIENT=SUPPORT

Default...

0

OFF

Numeric...

0

4

10

16

Human readable alternative...

OFF

USER

ADMIN

SUPPORT

TRACE_TIMESTAMP_CLIENT

Include a timestamp for each event in the client trace

TODO

TRACE_UNIQUE_CLIENT

Creates an individual client trace file for each process (without this, the file will get overwritten by successive runs of the client program)

Example entry...

TRACE_UNIQUE_CLIENT=ON

Default...

OFF

Server

LOG_DIRECTORY_SERVER

Example entry...

LOG_DIRECTORY_SERVER=/u01/app/oracle/product/180000/network/trace

Default...

$ORACLE_HOME/network/trace

LOG_FILE_SERVER

Example entry...

LOG_FILE_SERVER=sqlnet.log

Default...

sqlnet.log

TRACE_DIRECTORY_SERVER

Example entry...

TRACE_DIRECTORY_SERVER=/u01/app/oracle/product/180000/network/trace

TRACE_FILE_SERVER

Example entry...

TRACE_FILE_SERVER=server.trc

TRACE_FILELEN_SERVER

TODO

TRACE_FILENO_SERVER

TODO

TRACE_LEVEL_SERVER

Example entry...

TRACE_LEVEL_SERVER=16

Or...

TRACE_LEVEL_SERVER=SUPPORT

Default...

0

OFF

Numeric...

0

4

10

16

Human readable alternative...

OFF

USER

ADMIN

SUPPORT

TRACE_TIMESTAMP_SERVER

TODO

tnsping

TNSPING.TRACE_LEVEL

Example entry...

TNSPING.TRACE_LEVEL_SERVER=16

Or...

TNSPING.TRACE_LEVEL_SERVER=SUPPORT

Default...

0

OFF

Numeric...

0

4

10

16

Human readable alternative...

OFF

USER

ADMIN

SUPPORT

Bibliography


https://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/parameters-for-the-sqlnet.ora.htmlhttps://docs.oracle.com/database/121/NETRF/sqlnet.htmhttps://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/database-preparation-tasks-to-complete-before-upgrades.html http://www.juliandyke.com/Diagnostics/Trace/NetTrace.php
NAMES.DIRECTORY_PATHhttps://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/parameters-for-the-sqlnet.ora.html#GUID-65EF582E-F414-43EE-A70F-EC90E0B7292Fhttps://docs.oracle.com/en/database/oracle/oracle-database/12.2/netag/configuring-naming-methods.htmlhttps://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#NETRF192https://docs.oracle.com/cd/B19306_01/network.102/b14213/sqlnet.htm
SQLNET.EXPIRE_TIMEhttps://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/parameters-for-the-sqlnet.ora.html#GUID-1070805B-0703-457C-8D2E-4EEC26193E5Fhttps://grepora.com/2017/07/19/sqlnet-ora-parameter-sqlnet-expire_time/https://support.oracle.com Log Shipment Between Primary and Standby Intermittently Errors with ORA-12570 (Doc ID 550103.1)https://support.oracle.com Archived: Dead Connection Detection (DCD) Explained (Doc ID 151972.1)https://blog.dbi-services.com/sqlnet-expire_time-and-enablebroken/
SQLNET.INBOUND_CONNECT_TIMEOUThttps://docs.oracle.com/en/database/oracle/oracle-database/19/netrf/parameters-for-the-sqlnet.ora.html#GUID-E83FEC2B-52E7-4513-83D8-830F9D745099https://docs.oracle.com/en/database/oracle/oracle-database/21/netrf/oracle-net-listener-parameters-in-listener-ora.html#GUID-140AC8D3-091C-4129-B2E6-0A4773590C14https://support.oracle.com Description of Parameter SQLNET.INBOUND_CONNECT_TIMEOUT (Doc ID 274303.1)https://docs.oracle.com/cd/B19306_01/network.102/b14213/listener.htm#i503196