To replicate data to multiple target databases, define a connection for the primary target database and a connection for each secondary target database. For the source database, you can either define a connection or use a pre-existing one.
On the
Server Manager
tab >
Connections
view, click the
New
icon button on the Connections toolbar.
The
New
dialog box appears.
In the
Name
field, enter a name for the connection.
Connection names can contain only the digits 0-9, Latin letters A-Z and a-z, and the underscore (_) character. The Data Replication Console truncates connection names that are longer than 100 characters.
In the
Owner
list, select an owner for the connection.
In the
Type
list, select the target database type.
On the
Database
tab, enter connection information for the target, including the host name or IP address, port number, user name and password, and instance or database name.
In an Oracle ASM environment, enter connection information on the
ASM Settings
tab.
To test the connection, click
Test Connection
.
If the connection is successful, “Connected” is displayed to the left of the
Test Connection
button.
Click
OK
.
The
Connections
view lists the connection. For example, the following image lists the Oracle1 connectiont:
If you select a listed connection, the connection details are displayed on the right. Under
Configuration using this connection
, you can view the number of source databases, primary targets, and secondary targets that use the connection definition.