Re: No trace file in udump

From: <sybrandb_at_hccnet.nl>
Date: Thu, 06 Sep 2007 23:02:10 +0200
Message-ID: <vkq0e3lvhpvkv4n0utiam6tg2lcvlf0jih@4ax.com>

On Thu, 06 Sep 2007 13:02:18 -0700, Krish <Krishna.Bussu_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

Received on Thu Sep 06 2007 - 16:02:10 CDT