Decision Management & Intelligence (ODM, DI)

Decision Management & Intelligence (ODM, DI)

Connect with experts and peers to elevate technical expertise, solve problems and share insights


#Data
#Data
#Businessautomation
 View Only
Back to discussions
Expand all | Collapse all

Why am I getting ORA-01000: maximum open cursors exceeded error in the logs?

  • 1.  Why am I getting ORA-01000: maximum open cursors exceeded error in the logs?

    Posted Tue August 17, 2021 08:07 PM

    I am using the Oracle DB server for the decision center database & randomly I get the 'ORA-01000: maximum open cursors exceeded' error in the logs & then I am unable to access the decision center. A restart of the server is needed to access the decision center again. Why am I seeing this error & how do I resolve this problem?



    #OperationalDecisionManager(ODM)
    #Support
    #SupportMigration


  • 2.  RE: Why am I getting ORA-01000: maximum open cursors exceeded error in the logs?
    Best Answer

    Posted Tue August 17, 2021 08:10 PM

    This problem is seen when using Oracle JDBC driver v12.1.0.2.0 due to a known Oracle bug. To resolve this issue use Oracle JDBC driver v12.1.0.1.0 for your decision center database datasource connection.



    #OperationalDecisionManager(ODM)
    #Support
    #SupportMigration


  • 3.  RE: Why am I getting ORA-01000: maximum open cursors exceeded error in the logs?
    Best Answer

    Posted Thu October 21, 2021 05:39 PM

    Please make sure you are using a up to date Oracle jdbc driver as we've seen this issue reported with a few versions of Oracle jdbc driver. You can try the newer version of Oracle JDBC ojdbc8 driver instead of the one with same version as your database. According to Oracle JDBC and RDBMS interoperability matrix, you should be able to use the newer driver version.

    https://www.oracle.com/database/technologies/faq-jdbc.html



    #OperationalDecisionManager(ODM)
    #Support
    #SupportMigration


Related Content