Solved

ODBC ? OO4O error

Posted on 2001-09-03
8
378 Views
Last Modified: 2008-02-01
On my web site I am accessing an oracle database using oo4o and ODBC through ASP

I keep getting this message

Unable to make connection, ORA-00020: maximum number of processes (30) exceeded

Can anyone advise.

I have messed about with the connection pooling in the global.asa file for oo4o and with connection pooling in ODBC but to no avail.

I am using oracle version 8.0.6

Paul
0
Comment
Question by:plovett
8 Comments
 
LVL 3

Expert Comment

by:nigelrowe
ID: 6450580
What version of Oracle are you using?
0
 

Author Comment

by:plovett
ID: 6450611
using oracle 8.0.6
0
 
LVL 3

Expert Comment

by:nigelrowe
ID: 6452552
I use 8.1i and have seen this message. It concerned the DB configuration. There is a DB variable which you can change to increase this number, but I can't remember which one (there are several). Maybe you could ask your DB administrator to check this out.
0
Is Your AD Toolbox Looking More Like a Toybox?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

 

Author Comment

by:plovett
ID: 6452575
Thanks nigel..

There is a connection pooling setting in the global.asa file when using oo4o

I have tried to increase this but to no avail. I will follow your advice thanks.

Paul
0
 

Accepted Solution

by:
omerfarooque earned 200 total points
ID: 6452587
You could check up in the instance manager on the Oracle Enterprise Manager, for any instances that appear to be hanging. Try to end that process. These kind of errors normally come up due to some process either occupying too much of the alloted CPU usage, or forking more processes.
It would be a good idea to check up the DB activites by a DBA if the database is in prodcution.
0
 

Author Comment

by:plovett
ID: 6452712
Thanks Omer

I am going to give it a whirl now.

Paul
0
 
LVL 7

Expert Comment

by:lavinder
ID: 8680367
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this

question is:
Accept a comment - omarfarooque
Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
lavinder
EE Cleanup Volunteer

0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
add custom headers to my mail 2 55
Time/Date Query 11 41
Downside of adding characters set in ASP pages 6 21
Hide cell in a table 2 14
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

773 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