Link to home
Start Free TrialLog in
Avatar of huhu
huhu

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of bkowalski
bkowalski

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mark Geerlings
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.
Avatar of huhu
huhu

ASKER

Please tell me where is the  v$parameter ?
It's a database view, you need to issue the SQL directly against the Oracle database using SQL*Plus or some other tool.
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.
Avatar of huhu

ASKER

Thank you all.