5.5

Table Of Contents
3 Enable TCP on the database instance.
4 Set a TCP port.
Option Action
Static TCP port Set the TCP port to the default of 1433.
Dynamic TCP port a Use a named instance of SQL Server. You can only use dynamic ports with a
named instance of SQL Server.
b Select the Show DB URL check box in the virtual appliance management
interface (VAMI) of the vSphere Replication appliance.
c Modify the DB URL value. Replace port=port_number with
instanceName=instance_name in the URL.
d Use the PortQuery command from a remote machine to check that the port
on which the SQL Server Browser service runs is not blocked by a firewall.
The SQL Server Browser runs on port 1434. Type the PortQuery command
in a terminal window.
PortQry.exe -n Machine_Name -p UDP -e 1434
5 Verify that the firewall on the database server permits inbound connections on the TCP port.
6 Create the vSphere Replication security login.
7 Create the vSphere Replication database and set the vSphere Replication security login as the
database owner.
8 Keep the dbo user and dbo schema settings.
Because the vSphere Replication security login is the database owner, it maps to the database user
dbo and uses the dbo schema.
Configure Oracle Server for vSphere Replication
You must configure an Oracle Server database correctly to support vSphere Replication.
You create and configure an Oracle Server database for vSphere Replication by using the tools that
Oracle Server provides.
This information provides the general steps that you must perform to configure an Oracle Server
database for vSphere Replication. For instructions about how to perform the relevant steps, see the
Oracle documentation.
Procedure
1 When creating the database instance, specify UTF-8 encoding.
2 Create the vSphere Replication database user account.
3 If they are not selected already, select the CONNECT and RESOURCE roles.
These roles provide the privileges that vSphere Replication requires.
VMware vSphere Replication Administration
VMware, Inc. 54