Embedded Files
Example 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
Parameters
NAMES.DIRECTORY_PATH
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
SQLNET.ALLOWED_LOGON_VERSION
Deprecated in 12.1
Related Errors: ORA-28040
Related Errors: ORA-03134 , ORA-28040
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/database-preparation-tasks-to-complete-before-upgrades.htmlSQLNET.EXPIRE_TIME
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.
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.
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
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.
Oracle recommend setting SQLNET.INBOUND_CONNECT_TIMEOUT slightly higher than INBOUND_CONNECT_TIMEOUT_listener.
Example entry...
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /home/oracle/wallet)
)
)
Logging & Tracing Parameters
Logging & Tracing Parameters
Client
Client
LOG_DIRECTORY_CLIENT
Specifies the directory for the client log fileLOG_DIRECTORY_CLIENT
Example entry...
LOG_DIRECTORY_CLIENT=/u01/app/oracle/product/180000/network/log
Default...
$ORACLE_HOME/network/log
LOG_FILE_CLIENT
LOG_FILE_CLIENT
Example entry...
LOG_FILE_CLIENT=sqlnet.log
Default...
sqlnet.log
TRACE_DIRECTORY_CLIENT
TRACE_DIRECTORY_CLIENT
Example entry...
TRACE_DIRECTORY_CLIENT=/u01/app/oracle/product/180000/network/trace
TRACE_FILE_CLIENT
TRACE_FILE_CLIENT
Example entry...
TRACE_FILE_CLIENT=client.trc
TRACE_FILELEN_CLIENT
Specifies the size of the trace file in KBTRACE_FILELEN_CLIENT
Example entry...
TRACE_FILELEN_CLIENT=1024
Best used in conjunction with TRACE_FILENO_CLIENTDefault...
0
TRACE_FILENO_CLIENT
Specifies the number of trace filesTRACE_FILENO_CLIENT
Example entry...
TRACE_FILENO_CLIENT=7
Cycle through 7 trace files. Best used in conjunction with TRACE_FILELEN_CLIENTDefault...
0
TRACE_LEVEL_CLIENT
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 traceTRACE_TIMESTAMP_CLIENT
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)TRACE_UNIQUE_CLIENT
Example entry...
TRACE_UNIQUE_CLIENT=ON
Default...
OFF
Server
Server
LOG_DIRECTORY_SERVER
LOG_DIRECTORY_SERVER
Example entry...
LOG_DIRECTORY_SERVER=/u01/app/oracle/product/180000/network/trace
Default...
$ORACLE_HOME/network/trace
LOG_FILE_SERVER
LOG_FILE_SERVER
Example entry...
LOG_FILE_SERVER=sqlnet.log
Default...
sqlnet.log
TRACE_DIRECTORY_SERVER
TRACE_DIRECTORY_SERVER
Example entry...
TRACE_DIRECTORY_SERVER=/u01/app/oracle/product/180000/network/trace
TRACE_FILE_SERVER
TRACE_FILE_SERVER
Example entry...
TRACE_FILE_SERVER=server.trc
TRACE_FILELEN_SERVER
TRACE_FILELEN_SERVER
TODO
TRACE_FILENO_SERVER
TRACE_FILENO_SERVER
TODO
TRACE_LEVEL_SERVER
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
TRACE_TIMESTAMP_SERVER
TODO
tnsping
tnsping
TNSPING.TRACE_LEVEL
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
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://support.oracle.com Troubleshooting Guide ORA-3136: WARNING Inbound Connection Timed Out (Doc ID 465043.1)https://docs.oracle.com/cd/B19306_01/network.102/b14213/listener.htm#i503196
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://support.oracle.com Troubleshooting Guide ORA-3136: WARNING Inbound Connection Timed Out (Doc ID 465043.1)https://docs.oracle.com/cd/B19306_01/network.102/b14213/listener.htm#i503196
Page updated
Google Sites
Report abuse