Re: No trace file in udump

On Sep 6, 4:02 pm, sybra..._at_hccnet.nl wrote:
> On Thu, 06 Sep 2007 13:02:18 -0700, Krish <Krishna.Bu..._at_gmail.com>
> wrote:
>
>
>
>
>
> >Hi ,
>
> >I am trying to trace a perticular user sessions using a logon trigger.
> >This works fine if I connect to the database without tns alis.
> >Example : sqlplus scott/tiger
>
> >But no trace file is generating when I connect to the database using
> >TNS Alias.
> >Example: sqlplus scott/tiger_at_orcl
>
> >we are using Oracle9i Enterprise Edition Release 9.2.0.6.0 and the
> >database is running on Shared server mode.
>
> >user_dump_dest is already set. Please suggest.
>
> >Thanks,
> >Krish
>
> Trace files end up in ora_<sid>_S<nnnn>.trc and can end up in multiple
> trace files.
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -

Thanks for your reply Sybrand. But there were no files in udump and only alert_sid.ora in bdump. I even tried setting the trace_identifer .. no luck.

Thanks. Received on Thu Sep 06 2007 - 16:07:27 CDT