Re: unable to generate trace on HP-UX
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: sjaffarhussain@xxxxxxxxx
- Date: Mon, 14 Aug 2006 10:38:02 +0200
Perhaps you have enabled the trace in a certain session, analyzed (and
removed) the tracefile and disabled the event.
If you then, later on re-enable the trace for the same session, no trace
file will be written.
The reason is, that Oracle keeps the file descriptor open, pointing to the
"old" file still, which isn't there anymore. No new file will be created.
A workaround is, BEFORE you enable your event, figure out the name of the
tracefile that will be written to (ORacle uses uniform formats, can easily
be predicted) , and put a named pipe in its place. Then, when you enable the
trace, you start reading from that pipe (using i.e. tail -f ), and write
that output to a file you want to analyze. Using this technique, you can
easily enable and disable the trace, and it'll work just fine, as long as
the named pipe stays in place.
Stefan
On 8/14/06, Syed Jaffar Hussain <sjaffarhussain@xxxxxxxxx> wrote:
Hello List,
Recent past, we were able to generate trace files (setting events) on
one of our database (9i) on HP-UX.
Today, surprisingly, when we set trace, there is no trace file
generated at the udump?
What could cause this problem? There is another db running on the same
server, were trace files are generating.
--
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g OCP DBA
Banque Saudi Fransi,
Saudi Arabia
I blog at :http://jaffardba.blogspot.com/
http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
--
//www.freelists.org/webpage/oracle-l
Other related posts:
