Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12500 on Digital Unix
"Robert D. Perry" wrote:
> We need help with our Oracle Server 7.3.4 (Digital Unix, Alpha).
>
> We are getting the following error when we try to establish more than 56
>
> database connections:
>
> "ORA-12500: TNS:listener failed to start a dedicated server
> process"
>
> We are connecting to the Oracle Server from NT machines which all have
> the
> Oracle Client sw installed. We are connecting directly
> via SQL Plus, and via ODBC (from VB programs & C programs).
>
> We would like to increase the limit to 1000 connections (or more).
>
> What does anyone suggest to alleviate this problem.
Looks like some limit was reached somewhere; I'm not a Unix guru, so I can't
suggest which.
As an alternative, you could check out Multi Threaded Server, especially if
many client
sessions are OLTP kind of connections, that is they do not transfer huge
amounts of data.
In principle you predefine and spawn a limited number of servers, each of
which will handle
a number of client connects.
Currently, you will have a separate process for each connection (check with
netstat)
--
Met vriendelijke groet/kind regards,
Frank van Bortel
Technical consultant Oracle
Work: Home: ---------------------------------- ---------------------------- V&L Informatica BV Hunzestraat 4 Palandijn 3, 7521 PN Enschede 7555 WB Hengelo PoBox 545, 7500 AM Enschede (31)074-2425046053-4341500 Received on Fri Aug 13 1999 - 17:12:31 CDT