Recover from NullReferenceException in OracleClient.DBObjectPool...

Hello ALL!

We are getting killed by a customer because of this...

..NET 1.1 SP2
Server 2003 SP1
MS Provider for Oracle
Oracle 9.1.0.4

Program runs fine for days at a time and then intermittently we receive
this exception:

System.NullReferenceException: Object reference not set to an instance
of an object. at Data.OracleClient.DBObjectPool.GetObject(Object
owningObject, Boolean& isInTransaction) at
System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String
encryptedConnectionString, OracleConnectionString options,
OracleConnection owningObject, Boolean& isInTransaction) ...
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

At this point we see one of two things happen.
1. We are able to get connections for a short period and during this
period 'Mem Usage' of our app starts sky rocketing up... starts around
40MB'. Eventually we start getting timeouts from the pool manager. At
this point they need to restart the app, 'Mem Usage' is then usually
well over 100MB

2. We immediately start getting timeouts from the pool manager. At this
point they need to restart the app.

Note: From Oracle side we never show more then 3-4 connections.

Any thoughts here? I have seen many people with same situation...

Our current plan is to dynamically modify the connection string to
create a new connection pool once we trap this exception... This code
is in test preparing to move into production... I will post back if
this works...

All connections are being disposed in a try catch finally block! The
system will run for days at a time not leaking memory or connections!
Handling 1000's of transactions a day. Intermittently we then get this
exception.

Thanks in advance!

.

Relevant Pages

  • Re: Effect of listener on existing connections?
    ... Oracle support is not giving us satisfactory results. ... and attempts to create new connections are ... We also see these messages appearing with regularity in our listener ... how does a blocked listener explain the fact that apps with existing ...
    (comp.databases.oracle.server)
  • Re: Effect of listener on existing connections?
    ... Solaris 10 inside a ZFS zone (our previous system was Oracle ... and attempts to create new connections are ... issue of the listener locking up if you're not using ONS. ... how does a blocked listener explain the fact that apps with existing ...
    (comp.databases.oracle.server)
  • Connection delays causing problems.
    ... ORACLE connections sometimes take tens of seconds to come ... This is true whether the connection is via sqlplus, ACCELL ... Over 150 clients running ACCELL applications. ...
    (comp.databases.oracle.server)
  • Effect of listener on existing connections?
    ... Oracle support is not giving us satisfactory results. ... and attempts to create new connections are ... how does a blocked listener explain the fact that apps with existing ...
    (comp.databases.oracle.server)
  • Re: Can Access handle this configuration, or do I need SQL Server?
    ... My company runs a couple of mdbs and one large scale Oracle back ... end db system over both Citrix and RDP client connections. ... functioning correctly) and problems caused by flaky connections. ...
    (microsoft.public.access.formscoding)