 | |
TNSLSNR crashes on Windows
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
TNSLSNR crashes on Windows -
06-27-2003
, 04:23 AM
|
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. |
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 -
#2
| |||
| |||
|
|
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 - |
#3
| |||
| |||
|
|
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. |
The use_shared_socket = true is definitely not specifically for use
with a firewall. Also it seems to have been made obsolete in 9i
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address
#4
| |||
| |||
|
|
"Sybrand Bakker" <gooiditweg (AT) sybrandb (DOT) demon.nl> wrote in message news:sk0pfvgv1pfpmrpaqshs0u9hbnj32m9mbt (AT) 4ax (DOT) com... On Fri, 27 Jun 2003 13:10:02 +0100, "Niall Litchfield" n-litchfield (AT) audit-commission (DOT) gov.uk> wrote: 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. The use_shared_socket = true is definitely not specifically for use with a firewall. Also it seems to have been made obsolete in 9i Hi Sybrand Is USE_SHARED_SOCKET=TRUE used without a firewall between the clients and the db? If so why and under what circumstances? You will note that I didn't say *specifically* for use with a firewall, but that is the only time I have run across it. I wasn't aware that it was obsolete with 9i - but I expect that thats my ignorance showing. |
Hi Niall,
I definitely can imagine using it without a firewall, though basically
for administrative purposes: If you end up with many different
connections, and the server itself is using many different ports apart
from Oracle, and you want to identify the number of current Oracle
connections easily (on the tcp/ip level) it should be advantageous to
use this setting, as in that case you can easily grep or filter out
the default port. The first time I wanted to apply it was for that
purpose, though unfortunately it didn't yet work on NT
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.