Using Oracle for Arcviz metastore - hitting error "libclntsh.so: cannot open shared object file:

If you installed Arcadia Enterprise and using Oracle as the metastore for visualization server you might see an error like below complaining about not finding oracle library:

DPI-1047: 64-bit Oracle Client library cannot be loaded: "libclntsh.so: cannot open shared object file:

File "/opt/cloudera/parcels/ARCADIAENTERPRISE-4.4.0.0-1537468711.cdh5/lib/venv/lib64/python3.6/site-packages/django/db/backends/base/base.py", line 189, in connect

    self.connection = self.get_new_connection(conn_params)

  File "/opt/cloudera/parcels/ARCADIAENTERPRISE-4.4.0.0-1537468711.cdh5/lib/venv/lib64/python3.6/site-packages/django/db/backends/oracle/base.py", line 212, in get_new_connection

    return Database.connect(self._connect_string(), **conn_params)

django.db.utils.DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded: "libclntsh.so: cannot open shared object file: No such file or directory". See https://oracle.github.io/odpi/doc/installation.html#linux for help

SOLUTION

You will need to manually install Oracle client. Refer to this Error when trying to create an Oracle Connection

1 Like