Question

3
Replies
964
Views
Nadimuthu T Member since 2014 30 posts
ANZ
Posted: 2 years ago
Last activity: 2 years 8 months ago
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
Share this page LinkedIn