From oracle-l-bounce@freelists.org Tue Aug 17 17:56:57 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i7HMuvF25357 for ; Tue, 17 Aug 2004 17:56:57 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i7HMuvI25352 for ; Tue, 17 Aug 2004 17:56:57 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D446C72C9EB; Tue, 17 Aug 2004 18:02:00 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27398-67; Tue, 17 Aug 2004 18:02:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 33C8572C8D3; Tue, 17 Aug 2004 18:02:00 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 17 Aug 2004 18:00:30 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 367A972C6D7 for ; Tue, 17 Aug 2004 18:00:29 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27859-23 for ; Tue, 17 Aug 2004 18:00:29 -0500 (EST) Received: from web50601.mail.yahoo.com (web50601.mail.yahoo.com [206.190.38.88]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id ADFE072C244 for ; Tue, 17 Aug 2004 18:00:28 -0500 (EST) Message-ID: <20040817230111.93397.qmail@web50601.mail.yahoo.com> Received: from [24.148.161.169] by web50601.mail.yahoo.com via HTTP; Tue, 17 Aug 2004 16:01:11 PDT Date: Tue, 17 Aug 2004 16:01:11 -0700 (PDT) From: Michael Thomas Subject: Re: 10046 - Unable to trace JDBC thin client? To: oracle-l@freelists.org In-Reply-To: <6.1.0.6.2.20040817141357.030865d8@pop.centrexcc.com> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 7813 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mhthomas@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi, --- Wolfgang Breitling 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@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 -----------------------------------------------------------------