Network and connectivity requirements for Oracle environments

General port allocation

The Delphix Engine makes use of the following network ports regardless of the type of database platform:

General outbound from the Delphix engine port allocation

General inbound to the Delphix engine port allocation

Firewalls and intrusion detection systems (IDS)

Production databases on source environments (for dSources) are often separated from the non-production environment by firewalls. Firewalls can add milliseconds to the latency between servers. Accordingly, for best performance, there should be no firewalls between the Delphix Engine and the virtual database (VDB) target environments. If the Delphix Engine is separated from a source environment by a firewall, the firewall must be configured to permit network connections between the Delphix Engine and the source environments for the application protocols (ports) listed above.

Intrusion detection systems (IDSs) should also be made permissive to the Delphix Engine deployment. IDSs should be made aware of the anticipated high volumes of data transfer between dSources and the Delphix Engine.

SSHD configuration

Both source and target Unix environments are required to have sshd running and configured such that the Delphix Engine can connect over ssh.

The Delphix platform expects to maintain long-running, highly performant ssh connections with remote Unix environments. The following sshd configuration entries can interfere with these ssh connections and are therefore disallowed:

Network and connectivity requirements for Oracle

• IP connections must exist between the Delphix Engine and the source and target environments.

• For source environments, Delphix Engine uses an SSH connection to each source host, an HTTP connection from each source environment to Delphix Engine, and a DSP connection to the Delphix Engine. The Delphix Engine uses SQLNet connections to the DBMS on the source environment. 

• For target environments, Delphix uses an SSH connection to each target environment and an NFS connection to Delphix Engine. Delphix Engine uses SQLNet connections to the virtual databases on the target environment.

• A TCP Connection is opened between Oracle and the Delphix Connector Process on random high ports ( above 1024 ) on localhost ( 127.0.0.1 ).

scp Availability

The scp program must be available in the environment in order to add an environment.

Port allocation for Oracle environments

The following diagram describes the port allocations for Oracle environments. It illustrates the ports that we recommend to be open from Delphix to remote services, to the Delphix Engine, and to the Target Environments. 

The Delphix Engine makes use of the following network ports for Oracle dSources and VDBs:

Outbound from the Delphix engine port allocation

Inbound to the Delphix engine port allocation

AppData port requirements

The use of AppData requires the following ports/protocols. Two important notes about these specifications:

1. The next release of the Delphix Engine will significantly augment the port/protocol utilization of AppData. The upcoming-only requirements have been marked with a *.

2. AppData V2P uses RSYNC to export to the target. RSYNC between the target and Delphix Engine is not required for general virtualization usage. The V2P-only requirements have been marked with a ^.