Runtime error 440 maximum 59 of processes exceeded

Posted on 2003-03-24
Medium Priority
Last Modified: 2008-01-09
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

Question by:huhu
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2

Accepted Solution

bkowalski earned 500 total points
ID: 8197819
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.
LVL 35

Expert Comment

by:Mark Geerlings
ID: 8197846
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.

Author Comment

ID: 8197992
Please tell me where is the  v$parameter ?
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Expert Comment

ID: 8198022
It's a database view, you need to issue the SQL directly against the Oracle database using SQL*Plus or some other tool.
LVL 35

Expert Comment

by:Mark Geerlings
ID: 8198105
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.

Author Comment

ID: 8198320
Thank you all.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question