On May 12, 5:20=A0pm, grz01 <gr...@[EMAIL PROTECTED]
> wrote:
> On May 12, 10:14 pm, "fitzjarr...@[EMAIL PROTECTED]
" <orat...@[EMAIL PROTECTED]
> wrote:
>
>
>
>
>
> > On May 12, 2:47 pm, grz01 <gr...@[EMAIL PROTECTED]
> wrote:
>
> > > On May 12, 7:20 pm, "fitzjarr...@[EMAIL PROTECTED]
" <orat...@[EMAIL PROTECTED]
> wrote:
>
> > > > On May 12, 11:20 am,grz01<gr...@[EMAIL PROTECTED]
> 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.or=
a
> > > > > on both installations.
>
> > > > > LOG_DIRECTORY_CLIENT=3Dc:\oracle\log\
> > > > > LOG_FILE_CLIENT=3Dclient_log
> > > > > TRACE_DIRECTORY_CLIENT=3Dc:\oracle\log\
> > > > > TRACE_FILE_CLIENT=3Dclient_trace
> > > > > TRACE_FILELEN_CLIENT=3D10000
> > > > > TRACE_FILENO_CLIENT=3D5
> > > > > TRACE_LEVEL_CLIENT=3D16
> > > > > TRACE_TIMESTAMP_CLIENT=3DTRUE
> > > > > TRACE_UNIQUE_CLIENT=3DTRUE
>
> > > > > I have rebooted my machine, and ran some SQL-commands from TOAD
an=
d
> > > > > 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? =A0I 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. =A0Same 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
|
