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 > SQLnet logging/...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 16545 of 17140
Post > Topic >>

SQLnet logging/tracing

by grz01 <grz01@[EMAIL PROTECTED] > May 12, 2008 at 09:20 AM

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
 




 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 Sun Sep 7 18:58:02 CDT 2008.