Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle Database Error: ORA-00020      [Return To Oracle Error Index] Jump to:  
Oracle Error: ORA-00020

Error Description:
Maximum number of processes (string) exceeded

Error Cause:
All process state objects are in use.

Action:
Increase the value of the PROCESSES initialization parameter.


Add a comment 
KevinJun 29th, 2010 8:47am
This is a common problem and easily fixed. Increase the parameters 'processes' and 'sessions' by 50% or more in the profile dbs/init.ora. After doing that, restart the database.
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 70 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?