Question

3
Replies
987
Views
Close popover
Nadimuthu Thangavel (Nadimuthu T)
ANZ
Engineer
ANZ
IN
Nadimuthu T Member since 2014 31 posts
ANZ
Posted: February 5, 2018
Last activity: February 15, 2018
Closed

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

System Administration Data Integration
Moderation Team has archived post