Runtime error 440 maximum 59 of processes exceeded

I am using  oracle 8.1.7 (oo4o 8.1.7) and using VB6.0 to develop an application on window XP 2000. Every thing runs smoothly, but sometimes, there is an error stated that 'Runtime error 440 maximum 59 of processes exceeded' and all the connection to oracle are fail, I try to login oracle in work sheet the same error appears. I have to restart the application to run it again.
Can any one help me with this problem?

Thank a lot for your help

Huhu
huhuAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bkowalskiCommented:
Yes, you need to increase the processes parm in your init.ora file.  Check what it is now, it should be 59:
select value from v$parameter where name='PROCESSES';

Increase it to something like 500 and restart the database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark GeerlingsDatabase AdministratorCommented:
Is this a VB error on the client, or an Oracle error from the database server?  If it a database error, check your init*.ora file and look for the "processes" entry.  If that is set to "59", increase it to a larger value, then shutdown and restart the database.

It sounds to me though like this is a client-side application error, since you are apparently able to get past it by restarting the application.  If it was a database error, restarting the application would likely have no affect.  I've never used VB so I can't help you with a VB error.
0
huhuAuthor Commented:
Please tell me where is the  v$parameter ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

bkowalskiCommented:
It's a database view, you need to issue the SQL directly against the Oracle database using SQL*Plus or some other tool.
0
Mark GeerlingsDatabase AdministratorCommented:
Here is a query you can use for v$parameter:
select value from v$parameter where name = 'processes';

or this one to see them all:
select substr(name,1,35) "Parameter",
substr(value,1,40) "Value"
from v$parameter;

That is just an alternate way of seeing basically the same things that you can see by opening the init*.ora file on the server.
0
huhuAuthor Commented:
Thank you all.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.