Home » Infrastructure » Windows » Client Logging (Windows 7)
Client Logging [message #530075] Fri, 04 November 2011 08:41 Go to next message
notjust
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
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ALTER SESSION SET SQL_TRACE=TRUE
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: 8922
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:
diag_adr_enabled=off
trace_level_client = support
trace_directory_client = C:\tmp
trace_file_client=t


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


Current Time: Thu Mar 28 08:08:51 CDT 2024