Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help with Windows error

RE: Help with Windows error

From: Freeman, Donald <>
Date: Tue, 27 Jun 2006 16:43:35 -0400
Message-ID: <51327ABA927BEF4B96590554CEA7832C060B960D@enhbgpri05.backup>

It sounds like something is not getting closed down properly and eventually grabs all the resources until you have to reboot. There ought to be some windows tool that monitors the number of processes or number of links in use. In any event, it you have some kind of internally built application the problem could be there. I would have the SA take a look at it...unless of course that's you! There should be some way of monitoring the resources on the windows box and see what is consuming them.

-----Original Message-----
From: Igor Neyman [] Sent: Tuesday, June 27, 2006 4:40 PM
To:; Freeman, Donald;
Subject: RE: Help with Windows error

Your error message is about OS connections (or exceeding file system limit of connections to single file), not db links.

-----Original Message-----
Sent: Tuesday, June 27, 2006 4:26 PM
To: Freeman, Donald; Subject: RE: Help with Windows error

Yes. The problem crops up over time. I would say, on average, things run fine for 4-6 weeks. In that respect, it certainly seems like OS is hitting some sort of limit and then the problem(s) start.

The other tidbit I withheld is that there are 2 servers at this location and I have seen the same error on both - even though they are running different applications/databases. I thought Paul's question about the DB links was relevant but the developers assure me that any data used between/among the databases is extracted and loaded. I am not 100% convinced this is true, however.


> -----Original Message-----
> From: Freeman, Donald []
> Sent: Tuesday, June 27, 2006 2:19 PM
> To: Sweetser, Joe;
> Subject: RE: Help with Windows error
> Did it ever work? If it did, when did it start failing?
> -----Original Message-----
> From:
> [] On Behalf Of Sweetser, Joe
> Sent: Tuesday, June 27, 2006 3:52 PM
> To:
> Subject: Help with Windows error
> Oracle
> Windows 2000 SP4
> Intermittent error that (so far) is only resolved with a server
> Error manifests itself many ways but the most obvious are inability to

> connect to the database and/or inability to log into the server
> If you do get logged in to the server...inability to start an
> application; be it cmd or sqlplus. The error at that point is "Failed

> to initialize application". No errors in alert.log and database comes

> up fine after reboot.
> The only error I've found is in the listener.log and I can't figure
> the underlying Windows error truly means. I have googled and
> to no avail.
> 26-JUN-2006 10:23:18 * <snip> * establish * limsprod * 12500
> TNS-12500: TNS:listener failed to start a dedicated server process
> TNS-12560: TNS:protocol adapter error
> TNS-00530: Protocol adapter error
> 32-bit Windows Error: 31: Too many links
> Can anyone shed some light on what "Too many links" means? Open
> Network connections? Sockets?
> Thanks in advance,
> -joe
> --


Received on Tue Jun 27 2006 - 15:43:35 CDT

Original text of this message