Adding the Active Database to the Replication System

Create connection to the active database.

Execute:

create connection to active_ds.active_db
using profile …
set username to …
set password to …
with log transfer on
as active for logical_ds.logical_db

If you are using ExpressConnect for Oracle, execute:

create connection to ordb.ordb/*oracle data server name. database name*/
using profile rs_oracle_to_oracle;eco
set username to ...
set password to ...
with log transfer on
as active for logical_ds.logical_db
go

Alternatively, if you are using ECDA, execute:

create connection to dco2active.ordb/*dco instance name.database name*/
using profile rs_oracle_to_oracle;ecda
set username to ...
set password to ...
with log transfer on
as active for logical_ds.logical_db
go