Re: ODBC and SQLNET.LOG

In article <8p9v94$ige$15$1_at_news.t-online.com>,   "Dieter Gontermann" <SHPFrankfurt_at_shp-frankfurt.de> wrote:
> I didn't explicit turn on logging on the SQL*Net connection. But how
 can I
> turn it off?
> Is there any flag in the registry?

• I assume you've checked in the ODBC Data Source Administrator that you've not turned logging on there.
• Are you certain that no one has turned on SQL*Net logging? It definitely isn't turned on by default.
• To turn off SQL*Net tracing, open the file sqlnet.ora in your %ORACLE_HOME%\network\admin directory and make sure you have the line TRACE_LEVEL_CLIENT = OFF

Opinions expressed herein are my own and may not reflect those of Oracle Corporation.

>
> Dieter Gontermann
>
> <jocave_at_my-deja.com> schrieb in im Newsbeitrag:
> 8p6hlj$n84$1_at_nnrp1.deja.com...
> > In article <8p2asq$5u6$16$1_at_news.t-online.com>,
> > "Dieter Gontermann" <SHPFrankfurt_at_shp-frankfurt.de> wrote:
> > > I have serious problems with an ODBC-link to an Oracle-Database on
 a
 remote
> > > location. Whenever the line is down and a connection cannot be
 established,
> > > the ODBC driver creates a SQLNET.LOG file in the winnt/system32
 directory
> > > which grows up unlimited to more than 900 MB (not KB), so that the
 free
> > > diskspace is less than 5 Kb and the system is going down more or
 less.
> > >
> > > My question:
> > >
> > > Is there any way to either stop logging Oracle this way or to
 limit
 the file
> > > size for the SQLNET.LOG?
> >
> > I'm not certain that that the ODBC driver has anything to do with
> > generating this file. Unless you've explictly turned logging on
 (from
> > the ODBC Data Source Administrator | Tracing) and set the log file
 to
> > SQLNET.LOG, the ODBC driver shouldn't be logging anything, much less
 900
> > MB!
> >
> > Is it possible that you've turned on logging of your SQL*Net
 connection?
> >
> > Justin Cave
> > Oracle ODBC Development
> >
> > Opinions expressed herein are mine and may not reflect those of
 Oracle
> > Corporation
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 12 2000 - 00:01:06 CEST