OracleClient Pooled connection

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • =?Utf-8?B?RFNJU3VwcG9ydA==?=

    OracleClient Pooled connection

    I have an ASP.NET application runinng on IIS 5 .NET 1.1 Sp1 and recently
    we've been experiencing this error when the users are trying to print reports
    that connects to Oracle database. The only way to solve the issue right now
    is to restart the server or IIS 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)
    --------------------------------------------------------------------------------------

    So it look like that this an Oracle database pool issue but I don't know how
    to address and any suggestions would be helpful.




  • Luke Zhang [MSFT]

    #2
    RE: OracleClient Pooled connection

    Hello,

    From the error message, it seems it failed when open a connection to the
    Oracle database, did you open too much connection in the ASP.NET
    application. In ASP.NET application, we may close a connection right way
    after a database operation. Also, I not sure if there is some Orcale
    utilities which can check how many connections we open to a database. If
    so, it will also be helpful.

    BTW, for ASP.NET and ADO.NET related issue, you may post in:

    microsoft.publi c.dotnet.framew ork.aspnet
    microsoft.publi c.dotnet.framew ork.adonet

    Sincerely,

    Luke Zhang

    Microsoft Online Community Support
    =============== =============== =============== =====
    Get notification to my posts through email? Please refer to
    Learn with interactive lessons and technical documentation, earn professional development hours and certifications, and connect with the community.

    ications.

    Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
    where an initial response from the community or a Microsoft Support
    Engineer within 1 business day is acceptable. Please note that each follow
    up response may take approximately 2 business days as the support
    professional working with you may need further investigation to reach the
    most efficient resolution. The offering is not appropriate for situations
    that require urgent, real-time or phone-based interactions or complex
    project analysis and dump analysis issues. Issues of this nature are best
    handled working with a dedicated Microsoft Support Engineer by contacting
    Microsoft Customer Support Services (CSS) at
    http://msdn.microsoft.com/subscripti...t/default.aspx.
    =============== =============== =============== =====

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



    Comment

    • =?Utf-8?B?RFNJU3VwcG9ydA==?=

      #3
      RE: OracleClient Pooled connection

      Actually by the nature of the ASP.NET application all database connection are
      opened and closed by the MS Data Access Block which is a part of the MS
      Enterprise Library June 2005 and based on the documentation this code has a
      connection pool class which manages all the connection autumatically.
      Also this code is working fine in most cases however when we have more
      activities on from the users the server crash giving this error.
      It look like to me that the OracleClient ConnectionPool part has issue
      recycling connections, but I'm not sure.

      "Luke Zhang [MSFT]" wrote:
      Hello,
      >
      From the error message, it seems it failed when open a connection to the
      Oracle database, did you open too much connection in the ASP.NET
      application. In ASP.NET application, we may close a connection right way
      after a database operation. Also, I not sure if there is some Orcale
      utilities which can check how many connections we open to a database. If
      so, it will also be helpful.
      >
      BTW, for ASP.NET and ADO.NET related issue, you may post in:
      >
      microsoft.publi c.dotnet.framew ork.aspnet
      microsoft.publi c.dotnet.framew ork.adonet
      >
      Sincerely,
      >
      Luke Zhang
      >
      Microsoft Online Community Support
      =============== =============== =============== =====
      Get notification to my posts through email? Please refer to
      Learn with interactive lessons and technical documentation, earn professional development hours and certifications, and connect with the community.

      ications.
      >
      Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
      where an initial response from the community or a Microsoft Support
      Engineer within 1 business day is acceptable. Please note that each follow
      up response may take approximately 2 business days as the support
      professional working with you may need further investigation to reach the
      most efficient resolution. The offering is not appropriate for situations
      that require urgent, real-time or phone-based interactions or complex
      project analysis and dump analysis issues. Issues of this nature are best
      handled working with a dedicated Microsoft Support Engineer by contacting
      Microsoft Customer Support Services (CSS) at
      http://msdn.microsoft.com/subscripti...t/default.aspx.
      =============== =============== =============== =====
      >
      This posting is provided "AS IS" with no warranties, and confers no rights.
      >
      >
      >
      >

      Comment

      • Luke Zhang [MSFT]

        #4
        RE: OracleClient Pooled connection

        Hello,

        Connection pool also has max connection limit. So, it is better to check
        from Oracle side if there is a connection numbers peak when the exception
        occurs.

        Sincerely,

        Luke Zhang

        Microsoft Online Community Support
        =============== =============== =============== =====
        Get notification to my posts through email? Please refer to
        Learn with interactive lessons and technical documentation, earn professional development hours and certifications, and connect with the community.

        ications.

        Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
        where an initial response from the community or a Microsoft Support
        Engineer within 1 business day is acceptable. Please note that each follow
        up response may take approximately 2 business days as the support
        professional working with you may need further investigation to reach the
        most efficient resolution. The offering is not appropriate for situations
        that require urgent, real-time or phone-based interactions or complex
        project analysis and dump analysis issues. Issues of this nature are best
        handled working with a dedicated Microsoft Support Engineer by contacting
        Microsoft Customer Support Services (CSS) at
        http://msdn.microsoft.com/subscripti...t/default.aspx.
        =============== =============== =============== =====

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



        Comment

        Working...