Setting Up Connection Parameters for the Primary Database
Configure connectivity to the primary database.
Log in to the Replication Agent administration
port, and verify that the Replication Agent instance is in Admin state:
ra_status
If the instance is not in the Admin state,
change it to the 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.
If Your Primary Data Server Is:
Specify:
Oracle
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.
Microsoft SQL Server
The primary data server
name:
ra_config pds_server_name, server
where
server is the name of the
primary data server.
IBM DB2 UDB
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.
The data source name (DSN) specified for the
connectivity driver used on the primary database
connection.:
ra_config pds_datasource_name, pds_dsn
where
pds_dsn is the DSN.
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.
Specify the primary database name:
ra_config pds_database_name, pdb
where pdb is the database name
of the primary database.
Specify the primary data server user login name for the Replication Agent
instance:
ra_config pds_username, ra_pds_user
where ra_pds_user is
the user login name that the Replication Agent uses to log in to
the primary data server.
Specify the password for the Replication Agent user
login:
ra_config pds_password, ra_pds_pwd
where ra_pds_pwd is
the password for the user login name that the 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 Replication Agent test_connection
PDS command to test connectivity between the Replication
Agent and the primary database.