ORA-00604 Maximum open cursors exceeded
This error occurs when the number of open cursors exceeds the limit set by the database. We are aware of this issue and are working on a fix.
-
Workaround 1: Append following snippet to the database connection string
Connection Lifetime=180. This will close the connection every 180s and open a new one. This will prevent the number of open cursors from exceeding the limit. -
Workaround 2: Increase the maximum number of open cursors in the database to 1000.