Null reference, Cant access database until IIS is reset
458014Oct 3 2005 — edited Jun 26 2007We are using .Net 1.1, ODP.NET 9.2.0.401 to connect to oracle 9i,8i,8 databases.
The application is written ASP.NET and runs on a windows 2000 server.
Every now and then, the user get an 'Object Reference Not Set To an Instance of an Object' error, followed by''ORA-12554: TNS:current operation is still in progress' , followed by 'ORA-03127: no new operations allowed until the active operation ends' error.
This freezes up all the asp.net web applications (connecting to the oracle dbs) on the server and a IIS reset, fixes the issue. The error is sporadic, occurs once a week. Hitting the same page doesn't always cause the error.
PLease help/advise.