Hi, I am working on a project requiring us to pull the data from Oracle to MariaDB Galeria Cluster. For this, we have chosen to use a connect storage engine. I have followed the instructions as below

• Installed two node MariaDB Galera cluster.
• Install unixODBC
• Installed connect plugin.
• Installed oracle client 12.1
• Configured tnsnames.ora, odbc.ini and odbcinst.ini.

After that, I tested the connection, and it worked fine. However, when I try to create a table in MariaDB cli, it fails with the below error.

ERROR 1105 (HY000): SQLDriverConnect: [unixODBC][Driver Manager]Can't open lib '/usr/lib/oracle/12.1/client64/lib/libsqora.so.12.1' : file not found

I correctly set the env of LD_LIBRARY_PATH, and the permissions of the files look fine as I am trying with the root user.

Can someone please help with this.

Thanks,
Prabha