Re: TNS ORA-12500 - which unix user is used?

On 12 Dec 2002 15:53:48 -0800, pdg5001_at_yahoo.co.uk (Paul Smith) wrote:

>Hello,
>
>I am getting the error ORA-12500 regarding the TNS listener failing to
>start a dedicated server process on my HP-UX box. There are several
>suggestions on Google as to the cause and the solution. The most
>common of these is that the maximum number of processes has been
>reached for the unix user. What I am surprised at is that it appears
>to be the "oracle" user that always owns these server processes. I
>have a few questions about this that I would be most grateful for an
>expert's opinion on:
>
>(1) Is it always the oracle user that owns the dedicated server
>processes?
>(2) If the answer to (1) is yes, if I have an application used by 100
>clients connecting to the database on the HP-UX box, the maximum
>number of processes per user has to be set to 100+ (ignoring
>MTS/Shared Server) ?
>(3) Can the maximum number of processes be set on a per-user basis (I
>know it's not really the right group for this question).
>(4) Can I have several listeners, and would it help? [If I did have
>several listeners, would I have to have a "pool" of JDBC url
>connection strings corresponding to the ports that the listeners were
>listening on?]
>
>Many thanks,
>Paul

1. yes
2. yes
3. Unix issue, AFAIK a generic setting
4. it would not help

(They would still *all* run from the Oracle user)

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Dec 12 2002 - 23:47:03 CST