***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 11-FEB-2015 14:04:13
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=192.168.110.152)(PORT=60059))
Wed Feb 11 14:05:35 2015
***********************************************************************
怎么搞?
------解决思路----------------------
alertlog中,前后有没有其他的错误信息?
有没有相应的trc文件?
------解决思路----------------------
60059端口被占用了吗?防火墙开了吗?listener进程在不?listener.ora配置正确吗?
------解决思路----------------------
贴出lisnter.log的内容
------解决思路----------------------
这是已知问题,因为中间有防火墙的缘故,不一定能解决,虽然告警但不影响应用,可以试试官方推荐的方法:
1.sqlnet.ora添加参数:
sqlnet.expire_time = 3
DIAG_ADR_ENABLED = OFF
2.Listener.ora添加:
DIAG_ADR_ENABLED_LISTENER = OFF
重启listener