Creating connection to the active database

1. Log in to Replication Server using a login name with suitable permission.

2. 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