Metadata Sync Fails with ORA-01000: maximum open cursors exceeded


Using metabase 0.25 on top of an Oracle database that contains thousands of tables and hundreds of schemas. User accessing the database has only access to a couple of table/schemas.

The metadata sync fails with ORA-01000: maximum open cursors exceeded (even if database number of max cursor is set to 300!) which makes me think that metabase is opening a significant number of concurrent connections to the database during the sync process.

Is there a way to overcome this or my only option is to increase the open_cursor parameter on the database?


This sounds like a bug. I’ve filed an issue at

I’m having this same issue when connecting to Oracle. MetaBase 0.26.2 ( jar ) on Ubuntu 16.04 LTS. Thanks.

Hi there, let me explain what I did so far

  • changed from open-jdk to oracle jdk
  • changed from SID to service
  • changed jdbc driver versions ( ojdbc7.jar and ojdbc6.jar )

No luck !

From this same machine and using the same oracle configuration I can connect dremio to the oracle without problems and browse the schema and its contents.

Any idea ? What else could be tested ?


Ricardo Jorge