On May 12, 2:47=A0pm, 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.ora
> > > 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 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? =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. Same for the web app.
David Fitzjarrell
|
