oracle11g tns-12535 tns-00505,[Oracle報錯]TNS-12535: TNS:operation timed out、TNS-00505: Operation time...

Oracle 11.2.0.4 x64

OS CentOS 6.6 x64

問題描述：

alert日志出現網絡錯誤如下

***********************************************************************

Fatal NI connect error 12170.

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.4.0 - Production

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

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

Time: 29-MAY-2018 12:03:36

Tracing not turned on.

Tns error struct:

ns main err code: 12535

TNS-12535: TNS:operation timed out

ns secondary err code: 12560

nt main err code: 505

TNS-00505: Operation timed out

nt secondary err code: 110

nt OS err code: 0

Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.68.196.88)(PORT=62731))

Tue May 29 12:03:45 2018

***********************************************************************

問題原因：

1、Client在default 60秒內沒有完成認證

2、網絡攻擊，例如：半開連接攻擊

3、DB負載太高

解決方案：

①sqlnet.ora文件加入SQLNET.INBOUND_CONNECT_TIMEOUT=0

To specify the time, in seconds, for a client to connect with the database server and provide the necessary authentication information.

Default 60 seconds(11.2)

②listener.ora文件加入INBOUND_CONNECT_TIMEOUT_listener_name=0

To specify the time, in seconds, for the client to complete its connect request to the listener after the network connection had been established.

Default 60 seconds(11.2)

③重載監聽lsnrctl reload

參考文檔：

-The End-

Tank

20180604