Re: Net8 Tracing problem

Hi, Pete:

Pete Sharman <psharman_at_us.oracle.com> writes:

> This is a multi-part message in MIME format.
> --------------E55EF29B9BDD45C0250B3929
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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.
Unless you're suspecting that the listener is having problems, such as the process is not spawning, turning on listener tracing is not needed.

                                      Rick

>
> 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
>
>
> --------------E55EF29B9BDD45C0250B3929
> Content-Type: text/x-vcard; charset=us-ascii;
> name="psharman.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Pete Sharman
> Content-Disposition: attachment;
> filename="psharman.vcf"
>
> begin:vcard
> n:Sharman;Peter
> tel;cell:+1.650.868.9969
> tel;fax:+1.650.633.1669
> tel;work:+1.650.607.0109
> x-mozilla-html:FALSE
> url:http://www.oracle.com
> org:Oracle University, Consulting and Vertical Education;Oracle Corporation
> adr:;;500 Oracle Parkway M/S OPL-B1024;Redwood Shores;California;94065;USA
> version:2.1
> email;internet:psharman_at_us.oracle.com
> title:Project Manager [Quoted]
> note;quoted-printable:=0D=0A=0D=0A **** The statements and opinions expressed here are my **** =0D=0A **** own and do not necessarily represent those of **** =0D=0A **** Oracle Corporation. =20 ****=0D=0A=0D=0A"Controlling application developers is like herding cats." =0D=0AKevin Loney, ORACLE DBA Handbook =0D=0A=0D=0A"Oh no it's not! It's much harder than that!" =0D=0ABruce Pihlamae, long term ORACLE DBA
> x-mozilla-cpt:;9200
> fn:Pete Sharman
> end:vcard
>
> --------------E55EF29B9BDD45C0250B3929--
>

-- 
                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com