# Client prerequisites

Before you can work with an Oracle endpoint, make sure the prerequisites in this section have been met.

Information note

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`