Home » SQL & PL/SQL » SQL & PL/SQL » How to produce trace file?
How to produce trace file? [message #215078] Fri, 19 January 2007 03:58 Go to next message
siddarth
Messages: 1
Registered: January 2007
Location: india
Junior Member
Hi,

I created a sqlnet.ora file with the below contents under $ORACLE_HOME/network/admin, after that I am running a script which will update the database.But I couldn't find any trace generated under trace directory?
Please help me in this regard.

sqlnet.ora:
TRACE_LEVEL_CLIENT=16
TRACE_UNIQUE_CLIENT=ON
TRACE_FILE_CLIENT=client.trc
TRACE_DIRECTORY_CLIENT=/opt/oracle/10.1.0.3/network/trace
TRACE_TIMESTAMP_CLIENT=ON

-Thanks
Re: How to produce trace file? [message #215106 is a reply to message #215078] Fri, 19 January 2007 05:53 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I don't see anything wrong with those settings.

Did you disconnect from SQL*Plus and reconnect after setting the trace parameters? Do you only have one sqlnet.ora file? Are you sure that directory exists?

[Updated on: Fri, 19 January 2007 06:02]

Report message to a moderator

Re: How to produce trace file? [message #215110 is a reply to message #215106] Fri, 19 January 2007 06:22 Go to previous message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

You have to disconnect/connect to "force" an "error" to get the file created.

[Updated on: Fri, 19 January 2007 06:22]

Report message to a moderator

Previous Topic: UTL_SMTP
Next Topic: Changing datatype for the existing column
Goto Forum:
  


Current Time: Wed Dec 07 02:49:12 CST 2016

Total time taken to generate the page: 0.11571 seconds