Prerequisites
The following section describes the prerequisites for working with the Qlik Replicate Oracle endpoint.
Install the required driver
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
-
Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.
- Install Oracle Instant Client for Linux (x86-64) Version 19.0 or later.
-
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
-
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 -
Optionally, confirm that the driver location was copied:
cat site_arep_login.sh -
Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.
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.
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.
For other options related to the XStream server, see Setting advanced connection properties.
Permissions
When replicating from Oracle for Amazon RDS, see Required Amazon RDS for Oracle permissions 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.
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 <any-source-table>;
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 <any-source-table>;
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.