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

On May 12, 11:20*am, grz01 <gr...@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

On May 12, 7:20 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
> On May 12, 11:20 am,grz01<gr...@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 using http://127.0.0.1:8080/apex,
and EE using http://machinename:1158/em)
requires the TNSListener running,
so I guess sqlnet should still see the traffic...?

/grz01

On May 12, 2:47*pm, grz01 <gr...@spray.se> wrote:
> On May 12, 7:20 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>
>
>
>
>
> > On May 12, 11:20 am,grz01<gr...@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

On May 12, 10:14 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
> On May 12, 2:47 pm, grz01 <gr...@spray.se> wrote:
>
>
>
> > On May 12, 7:20 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>
> > > On May 12, 11:20 am,grz01<gr...@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/B...102/b14213.pdf

I would expect these parameters to change the default behaviour?
------------------ grz01

On May 12, 5:20*pm, grz01 <gr...@spray.se> wrote:
> On May 12, 10:14 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>
>
>
>
>
> > On May 12, 2:47 pm, grz01 <gr...@spray.se> wrote:
>
> > > On May 12, 7:20 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote:
>
> > > > On May 12, 11:20 am,grz01<gr...@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/B...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