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

A few additions to Sybrands answers are embedded below.

> >(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

This is caused by the fact that the oracle executable is 'equipped' with the so called setuid. "ls -l oracle" should return something like:

-rwsr-s--x 1 oracle dba 34562048 May 17 2002 oracle

Because of the setuid every process spawned by oracle has the same privileges as the oracle executable itself, unrespective of the user that started the process. It will run as if oracle (the owner of the executable) started the process.

> 2) yes
> 3) Unix issue, AFAIK a generic setting

Maximum number of processes on an HP-box is determined by the "nproc" kernel parameter. Be aware that quite a few other parameter are influenced by the nproc-parameter (e.g. nfiles, max number of files that can be opened simultaneously).

> 4) it would not help
>
> (They would still *all* run from the Oracle user)
>

Additions and corrections are welcome,

Peter Received on Fri Dec 13 2002 - 00:48:38 CST