Home » RDBMS Server » Server Administration » Max number of processes ora-00020 message
Max number of processes ora-00020 message [message #338748] Tue, 05 August 2008 20:54 Go to next message
evergrean
Messages: 15
Registered: February 2008
Junior Member
We are getting ora-00020 message (ORA-00020: maximum number of processes (%s) exceeded) when trying to connect to our Oracle 9i database instance using OEM. Most connections are from server sides such as ColdFusion and JSP/Servlets.
The server sides give me back similiar message:150 maximum number of processes exceeded.

I googled the error message and it says to find what user is causing the problem. I used v$session but didnt find any user keeping the connection open.

Please advise what could be causing this message and how can it be fixed?

[Updated on: Tue, 05 August 2008 21:00]

Report message to a moderator

Re: Max number of processes ora-00020 message [message #338753 is a reply to message #338748] Tue, 05 August 2008 21:00 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated in URL above.

>I used v$session but didnt find any user keeping the connection open.
Post your query & results returned.


>Please advise what could be causing this message and how can it be fixed?

using sqlplus

SQL> SELECT MACHINE, COUNT(*) FROM V$SESSION GROUP BY MACHINE;

Post results from above using <codetags> as describe in Posting Guidelines above


Previous Topic: ORA-04034: unable to shrink pool to specified size
Next Topic: JDK Upgrade from 1.4.2_08 to 1.4.2_13 on oracle 10.2.0.2
Goto Forum:
  


Current Time: Sat Dec 10 20:26:08 CST 2016

Total time taken to generate the page: 0.08669 seconds