DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oracle.exe error

  1. #1
    Join Date
    Mar 2002
    Posts
    56
    I am trying to configure dead connection cetection by setting
    SQLNET.EXPIRE_TIME=10 in sqlnet.ora file
    But after database is started I get an fatal Oracle.exe error and the instance and service are shutted down.
    Could you guys tell me what's wrong with this parameter?
    Thanx

  2. #2
    Join Date
    Jan 2001
    Location
    Vancouver, Canada
    Posts
    87
    Purposeof sqlnet.expire_time parameter is to "Determines time interval to send a probe to verify the session is alive".

    Default: None

    Minimum Value: 0 minutes

    Recommended Value: 10 minutes

    Example: sqlnet.expire_time=10
    ===========================
    You are not going to get information from using this parameter in sqlnet.ora file. Best is to turn the tracing on at support level and start database. Please check Oracle alert log and listener.log file before you proceed with more investigation.

    I hope this helps.

    Cheers!!!

    Mohammad Zahid
    Software Developer
    Database Management Applications.
    Vancouver, Canada
    E-mail: mzahid@shaw.ca

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width