TNSLSNR crashes on Windows

From: lordfener <lordfener_at_infinito.it>
Date: 27 Jun 2003 02:23:10 -0700
Message-ID: <490082e2.0306270123.56b28061@posting.google.com>

Hi all,
i got the same problem (Win2000pro SP2 + Oracle9i rel. 2):

> Benjamin Day wrote on 2003-02-04 14:01:34 PST
> 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 managed to achieve a limited amount of success by doing the
> following
> - go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
> - Add new string value USE_SHARED_SOCKET = TRUE
> Now I can connect without TNSLSNR.EXE crashing. I can still crash it
> by doing a TNSPING.

Few days ago I experienced a similar problem: before adding the registry key, every connection attempt made the listener crash (tnsping, sqlplus, export, OWB client, etc...), with this new key every connection works again but tnsping, which still makes listener crash !

The bad side of the story is that everything worked perfectly for almost nine months, until 2-3 weeks ago !! :-( I didn't install huge software, except Sun JDK 1.4.1_03 and a few video editing tools.

I experienced another strange behaviour, which might be correlated: the HTTP (Apache) server coming with 9i server is now useless: I had to stop the service because, about half a minute after starting, i takes 100% cpu and starts fastly writing GBytes of log file (%ORACLE_HOME%\Apache\Apache\logs\error_log) until HD is full !

• BEGIN LOG ------ Here follows a piece of this infinite log: [Fri Jun 27 10:07:02 2003] [warn] FastCGI: server "e:/oracle/ora92/bin/isqlplus" (pid 988) terminated with exit with status '8092272' [Fri Jun 27 10:07:07 2003] [warn] FastCGI: server "e:/oracle/ora92/bin/isqlplus" restarted (pid 744) [Fri Jun 27 10:07:08 2003] [warn] FastCGI: server "e:/oracle/ora92/bin/isqlplus" can't be restarted:exceeded max restarts [Fri Jun 27 10:07:08 2003] [warn] FastCGI: server "e:/oracle/ora92/bin/isqlplus" can't be restarted:exceeded max restarts [Fri Jun 27 10:07:08 2003] [warn] FastCGI: server "e:/oracle/ora92/bin/isqlplus" can't be restarted:exceeded max restarts (... and so on ...)
• END LOG ------

Might it be a correlation between these two problems ? Any suggestion ?

Thanks in advance,

   Stefano

• Oracle 8i DBA -
• QuasarItaliaGroup -

Received on Fri Jun 27 2003 - 04:23:10 CDT