Maximum open cursors Error on login and other times
We are receiving a maximum open cursors error - attached is the error. Has anyone seen anything like this or know what to do about this error?
Regards,
Alvin Chao
An error occurred: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select configurat0.id as id17, configurat0.type as type76, configurat0.metadataId as metadataId76, configurat0.content as content76 from cascade.cxml_configurationfile configurat0 where configurat0.type=?]; SQL state [60000]; error code [604]; ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-01000: maximum open cursors exceeded ; nested exception is java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-00604: error occurred at recursive SQL level 1 ORA-01000: maximum open cursors exceeded ORA-01000: maximum open cursors exceeded
You may choose to retry the operation. If the problem persists, please contact a system administrator.
The error has been logged to the system console.
Discussions are closed to public comments.
If you need help with Cascade CMS please
start a new discussion.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
Support Staff 1 Posted by Tim on 28 Mar, 2012 03:04 PM
Hi,
Has anything changed in your environment recently that seems to have coincided with the appearance of this error message? I'd be interested to know if you've upgraded Oracle from 10g to 11g, upgraded Cascade, or migrated database servers. While there is always a chance this could be an issue with the application, I haven't had any other reports of it yet so I'd like to rule everything else out as well.
Thanks!
2 Posted by chaoaj on 29 Mar, 2012 12:12 PM
Tim,
We increased our Open_Cursors as the error mentioned and that has relieved
the issue for now. What # do you recommend for this setting in a typical
Cascade instance. We plan to eventually support up to 800 users in the
database probably around 75-100 concurrent.
Regards,
@lvin
------------------------
Alvin Chao IT Web
JMU - MSC 5734 - Massnutten Hall 293
Harrisonburg, VA 22807
540-568-6206
[email blocked]
http://educ.jmu.edu/~chaoaj
Support Staff 3 Posted by Tim on 29 Mar, 2012 12:59 PM
Hey Alvin,
I'm no Oracle expert so that question is a bit difficult for me to answer. I did find what appears to be a useful article on Monitoring Open and Cached Cursors that may help you out. The Oracle documentation for the setting can be found here.
If no one else on these forums chimes in with their Oracle experience, you may want to ping the Higher Education mailing list and ask what those users have this value set to.
I hope this helps!
Tim closed this discussion on 18 May, 2012 07:10 PM.