Hello, I'm trying to ingest a oracle database: Getting this error:

'DatabaseError: (cx_Oracle.DatabaseError) DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared '
           'object file: No such file or directory". See <https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html> for help\n'
           '(Background on this error at: <http://sqlalche.me/e/13/4xp6>)\n',
           "2022-03-01 09:16:17.371091 [exec_id=9a7d99e0-a12e-433e-ba3e-c4d384602ff6] INFO: Failed to execute 'datahub ingest'",

I did install the oracle package with pip install 'acryl-datahub[oracle]'. Any thoughts on where the error could be?

hi Sindre, take a look at https://stackoverflow.com/a/55825571

Thanks, not seeing any difference after adding the variable, is there some other things that should be done? Added with: export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib/${LD_LIBRARY_PATH+$LD_LIBRARY_PATH}

are you on linux or macos?

To test it out, DataHub is set up on a single linux EC2 in AWS, using the docker installation, having everything on the same server.

try installing libaio1

Package libaio-0.3.109-13.amzn2.0.2.x86_64 already installed and latest version And libaio1 is not found in yum

I guess you will need to install the instant client

Ok I will try this out soon hopefully, any reason why this does should not work with the default setup in DataHub?

It should!! If it doesn't that is an issue we need to raise

I have it working from the Windows Command line but not through the datahub UI. Any reason why? Same error "'DatabaseError: (cx_Oracle.DatabaseError) DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared '"

I recall this was an issue we were seeing for oracle specifically where there must be some additional system packages installed. cc @gray-shoe-75895 - do you remember this situation?

I was not able to do this with ingestion in command line as well

@square-solstice-69079 are you using windows?

I'm running all commands on the linux machine that we have it installed on

ah ok sorry can't help you then. I had to install the oracle instant client

no worries 🙂

as per https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html

no, but it seems like it was added when doing: pip install 'acryl-datahub[oracle]'

ok

@square-solstice-69079 in these instructions https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html#install-oracle-client, there’s a few extra steps you need to take to install the “oracle instant client”

I tried this and seem to be a bit stuck. Getting this error now: DatabaseError: (cx_Oracle.DatabaseError) DPI-1047: Cannot locate a 64-bit Oracle Client library: "/opt/oracle/instantclient_19_14/lib/libclntsh.so: cannot open shared object file: No such file or directory". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help (Background on this error at: http://sqlalche.me/e/13/4xp6) I downloaded the 19.14 client (instantclient-basic-linux.x64-19.14.0.0.0dbru.zip) Extracted into opt/oracle/instantclient_19_14 My env variables are now: ORACLE_HOME=/opt/oracle/instantclient_19_14 LD_LIBRARY_PATH=/opt/oracle/instantclient_19_14: oracle folder:

That’s super strange - not sure why the yum install failed but the manual rpm worked. In any case, glad it’s working now! Let us know what we can do improve the docs

Yea the problem with using yum, was that it did not find the package, and I was a bit unsure on how to add a repo that got those oracle packages.

Hello, I have the same error but in versions 0.11 or higher. In version 0.10.5 this error does not appear.

Hey there! 👋 Make sure your message includes the following information if relevant, so we can help more effectively! 1. Are you using UI or CLI for ingestion? 2. Which DataHub version are you using? (e.g. 0.12.0) 3. What data source(s) are you integrating with DataHub? (e.g. BigQuery)