Problems with connection pooling on Oracle (ORA-03114)

We are having issues with some of our applications that utilize=
connection pooling via the OracleConnection Class
Of the System=2EData=2EOracleClient Namespace=2E At this time we are=
unable to determine of the problem lies within our code that=
connects to our DB and then executes the necessary stored=
procecures, the parameters we define in the ConnectionString=
property, or the Oracle DB itself=2E What we do know, however is=
that when we enable connection pooling, over time our=
application is no longer able to connect to our DB and we=
receive =2ENET errors like the one I?ve pasted below=2E Then, when=
we recycle the application pool that this application is running=
in, we are able to connect to the DB again and our application=
works=2E Then, like I said over time, it will fail again, with the=
same or similar message=2E I?m also wondering if our code is not=
handling the connection to the DB properly=2E Perhaps we are not=
closing connections when an exception is thrown, or we are just=
not handling errors returned from the DB gracefully=2E

*****************************************************************=
****
Application KSLearn FailedSystem=2EWeb=2EHttpUnhandledException:=
Exception of type System=2EWeb=2EHttpUnhandledException was thrown=2E=
---> System=2EData=2EOracleClient=2EOracleException: ORA-03114: not=
connected to ORACLE

-----------------------
Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/)

<Id>PqWnZqQwA0WZPDSxYXDN7w=3D=3D</Id>

Cowboy
Fri Jun 18 11:21:17 CDT 2004

You need to check for errors in your code as the MS components can lock a
connection if there are certain types of errors. I do quite a bit of Oracle
work, but I am not an Oracle expert, so I cannot tell which specific errors
simply lock up Connections. The DBA should be able to track down what was
being run when the lock occurred, however, and you can check that piece of
code.

My suggestion, if possible, is to refactor with the free ODP.NET components
from Oracle. Most of the objects share the same names, although some of the
Oracle methods are named different (ie, be careful and test thoroughly). If
you are not working exclusively with stored procedures, I would recommend
it.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************
"Nick Fischio via .NET 247" <anonymous@dotnet247.com> wrote in message
news:evDchmUVEHA.384@TK2MSFTNGP10.phx.gbl...
We are having issues with some of our applications that utilize connection
pooling via the OracleConnection Class
Of the System.Data.OracleClient Namespace. At this time we are unable to
determine of the problem lies within our code that connects to our DB and
then executes the necessary stored procecures, the parameters we define in
the ConnectionString property, or the Oracle DB itself. What we do know,
however is that when we enable connection pooling, over time our application
is no longer able to connect to our DB and we receive .NET errors like the
one I?ve pasted below. Then, when we recycle the application pool that this
application is running in, we are able to connect to the DB again and our
application works. Then, like I said over time, it will fail again, with the
same or similar message. I?m also wondering if our code is not handling the
connection to the DB properly. Perhaps we are not closing connections when
an exception is thrown, or we are just not handling errors returned from the
DB gracefully.

*********************************************************************
Application KSLearn FailedSystem.Web.HttpUnhandledException: Exception of
type System.Web.HttpUnhandledException was thrown. --->
System.Data.OracleClient.OracleException: ORA-03114: not connected to ORACLE

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>PqWnZqQwA0WZPDSxYXDN7w==</Id>

Angel
Wed Jun 23 13:11:57 CDT 2004

Nick,
Like Gregory mentions there are some errors that we are not handling
correctly in our managed pooler implementation, you should contact PSS
directly for the latest QFE 830173.

Thank you
--
Angel Saenz-Badillos [MS] Managed Providers
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.


"Cowboy (Gregory A. Beamer) [MVP]" <NoSpamMgbworld@comcast.netNoSpamM> wrote
in message news:e8giQHVVEHA.264@TK2MSFTNGP10.phx.gbl...
> You need to check for errors in your code as the MS components can lock a
> connection if there are certain types of errors. I do quite a bit of
Oracle
> work, but I am not an Oracle expert, so I cannot tell which specific
errors
> simply lock up Connections. The DBA should be able to track down what was
> being run when the lock occurred, however, and you can check that piece of
> code.
>
> My suggestion, if possible, is to refactor with the free ODP.NET
components
> from Oracle. Most of the objects share the same names, although some of
the
> Oracle methods are named different (ie, be careful and test thoroughly).
If
> you are not working exclusively with stored procedures, I would recommend
> it.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> ************************************************
> Think Outside the Box!
> ************************************************
> "Nick Fischio via .NET 247" <anonymous@dotnet247.com> wrote in message
> news:evDchmUVEHA.384@TK2MSFTNGP10.phx.gbl...
> We are having issues with some of our applications that utilize connection
> pooling via the OracleConnection Class
> Of the System.Data.OracleClient Namespace. At this time we are unable to
> determine of the problem lies within our code that connects to our DB and
> then executes the necessary stored procecures, the parameters we define in
> the ConnectionString property, or the Oracle DB itself. What we do know,
> however is that when we enable connection pooling, over time our
application
> is no longer able to connect to our DB and we receive .NET errors like the
> one I?ve pasted below. Then, when we recycle the application pool that
this
> application is running in, we are able to connect to the DB again and our
> application works. Then, like I said over time, it will fail again, with
the
> same or similar message. I?m also wondering if our code is not handling
the
> connection to the DB properly. Perhaps we are not closing connections when
> an exception is thrown, or we are just not handling errors returned from
the
> DB gracefully.
>
> *********************************************************************
> Application KSLearn FailedSystem.Web.HttpUnhandledException: Exception of
> type System.Web.HttpUnhandledException was thrown. --->
> System.Data.OracleClient.OracleException: ORA-03114: not connected to
ORACLE
>
> -----------------------
> Posted by a user from .NET 247 (http://www.dotnet247.com/)
>
> <Id>PqWnZqQwA0WZPDSxYXDN7w==</Id>
>
>