When Mirror Replication Agent connects to another Mirror Activator system component, it uses values stored in its configuration parameters to define the following minimal set of connection properties:
Server host name
Port number
User login name
User login password
For its connection to the Replication Server, Mirror Replication Agent relies on the values of two additional configuration parameters (rs_source_db and rs_source_ds) to identify the Replication Server primary database connection in the LTL connect source command.
The Mirror Replication Agent instance must be in Admin state to set up connection parameters. In Admin state, the instance has no connections established to other replication system components, but it is available to execute administrative commands. See “Understanding Mirror Replication Agent states”.
The values of the rs_source_db and rs_source_ds parameters
must exactly match the database and data server names specified
in the create connection command for the Replication
Server primary database connection. The values are case-sensitive.
For more information about the rs_source_db and rs_source_ds parameters, see the Mirror Replication Agent Reference Manual.
To record the values of connection configuration parameters for each Mirror Replication Agent instance, use the “Installation and Setup Worksheet” in the Mirror Replication Agent Installation Guide.
The Mirror Replication Agent instance must be running before you can set
its connection configuration parameter values. See “Starting Mirror Replication Agent” for more
information.
Setting up connection parameters for the primary database
In the Admin state, the Mirror Replication Agent instance has no connections established to other replication system components, but it is available to execute administrative commands. The Mirror Replication Agent instance must be in Admin state to set up connection parameters.
Log in to the Mirror Replication Agent administration port, and verify that the Mirror Replication Agent instance is in Admin state.
Use the following command to verify that the Mirror Replication Agent instance is in Admin state:
ra_status
If the instance is not in
Admin state, use the following command to put it in Admin state:
suspend
Specify the primary data server host name:
ra_config pds_hostname, pds_host
where pds_host is the network name of the primary data server host machine. For a clustered ASE, use the following command:
ra_config pds_server_name, cluster_server_name
where cluster_server_name is the cluster server name:
Specify the primary data server port number:
ra_config pds_port_number, NNN
where NNN is the number of the network port where the primary data server listens for connections. For a clustered ASE, use the following command:
ra_config pds_interfaces_file, "path_and_file"
where path_and_file is the path and filename of the interfaces file.
Specify the primary database name:
ra_config pds_database_name, pdb
where pdb is the primary database name (ASE), or the Oracle SID (Oracle).
Specify the primary data server user login name for the Mirror Replication Agent instance:
ra_config pds_username, ma_pds_user
where ma_pds_user is the user login name that the Mirror Replication Agent uses to log in to the primary data server.
Specify the password for the Mirror Replication Agent user login:
ra_config pds_password, ma_pds_pwd
where ma_pds_pwd is the password for the user login name that the Mirror Replication Agent uses to log in to the primary data server.
After you set up connection configuration parameters for the primary database, you can use the Mirror Replication Agent test_connection PDS command to test connectivity between the Mirror Replication Agent and the primary database. See “Testing network connectivity” for more information.
Setting up connection parameters for the Replication Server
If the Replication Server and databases were previously configured for a Replication Server warm standby application, the Mirror Replication Agent must use the same values for its rs_source_db and rs_source_ds parameters as the ASE RepAgent thread used for its connect database and connect dataserver parameters. See Chapter 1 of the Mirror Replication Agent Primary Database Guide.
Log in to the Mirror Replication Agent administration port, and verify that the Mirror Replication Agent instance is in Admin state:
Use the following command:
ra_status
If the instance is not in Admin state, use the following command to put it in Admin state:
suspend
Specify the Replication Server host name:
ra_config rs_hostname, rs_host
where rs_host is the network name of the Replication Server host machine.
Specify the Replication Server port number:
ra_config rs_port_number, NNN
where NNN is the number of the network port where Replication Server listens for connections.
Specify the Replication Server character set:
ra_config rs_charset, charset
where charset matches the RS_charset value in the Replication Server’s configuration (.cfg) file. The location of the Replication Server's configuration file is $SYBASE/REP-15_2/install/<instance>.cfg.
For Replication Server 15.1 and later releases, Mirror
Replication Agent uses the value of the Replication Server RS_charset parameter instead
of the Mirror Replication Agent rs_charset parameter.
However, if Mirror Replication Agent cannot connect to Replication
Server, the Mirror Replication Agent rs_charset parameter
is used.
Specify the Replication Server user login name for the Mirror Replication Agent instance:
ra_config rs_username, ma_rs_user
where ma_rs_user is the user login name that the Mirror Replication Agent uses to log in to the Replication Server.
Specify the user login password for the Mirror Replication Agent instance:
ra_config rs_password, ma_rs_pwd
where ma_rs_pwd is the password for the user login name that the Mirror Replication Agent uses to log in to the Replication Server.
Specify the primary data server name for the Replication Server primary database connection:
ra_config rs_source_ds, pds
where pds is the primary data server name that the Mirror Replication Agent uses in the LTL connect source command.
Specify the primary database name for the Replication Server primary database connection:
ra_config rs_source_db, pdb
where pdb is the primary database name that the Mirror Replication Agent uses in the LTL connect source command.
Setting up connection parameters for the ERSSD
(or RSSD)
Log in to the Mirror Replication Agent administration port, and verify that the Mirror Replication Agent instance is in Admin state:
Use the following command:
ra_status
If the instance is not in Admin state, issue the following command to put it in Admin state:
suspend
Specify the ERSSD host name:
ra_config rssd_hostname, rssd_host
where erssd_host is the network name of the ERSSD host machine.
Specify the ERSSD port number:
ra_config rssd_port_number, NNN
where NNN is the number of the network port where the ERSSD server listens for connections.
Specify the ERSSD database name:
ra_config rssd_database_name, rssd_db
where rssd_db is the database name of the ERSSD.
Specify the ERSSD user login name for the Mirror Replication Agent instance:
ra_config rssd_username, ma_rssd_user
Here, ma_erssd_user is the user login name that the Mirror Replication Agent uses to log in to the ERSSD.
Specify the user login password for the Mirror Replication Agent instance:
ra_config rssd_password, ma_rssd_pwd
Here, ma_rssd_pwd is the password for the user login name that the Mirror Replication Agent uses to log in to the RSSD.
After you set up connection configuration parameters for the Replication Server and RSSD, you can use the Mirror Replication Agent test_connection RS command to test connectivity between the Mirror Replication Agent and the Replication Server and RSSD. See “Testing network connectivity”.
