Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: TNS ORA-12500 - which unix user is used? Date: Fri, 13 Dec 2002 06:47:03 +0100 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: <2b9e76b9.0212121553.4bfa08e8@posting.google.com> X-Newsreader: Forte Agent 1.92/32.572 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 42 Xref: newsfeed1.easynews.com comp.databases.oracle.server:169564 X-Received-Date: Thu, 12 Dec 2002 22:46:29 MST (news.easynews.com) On 12 Dec 2002 15:53:48 -0800, pdg5001@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