Home » Infrastructure » Windows » Client Logging (Windows 7)
Client Logging [message #530075] Fri, 04 November 2011 08:41 Go to next message
Messages: 1
Registered: November 2011
Junior Member
I am trying to trouleshoot an issue with Oracle and want to see what commands are being sent by by process. By reading the documentation it appears there is client logging to do this but I can not get it to work. I added the following commands to my SQLNET.ORA file but no log file is created:

tnsping.trace_directory = C:\app\product\11.2.0\client_4\network\trace
tnsping.trace_level = admin
trace_level_client = user
trace_directory_client = C:\log
log_directory_client = C:\log
trace_unique_client = on
trace_timestamp_client = on

Ths TNSPING works just fine it logs the information I expect.

The client logging, however, never creates a file . Any help would be appreciated.
Re: Client Logging [message #530078 is a reply to message #530075] Fri, 04 November 2011 09:01 Go to previous messageGo to next message
Messages: 26763
Registered: January 2009
Location: SoCal
Senior Member
above will capture & record all SQL issued.
Re: Client Logging [message #530079 is a reply to message #530075] Fri, 04 November 2011 09:14 Go to previous message
John Watson
Messages: 8542
Registered: January 2010
Location: Global Village
Senior Member
What you are doing won't work with 11g (which is why you are always meant to include your exact release.) If you you don;t want to use the 11g ADR facility, you'll need to do this:
trace_level_client = support
trace_directory_client = C:\tmp

Previous Topic: Oracle Non Transaction Inserts
Next Topic: Remote Oracle Service
Goto Forum:

Current Time: Fri May 07 04:49:24 CDT 2021