Error in Data360 Analyze: "Unable to open library `libclntsh.so`: cannot open shared object file. No such file or directory"

BACKGROUND:

Sometimes when using the database nodes in Data360 Analyze, you may see the following error. This could be due to the Linux machine having had patches applied for example, or if you are migrating data flows from one environment to another.

SOLUTION:

The linux environment variable LD_LIBRARY_PATH must point to the Oracle Client software.
If the Oracle Client software has been uninstalled, or moved to a new folder, then LD_LIBRARY_PATH must be updated and Analyze must be restarted. The Linux team will know where to find LD_LIBRARY_PATH and how to set the entry. Users can also set LD_LIBRARY_PATH in their " .profile.lavastorm file ".

As the error message suggests, you should also check that the Oracle client is installed and you're using the correct version.