Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Re: SQLnet logg...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 6 Topic 16545 of 17418
Post > Topic >>

Re: SQLnet logging/tracing

by "fitzjarrell@[EMAIL PROTECTED] " <oratune@[EMAIL PROTECTED] > May 12, 2008 at 10:20 AM

On May 12, 11:20=A0am, 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?  I expect not.


David Fitzjarrell
 




 6 Posts in Topic:
SQLnet logging/tracing
grz01 <grz01@[EMAIL PR  2008-05-12 09:20:58 
Re: SQLnet logging/tracing
"fitzjarrell@[EMAIL   2008-05-12 10:20:17 
Re: SQLnet logging/tracing
grz01 <grz01@[EMAIL PR  2008-05-12 12:47:03 
Re: SQLnet logging/tracing
"fitzjarrell@[EMAIL   2008-05-12 13:14:01 
Re: SQLnet logging/tracing
grz01 <grz01@[EMAIL PR  2008-05-12 15:20:12 
Re: SQLnet logging/tracing
"fitzjarrell@[EMAIL   2008-05-13 07:15:04 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 15:49:23 CST 2008.