Re: Oracle 9i Listener crashes after every logon

"Pieter" <pietje_at_gb.be> wrote in message news:dvjA7.9579$ic.645_at_afrodite.telenet-ops.be...
> I get the following error :
>
> Application Error
> The instruction at "0x6195.. referenced memory at "0x000000578", the
memory
> could not be read
>
> log file and trace file don't mention any problems. The listener is
> abruptly terminated.
>
> Is there a quick way to create a new listener service (and delete the old
> one) ?
>
> Peter
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:tt39chhljsmm77_at_corp.supernews.com...
> >
> > "Pieter" <pietje_at_gb.be> wrote in message
> > news:gQfA7.7796$ic.320_at_afrodite.telenet-ops.be...
> > > I installed Oracle 9i on Win 2000.
> > > Every time I connect my listener crashes. I uninstalled everything
and
> > did
> > > a reinstall : same problem !!
> > >
> > > I always get connected, but have to restart the listener.
> > >
> > > Does anybody have the same problem ?
> > >
> > >
> >
> > Please verify any error messages in

%ORACLE_HOME%\network\log\listener.log
> >
> > Hth
> >
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> >
> >
>
>

So it looks like an O/S and memory management problem. Usual questions to ask: how much memory and maybe in this case also: what else is running on that box?

If oradim still exists, you can use it to delete *any* service by using oradim -delete -service <servicename>

IIRC, starting lnsrctl when the service is not being present, creates the service.
This is definitely not documented.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Sat Oct 20 2001 - 15:34:04 CDT