OracleClient Connection Pooling

22 Feb 2007 7:32 PM

DSISupport

Hi,
I have this ASP.NET application developed with VS.NET 2003 VB.NET and
deplyed on Windows 2K server IIS 5.
This application uses the following:
- Oracle 10G databse
- MS Data Access Block from MS Enterprise Library June 2005 (with the other
blocks like exception, security...)
- Use Crystal Report Components for printing reports online
And everything was fine until recenntly we started getting this error
randomly and the only way to fix is reboot the server. and this is the error
message: --------------------------------------------------------------------------------------
TargetSite : System.Data.OracleClient.DBPooledObject
GetObject(System.Object, Boolean ByRef)
Stack Trace :    at System.Data.OracleClient.DBObjectPool.GetObject(Object
owningObject, Boolean& isInTransaction)
   at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String
encryptedConnectionString, OracleConnectionString options, OracleConnection
owningObject, Boolean& isInTransaction)
   at
System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString
parsedConnectionString, Object transact)
   at System.Data.OracleClient.OracleConnection.Open()
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection()
   at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DBCommandWrapper command)
   at Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase.ExecuteReader(DBCommandWrapper commandWrapper)
   at EssessmentDataAccessLayer.clsPMRFormDAL.get_dt_PMR_by_PMR_ID(Int32
PMR_ID) --------------------------------------------------------------------------------------
And from the error message it look like that Oracle client database pooling
is not working properly but I don't know how to fix.
Do you have any suggestions.

Thanks.

23 Feb 2007 2:02 AM

Steven Cheng[MSFT]

Hello,

Regarding on this Oracle database connection issue, I've also found your
another thread in the microsoft.public.dotnet.framework.aspnet newsgroup.
The community member wfairl has posted some further information there, if
you feel convenient, we can continue to discuss this issue in that thread.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead

This posting is provided "AS IS" with no warranties, and confers no rights.