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

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

RE: Help with Windows error

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Tue, 27 Jun 2006 16:40:04 -0400
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A2010FB5DD@EXCHANGE.corp.perceptron.com>


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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Tuesday, June 27, 2006 4:26 PM
To: Freeman, Donald; Oracle-L_at_freelists.org 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.

-joe

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

> connect to the database and/or inability to log into the server
itself.
> 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
what
> the underlying Windows error truly means. I have googled and
metalink'd
> 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
files?
> Network connections? Sockets?
>
> Thanks in advance,
> -joe
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 27 2006 - 15:40:04 CDT

Original text of this message

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