WARNING: inbound connection timed out (ORA-3136)

周末有个单机报错，

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=172.16.55.197)(PORT=41994))
WARNING: inbound connection timed out (ORA-3136)

直接上mos文档

 465043.1  Troubleshooting ORA-3136 WARNING Inbound Connection Timed Out

故障排除指南 ORA-3136：WARNING Inbound Connection Timed Out (Doc ID 2331569.1)

将数据库listener.ora和sqlnet.ora的超时设置为0
（即不限制，Oracle 11g默认值为60s，大规范并发情况下，如同时2000以上个业务连接，60s超时设置通常导致大部分应用不能在此期间连接上数据库），然后重启监听。
$  echo 'SQLNET.INBOUND_CONNECT_TIMEOUT = 0' >> $ORACLE_HOME/network/admin/sqlnet.ora
$   echo 'INBOUND_CONNECT_TIMEOUT_LISTENER = 0' >> $ORACLE_HOME/network/admin/listener.ora

$ lsnrctl stop; lsnrctl start