# Oracle: ORA-01000 maximum open cursors exceeded

**URL:** <https://forum.liquibase.org/t/oracle-ora-01000-maximum-open-cursors-exceeded/2022>\
**Category:** General Discussion\
**Created:** [July 5, 2012, 1:56pm UTC](https://forum.liquibase.org/t/oracle-ora-01000-maximum-open-cursors-exceeded/2022 "2012-07-05T13:56:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![karl\_puperze](https://avatars.discourse-cdn.com/v4/letter/k/b487fb/32.png) [@karl\_puperze](https://forum.liquibase.org/u/karl_puperze)\
**Post date:** [July 5, 2012, 1:56pm UTC](https://forum.liquibase.org/t/oracle-ora-01000-maximum-open-cursors-exceeded/2022/1 "2012-07-05T13:56:00Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [July 5, 2012, 1:56pm UTC](https://forum.liquibase.org/t/oracle-ora-01000-maximum-open-cursors-exceeded/2022/2 "2012-07-05T13:56:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\
**Post date:** [July 5, 2012, 1:56pm UTC](https://forum.liquibase.org/t/oracle-ora-01000-maximum-open-cursors-exceeded/2022/3 "2012-07-05T13:56:00Z")

</div>

Ask your DBA what parameter open\_cursors is set to.&nbsp; On our systems its set to over 400.

---

<div class="post-metadata">

**Author:** ![noldewit](https://avatars.discourse-cdn.com/v4/letter/n/3bc359/32.png) [@noldewit](https://forum.liquibase.org/u/noldewit)\
**Post date:** [July 5, 2012, 1:56pm UTC](https://forum.liquibase.org/t/oracle-ora-01000-maximum-open-cursors-exceeded/2022/4 "2012-07-05T13:56:00Z")

</div>

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

[http://forum.liquibase.org/#Topic/49382000000906003](http://forum.liquibase.org/#Topic/49382000000906003)