Client prerequisites
Before you can work with an Oracle endpoint, make sure the prerequisites in this section have been met.
Support for the XMLTYPE data type requires the full Oracle Client.
Replicate on Windows
Install Oracle Instant Client for Microsoft Windows (x64) Version 19.0 or later.
Replicate on Linux
Install Oracle Instant Client for Linux (x86-64) Version 19.0 or later.
In addition, if not already included in your system, you need to create a symbolic link in the $Oracle_Home\lib directory. This link should be called libclntsh.so, and should point to a specific version of this file.
Example:
lrwxrwxrwx 1 oracle oracle 63 Oct 2 14:16 libclntsh.so -> /u01/app/oracle/home/lib/libclntsh.so.19.1
Additionally, append the LD_LIBRARY_PATH environment variable to the Oracle lib directory by copying the driver location to the site_arep_login.sh file as follows:
echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/u01/app/oracle/home/lib/" > site_arep_login.sh