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-2425046
053-4341500