Make a copy of this worksheet for each Replication Agent instance you install. Fill out the worksheet before you install the Replication Agent software.
See the Replication Agent Reference Manual for detailed descriptions of Replication Agent commands, options, and parameters.
|
Item |
Description |
Example Value |
Your Value |
|---|---|---|---|
|
1a |
Replication Agent instance type This identifies the type of primary database the Replication Agent instance works with. |
oracle |
|
|
1b |
Replication Agent instance name This name must be unique among all Replication Agent instances. |
ra_sales_instance |
|
|
1c |
admin_port This is the client socket port number for the Replication Agent administration port. The port number must be unique (not used by any other application on the Replication Agent host machine). Note:
Check with the system administrator to determine which
port numbers are available.
Note:
Replication Agent for Oracle and Replication Agent for Microsoft
SQL Server each require two port numbers. The additional one is for
the RASD. By default, Replication Agent assigns the RASD port—admin
port +1. This number must also be unique.
|
10000 |
|
|
1d |
Location of the interfaces file. Use this item only if you plan to use the isql utility or Replication Manager to administer the Replication Agent instance. |
||
|
1e |
admin_user This is the administrative user ID you use to log in to the Replication Agent instance. The default value is sa. |
admin_user |
|
|
1f |
admin_pw This is the administrative password you use to log in to the Replication Agent instance. The default value is an empty string (""). |
admin_pw |
|
Item |
Description |
Example Value |
Your Value |
|---|---|---|---|
|
2a |
rs_source_ds This is a data server name representing the primary data server to which Replication Agent connects. This value is specified in the Replication Server create connection command used to create the Replication Agent connection in the primary Replication Server. Note:
This name can be the name of the Replication Agent instance.
|
ra_sales_instance |
|
|
2b |
rs_source_db This is a database name representing the primary database to which Replication Server connects. This value is specified in the Replication Server create connection command used to create the Replication Agent connection in the primary Replication Server. Note:
This name can be any name that helps you identify this
as the connection to the primary database. For example, it can be
the same name as the pds_database_name.
|
sales_db |
|
|
2c |
Maintenance user This is the Replication Server maintenance user ID associated with the connection to the primary database. Replication Server requires a maintenance user ID for every database connection. This value is used in the create connection command when you create the connection to the primary database. Note:
This user ID must be valid at the primary database.
|
maint_user |
|
|
2d |
Maintenance user password This is the Replication Server maintenance user password associated with the connection to the primary database. |
maint_pwd |
|
Item |
Description |
Example Value |
Your Value |
|---|---|---|---|
|
3a |
rs_host_name This is the name or IP address of the Replication Server host machine. |
rs_host |
|
|
3b |
rs_port_number This is the port number Replication Agent uses to log in to Replication Server. |
1111 |
|
|
3c |
rs_username This is the Replication Server client user ID that Replication Agent uses to log in to the primary Replication Server. This user ID must have connect source authority in the Replication Server. Note:
The value for the rs_username parameter cannot
be the same as the value for the pdb_maint_user parameter
(item 2c).
|
rs_user |
|
|
3d |
rs_password This is the Replication Server client user password that Replication Agent uses. |
rs_pw |
|
|
3e |
rs_charset Note:
This property is referenced only if you are using Replication
Server 15.0 and earlier. For Replication Server 15.0.1 and later,
Replication Agent automatically queries the Replication Server property RS_charset.
This is the character set that Replication Agent uses when creating LTL commands for Replication Server. It must match the Replication Servers character set, defined by the RS_charset property in the Replication Server configuration file. An example of a configuration file is $SYBASE/REP-15_0/install/ instance_name .cfg, where instance_name is the name of the Replication Agent instance. Note:
If you are using Replication Server 15.0 and earlier,
setting this property to anything other than the character set of
the primary Replication Server causes it to incorrectly perform
character set conversion of the LTL commands it receives from Replication Agent.
Only if this value is different from the RA_JAVA_DFLT_CHARSET
value (which should match the primary databases character set) will Replication
Agent perform character set conversion on the character data being
replicated. Character set conversion slows performance.
|
|
Item |
Description |
Example Value |
Your Value |
|---|---|---|---|
|
4a |
rssd_host_name This is the name of the host machine on which the RSSD of the primary Replication Server resides. |
rssd_host |
|
|
4b |
rssd_port_number This is the client socket port number for the RSSD data server. |
1111 |
|
|
4c |
rssd_database_name This is the database name of the RSSD of the primary Replication Server. |
rsdb_RSSD |
|
|
4d |
rssd_username This is the RSSD client user ID that Replication Agent uses to access the RSSD of the primary Replication Server. |
rssd_user |
|
|
4e |
rssd_password This is the RSSD client password that Replication Agent uses. |
rssd_pass |
|
Item |
Description |
Example Value |
Your Value |
|---|---|---|---|
|
5a |
pds_tns_filename Note:
This value is for Oracle only.
The fully-qualified file name identifying the Oracle tnsnames.ora file that contains connection properties for the primary Oracle data server. |
/path1/tnsnames.ora |
|
|
5b |
pds_tns_connection Note:
This value is for Oracle only.
The Oracle connection name that identifies the primary database connection in the Oracle tnsnames.ora file |
SALES_DB_CONN |
|
|
5c |
asm_tns_filename Note:
This value is for Oracle only.
Identifies the Oracle tnsnames.ora filename where the ASM connection information is located. If this is the same tnsnames.ora file as configured in pds_tns_filename, you can leave this parameter unset. Note:
Set this parameter only if the redo logs of your primary
Oracle are under Automatic Storage Management.
|
/path2/tnsnames.ora |
|
|
5d |
asm_tns_connection Note:
This value is for Oracle only.
Identifies the Oracle ASM connection name found in the tnsnames.ora file. Note:
Set this parameter only if the redo logs of your primary
Oracle are under Automatic Storage Management.
|
+ASM1_CONN |
|
|
5e |
asm_username Note:
This value is for Oracle only.
Identifies the Oracle user name to be used when connecting to the ASM server. Note:
Set this parameter only if the redo logs of your primary
Oracle are under Automatic Storage Management.
|
sys as sysdba |
|
|
5f |
asm_password Note:
This value is for Oracle only.
Password for Oracle ASM access for the user specified in asm_username. Note:
Set this parameter only if the redo logs of your primary
Oracle are under Automatic Storage Management.
|
change_on_install |
|
|
5g |
pds_port_number This is the client socket port number for the primary database gateway server. |
1111 |
|
|
5h |
pds_server_name Note:
This value is for Microsoft SQL Server only.
This is the name of the Microsoft SQL Server primary database server. |
doc_23 |
|
|
5i |
pds_database_name This is the name of the primary database on the primary database server. Replication Agent uses this value to determine which database is the primary database. Note:
For Oracle, use the $ORACLE_SID. For Microsoft
SQL Server and for UDB, use the actual name of the primary database.
|
sales_db |
|
|
5j |
pds_datasource_name Note:
This value is for DB2 Universal Database only.
This is the datasource name (DSN) of the ODBC driver or the catalogued database alias for the primary database. |
sales_db_alias |
|
|
5k |
pds_username This is the user ID that Replication Agent uses to log in to the primary database. |
pds_user |
|
|
5l |
pds_password This is the password for pds_username. |
pds_pw |
|
|
5m |
This is the Java-equivalent of the primary database character set. Note:
Unless you want to override the default character set
that the JVM finds on your system, you do not need
to explicitly set the character set-related environment variable,
RA_JAVA_DFLT_CHARSET. However, the system
default character set must match the character set of the primary
database.
|
||
|
5n |
pds_dac_port_number Note:
This value is for Microsoft SQL Server only.
The dedicated administration connection port number that Replication Agent uses to connect to the primary database during the server-level initialization of the primary data server. |
1348 |
|
Item |
Description |
Example Value |
Your Value |
|---|---|---|---|
|
6a |
Replicate host name The name of the host machine on which the replicate data server resides. You need this name when you create subscriptions. See the Replication Server documentation. |
rds_host |
|
|
6b |
Replicate database name This is the name of the replicate database on the replicate database server. You need this name when you create subscriptions. See the Replication Server documentation. |
replicate_db |
|
|
6c |
ddl_username Note:
This value is for Oracle and Microsoft SQL Server only.
This is the replicate database client user ID that Replication Server uses to log in to the replicate database to apply DDL commands. This user ID must have authority in the replicate database to create any schema or issue any DDL command replicated from the primary database. The Replication Agent sends this ID and password to Replication Server together with any DDL command executed at the primary database. Note:
The value for ddl_username cannot
be the same as the value of the maintenance user defined in Replication
Server for the replicate connection.
|
scott |
|
|
6d |
ddl_password Note:
This value is for Oracle and Microsoft SQL Server only.
This is the replicate database client user password that Replication Server uses with the value for ddl_username. |
tiger |
Replication Agent Administration Guide –
initial configuration of Replication Agent parameters for Replication Server
Replication Agent Primary Database Guide –
initial configuration of the primary database you are replicating
Replication Agent Reference Manual –
ra_config command
Replication Server Reference Manual –
Replication Server commands and parameters