Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Getting Oracle to tell me why it's unhappy

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

From: Calvin Crumrine <Calvin_Crumrine_at_dced.state.ak.us>
Date: Tue, 08 May 2001 11:26:35 -0800
Message-ID: <3AF8486A.2B9868F3@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? Received on Tue May 08 2001 - 14:26:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US