The USE_SHARED_SOCKET=TRUE is for use with a firewall. if you have one i
suggest you see if changes have been made to it. otherwise i'd look at the
network setup.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"lordfener" <lordfener_at_infinito.it> wrote in message
news:490082e2.0306270123.56b28061_at_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 - 07:10:02 CDT
