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

The cause of the problem:

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.3.0-Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0-Production

TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.3.0-Production

Time: 24-MAY-2017 18:40:22

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.2) (PORT=44430))

WARNING: inbound connection timed out (ORA-3136)

Wed May 24 18:45:22 2017

Solution:

[oracle@ogg3 ~] $cd / u01/app/oracle/product/11.2.0/dbhome_1/network/admin/

[oracle@ogg3 admin] $vim listener.ora

INBOUND_CONNECT_TIMEOUT_LISTENERNAME = 0

[oracle@ogg3 admin] $vim sqlnet.ora

DIAG_ADR_ENABLED=OFF

SQLNET.INBOUND_CONNECT_TIMEOUT = 0

[oracle@ogg3 admin] $lsnrctl

LSNRCTL for Linux: Version 11.2.0.3.0-Production on 28-JUN-2017 18:03:55

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL > reload

LSNRCTL > exit

[oracle@ogg3 admin] $

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.