Chapter 12: Managing Heterogeneous Warm Standby for Oracle
Creating connection to the standby database
Log in to Replication
Server using a login name with suitable permission.
Execute:
create connection to standby_ds.standby_db
using profile …
set username to …
set password to …
with log transfer on
as standby for logical_ds.logical_db