Setup for Different Oracle Versions

The Oracle client must be installed on the same system as Syniti Data Replication.

Oracle v 8.1.7 and higher can be used as a source for replication in refresh and mirroring modes, and a target for replication in synchronization. Replications are based on Oracle redo log files which require use of a dictionary file. The dictionary file, starting from Oracle 9.0, has become ”online” and it is automatically created and managed by the DBMS, but for previous versions (8.1.7 up to 9.0), it must be created manually. Once created, you need to inform Syniti DR about its name and location to allow the mirroring to take place.

Your Syniti DR user account should be granted permissions to read the Oracle LogMiner (if using Oracle as a source), and write to the target tables (if using Oracle is a target.)

Oracle 9.0 or Higher

When creating a source connection for Oracle (or a source or target connection if you plan to do synchronization), check that the Use Online Dictionary option is selected in the Setup Info screen of the Source Connection wizard.  

Oracle 8.1.7 to 9.0

  1. Create the dictionary in the database. The user ID should have Database Administrator privileges.
    Using PL/SQL, run the following command:

            EXECUTE DBMS_LOGMNR_D.BUILD('<dictionary name>', '<dictionary path>')

  1. When creating a source connection for Oracle (or a source or target connection if you plan to do synchronization), check that the  Use Flat File Dictionary option is selected in the Setup Info screen of the Source Connection wizard.

  2. In the Dictionary File field, type the name of the dictionary file that you created above.