SQLNET.ORA Parameters: SQLNET.EXPIRE_TIME & SQLNET.INBOUND_CONNECT_TIMEOUT
Finally after a long long time posting on this blog. Hi All, Oracle documentation states SQLNET.EXPIRE_TIME parameter is used to avoid unused sessions to be kept open in database and locking resources. For SQLNET.INBOUND_CONNECT_TIMEOUT, it states: If the client fails to establish a connection and complete authentication in the time specified, then the database server terminates the connection. In addition, the database server logs the IP address of the client and an ORA-12170: TNS:Connect timeout occurred error message to tnslsnr diag destination ($ORACLE_HOME/diag/tnslsnr/<listener_name>/trace/<listener.log> . The client receives either an ORA-12547: TNS:lost contact or an ORA-12637: Packet receive failed error message.and also records in alert log if audit is enabled for IPs. In our environment both parameters are set for default value which I feel were too low SQLNET.EXPIRE_TIME (0 - disabled) & SQLNET.INBOUND_CONNECT_TIMEOUT (60 seconds), potent