OracleClient connection pooling

[=?Utf-8?B?RFNJU3VwcG9ydA==?=]

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.Ora cleClient.DBPoo ledObject
GetObject(Syste m.Object, Boolean ByRef)
Stack Trace : at System.Data.Ora cleClient.DBObj ectPool.GetObje ct(Object
owningObject, Boolean& isInTransaction )
at
System.Data.Ora cleClient.Oracl eConnectionPool Manager.GetPool edConnection(St ring
encryptedConnec tionString, OracleConnectio nString options, OracleConnectio n
owningObject, Boolean& isInTransaction )
at
System.Data.Ora cleClient.Oracl eConnection.Ope nInternal(Oracl eConnectionStri ng
parsedConnectio nString, Object transact)
at System.Data.Ora cleClient.Oracl eConnection.Ope n()
at Microsoft.Pract ices.Enterprise Library.Data.Da tabase.OpenConn ection()
at
Microsoft.Pract ices.Enterprise Library.Data.Da tabase.ExecuteR eader(DBCommand Wrapper command)
at
Microsoft.Pract ices.Enterprise Library.Data.Or acle.OracleData base.ExecuteRea der(DBCommandWr apper commandWrapper)
at EssessmentDataA ccessLayer.clsP MRFormDAL.get_d t_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.

[wfairl]

On Feb 22, 11:36 am, DSISupport <DSISupp...@new sgroup.nospamwr ote:

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.Ora cleClient.DBPoo ledObject
GetObject(Syste m.Object, Boolean ByRef)
Stack Trace : at System.Data.Ora cleClient.DBObj ectPool.GetObje ct(Object
owningObject, Boolean& isInTransaction )
at
System.Data.Ora cleClient.Oracl eConnectionPool Manager.GetPool edConnection(St *ring
encryptedConnec tionString, OracleConnectio nString options, OracleConnectio n
owningObject, Boolean& isInTransaction )
at
System.Data.Ora cleClient.Oracl eConnection.Ope nInternal(Oracl eConnectionStri *ng
parsedConnectio nString, Object transact)
at System.Data.Ora cleClient.Oracl eConnection.Ope n()
at Microsoft.Pract ices.Enterprise Library.Data.Da tabase.OpenConn ection()
at
Microsoft.Pract ices.Enterprise Library.Data.Da tabase.ExecuteR eader(DBCommand *Wrapper command)
at
Microsoft.Pract ices.Enterprise Library.Data.Or acle.OracleData base.ExecuteRea *der(DBCommandW rapper commandWrapper)
at EssessmentDataA ccessLayer.clsP MRFormDAL.get_d t_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.

Are you using an Oracle name server? I've run into a similar issue
when using the .net managed provider in an environment where a name
server was used to resolve names.

[=?Utf-8?B?RFNJU3VwcG9ydA==?=]

I just checked with our DBA team and they confirmed that we're not using
Oracle Name Server and we're using TNS names instead?
Does this make my issue harder? also what did you do to fix the issue?

Thanks.

"wf****@gmail.c om" wrote:

On Feb 22, 11:36 am, DSISupport <DSISupp...@new sgroup.nospamwr ote:

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.Ora cleClient.DBPoo ledObject
GetObject(Syste m.Object, Boolean ByRef)
Stack Trace : at System.Data.Ora cleClient.DBObj ectPool.GetObje ct(Object
owningObject, Boolean& isInTransaction )
at
System.Data.Ora cleClient.Oracl eConnectionPool Manager.GetPool edConnection(St Â*ring
encryptedConnec tionString, OracleConnectio nString options, OracleConnectio n
owningObject, Boolean& isInTransaction )
at
System.Data.Ora cleClient.Oracl eConnection.Ope nInternal(Oracl eConnectionStri Â*ng
parsedConnectio nString, Object transact)
at System.Data.Ora cleClient.Oracl eConnection.Ope n()
at Microsoft.Pract ices.Enterprise Library.Data.Da tabase.OpenConn ection()
at
Microsoft.Pract ices.Enterprise Library.Data.Da tabase.ExecuteR eader(DBCommand Â*Wrapper command)
at
Microsoft.Pract ices.Enterprise Library.Data.Or acle.OracleData base.ExecuteRea Â*der(DBCommand Wrapper commandWrapper)
at EssessmentDataA ccessLayer.clsP MRFormDAL.get_d t_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.

Are you using an Oracle name server? I've run into a similar issue
when using the .net managed provider in an environment where a name
server was used to resolve names.

[wfairl]

On Feb 22, 2:00 pm, DSISupport <DSISupp...@new sgroup.nospamwr ote:

I just checked with our DBA team and they confirmed that we're not using
Oracle Name Server and we're using TNS names instead?
Does this make my issue harder? also what did you do to fix the issue?

Thanks.

"wfa...@gmail.c om" wrote:

On Feb 22, 11:36 am, DSISupport <DSISupp...@new sgroup.nospamwr ote:

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 theother
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.Ora cleClient.DBPoo ledObject
GetObject(Syste m.Object, Boolean ByRef)
Stack Trace : at System.Data.Ora cleClient.DBObj ectPool.GetObje ct(Object
owningObject, Boolean& isInTransaction )
at
System.Data.Ora cleClient.Oracl eConnectionPool Manager.GetPool edConnection(St **ring
encryptedConnec tionString, OracleConnectio nString options, OracleConnectio n
owningObject, Boolean& isInTransaction )
at
System.Data.Ora cleClient.Oracl eConnection.Ope nInternal(Oracl eConnectionStri **ng
parsedConnectio nString, Object transact)
at System.Data.Ora cleClient.Oracl eConnection.Ope n()
at Microsoft.Pract ices.Enterprise Library.Data.Da tabase.OpenConn ection()
at
Microsoft.Pract ices.Enterprise Library.Data.Da tabase.ExecuteR eader(DBCommand **Wrapper command)
at
Microsoft.Pract ices.Enterprise Library.Data.Or acle.OracleData base.ExecuteRea **der(DBCommand Wrapper commandWrapper)
at EssessmentDataA ccessLayer.clsP MRFormDAL.get_d t_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.

Are you using an Oracle name server? I've run into a similar issue
when using the .net managed provider in an environment where a name
server was used to resolve names.- Hide quoted text -

- Show quoted text -

We used tnsnames :). I'm not sure if it was the exact same problem but
it sounds similar. There was an issue between the microsoft managed
provider and the oci library where a thread was entering a
synchronization context while opening a connection and then never
leaving the context because it hung on the call to resolve the server
(using Oracle name server). We'd then receive timeout errors when
trying to open another connection until we killed the process. At the
time I found some other reports of the issue in metalink but there
weren't any resolutions other than using Oracle's managed provider
(instead of Microsoft's) or not using an oracle nameserver. We had too
much provider specific code so we chose the latter.

First thing I would do is use the microsoft debugging tools so you can
identify exactly where the problem is.
http://www.microsoft.com/whdc/devtoo...g/default.mspx

[=?Utf-8?B?RFNJU3VwcG9ydA==?=]

I think that we can always change the code to use the Oracle database
provider and see if that resolve the issue however that could take some time
because a lot of stuff are a provider specific. The other possible fix would
be try to disable the connection pooling but that may also slow down the
application.
I was hoping to find a fix and keep using the MS DB Provider for Oracle with
the connection pooling and I'm still searching for the fix to this issue.

"wf****@gmail.c om" wrote:

On Feb 22, 2:00 pm, DSISupport <DSISupp...@new sgroup.nospamwr ote:

I just checked with our DBA team and they confirmed that we're not using
Oracle Name Server and we're using TNS names instead?
Does this make my issue harder? also what did you do to fix the issue?

Thanks.

"wfa...@gmail.c om" wrote:

On Feb 22, 11:36 am, DSISupport <DSISupp...@new sgroup.nospamwr ote:
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.Ora cleClient.DBPoo ledObject
GetObject(Syste m.Object, Boolean ByRef)
Stack Trace : at System.Data.Ora cleClient.DBObj ectPool.GetObje ct(Object
owningObject, Boolean& isInTransaction )
at
System.Data.Ora cleClient.Oracl eConnectionPool Manager.GetPool edConnection(St Â*Â*ring
encryptedConnec tionString, OracleConnectio nString options, OracleConnectio n
owningObject, Boolean& isInTransaction )
at
System.Data.Ora cleClient.Oracl eConnection.Ope nInternal(Oracl eConnectionStri Â*Â*ng
parsedConnectio nString, Object transact)
at System.Data.Ora cleClient.Oracl eConnection.Ope n()
at Microsoft.Pract ices.Enterprise Library.Data.Da tabase.OpenConn ection()
at
Microsoft.Pract ices.Enterprise Library.Data.Da tabase.ExecuteR eader(DBCommand Â*Â*Wrapper command)
at
Microsoft.Pract ices.Enterprise Library.Data.Or acle.OracleData base.ExecuteRea Â*Â*der(DBComma ndWrapper commandWrapper)
at EssessmentDataA ccessLayer.clsP MRFormDAL.get_d t_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.

Are you using an Oracle name server? I've run into a similar issue
when using the .net managed provider in an environment where a name
server was used to resolve names.- Hide quoted text -

- Show quoted text -

We used tnsnames :). I'm not sure if it was the exact same problem but
it sounds similar. There was an issue between the microsoft managed
provider and the oci library where a thread was entering a
synchronization context while opening a connection and then never
leaving the context because it hung on the call to resolve the server
(using Oracle name server). We'd then receive timeout errors when
trying to open another connection until we killed the process. At the
time I found some other reports of the issue in metalink but there
weren't any resolutions other than using Oracle's managed provider
(instead of Microsoft's) or not using an oracle nameserver. We had too
much provider specific code so we chose the latter.

First thing I would do is use the microsoft debugging tools so you can
identify exactly where the problem is.
http://www.microsoft.com/whdc/devtoo...g/default.mspx