ODP.NET Managed Driver ASP.NET application fails to return data after 100 refresh cycles
We have developed an ASP.NET application which contacts the database every 15 minutes to retrieve data used to update a status board in our production area. We are using the Oracle.ManagedDataAccess.dll version 4.121.1.0 to connect to an Oracle 11g DB. The application starts up and runs normally for many hours, but consistently fails before 24 hours are up. The exception thrown is ORA-01017.
We have attempted to use Oracle tracing, but the trace files are very large since we have to run for many hours. Any help on how we can troubleshoot what might be happening here would be greatly appreciated.
0