Re: where is my trace

"Howard J. Rogers" wrote:
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:tq786i9o6kr9c3_at_news.demon.nl...
> >
> > "Ban Spam" <ban-spam_at_operamail.com> wrote in message
> > news:Xns911D6EC97EED3SunnySD_at_24.0.3.73...
> > > "xxx" <www._at_ww.pl> wrote in news:9o02l3$baq$1_at_sunsite.icm.edu.pl:
> > >
> > > > Hi
> > > >
> > > > I can't find trace file in my oracle directory.
> > > > I set of course dump destination like:
> > > > background_dump_dest
> > > > user_dump_dest
> > > > core_dump_dest
> > > > but these are empty even I run 'alter database backup controlfile to
> > > > trace'. I set oracle_trace_enable = TRUE too.
> > > > Where should I search for it.
> > > >
> > > > Thanks in advance. Bartos
> > > >
> > > >
> > > On my Solaris system using OFA, the trace file is placed in
> > > /u01/app/oracle/admin/SID/bdump directory;
> > > where you replace "SID" with your actual value.
> > >
> > > HTH & YMMV, HAND!
> >
> >
> > Incorrect
> > The result of sql_trace and alter database backup controlfile to trace is
> > placed into the directory pointed to by the user_dump_dest parameter.
> > usually the file name has either the Unix pid or the NT thread number in
> it.
> > You can find that by running
> > select spid from v$process p, v$session s
> > where s.sid = (select sid from v$mystat where rownum = 1)
> > and p.addr = s.paddr
> >
> > Regards,
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
>
> Just to clarify (I hope):
>
> There *is* a parameter 'user_dump_dest', which can be pointed to any
> directory you fancy. But if that parameter is left out of the init.ora,
> then there is a *default* directory, which from memory is the
> ORACLE_HOME/admin/<SID>/udump directory mentioned by the earlier poster.
>
> I do believe, however, that I have seen an occasion on one of the training
> courses where a student's unix account had been set up incorrectly, such
> that he didn't have write permissions to the user_dump_dest specified in the
> init.ora -and trace files were requested but silently refused to be created.
> So maybe it's just a permissions problem.
>
> Regards
> HJR
Another obvious mistake I made recently was to forget to restart the instance after changing the parameter in the pfile to enable tracing.

mikejay Received on Wed Oct 03 2001 - 12:29:13 CDT