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

Robert,

How many physical CPUs (and logical, if hyperthreading is enabled) are in that server?
What type of storage subsystem is supporting the database? Can you reasonably expect a degree of parallelism of greater than 4 off of a dual CPU box?

If you don't need to support parallelism, I'd suggest turning it off.

Are you sure that you didn't hit some other resource restriction other than "processes"?
Might you have hit the process limit (memory consumption) or have exhausted a kernel resource?

Check your OS kernel settings (sysctl) and memory allocations.

hth.

-bdbafh Received on Fri Feb 24 2006 - 13:41:41 CST