Missing library for sqlldr

Hi, I am trying to use sqlldr to load the cache on an oracle database. sqlldr runs fine on the denodo system account. I just had to add ``` export LD_LIBRARY_PATH=/usr/lib/oracle/18.3/client64/lib:$LD_LIBRARY_PATH ``` to the profile. Nevertheless, it does not run through Denodo, and I get the following : ``` 1826448 [Thread-30] ERROR 2018-12-04T10:51:40.578 com.denodo.vdb.util.tablemanagement.sql.insertion.oracle.OracleSqlldrInsertWorker [] - STDERR >/usr/lib/oracle/18.3/client64/bin/sqlldr: error while loading shared libraries: libclntsh.so.18.1: cannot open shared object file: No such file or directory 1826449 [Access(10)-19-03.01-luxembourg_cars.iv_immatricu...] ERROR 2018-12-04T10:51:40.579 com.denodo.vdb.util.tablemanagement.sql.insertion.DFInsertWorker [] - Error closing resource: Error executing sqlldr command com.denodo.vdb.util.tablemanagement.TableManagerException: Error executing sqlldr command ``` I do not know what is happening. Any ideas? VDP has been restarted, obviously.
user
04-12-2018 04:54:44 -0500

1 Answer

Hi, I was able to replicate the behaviour you are encountering. This is the expected behaviour to avoid having libraries not related to Denodo Platform to affect the Denodo Platform. I would recommend to create a new script to wrap the sqlldr command, and in that context, modify the environment variables it needs (e.g. LD_LIBRARY_PATH). Hope this helps!
Denodo Team
12-12-2018 02:13:12 -0500
You must sign in to add an answer. If you do not have an account, you can register here