Re: TNSLSNR crashes on Windows XP

Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<a6g04vkj39roqiip42u5mf59oesmrv8ric_at_4ax.com>...
> Apart from
>
> [04-FEB-2003 16:33:27:383] ntt2err: soc 268 error - operation=5,
> ntresnt[0]=524, ntresnt[1]=997, ntresnt[2]=0
>
> nothing to be seen
>
> And what is more: NO connection attempt to be seen.
> You did try to connect to the database?
> One would need you to do that (and leave tracing enabled of course) to
> look at something useful.
>
> Regards
> Sybrand Bakker, Senior Oracle DBA

The logs that I posted don't include any attempts to connect using SQLPlus. These only show my attempts to control and observe the listener through LSNRCTL.EXE. The traces that I've looked at from when I have issued an actual "connect" command are equally uninteresting.

It appears that TNSLSNR.EXE causes the WinXP equivalent of a Dr. Watson error (performs an operation that the OS deems illegal) and that the OS just kills the process. If TNSLSNR is killed, it wouldn't have the opportunity to write anything to the trace or listener log.

-Ben

> On 4 Feb 2003 14:01:34 -0800, benday_at_benday.com (Benjamin Day) wrote:
>
> >> > Does anyone have any guesses as to what the underlying problem(s)
> >> > could be?
> >>
> >> Best we have a look at your listener.ora, your sqlnet.ora and your
> >> tnsnames.ora. But since your original error indicates a problem in the
> >> oranttcp DLL, then it could be a corrupt install, a permissions problem, bad
> >> RAM or anything else. Which is why I'd re-install Windows, re-install Oracle
> >> and see if the problem is repeatable.
> >
> >Thanks Howard for taking a look and responding to my postings.
> >
> >Since re-building my laptop is going to be a wicked pain, I think I'd
> >like to try to eliminate everything else before I re-install.
> >
> >I think I've managed to re-define the problem a little. I can start
> >the listener through ControlPanel.Services and through LSNRCTL.EXE.
> >Through ControlPanel.Services it will start and stay running
> >indefinitely but if I try to query it's status through LSNRCTL it
> >immediately crashes. If I try to start it through LSNRCTL.EXE it
> >reports a successful start and then crashes.
> >
> >I've managed to get tracing turned on for the listener. I've posted
> >the trace file, log file, listener.ora, sqlnet.ora, and tnsnames.ora
> >at http://www.benday.com/oracleStuff
> >
> >I'd really appreciate it if you could take a look.
> >
> >Thanks,
> >-Ben
>
>

>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Feb 05 2003 - 06:06:24 CST