My Oracle Support Banner

ORA-1000 After Upgrading To JDBC 12.1.0.2 With WebLogic 12.1.3 (Doc ID 2174682.1)

Last updated on FEBRUARY 03, 2019

Applies to:

JDBC - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms


When trying to use JDBC 12.1.0.2 with WLS 12.1.3, encountered the error 'maximum cursor limit exceeded'.
Based on this forum thread reporting a similar issue, <Patch 19632480> - ORACLEDATABASEMETADATA.GETTABLES CURSOR CONNECTION LEAK was applied, but the ORA-01000: maximum open cursors exceeded error persists.

This forces JDBC 11g to be used with WebLogic 12.1.3 application datasources, with which the error does not occur.

ERROR
-----------------------
ORA-01000: maximum open cursors exceeded


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 20741228 on top of WebLogic 12.1.3 for production version of JDBC 12.1.0.2.
2. Apply patch 19632480 to fix the issue in bug: 19632480 - ORACLEDATABASEMETADATA.GETTABLES CURSOR CONNECTION LEAK.
3. Run the application. The ORA-1000 error will be reported in the WebLogic logs.


Cause

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
Symptoms
Cause
Solution
References


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