Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Intermittend ORA-12519, TNS:no appropriate service handler found

Re: Intermittend ORA-12519, TNS:no appropriate service handler found

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 27 Feb 2006 19:26:30 +0100
Message-ID: <dtvfgo$ngb$2@news5.zwoll1.ov.home.nl>


Robert Klemme wrote:

 >> I have seen *x systems go down to their knees with many connections,
>> especially because most systems take their time to clean up
>> disconnected sessions.
>> netstat may be of help here - check if you have many waiting
>> (TIME_WAIT).

>
> From what I've seen so far the machine is far from going down because of
> this but I'll try to dig into that.
>

I meant, the machine is no longer capable of handling new requests - all the indicators you query may indicate the machine has resources plenty, where in fact it is out of ports (64k max...).

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Mon Feb 27 2006 - 12:26:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US