Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

C# EntityFramework. ORA-01000: maximum open cursors exceeded

SergeyKotelnikovMay 29 2019 — edited Jun 18 2019

Hi all.

We caught ORA-01000: maximum open cursors exceeded.

1. We use C# EF Oracle.EntityFrameworkCore 2.18.0-beta3

2. We use DbContextPool:

...

.AddDbContextPool<ClientsDbContext>(dbConfig => dbConfig.UseOracle(

                    _configuration.GetConnectionString("ClientsDb"),

                    options => options.EnableOracleRetryOnKnownFailure(3, TimeSpan.FromSeconds(3))))

...

3. We Inject our DbContext as scoped object. So its disposed correctly each request - we checked it.

4. We use common EF operations - add, update etc, nothing special

5. The exception appears after about 2 weeks continuous service job. After the restart our service works fine. And after another 2 weeks the same exception appears again

Our suspicions - may be connections are not closed correctly inside the library? Can you recommend something to avoid this problem.

Thanks in advance

Comments

Processing

Post Details

Added on May 29 2019
6 comments
2,880 views