OraFAQ Forum: SQL & PL/SQL » How to produce trace file?

Home » SQL & PL/SQL » SQL & PL/SQL » How to produce trace file?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to produce trace file? [message #215078]

Fri, 19 January 2007 03:58

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

Report message to a moderator

Re: How to produce trace file? [message #215106 is a reply to message #215078]

Fri, 19 January 2007 05:53

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 12 08:00:30 CST 2024