Re: Getting Oracle to tell me why it's unhappy

From: John van Eck <JvanEck_at_ssc.dordrecht.nl>
Date: Mon, 14 May 2001 16:04:24 +0200
Message-ID: <3AFFE5E8.6B19C12A@ssc.dordrecht.nl>

Hi,

I just encountered this dicussion and by chance I needed the TRACE_LEVEL_CLIENT myself not so long ago. There is documentation on this point, I got the information from page C-18 from the Net8 release 8.0.5 For windows NT and Windows 95/98 Getting Started manual in the chapter about understanding the SQLNET.ORA file.
Hope this is of some help.

John van Eck, DBA

Sybrand Bakker schreef:

> "Calvin Crumrine" <Calvin_Crumrine_at_dced.state.ak.us> wrote in message
> news:3AF8486A.2B9868F3_at_dced.state.ak.us...
> > Sybrand Bakker wrote:
> >
> > > "Antti Järvinen" <costello_at_iki.fi> wrote in message
> > > news:m31yq0gdth.fsf_at_cs72168.pp.htv.fi...
> > > > stanb_at_panix.com (Stan Brown) writes:
> > > > > So (finally) here's the question. How can I configure Oracle to
 give me
> > > > > the gory details f what the appliaction is requestiong Oracle to
 do,
> > > > > preferably just when it fails, as the application ogs _a lot_ of
 data
 to
> > > > > Oracle.
> > > >
> > > > Several people have suggested turning trace on in the db instance or
 session
> > > > which can be done no prob. Another way of doing this is to turn trace
> > > > on on sql*net, but of course only if your app connects via sql*net. So
> > > > in the

 $ORACLE_HOME/app/oracle/product/version/network/admin/sqlnet.ora
> > > > of your client machine say something like
> > > > LOG_DIRECTORY_CLIENT=/specify/here/a/directory
> > > > TRACE_DIRECTORY_CLIENT=/specify/here/a/directory
> > > > TRACE_LEVEL_CLIENT=SUPPORT
> > > > or maybe
> > > > TRACE_LEVEL_CLIENT=19
> > > > (or 9, or other random number that is documented nowhere?)
> > > > then run your app and in the sqlnet.log and sqlnet.trc files that
> > > > appear in the specified directory you should find also your
> > > > sql statements. Bad thing here is that it may be difficult to
> > > > try finding values of possible bind variables, that here are
> > > > of somewhat interest..
> > > >
> > > > --
> > > > Antti Järvinen, costello_at_iki.fi
> > > > "concerto for two faggots and orchestra"
> > >
> > > The magic number is *16*
> > >
> > > Hth,
> > >
> > > Sybrand Bakker, Oracle DBA
> >
> > Of course-it had to be either 16 or 9, as any good mystic could tell you.
 Is
> > there documentation for 16?
> >

>

> Maybe there is (in the net8 administrators guide) maybe there's not. I
> learned the trick from someone ages ago (some 4 years) and I even don't
> remember from whom.

>

> Regards,

>
> Sybrand Bakker, Oracle DBA
  Received on Mon May 14 2001 - 09:04:24 CDT