During RedHat installations of Data Loss Prevention where the Oracle Client is being utilized, the installer may fail when attempting to connect to the database.

An error similar to the following will occur as the installer fails:

/usr/lib/oracle/11.2/client64/bin/sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Most often noticed after reinstalling the Oracle client, the error is specifically related to improper pathing to shared libraries.

The following steps should resolve the issue:

1. Identify the proper oracle library path on the RedHat server where Data Loss Prevention is attempting to be installed.  This path may be similar to one of the following examples:

   • /usr/lib/oracle/12.1/client64/lib/

   • /usr/lib/oracle/11.2/client/lib/

2. Navigate to /etc/ld.so.conf.d/ and ensure oracle.conf exists.  If it does not exist, create it with the following command:

   • sudo vi /etc/ld.so.conf.d/oracle.conf && sudo chmod o+r /etc/ld.so.conf.d/oracle.conf 

3. Add the oracle library path identified in Step 1 (as the first and only line) to the file.  If oracle.conf already exists in the environment, ensure that the first and only line in the file is the oracle library path.
4. Save and exit oracle.conf.
5. Run sudo ldconfig.
6. Reattempt the installation of Data Loss Prevention.