Re: 10046 - Unable to trace JDBC thin client?

From: Michael Thomas <mhthomas_at_yahoo.com>
Date: Tue, 17 Aug 2004 16:01:11 -0700 (PDT)
Message-ID: <20040817230111.93397.qmail@web50601.mail.yahoo.com>

Hi,

Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> I am able to get sql traces for jdbc thin client
> connections using
> dbms_system.set_ev.
>
> At 01:14 PM 8/17/2004, you wrote:
> >None taken, sometimes it is the obvious. In this
> case I have cleared out
> >the entire directory prior to my tests. In
> addition, I have successfully
> >executed the same process with a SQL*Plus session.
> >I will be researching the oradebug and set_ev
> methods to see if I receive
> >similar results. Thanks for all the input.
>
... I'm doing this from two years old memory, sorry if its muddy. :-) ...

Do I remember making thin client connections with both tnsnames.ora and without tnsnames.ora from a client? There are so many types of JDBC connection and parameter combinations with Oracle client and server I may be mistaken. If so, sorry.

But, in the *without* tnsnames.ora case, the JDBC connection could build the required connection information without tnsname.ora depending on (one of the many flavors of) how the connection object was instantiated.

It might help to post the bit of JDBC code you are using to connect from the client. This might insure everyone understands your test.

I'm suggesting this because it seems to me like the trace should be working, and maybe its something else unusual?

HTH Regards,

Mike Thomas

Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Aug 17 2004 - 17:56:57 CDT