This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes what does this Oracle error msg mean ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "what does this Oracle error msg mean ?" Watch "what does this Oracle error msg mean ?" New topic
Author

what does this Oracle error msg mean ?

Artemesia Lakener
Ranch Hand

Joined: Jun 21, 2005
Posts: 162
ORA-00020: maximum number of processes (150) exceeded

Note: I was testing a Java web application on an application server.

thanks
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Have a look and see what is using up all these processes (by checking the v$process and v$session tables). That will let you know what the culrpit is. It could be that your database is not configured to allow enough processes, in which case increase that with the PROCESSES initialization parameter.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
sandeep balyan
Ranch Hand

Joined: Jul 25, 2001
Posts: 134
This means that all of 150 configured connection are in use .for resolving this
you can increase the maxconnection to a high number .But I think their is a problem in your java application and the problem is application is not dropping database connection i.e. connection are not closed in jsp/java files.
check for
connection.close();


Want to do something great will do one day
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: what does this Oracle error msg mean ?
 
Similar Threads
Tech Word Game
adding tomcat 6.0 error
StuckThreadMaxTime Error.
single threaded or multi threaded
Deploy Java Application On Customer Side?