How To fix this issue
This issue will occur due to lack of number process configured so that to fix this issue we need to update the Number of Process in this table V$RESOURCE_LIMIT.
First of all check the configured number of process using the following query.
SELECT * FROM V$RESOURCE_LIMIT WHERE RESOURCE_NAME='process';
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALUE ------------- ------------------- --------------- ----------- processes 148 150 150
If CURRENT_UTILIZATION is almost equivalent to MAX_UTILIZATION then we need to increase the number of process using the following query.
How to increase the number of process
First up open the command prompt and type the following the queries
cmd>sqlplus / as sysdba sqlplus>alter system set processes=300 scope=spfile; sqlplus>shut immediate; sqlplus>startup
And then check the number of process by using the select query. and then try to access the data base and you many not get this error.
Hello! I am Narayanaswamy founder and admin of narayanatutorial.com. I have been working in IT industry more than 7 years. NarayanaTutorial is my web technologies blog. My specialties are Java / J2EE, Spring, Hibernate, Struts, Webservices, PHP, Oracle, MySQL, SQLServer, Web Hosting and Website Development.
I am a self learner and passionate about training and writing. I am always trying my best to share my knowledge through my blog.