Question
TATA Consultancy Services
IN
Last activity: 15 Feb 2018 3:24 EST
DatabaseException caused by prior exception: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
Hi, We are getting the maximum open cursors exceeded exception in log files and unable to work on the env. We have checked with DB team they are suggested to close the open cursors and need to close in application side. Can any one explain about that. Where we need to configure. We are using PRPC 7.3 env. DatabaseException caused by prior exception: java.sql.SQLException: ORA-01000: maximum open cursors exceeded ORA-06512: at "PEGASIT_DATA.SPPR_SYS_RESERVEQUEUEITEM_B", line 152 ORA-01000: maximum open cursors exceeded ORA-06512: at line Regrads, Muthu
Pegasystems Inc.
IN
Hello!
Hope you are doing Good.
1.Can You paste complete Exception stack from the server log file.
Couple of approaches you need to try
1. Can you try upgrading the driver version to OJDBC6 or later
Please go through the below links ,this might be helpful:
Regards,
Hepsi
Pegasystems Inc.
IN
Hi Muthu,
If you have started seeing this recently, there might be a chance of new functionality or usecase causing this.
Please use below url to check for the queries that cursor might be using to understand more on the use case causing this.
https://docs.oracle.com/cd/E40329_01/admin.1112/e27149/cursor.htm#OMADM5352
Regards,
Ujjwal