# Re: SQLnet logging/tracing

From: <fitzjarrell_at_cox.net>
Date: Tue, 13 May 2008 07:15:04 -0700 (PDT)
Message-ID: <2b908949-9848-4770-8e6f-20c7289e2b1b@b64g2000hsa.googlegroups.com>

On May 12, 5:20 pm, grz01 <gr..._at_spray.se> wrote:
> On May 12, 10:14 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>
>
>
>
>
> > On May 12, 2:47 pm, grz01 <gr..._at_spray.se> wrote:
>
> > > On May 12, 7:20 pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>
> > > > On May 12, 11:20 am,grz01<gr..._at_spray.se> wrote:
>
> > > > > Hello,
>
> > > > > Need some quick help...
>
> > > > > I have an XP-machine with Oracle 10g,
> > > > > both EE and XE installed as standard "starter databases" with the
> > > > > Installers.
>
> > > > > Now I wanted to turn on sql-net tracing/logging,
> > > > > so I created two directories C:\oracle\log and C:\oraclexe\log
> > > > > and added the lines below to %ORACLE_HOME%\NETWORK\ADMIN\sqlnet.ora
> > > > > on both installations.
>
> > > > > LOG_DIRECTORY_CLIENT=c:\oracle\log\
> > > > > LOG_FILE_CLIENT=client_log
> > > > > TRACE_DIRECTORY_CLIENT=c:\oracle\log\
> > > > > TRACE_FILE_CLIENT=client_trace
> > > > > TRACE_FILELEN_CLIENT=10000
> > > > > TRACE_FILENO_CLIENT=5
> > > > > TRACE_LEVEL_CLIENT=16
> > > > > TRACE_TIMESTAMP_CLIENT=TRUE
> > > > > TRACE_UNIQUE_CLIENT=TRUE
>
> > > > > I have rebooted my machine, and ran some SQL-commands from TOAD and
> > > > > the
> > > > > web-interfaces, but nothing ends up in this directory, it is still
> > > > > empty.
>
> > > > > I am obviously missing something trivial?
> > > > > What else do I need to do?
>
> > > > > TIA,
> > > > > ------------------------grz01
>
> > > > Did you also apply these changes to the sqlnet.ora files on the
> > > > machine where TOAD is installed and the machine where the web-based
> > > > application runs?  I expect not.
>
> > > > David Fitzjarrell
>
> > > Hi David,
>
> > > I am just running local, so host and client is same machine.
>
> > > Both TOAD and webinterface
> > > (XE using usinghttp://127.0.0.1:8080/apex,
> > > and EE usinghttp://machinename:1158/em)
> > > requires the TNSListener running,
> > > so I guess sqlnet should still see the traffic...?
>
> > > /grz01- Hide quoted text -
>
> > > - Show quoted text -
>
> > Then you should be looking for cli.trc files in the same directory
> > where the TOAD executables reside.  Same for the web app.
>
> > David Fitzjarrell
>
> Hi David,
> Hmm...
> First, I scanned my whole disk for files of pattern "cli*.trc", but no
> such.
> Second, I wonder... if it were the case as you say here,
> what is then the purpose of the parameters I listed above, and when/
> how are they used?
> They are described in pages 5-3 and 5-24ff of the "Net Services
> Reference 10g":
>
> http://download.oracle.com/docs/cd/B19306_01/network.102/b14213.pdf
>
> I would expect these parameters to change the default behaviour?
> ------------------ grz01- Hide quoted text -
>
> - Show quoted text -

And they should however you've been 'complaining' that you cannot find the trace files generated. By default any client tracing is found in a cli.trc file on a Windows machine, and it's usually found in the same directory where the application being traced was launched. However, your error here is in using the log directory for your trace files; when I use your settings I get no trace files written. When I change TRACE_DIR_CLIENT to c:\oracle\trace I immediately get trace files written for the currently connected session.

Change your TRACE_DIR_CLIENT setting to be some location other than the log directory you specified and you should see results.

David Fitzjarrell Received on Tue May 13 2008 - 09:15:04 CDT

Original text of this message