Maximum open cursors Error on login and other times

chaoaj's Avatar

chaoaj

27 Mar, 2012 09:20 PM

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.

  1. Support Staff 1 Posted by Tim on 28 Mar, 2012 03:04 PM

    Tim's Avatar

    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.

    • What version of Cascade Server are you on?
    • What version of Oracle are you on?
    • What is the OPEN_CURSORS value set to in your Oracle instance?
    • You mentioned that you've seen this occur on login and at other times. Can you provide more details on what operations in the system cause this error to be displayed?

    Thanks!

  2. 2 Posted by chaoaj on 29 Mar, 2012 12:12 PM

    chaoaj's Avatar

    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

  3. Support Staff 3 Posted by Tim on 29 Mar, 2012 12:59 PM

    Tim's Avatar

    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!

  4. Tim closed this discussion on 18 May, 2012 07:10 PM.

Comments are currently closed for this discussion. You can start a new one.

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