We had this problem ALOT with various releases and patch levels of Oracle
7.x on NT 3.51 and NT 4.0
We never did totally figure it out.
A reboot of the server always fixed it for a while.
I told the clients that as far as I could determine, NT just got tired after
a while.
I reccomended that they reboot the server on a reqular basis ( every week or
two) and that seemed to keep the problem at bay.
Of course for a 24/7 shop this would not work but then again, a 24/7 shop
probably would not try NT yet.

We ran these problems by Oracle and they, of course, always had us patch to
the next patch level.
Occassionally, this actually seemed to help.
At one time, I could have told you that 7.x.x.x.22 worked while an earlier
or a later patch level did not work. ( forgot actual numbers though .22 was
one of them). We had the problem with 7.1 thru 7.3

I thought I had narrowed it down to being a problem with the MTS servers as
turning the multi-threaded listener off seemed to help sometimes but since
it did not work EVERY time, it may have been something entirely different.

I think it was a memory leak of some kind but we never really found out what
the problem was.
It just went away with later releases.

It disturbs me to find that it is baaaacccck.
Maybe we, or Oracle, can finally figure it out this time.
It only seemed to happen on NT systems though.

da



----- Original Message -----
From: "Trilling, Jeff" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, March 28, 2002 12:59 PM
Subject: corrupted listener???


> Dear Gurus -
> All of a sudden my users can't connect and get:
> TNS-12500: TNS:listener failed to start a dedicated server process
> I did a lsnrctl status and it says the service handlers are up. I
> did lsnrctl stop, lsnrctl start and lsnrctl reload. I shut down the
listener
> service (NT) and restarted, Nothing seemed to help. I can connect to the
> database from the server but not from any of the clients. I turned on
> tracing but nothing seems abnormal. I shut down the database and restarted
> and this did not help. The only remedy was a reboot of the server which
> corrected the problem. Any body seen this ? Ora-817 NT4 - Thanks in
advance
> - Jeff
>
>
>
> --------
> Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>

Oracle LazyDBA home page