609 错误分析及解决方法(2)

client changed its mind and closed the connection immediately after initiating it
    client crashed
    firewall kills the connection
    some oracle timeout set on client
解决方案:

Because the entry from listener.log contains only CONNECT_DATA and CID related information we need to check the client configuration for any sqlnet  timeouts:

possible timeouts in sqlnet.ora in client oracle home:
    sqlnet.outbound_connect_time
    sqlnet.recv_timeout
    sqlnet.send_timeout
    tcp_connect_timeout

检查客户端目录中sqlnet.ora的超时设置,通常是这个引起的

possible timeout in client connect descriptor (hardcoded in client application or in client tnsnames.ora):
    connect_timeout

检查客户端应用或客户单tnsnames.ora中的超时参数

CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2

Oracle Linux 6.5安装Oracle 11.2.0.4 x64

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/56230557dc55d39628aaf3d1c3946da3.html