急！！求助！！oracle11g rac 总是有Fatal NI connect error 12170 怎么解决

[weixin_40454244]

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for Solaris: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for Solaris: Version 11.2.0.4.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 11.2.0.4.0 - Production
Time: 09-MAR-2018 14:04:05
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: 145
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.xx)(PORT=35629))
oracle11grac 告警日志中 总是会出现这样的错误，请问各位大佬，该怎么解决

[学海无涯-回头是岸]

只是alert 里面报错? 系统上有什么问题出现吗?

[weixin_40454244]

引用 1 楼 baidu_36457652 的回复:

只是alert 里面报错? 系统上有什么问题出现吗?

系统后台会报这个 但是比alter 中的少java.sql.SQLRecoverableException: IO 错误: Connection timed out

[学海无涯-回头是岸]

lsnectl status 看看监听状态

[weixin_40454244]

引用 3 楼 baidu_36457652 的回复:

lsnectl status 看看监听状态

LSNRCTL for Solaris: Version 11.2.0.4.0 - Production on 14-MAR-2018 18:01:12 Copyright (c) 1991, 2017, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Solaris: Version 11.2.0.4.0 - Production Start Date 12-MAR-2018 18:11:56 Uptime 1 days 23 hr. 49 min. 16 sec Trace Level off Security ON: Local OS Authentication SNMP ON Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/11.2.0/grid/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxxxx)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxxxxxxxx)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "wind" has 1 instance(s). Instance "wind1", status READY, has 1 handler(s) for this service... Service "windXDB" has 1 instance(s). Instance "wind1", status READY, has 1 handler(s) for this service... The command completed successfully 监听状态好像没什么异常

[好记忆不如烂笔头abc]

参看这 http://www.xifenfei.com/2014/09/alert-log-errors-12170-tns-12535tns-00505-operation-timed-out.html

[weixin_40454244]

已经修改了 ，会话保持，不知道问题能否顺利解决