Initializing the Replication Agent

To configure Replication Agent for the active database, start the Replication Agent for Oracle (RAO) instance and connect to it using isql.

1. Set the archive log file path of the source Oracle database:

   ra_config pdb_include_archives, true
   go
   ra_config pdb_archive_path, <path-to-oracle-archive-directory>
   go
   

2. Configure connection of Replication Agent to the primary database:

   ra_config pds_host_name, <the host name of the source oracle>
   go
   ra_config pds_port_number <the port number of the source oracle>
   go
   ra_config pds_database_name,<the source oracle database name>
   go
   ra_config  pds_username, <the oracle user for Replication Agent>
   go
   ra_config pds_password, <password>
   go
   test_connection PDS
   go
   

   If the connection is established successfully, you see:

   Type Connection
   

   ---- 		----------
   

   PDS  succeeded
   

3. Configure the Replication Agent connection to Replication Server:

   ra_config rs_host_name, <the host name of the Replication Server>
   go
   ra_config rs_port_number, <the port number of the
   Replication Server>
   go
   ra_config rs_username, <the Replication Server user for Replication Agent>
   go
   ra_config rs_password, <password>
   go
   ra_config rs_source_ds ',' <the DCON server name> 
   go
   ra_config rs_source_db ',' <the source oracle database name>
   go
   

   If you are using ExpressConnect for Oracle, replace the DirectConnect sever name with the name of the Oracle instance. For example:

   ra_config rs_source_ds, 'ordb'
   go
   rs_config rs_source_db, 'ordb'
   go
   

4. Configuring the Replication Agent connection to ERSSD:

   ra_config rssd_host_name <the host name of the ERSSD>
   go
   ra_config rssd_port_number, <the port number of the ERSSD>
   go
   ra_config rssd_username, <the ERSSD user for
   Replication Agent>
   go
   ra_config rssd_password, <password>
   go
   ra_config rssd_database_name, <the database name of the ERSSD>
   go
   test_connection RS
   go
   

   If the connection is established successfully, you see:

   Type Connection
   

   ---- 		----------
   

   RS  succeeded
   

5. If the character set of Replication Server is not the same as Replication Agent, update the Replication Server character set:

   ra_config rs_charset, <the charset of the Replication Server>
   

6. Create a replication definition for each table marked for replication:

   ra_config pdb_auto_create_repdefs, true 
   go
   

7. Set automatic marking of user tables:

   ra_config pdb_automark_tables, true 
   go
   

8. Initialize the Replication Agent transaction log:

   pdb_xlog init
   

9. Enable DDL replication for the active database. Enter:

   pdb_setrepddl enable
   

   Some DDL commands are filtered even when DDL replication is enabled. If you are enabling DDL replication, you must also set ddl_password and ddl_username.

10. Create replication definitions for tables created before Replication Agent was initialized:

    rs_create_repdef all 
    go