-
Bug
-
Resolution: Not an Issue
-
P4
-
None
-
7u80
-
x86
-
other
FULL PRODUCT VERSION :
java- version output
java version "1.7.0"
Java(TM) SE Runtime Environment (build pwa6470sr4fp1ifix-20130423_02(SR4 FP1+IV3
8579+IV38399+IV40208))
IBM J9 VM (build 2.6, JRE 1.7.0 Windows Server 2012 amd64-64 Compressed Referenc
es 20130421_145945 (JIT enabled, AOT enabled)
J9VM - R26_Java726_SR4_FP1_2_20130421_2353_B145945
JIT - r11.b03_20130131_32403ifx4
GC - R26_Java726_SR4_FP1_2_20130421_2353_B145945_CMPRSS
J9CL - 20130422_145945)
JCL - 20130225_01 based on Oracle 7u13-b08
ADDITIONAL OS VERSION INFORMATION :
Windows Server 2012 R2
A DESCRIPTION OF THE PROBLEM :
This is known issue for which bug is already reported. viz 19632480.Seems like its patched with weblogic server patch(community link: https://community.oracle.com/thread/3682300)
Can we have a generic updated ojdbc7.jar with includes this fix.(we need it with version 7 only)
STEPS TO FOLLOW TO REPRODUCE THE PROBLEM :
community link: https://community.oracle.com/thread/3682300
EXPECTED VERSUS ACTUAL BEHAVIOR :
EXPECTED -
no cursor leaks should exist.
ACTUAL -
Cursor leaks are happening
ERROR MESSAGES/STACK TRACES THAT OCCUR :
0000011a SystemOut O 16:53:41,863 ERROR [ims.tmt.persistence] PersistenceProvider: WebContainer : 0: insertTaskSessionEvent: exception getting task session: ORA-01000: maximum open cursors exceeded
and the tasksessionid = 18307ea5-504af761-74347b0e-e009d4
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
REPRODUCIBILITY :
This bug can be reproduced always.
CUSTOMER SUBMITTED WORKAROUND :
community link: https://community.oracle.com/thread/3682300
java- version output
java version "1.7.0"
Java(TM) SE Runtime Environment (build pwa6470sr4fp1ifix-20130423_02(SR4 FP1+IV3
8579+IV38399+IV40208))
IBM J9 VM (build 2.6, JRE 1.7.0 Windows Server 2012 amd64-64 Compressed Referenc
es 20130421_145945 (JIT enabled, AOT enabled)
J9VM - R26_Java726_SR4_FP1_2_20130421_2353_B145945
JIT - r11.b03_20130131_32403ifx4
GC - R26_Java726_SR4_FP1_2_20130421_2353_B145945_CMPRSS
J9CL - 20130422_145945)
JCL - 20130225_01 based on Oracle 7u13-b08
ADDITIONAL OS VERSION INFORMATION :
Windows Server 2012 R2
A DESCRIPTION OF THE PROBLEM :
This is known issue for which bug is already reported. viz 19632480.Seems like its patched with weblogic server patch(community link: https://community.oracle.com/thread/3682300)
Can we have a generic updated ojdbc7.jar with includes this fix.(we need it with version 7 only)
STEPS TO FOLLOW TO REPRODUCE THE PROBLEM :
community link: https://community.oracle.com/thread/3682300
EXPECTED VERSUS ACTUAL BEHAVIOR :
EXPECTED -
no cursor leaks should exist.
ACTUAL -
Cursor leaks are happening
ERROR MESSAGES/STACK TRACES THAT OCCUR :
0000011a SystemOut O 16:53:41,863 ERROR [ims.tmt.persistence] PersistenceProvider: WebContainer : 0: insertTaskSessionEvent: exception getting task session: ORA-01000: maximum open cursors exceeded
and the tasksessionid = 18307ea5-504af761-74347b0e-e009d4
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:4875)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1361)
REPRODUCIBILITY :
This bug can be reproduced always.
CUSTOMER SUBMITTED WORKAROUND :
community link: https://community.oracle.com/thread/3682300