Oracle

Note

When using Replicate Preview, only Snapshot (also known as Refresh) replication is supported. Please ensure that you follow the guidelines specific to Refresh replication in this database system. To utilize other replication types, use the desktop version of the application and refer to the corresponding information to those replication methods.

Overview

This page provides the required information for setting up replications using Oracle as a:

Versions Supported

Oracle is supported as source and target systems in Refresh, Mirroring, and Synchronization with the following version combinations:

Oracle version 18c
Oracle version 19c
Oracle version 21c

Editions Supported

Those versions are supported as source and target systems:

Oracle Enterprise Edition
Standard Edition
Express Edition
Oracle Autonomous
Oracle Autonomous Warehouse

Prerequisites

Before connecting to an Oracle database from Syniti Replicate, ensure that the Oracle .NET provider is installed and accessible from the system where Syniti Replicate is running, which is available from Oracle with the Oracle Database Client.

If you install Syniti Replicate on the system where the Oracle server is installed, the Oracle .NET Data Provider should already be installed as part of the Oracle installation and Syniti Replicate should be able to find the provider automatically.

If you install Syniti Replicate on a different system, to connect to the Oracle server you need to install the Oracle client on the same system as Syniti Replicate.

Assembly: Oracle.DataAccess (file name: Oracle.DataAccess.dll)

Sample path: C:\oracle19\client\odp.net\bin\2.x\Oracle.DataAccess.dll.

Register the Oracle.DataAccess.dll assembly in GAC

You must register the Oracle.DataAccess.dll assembly to the Global Assembly Cache (GAC) for .NET version 2 and version 4:

Open Command Prompt as an Administrator.
Access %ORACLE_CLIENT_HOME%\ODP.NET\bin\2.x.
Execute the following command:
oraprovcfg.exe/action:gac/providerpath:Oracle.DataAccess.dll
Navigate to %ORACLE_CLIENT_HOME%\ODP.NET\bin\4.x.
Execute the following command:
oraprovcfg.exe/action:gac/providerpath:Oracle.DataAccess.dll

Add the Oracle Client in your Windows Environments

To ensure your system recognizes the Oracle Client, you need to set the following environment variables:

Update the PATH variable

Open Environment Variables:
- Press Win + R, enter sysdm.cpl, and press Enter.
- Access the Advanced tab and click Environment Variables.
Add Oracle Client to PATH:
- In the System Variables section, locate and select Path.
- Click Edit and add the path to your Oracle Client's bin folder, for example, C:\Oracle\WINDOWS.X64_193000_client_home\bin.
Click OK to save.

Considerations

Ensure that the Oracle client version must be aligned with the Oracle database.
Instant Client doesn’t contain the .NET provider, you must download the full client.

Limitations

When using Oracle 19 or higher on Real Application Cluster (RAC) is not supported via Log Reader or Log Server Agent. Only Triggers-based replication is supported.
Oracle SEHA (Standard Edition High Availability) is not supported.
Oracle ASM and TDE File formats are not supported with Log Server Agent.
Using Oracle as source, with multiple PDBs, all of them must be open. The Oracle LogMiner expects all PDB opens to access to the LogMiner of all nodes, even if there are not used for replications.

Connection Properties

Required Information

Property	Description
Data Source	Oracle Net Service name that identifies the database to connect to.
User ID	Database User ID
Password	User password

Optional Information

Property	Description
Connection Timeout	Maximum time (in seconds) to wait for a free connection from the pool. Default value 15 seconds.
Connection Lifetime	Maximum life time (in seconds) of the connection. Default value is 0 seconds.
Statement Cache Purge	Purges the statement cache when the connection goes back to the pool. Default value is False.
Statement Cache Size	Enables Statement Caching and sets the cache size, that is, the maximum number of statements that can be cached. Default value is 0.
Proxy user ID	User name of the proxy user.
Proxy Password	Password of the proxy user.
Pooling	Enables or disables connection pooling. Default value is False.
Max Pool Size	The maximum number of connections allowed in the pool.
Min Pool Size	The minimum number of connections allowed in the pool.
Incr Pool Size	Controls the number of connections that are stablish when all the connections in the pool are used. Default value is 5.
Decr Pool Size	Controls the number of connections that are closed when an excessive amount of established connections are used. Default value is 1.
Enlist	Enables or disables serviced components to automatically enlist in distributed transactions. Default value False.
Extended Properties	Additional properties no listed in the grid. Enter the properties as a list of "property = value" string separated by ";".