Shulou(Shulou.com)06/01 Report--

[phenomenon]

* Fatal NI connect error 12170. VERSION INFORMATION: TNS for Linux: Version 12.1.0.2.0-Production Oracle Bequeath NT Protocol Adapter for Linux: Version 12.1.0.2.0-Production TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.2.0-Production Time: 21-MAR-2018 14:01:26 Tracing not turned on. Tns error struct: ns main err code: 12535 TNS-12535: TNS:operation timed out ns secondary err code: 12606 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 Client address: (ADDRESS= (PROTOCOL=tcp) (HOST=192.168.1.81) (PORT=52933)) Wed Mar 21 14:01:26 2018WARNING: inbound connection timed out (ORA-3136) Wed Mar 21 14:01:26 2018 * * * *

[reason]

1. Because of a large number of malicious connections, it is correct to report an error and terminate the client connection.

two。 The connection is normal, but the login verification is not completed within 60 seconds of SQLNET.INBOUND_CONNECT_ timeout value.

3. The database server has a high load, similar to HANG.

[solution]

(1) View the current sqlnet.ora

[oraprod@erpdb PROD_erpdb] $cat sqlnet.ora# Do not edit settings in this file manually. They are managed# automatically and will be overwritten when AutoConfig runs.# For more information about AutoConfig, refer to the Oracle# E-Business Suite Setup Guide.##$Header: NetServiceHandler.java 120.28.12020000.8 2016-03-30 11:22:32 kmandal ship $# NAMES.DIRECTORY_PATH= (TNSNAMES ONAMES, HOSTNAME) SQLNET.EXPIRE_TIME= 10SQLNET.INBOUND_CONNECT_TIMEOUT = 60SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

(2) check the INBOUND_CONNECT_TIMEOUT_PROD of the current listener:

LSNRCTL > show inbound_connect_timeoutConnecting to (ADDRESS= (PROTOCOL=tcp) (HOST=) (PORT=1521)) LISTENER parameter "inbound_connect_timeout" set to 60The command completed successfully

(3) Oracle recommends that the value of sqlnet.ora INBOUND_CONNECT_TIMEOUT is greater than the value of INBOUND_CONNECT_TIMEOUT_PROD in listener.ora--.

For example:

Sqlnet.oraSQLNET.INBOUND_CONNECT_TIMEOUT = 120

Listener.oraINBOUND_CONNECT_TIMEOUT_PROD = 119

Verify:

LSNRCTL > show inbound_connect_timeout

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.