• sqlnet.expire_time


    应用一直好好的,突然有一天,日志中开始时不时的出现ora-03135,奇了怪。查了一下——

    bash-2.05$ oerr ora 3135
    03135, 00000, "connection lost contact"
    // *Cause:  1) Server unexpectedly terminated or was forced to terminate.
    //          2) Server timed out the connection.
    // *Action: 1) Check if the server session was terminated.
    //          2) Check if the timeout parameters are set properly in sqlnet.ora.

    在$ORACLE_HOME/network/admin/sample/sqlnet.ora中找了一下有这一小节——

    ########################
    #sqlnet.expire_time = 10
    ########################
    #
    #Possible values: 0-any valid positive integer! (in minutes)
    #Default: 0 minutes
    #Recommended value: 10 minutes
    #
    #Purpose: Indicates the time interval to send a probe to verify the
    #         client session is alive (this is used to reclaim watseful
    #         resources on a dead client)
    #
    #Supported since: v2.1

    于是,在sqlnet.ora中加入

    sqlnet.expire_time = 10


    重启listener

    bash-2.05$ lsnrctl reload

    ……
    The command completed successfully

    观察两天,日志中未再报ora-03135错误了。


    文章出处:DIY部落(http://www.diybl.com/course/7_databases/oracle/oraclejs/2008727/134173.html)

  • 相关阅读:
    poj 1611 The Suspects
    POJ 2236 Wireless Network
    POJ 1703 Find them, Catch them
    poj 1733 Parity game
    hdu 1598 find the most comfortable road
    cmake的使用二:链接第三方静态库
    线段树基础
    迪杰斯特拉算法
    Floyd详解
    STL中的set使用方法详细
  • 原文地址:https://www.cnblogs.com/luluping/p/1683179.html
Copyright © 2020-2023  润新知