Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ora-00020 error

Status
Not open for further replies.

kensington45

Technical User
Jun 26, 2008
9
We are getting ora-00020 message (ORA-00020: maximum number of processes (%s) exceeded) when trying to connect to our Oracle 9i database.

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?
 
This usually just means that the maximum number of processes as defined in the startup pfile or spfile has been reached - try increasing the number available gradually to reach an optimum for your system.

I want to be good, is that not enough?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top