My Oracle Support Banner

Investigating "ORA-01000: maximum open cursors exceeded" WebLogic Server Support Pattern (Doc ID 1141024.1)

Last updated on OCTOBER 04, 2021

Applies to:

Oracle WebLogic Server - Version 6.1 and later
Information in this document applies to any platform.
***Checked for relevance on Dec 5, 2016***

Purpose

This document is a support pattern describing how to troubleshoot and fix ORA-01000 errors propagated to WebLogic Server via SQLException.

Problem Description

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.

Problem Troubleshooting

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.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Problem Description
 Problem Troubleshooting
Troubleshooting Steps
 Diagnostic Queries
 Common Causes and Solutions
 Code Practice
 Statement Caching
 Database Driver
 Known Issues
 Need further help?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.