# Prerequisites

The following section describes the prerequisites for working with the Qlik Replicate Oracle endpoint.

## Install the required driver

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

1. Stop the Replicate service and optionally confirm that it has stopped as described in [Replicate server procedures](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Installation/Server_Procedures.htm).

2. Install Oracle Instant Client for Linux (x86-64) Version 19.0 or later.

3. In addition, if not already included in your system, create a symbolic link in the `$Oracle_Home\lib` directory. Name the link `libclntsh.so`, and point it 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

4. Change the working directory to <Replicate-Install-Dir>/bin.and append the `LD_LIBRARY_PATH` environment variable to the Oracle instant client directory and to the Replicate `lib` directory. Do this by copying the driver location to the `site_arep_login.sh` file:

   ```
   echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/opt/oracle/instantclient_<version>:/opt/attunity/replicate/lib/" > site_arep_login.sh
   ```

5. Optionally, confirm that the driver location was copied:

   ```
   cat site_arep_login.sh
                           
   ```

6. Start the Replicate service and optionally confirm that it has started as described in [Replicate server procedures](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/Installation/Server_Procedures.htm).

## Oracle XStream Prerequisites

You need to obtain a license from Oracle to use the Oracle XStream API.

After obtaining the license, fulfill the prerequisites described in [Prerequisites for Configuring XStream Out](https://docs.oracle.com/en/database/oracle/oracle-database/19/xstrm/configuring-xstream-out.html#GUID-C3391C7F-D2C5-4A65-AA29-4B0EBC2B205E).

### Create XStream Outbound server

By default, Replicate, creates a local ‘Capture Process’ and ‘Outbound Server’ per task. This requires the Oracle user to have XStream administrator privileges, as described in [Configure an XStream Administrator on All Databases](https://docs.oracle.com/en/database/oracle/oracle-database/19/xstrm/configuring-xstream-out.html#GUID-C0E1C4AC-994A-4F62-B580-63742C9B7128).

For other options related to the XStream server, see [Setting advanced connection properties](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/OracleXStream/setting_advanced_conneciton_params.htm).

## Permissions

Information note

When replicating from Oracle for Amazon RDS, see [Required Amazon RDS for Oracle permissions](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/OracleXStream/oracle_rds_prerequisites.htm#Required) instead.

### General permissions

To use the Oracle XStream endpoint in a replication task, the user defined in the Oracle XStream endpoint settings must be granted the following privileges in the Oracle database.

Information note

If any of the required privileges cannot be granted to a V$xxx, then grant them to the V\_$xxx.

* CREATE SESSION
* SELECT on V\_$PARAMETER
* SELECT on V\_$NLS\_PARAMETERS
* SELECT on V\_$CONTAINERS
* SELECT on ALL\_INDEXES
* SELECT on ALL\_OBJECTS
* SELECT on ALL\_TABLES
* SELECT on ALL\_USERS
* SELECT on ALL\_CATALOG
* SELECT on ALL\_CONSTRAINTS
* SELECT on ALL\_CONS\_COLUMNS
* SELECT on ALL\_TAB\_COLS
* SELECT on ALL\_IND\_COLUMNS
* SELECT on ALL\_LOG\_GROUPS
* SELECT on V\_$DATABASE
* SELECT on SYS.DBA\_REGISTRY
* If views are exposed: SELECT on ALL\_VIEWS

Grant the following additional privilege (for each source table) when you are replicating a list of specific tables:

* SELECT on &lt;any-source-table&gt;;

Grant the following additional privilege when using a pattern for the table list:

* SELECT ANY TABLE;

Grant the following additional privilege (for each source table) when Replicate adds supplemental logging automatically (the default behavior) and you are replicating a list of specific tables.

* ALTER on &lt;any-source-table&gt;;

Grant the following additional privilege when Replicate adds supplemental logging automatically (the default behavior) and you are using a pattern for the table list:

* ALTER ANY TABLE;

For information on the Automatically add supplemental logging option, see [​Additional advanced properties](https://help.qlik.com/en-US/replicate/May2026/Content/Replicate/Main/OracleXStream/setting_advanced_conneciton_params.htm#​Additio).