Forums

Connect to Oracle external

Good afternoon, I'm trying to connect the superset to a database, but the following error is occurring:

ERROR: {"error": "Connection failed! \ N \ nThe error message returned was: \ n (cx_Oracle.DatabaseError) DPI-1047: 64-bit Oracle Client library can not be loaded: \" libclntsh.so: can not open shared object file: No such file or directory \ ". See https://oracle.github.io/odpi/doc/installation.html#linux for help (Background on this error at: http://sqlalche.me/e/ 4xp6) "}

In windows I solved the problem by adding a variable in the environment:

https://github.com/oracle/python-cx_Oracle/issues/5

How do I do in linux?

Could you try following the instructions from this gist, skipping step 1 (because I think all of the appropriate files are already installed) and see if it helps?

I did not understand step 5, as the file 'oracle.conf' did not exist in the folder I tried to create, but the permission was denied.

Hmm, good point -- I missed that one. Try skipping that step, and see if it works without it.

It does not work. At that first moment I got an alternative solution, using the superset database.

OK -- glad you have a solution, at least!