调度出现TNS-12535: TNS:operation timed out、TNS-00505: Operation timed out错误信息

alert.log报的错误信息如下:

Fatal NI connect error 12170.

  VERSION INFORMATION:
    TNS for Linux: Version 11.2.0.1.0 - Production
    TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
  Time: 12-AUG-2015 06:15:03
  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=***.***.***.***)(PORT=1521))

查相关资料:处理如下:

分别在 listener.ora,sqlnet.ora加入如下内容:在重启监听

listener.ora
INBOUND_CONNECT_TIMEOUT_LISTENER = 0
DIAG_ADR_ENABLED_LISTENER = OFF

sqlnet.ora
DIAG_ADR_ENABLED = OFF
SQLNET.INBOUND_CONNECT_TIMEOUT =0

posted @ 2015-08-17 10:25  lottu  阅读(1715)  评论(0)    收藏  举报