Re: OracleClient connection pooling

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Feb 22, 11:36 am, DSISupport <DSISupp...@xxxxxxxxxxxxxxxx> wrote:
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(St­ring
encryptedConnectionString, OracleConnectionString options, OracleConnection
owningObject, Boolean& isInTransaction)
at
System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionStri­ng
parsedConnectionString, Object transact)
at System.Data.OracleClient.OracleConnection.Open()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection()
at
Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(DBCommand­Wrapper command)
at
Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase.ExecuteRea­der(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.

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.

.

Relevant Pages

  • [NEWS] Multiple Vulnerabilities in Oracle Database (Character Conversion, Extproc, Password Disclosu
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Multiple vulnerabilities were discovered in the (Oracle database server ... password is required to exploit this vulnerability. ...
    (Securiteam)
  • Re: Solaris 10 - problem with connect to Oracle 10.2.0.2 with ORA_SYSDBA
    ... It's a production server, I can't upgrade DBD::Oracle for the moment. ... you are using the system command and given it returns -1 it failed. ... The oracle client libraries fiddle with SIGCHILD handling - presumably because it wants to know a SIGCHILD signals. ...
    (perl.dbi.users)
  • Re: How to make your report run faster
    ... I've done no work with Oracle as the Server DB, ... > if they click the listbox then "Preview report" button is enabled. ... > -I was try to make the old queries for subreport, ...
    (microsoft.public.access.reports)
  • Re: I cant find a SETUP.EXE in the SQL Plus Client ??
    ... someone else's server for testing some SELECT statements I'm ... free client because I don't own the Oracle license. ... SQL statements. ... There is no documentation with that download. ...
    (comp.databases.oracle.tools)
  • RE: sunmanagers Digest, Vol 44, Issue 20
    ... diagnostics from the front-panel. ... Any ideas on what the problem may be or how to get this server powered ... The cluster itself is working, but I'm unable to shut down the nodes. ... Oracle uses shared memory for the communication between the client ...
    (SunManagers)