Configuring Replication Server for replication from the primary database

This section describes the configuration steps required for replication from the primary database. It includes:

• Creating a Replication Server connection to the primary database

• Creating a database replication definition

• Creating the database replication subscription

1. Go to the Replication Agent scripts, $SYBASE/RAX-15_1/scripts/oracle directory:

2. Make a copy of the oracle_create_rs_primary_connection.sql script:

   cp oracle_create_rs_primary_connection.sql
   my_oracle_create_rs_primary_connection.sql
   

3. Before executing the my_oracle_create_rs_primary_connection.sql script against your Replication Server, change all occurrences of value {pds}.{pdb} to the name of the Replication Server connection used for the connection from Replication Agent for Oracle, where:

   • pds is rs_source_ds (located in $SYBASE/RAX-15_1/init/oracle.rs).

   • pdb is rs_source_db (located in $SYBASE/RAX-15_1/init/oracle.rs).

   You must save the defined values to be used for the Replication Agent oracle.rs file later in the process.

   For example, NY.NYora92.

4. Change sys and sys_pwd to the user ID and password of the Oracle user who must have permission to apply DML operations against all user tables to be replicated, where:

   • sys is the user ID of the Oracle user (sys).

   • sys_pwd is the password of the Oracle user (change_on_install).

   This user must be a valid user in the Oracle database.

   The following command creates a Replication Server connection to the primary database example:

   create connection to NY.NYora92
   set error class rs_sqlserver_error_class
   set function string class rs_oracle_function_class
   set username sys
   set password change_on_install
   with log transfer on, dsi_suspended 
   go
   

5. Execute the script in Replication Server:

   isql –Usa –P –SSAMPLE_RS -i my_oracle_create_rs_primary_connection.sql
   

   A message is displayed that indicates the Replication Server connection to the primary database is created.

1. Navigate to the $SYBASE/RAX-15_1/scripts/sybase directory:

2. Make a copy of the rs_create_test_db_repdef.sql script:

   cp rs_create_test_db_repdef.sql
   my_rs_create_test_db_repdef.sql
   

3. Before executing the my_rs_create_test_db_repdef.sql script, change the value of “{pds}.{pdb}” to the name of the connection string you defined for the primary database, where:

   • pds is rs_source_ds (located in $SYBASE/RAX_15_1/init/oracle.rs).

   • pdb is rs_source_db (located in $SYBASE/RAX_15_1/init/oracle.rs).

   For example, NY.NYora92

   This is a database replication definition example:

   create database replication definition NY_repdef1
   with primary at NY.NYora92
   replicate DDL
   go
   

4. Connect to the Replication Server and enter:

   isql -Usa -P –SSAMPLE_RS -i my_rs_create_test_db_repdef.sql
   

   A message is displayed that indicates the database replication definition is created.

1. Make a copy of the rs_create_test_db_sub.sql script:

   cp rs_create_test_db_sub.sql
   my_rs_create_test_db_sub.sql
   

2. Before executing the my_rs_create_test_db_sub.sql script, change the “{pds}.{pdb}” and “{rds}.{rdb}'”to the appropriate connection name, where:

   • pds is rs_source_ds (located in $SYBASE/RAX_15_1/init/oracle.rs).

   • pdb is rs_source_db (located in $SYBASE/RAX_15_1/init/oracle.rs).

   • rds is the DirectConnect server name

   • rdb is any valid identifier. (Sybase recommends that you use the Oracle SID name.)

   Here is an example of create database replication subscription:

   create subscription NY_sub1
   for database replication definition NY_repdef1
   with primary at NY.NYora92
   with replicate at DCOServer.oratest2
   without materialization
   go
   

3. Connect to Replication Server and execute:

   isql -Usa -P –SSAMPLE_RS -i my_rs_create_test_db_sub.sql
   

   A message is displayed that indicates the subscription is in the process of being created.