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

Hi,

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?

Thanks,
Salah

This sounds like a bug. I’ve filed an issue at https://github.com/metabase/metabase/issues/6029

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 ?

Thanks,

Ricardo Jorge