Connecting to an Oracle RAC by Using a Virtual IP Address or Host Name
Connecting to an Oracle RAC by Using a Virtual IP Address or Host Name
If an Oracle RAC source has a virtual IP address or host name that supports failover and is routed to an active node, you can configure Data Replication to use this virtual IP address or host name.
If the Extractor or Data Replication Console fails to connect to a particular database instance or ASM instance, the virtual IP address or host name transparently fails over to another available instance.
You must specify the virtual IP address or host name and the global Oracle service name to connect to the Oracle database. You must also specify the virtual IP address or host name and the global ASM service name to connect to the Oracle ASM instance. Enter these connection details in one of the following ways:
On the
Source Database
tab, click
New connection
to create a new source database connection. Then specify the connection strings in the
New
dialog box.
On the
Server Manager
tab >
Connections
view, click the
New
icon button on the Connections toolbar. Then specify the connection strings in the
New
dialog box.
On the
Server Manager
tab >
Connections
view, select an existing Oracle source database connection and click the
Edit
icon button on the Connections toolbar. Then specify the connection strings in the
Editing
dialog box.
On the
Database
tab of the
New
dialog box or
Editing
dialog box, enter the following connection information for the Oracle database:
In the
Type
list, select
Oracle
.
In the
Host
field, enter the virtual IP address or host name of an active Oracle database instance.
In the
Port
field, enter the Oracle listener port number. Valid values are integers from 1 through 65535.
In the
User
and
Password
fields, enter a database user ID and password that permits connection to the Oracle database.
In the
Instance/DB
field, enter the global Oracle service name. Do not use the Oracle instance name.
In the
New
dialog box, click
OK
. In the
Editing
dialog box, click
Save
and then click
Yes
at the confirmation prompt.
On the
ASM Settings
tab of the
New
dialog box or
Editing
dialog box, enter the following connection information for the Oracle ASM instance:
In the
ASM instance host name
field, enter the virtual IP address or host name of an active Oracle ASM instance.
In the
ASM instance port
field, enter the port number to use for connecting to the ASM instance. Valid values are integers from 1 through 65535.
In the
ASM sys username
and
ASM sys password
fields, enter a user name and password that permits connection the Oracle ASM instance.
This user must have SYSDBA privileges.
In the
ASM instance
field, enter the global Oracle ASM service name. Do not use the ASM instance name.