Re: sqlnet.ora question

From: Manoj Appully <manoj.appully_at_bridge.bellsouth.com>
Date: 1997/01/28
Message-ID: <32EE681B.6946@bridge.bellsouth.com>#1/1

Mike Moritz wrote:

Can anyone tell me when sqlnet.ora is read? Oracle support says
"Each time a SQL*Net connection is established." My testing seems
to show that I have to shutdown the database and start it up again.

I've tried stopping and re-starting the TNS listener but that doesn't seem to do it.

I'm experimenting with the Dead Connection Detection parameter
"sqlnet.expire_time"

I'm running Oracle7 Server 7.1.4.1.0 and TNSLSNR 2.1.4.1.0 on an HP 9000/800 HP-UX 9.04

Thank you

     __  __  _  _
    |  \/  |(_)| |__ ___                                   __o
    | |\/| || || / // -_)      Mike Moritz               _ \<._
    |_|  |_||_||_\_\\___|      mmoritz_at_netcom.com   ____(_)/ (_)____

Mike -

Make sure that sqlnet.ora is in $ORACLE_HOME/network/admin, set your expire_time = n where n = number of minutes.

Reload or bounce your listener.

But a word of caution beware of problems due to DCD being turned on, hope u know about it.

Hope this helps,

Manoj Received on Tue Jan 28 1997 - 00:00:00 CST