Oracle中session超时问题之监听SQLNET.EXPIRE_TIME

问题：在数据产品项目实施过程中遇到oracle跑批大数据量时，每次到2小时session就自动断了。

原因：内网服务器防火墙设置了2个小时的超时限定

解决方案：在oracle监听中添加SQLNET.EXPIRE_TIME=10

方案理由：

关于sqlnet.expire_time

 

 

Fatal NI connect error 12537, connecting to:

(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.xxx.xxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xxxx.com)(CID=(PROGRAM=oracle)(HOST=xxx)(USER=oracle11g))))

 

  VERSION INFORMATION:

    TNS for Linux: Version 11.2.0.4.0 - Production

    TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production

  Time: 18-APR-2014 11:05:46

  Tracing not turned on.

  Tns error struct:

    ns main err code: 12537

 

TNS-12537: TNS:connection closed

    ns secondary err code: 12560

    nt main err code: 507

 

TNS-00507: Connection c