• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Paul Clapham
  • Bear Bibeault
  • Jeanne Boyarsky
  • Ron McLeod
  • Tim Cooke
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Jj Roberts
  • Stephan van Hulst
  • Carey Brown
  • salvin francis
  • Scott Selikoff
  • fred rosenberger

what does this Oracle error msg mean ?

Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ORA-00020: maximum number of processes (150) exceeded

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

Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
We've gotta get close enough to that helmet to pull the choke on it's engine and flood his mind! Or, we could just read this tiny ad:
the value of filler advertising in 2020
    Bookmark Topic Watch Topic
  • New Topic