Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Intermittend ORA-12519, TNS:no appropriate service handler found

Re: Intermittend ORA-12519, TNS:no appropriate service handler found

From: Robert Klemme <bob.news_at_gmx.net>
Date: Mon, 27 Feb 2006 09:16:52 +0100
Message-ID: <46fqrkFao0s2U1@individual.net>


Sybrand Bakker wrote:
> On 24 Feb 2006 11:35:34 -0800, "shortcutter_at_googlemail.com"
> <shortcutter_at_googlemail.com> wrote:
>
>> Second, it was explained that the
>> error will occur if "processes" is set too low. Third, the parameter
>> "processes" is derived from "parallel_max_servers" (indicated by
>> online doc, and you cannot change it directly via EM).
>
> Your understanding is incorrect. Processes doesn't derive from
> parallel_max_servers at all.

This is the documentation linked from the EM page:

PROCESSES
Property Description
Parameter type Integer
Default value Derived from PARALLEL_MAX_SERVERS Modifiable No
Range of values 6 to operating system-dependent Basic Yes
Real Application Clusters Multiple instances can have different values.

PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes.

The default values of the SESSIONS and TRANSACTIONS parameters are derived from this parameter. Therefore, if you change the value of PROCESSES, you should evaluate whether to adjust the values of those derived parameters.

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/initparams167.htm#REFRN10175

Kind regards

    robert Received on Mon Feb 27 2006 - 02:16:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US