Re: No trace file in udump

On Sep 7, 10:57 am, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Krish 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
>
> Your tnsnames have "server=dedicated" by any chance?
> If so, your shared mode circuit isn't used.
>
> Perhaps "orcl" connects to something totally different?
> Like, on the moon?
>

And even further out, check the listener.ora on the server for a different ORACLE_HOME.

jg

--
@home.com is bogus.
Lies, Damn Lies, Statistics, Internet.
http://www.signonsandiego.com/uniontrib/20070907/news_1n7music.html