TNS-12535: TNS:operation timed out (WARNING: inbound connection timed out (ORA-3136))

問題原因:

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

解決方法:

[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]$

本文轉自 z597011036 51CTO部落格，原文連結：http://blog.51cto.com/tongcheng/1929113，如需轉載請自行聯系原作者