查看sqlnet.log,发现大量的
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for Linux: Version 10.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
Time: 10-JUN-2015 14:00:33
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS
peration 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
网上查询了相关问题,发现和ORA-3136 有关。网上提到可以在listener.ora中添加
INBOUND_CONNECT_TIMEOUT_listener_name=0,但我输入lisnrctl并查看参数
show inbound_connect_time后发现该值已经为0了。抱着试试看的心理在listener.ora文件中还是添了那一行。结果重启监听后客户端连接就一直报ORA-12505。监听都是用netca配置的默认配置,求指导。(还有就是会话环境配置等地方也没有做超时限制)。