Oracle: ORA-01000 maximum open cursors exceeded

General Discussion
1

When I try to process a huge set of changesets I always get the following error message:

  1. INFO 21.06.12 19:52:liquibase: java.sql.SQLException: ORA-01000: maximum open cursors exceeded
Then I have to split it in smaller sets and it works. We use Oracle 10g/11g. Is it a configuration problem or should I create a new Jira issue?
2

Is there somebody that has the same problem (and solved it) or knows how to deal with this kind of oracle error?

3

Ask your DBA what parameter open_cursors is set to.  On our systems its set to over 400.

4

Encountered this on 3.0.5, not on 2.0.5. For that reason posted a new issues:


http://forum.liquibase.org/#Topic/49382000000906003