?
Solved

OIP-04148: Unable to obtain a free database object from the pool

Posted on 2004-11-30
3
Medium Priority
?
2,129 Views
Last Modified: 2008-01-09

Everytime that the Oracle DB Machine locks up I get the following error message: "OIP-04148: Unable to obtain a free database object from the pool"  but when the Db machine is back (comes back) i  still get the error message.
This error message doesn't affect all my websites that are configured on the IIS.  Is there any recommendations on how to fix this error???  
Machine Win2K Server, IIS 5.0, running as webserver machine
0
Comment
Question by:casatech
1 Comment
 
LVL 7

Accepted Solution

by:
pettmans earned 1500 total points
ID: 12711201
First checking my assumptions:

This error iis generated on the web server or from a browser accessing a host web site. Yes?

If you are using IIS for your web server, then it is likely that database connections, object creations etc are being set up in a file called GLOBAL.ASA which you'll find in the home directory of the web site.

GLOBAL.ASA contents are run at application startup/shutdown, or user session startup or shutdown, depending on what events are specified. So you may need to restart your application after the Oracle Server becomes available again. You can do this through:
stop/start of the website, or through
unloading the applictation (start IIS manager, rightclick web site and sekect properties, go to Home Directory Tab and click on UNLOAD at the bottom of the window.

Regards,
Scott Pettman
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

599 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