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: Net8 Tracing problem

Re: Net8 Tracing problem

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 12 Aug 1999 09:50:25 -0700
Message-ID: <37B2FB51.E6486D76@us.oracle.com>


Jason

You need to turn on tracing in the sqlnet.ora file on the server (TRACE_LEVEL_SERVER = 16 is the most detailed) and the listener.ora file (TRACE_LEVEL_listener_name = 16). It's detailed in the Net8 manual.

HTH. Pete

jason wrote:

> I've got a VB6 / ADO 2.1 / Ora 8.04 problem where I'm inserting records
> using a server-side cursor within a function, but when the VB executes the
> ADO Command - it completely blows with "at 0xXXXXXXXX referenced
> memory at 0xXXXXXXXX. The memory could not be written. "
>
> I'm trying to trace what happens on the server-side using Net8 Assistant. I
> can get a Client-side trace file but not a server-side one.
>
> 1) Could anyone help me get a server-side trace file (please) ?
> 2) If I could get a trace file, would it help me in finding if / where the
> Function / Cursor is erroring ?
> 3) Is there any documentation to help me translate the trace file ?
>
> TIA
> Any help would be very much appreciated.
> Jason

--
Regards

Pete


Received on Thu Aug 12 1999 - 11:50:25 CDT

Original text of this message

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