Setup Listener on Infiniband Network using both SDP and TCP Protocol (Doc ID 1580584.1)

Last updated on AUGUST 08, 2016

Applies to:

Exadata Database Machine V2 - Version All Versions and later
Oracle Exadata Hardware - Version 11.2.0.1 and later
Exadata Database Machine X2-2 Hardware - Version All Versions and later
Exadata Database Machine X2-8 - Version All Versions and later
Exadata X3-2 Hardware - Version All Versions and later
Generic Linux

Goal

Exadata Environment, though the same can be used for Non-Exadata Deployments that are using Infiniband
and the Linux platform supporting SDP protocol.

Configuring Sql*Net Listener using SDP/TCP protocol on Infiniband Network.   If the intention is to make usage of SDP on various environments, i.e. multiple RACKS/Clusters be sure to implement this change on all nodes.

 

Please Note Oracle recommends the usage of TCP instead of SDP for Exalogic to Exadata connectivity. 

Although the following instructions in this MOS note outline steps to deploy either protocol, it is highly recommended to use TCP for maximum stability.

The stability benefits provided by TCP outweigh any performance increase obtained from the use of SDP. For a variety of workloads in several scenarios, we have observed extremely good performance with TCP. In case of link failovers, TCP also resumes better than SDP due to less dependency on hardware layers.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms