Investigating "ORA-01000: maximum open cursors exceeded" WebLogic Server Support Pattern
(Doc ID 1141024.1)
Last updated on JANUARY 30, 2022
Oracle WebLogic Server - Version 6.1 and later Information in this document applies to any platform.
This document is a support pattern describing how to troubleshoot and fix ORA-01000 errors propagated to WebLogic Server via SQLException.
Oracle uses the OPEN_CURSORS parameter to specify the maximum number of open cursors a session can have at once. When this number is exceeded, Oracle reports an ORA-01000 error. When this error is propagated to WebLogic Server, a SQLException is thrown.
This pattern discusses possible causes and solutions of this error when using WebLogic Server.
Please note that not all of the following items would need to be done. Some issues can be solved by only following a few of the items.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!