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

Last updated on JUNE 27, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms