Configuring Replication Agent

Start the RAO instance and connect to it using isql.

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

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

2. Configure a connection between Replication Agent and the primary database. Enter:

   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. Enter:

   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 current RAO instance name> 
   go
   ra_config rs_source_db, <the source oracle database name>
   go

   Note:

   You must specify the RAO instance name.

4. Configure the Replication Agent connection to the 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 charset of Replication Server is not the same as Replication Agent, enter:

   ra_config rs_charset, <the charset of the Replication Server>

6. To correctly handle update or delete transactions, configure ltl_send_only_primary_keys as false:

   ra_config ltl_send_only_primary_keys, false

   Note:

   Sybase IQ InfoPrimer cannot handle delete or update transactions if you do not perform this step.

7. Initialize Replication Agent:

   pdb_xlog init